Why not register?
Author |
Message |
elchupacabra
|
Posted: Tue Jul 29, 2008 5:18 am Post subject: Re: Site issues/bugs |
|
The Ancient One Joined: Sat Oct 20, 2007 10:31 am Posts: 3600
|
No no. I got that when I accidentally chose the wrong source type. EDIT:I can't post new posts: Code: | General Error SQL ERROR [ mysql4 ]
Duplicate entry '190814' for key 1 [1062]
An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
Please notify the board administrator or webmaster: noreply@dead-donkey.com |
Last edited by elchupacabra on Fri Aug 15, 2008 10:39 am, edited 1 time in total.
|
|
Top |
|
|
spudthedestroyer
|
Posted: Tue Jul 29, 2008 7:59 am Post subject: Re: Site issues/bugs |
|
Site Admin Joined: Sat Nov 02, 2002 1:35 am Posts: 19753 Location: En España
|
elchupacabra wrote: | No no. I got that when I accidentally chose the wrong source type. |
oh okay, i'll look on phpbb3 for a bug report
_________________ Mouse nipple for the win! Trackpoint or death!
|
|
Top |
|
|
RedVeil
|
Posted: Fri Aug 15, 2008 11:12 pm Post subject: Re: Site issues/bugs |
|
The Devil, Probably Joined: Fri Oct 26, 2007 3:40 pm Posts: 2250 Location: Inside my body.
|
|
Top |
|
|
Slayer
|
Posted: Sat Aug 16, 2008 5:01 pm Post subject: Re: Site issues/bugs |
|
The Ancient One Joined: Mon Jan 22, 2007 9:13 pm Posts: 7856
|
When I click view newest posts in the thread "More Zombie Porn!" in /Horror Fanatics Cabal I get this: viewtopic.php?f=32&t=15604&view=unread#unread (the release thread of "My Best Friend IS A Vampire" in /Screeners and unverified releases) It seems some post IDs got mixed up too.
_________________
THIRD SEAL MEANS FAMINE
|
|
Top |
|
|
spudthedestroyer
|
Posted: Sat Aug 16, 2008 5:26 pm Post subject: Re: Site issues/bugs |
|
Site Admin Joined: Sat Nov 02, 2002 1:35 am Posts: 19753 Location: En España
|
that is not at all likely, the clock is more likely to have been reset. I no longer have root access to the box since the host bungled a migration. Can't do anything until i get that back.
_________________ Mouse nipple for the win! Trackpoint or death!
|
|
Top |
|
|
spudthedestroyer
|
Posted: Sat Aug 16, 2008 5:39 pm Post subject: Re: Site issues/bugs |
|
Site Admin Joined: Sat Nov 02, 2002 1:35 am Posts: 19753 Location: En España
|
the timezone is wrong on the new server, its two hours ahead.
What a fucking farce
_________________ Mouse nipple for the win! Trackpoint or death!
|
|
Top |
|
|
spudthedestroyer
|
Posted: Sat Aug 16, 2008 5:45 pm Post subject: Re: Site issues/bugs |
|
Site Admin Joined: Sat Nov 02, 2002 1:35 am Posts: 19753 Location: En España
|
okay i know what's happened, the fucking idiot has fucked up a data migration, turned off the old box then asked us to update the DNS. i've updated the DNS to the new server, where upon i stated he hadn't switched the new box on. He then assigned the new ips to the old box, rebuilt a new server then switched ips. So the data is now spread across two fucking boxes. So all the data posted during that time is on the old server, but i can't insert it into the new database now because there have been posts since.
_________________ Mouse nipple for the win! Trackpoint or death!
|
|
Top |
|
|
elchupacabra
|
Posted: Sat Aug 16, 2008 6:13 pm Post subject: Re: Site issues/bugs |
|
The Ancient One Joined: Sat Oct 20, 2007 10:31 am Posts: 3600
|
|
Top |
|
|
Slayer
|
Posted: Sat Aug 16, 2008 6:37 pm Post subject: Re: Site issues/bugs |
|
The Ancient One Joined: Mon Jan 22, 2007 9:13 pm Posts: 7856
|
spudthedestroyer wrote: | So the data is now spread across two fucking boxes. |
Is this also the cause of the mixing up of the post ID's?
_________________
THIRD SEAL MEANS FAMINE
|
|
Top |
|
|
spudthedestroyer
|
Posted: Sat Aug 16, 2008 7:07 pm Post subject: Re: Site issues/bugs |
|
Site Admin Joined: Sat Nov 02, 2002 1:35 am Posts: 19753 Location: En España
|
Slayer wrote: | spudthedestroyer wrote: | So the data is now spread across two fucking boxes. |
Is this also the cause of the mixing up of the post ID's? |
I don't think there are any mixed up postids, if you mean the unread link you posted, it will go to the first post it believes to be unread which is based upon datetime stamp not post id. Post ids and time are mutually exclusive, topics are ordered by datetime rather than postid.
_________________ Mouse nipple for the win! Trackpoint or death!
|
|
Top |
|
|
Slayer
|
Posted: Sat Aug 16, 2008 7:30 pm Post subject: Re: Site issues/bugs |
|
The Ancient One Joined: Mon Jan 22, 2007 9:13 pm Posts: 7856
|
Well, then it puzzles me why I get relocated from cabal to screeners
_________________
THIRD SEAL MEANS FAMINE
|
|
Top |
|
|
spudthedestroyer
|
Posted: Sat Aug 16, 2008 7:47 pm Post subject: Re: Site issues/bugs |
|
Site Admin Joined: Sat Nov 02, 2002 1:35 am Posts: 19753 Location: En España
|
Well mysql when locked said there were two post ids the same could simply be that, but it won't be posts being on two different servers.
_________________ Mouse nipple for the win! Trackpoint or death!
|
|
Top |
|
|
spudthedestroyer
|
Posted: Sat Aug 16, 2008 8:15 pm Post subject: Re: Site issues/bugs |
|
Site Admin Joined: Sat Nov 02, 2002 1:35 am Posts: 19753 Location: En España
|
okay slayer, your id is the one at the top of the page: Code: | Duplicate entry '190814' for key 1 [1062] |
So when i repairded the table it will have updated one of the duplicates to a new number, but not updated references. You had a 1/180585 chance of finding that link I think that the server has no been completely migrated; there is one outstanding issue which is that the clock is wrong which I think it is getting from the server bios. When this is reset it might cause some mild freakiness since we'll be going back in time 2 hours, but barring staying with a 2 hour out clock there's nothing much we can do about that one Its with our highly capable (handicapable?) host
_________________ Mouse nipple for the win! Trackpoint or death!
|
|
Top |
|
|
Slayer
|
Posted: Sun Aug 17, 2008 8:24 pm Post subject: Re: Site issues/bugs |
|
The Ancient One Joined: Mon Jan 22, 2007 9:13 pm Posts: 7856
|
spudthedestroyer wrote: | okay slayer, your id is the one at the top of the page: Code: | Duplicate entry '190814' for key 1 [1062] |
So when i repairded the table it will have updated one of the duplicates to a new number, but not updated references. You had a 1/180585 chance of finding that link |
I'm great, I knew it
_________________
THIRD SEAL MEANS FAMINE
|
|
Top |
|
|
spudthedestroyer
|
Posted: Sun Aug 17, 2008 8:38 pm Post subject: Re: Site issues/bugs |
|
Site Admin Joined: Sat Nov 02, 2002 1:35 am Posts: 19753 Location: En España
|
lol, slayer akbar!
_________________ Mouse nipple for the win! Trackpoint or death!
|
|
Top |
|
|
pure
|
Posted: Wed Oct 22, 2008 2:11 pm Post subject: Re: Site issues/bugs |
|
The Devil, Probably Joined: Fri Jan 06, 2006 1:58 pm Posts: 1940 Location: Just Follow The Stench
|
When I transload an image and insert it to a topic (using quick reply) it keeps on waiting and doesn't show up. But if I go to topic the I see that it's already inserted. Not a big problem, like said you can get around it, but annoying nevertheless
_________________
"SBiG: Bad Movie Download Central | Home of the ShitBusters" | White Wine FTW
|
|
Top |
|
|
spudthedestroyer
|
Posted: Fri Oct 24, 2008 1:12 pm Post subject: Re: Site issues/bugs |
|
Site Admin Joined: Sat Nov 02, 2002 1:35 am Posts: 19753 Location: En España
|
sorry, I'm not sure what you mean there pure... you mean you post an image in the quick reply and it doesn't appear?
_________________ Mouse nipple for the win! Trackpoint or death!
|
|
Top |
|
|
RedVeil
|
Posted: Fri Oct 24, 2008 2:20 pm Post subject: Re: Site issues/bugs |
|
The Devil, Probably Joined: Fri Oct 26, 2007 3:40 pm Posts: 2250 Location: Inside my body.
|
|
Top |
|
|
pure
|
Posted: Fri Oct 24, 2008 9:01 pm Post subject: Re: Site issues/bugs |
|
The Devil, Probably Joined: Fri Jan 06, 2006 1:58 pm Posts: 1940 Location: Just Follow The Stench
|
Well yes and no, let me refrase myself a bit then; I've transloaded an image using: http://images.dead-donkey.com/transload/transload.phpThen I tried to post the outcome (of this transload) using the quick reply box in the forums. When I pressed Submit the page kept on loading and loading and loading.... But if I CTRL-Clicked the thread title, so it opens in a new tab in FireFox, it already showed the image I was trying to post. I hope this makes sense
_________________
"SBiG: Bad Movie Download Central | Home of the ShitBusters" | White Wine FTW
|
|
Top |
|
|
RedVeil
|
Posted: Fri Oct 24, 2008 9:20 pm Post subject: Re: Site issues/bugs |
|
The Devil, Probably Joined: Fri Oct 26, 2007 3:40 pm Posts: 2250 Location: Inside my body.
|
|
Top |
|
|
Who is online |
Users browsing this forum: No registered users and 4 guests |
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot post attachments in this forum
|
|