well I registered in july but I didn't see the old codeguru
Printable View
well I registered in july but I didn't see the old codeguru
There is already so much ... however i feel i need to add this one too..
On occasion (and has happened to me about 4 times in the last few months) when submitting a post or an edit (Self or mod edit) i get a SQL error page with the following detail
and this is very often around the time that there's terrible lag on the site... So I think it could be related...Code:Database error in vBulletin 4.1.5:
Invalid SQL:
INSERT INTO searchgroup (username, contenttypeid, groupid, userid, dateline)
VALUES ( 'arunchristopher', 2, 521485, 385811, 1346160561 )
ON DUPLICATE KEY UPDATE username = VALUES(username), contenttypeid = VALUES(contenttypeid), groupid = VALUES(groupid), userid = VALUES(userid), dateline = VALUES(dateline);
MySQL Error : Lock wait timeout exceeded; try restarting transaction
Error Number : 1205
Request Date : Thursday, August 30th 2012 @ 12:01:08 AM
Error Date : Thursday, August 30th 2012 @ 12:01:37 AM
Script : http://forums.codeguru.com/editpost.php?do=updatepost&postid=2082535
Referrer : http://forums.codeguru.com/showthread.php?521485-VB-6-calculates-differently-for-No-Optimiza-and-Optimize-for-Fast-Code-exe-builds
IP Address : 198.54.202.3
Username : GremlinSA
Classname : vB_Database
MySQL Version : 5.5.21-log
Where do you see that???
Once again trying to get to this topic...
Screen shot attached....
Attachment 30295
I've seen that page quite frequently too. It seems to crash the forum and I usually can't get back onto CG for maybe 3 or 4 minutes.
I clear out my CG cookies after that message and then sign back in. Seems to work right away.
Yes, it helps, however only for some days (sometimes a week), and then all the problems come back. And I do NOT want to remove my cookies/history every week because all my saved logins go away! :eek:
Note that I didn't have such a problem with the previous CG versions at all.
I don't think cookies has anything to do with it. I don't clear cookies, but the message just comes and goes when it feels like it. I'll get it a few times, then 5 minutes later it's gone away.
The last hours or so CG have behaved like before the update so some major issue might have been fixed (holding my thumbs). :)
I had thought the same until about forty minutes ago being in the "quick reply" mode I got the "... want to leave this page" dialog and after pressing "leave this page" button got moved to the "normal reply with quoutes" mode with already published message and a popup dialog telling me that I cannot post my message until .... seconds! :thumbd: :mad:
And I got the "database problem" messages the whole day yesterday and also once or two times today. :eek:
Some processes were ended as of last night. Let's see how performance is for the next day or two. Let's see if it is any better at all.....
Brad!
I have no idea what "Some processes were ended as of last night" means but the most of the problems still persists:
- Some minutes ago I got again the popup about "Leave this page" and after confirm to leave could saw my post being duplicated.
- Then while trying to post in this thread I had to wait about 40..50 seconds and then got the message about connection problem with this site... (well, after Refresh it began to work again)
ugh.
I'll make sure everyone internally knows that the issues continue and that we need to continue to search for solutions.
Brad!