Re: MySQL 5.0.24 hard time with VB 3.5.4 and 3.6
Abdullah Ibn Hamad Al-Marri wrote:
Invalid SQL:
INSERT IGNORE INTO session
(sessionhash, userid, host, idhash, lastactivity, location,
styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation,
useragent, bypass, profileupdate)
VALUES
('49778b903012cc3dba1481897dcb5749', 0, '62.68.61.2',
'ab1219e33a7fca1808ca880a806b6383', 1155125518,
'/showthread.php?t=5311&page=4', 0, 0, 0, 21, 5311, 0, 0, 'Mozilla/4.0
(compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)', 0, 0);
MySQL Error : MySQL server has gone away
Error Number : 2006
Date : Wednesday, August 9th 2006 @ 12:13:16 PM
Script : http://bb.wearab.net/showthread.php?t=5311&page=4
There's nothing wrong with this query as far as I can see (maybe
misaligned quotes, didn't check), but I don't think that's the problem.
Check:
http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
It's probably timeout from the server and it usually comes out of TCP
timeout (the admin should take care of it) or executing queries with
closed db handles in your code (you should care for it).
If you're sure it's not your fault, (and you do have privileges) send
that page to the admin and ask him for a better network! ;)
cheers,
--renato
PS: This error message is subject to forums like this quite often, if
you had googled for the error message you'd check that the page I'm
referring to is the first match.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 5.0.24 hard time with VB 3.5.4 and 3.6
Hello folks,
I'm having hard time with MySQL, I posted this issue t the vb board, and they
claimed it's MySQL issue.
I have this issue since I upgraded to MySQL 5.0.22 and now it's still I going
on since I upgraded to MySQL 5.0.24 too.
Database error in vBulletin 3.6.0:
Invalid SQL:
INSERT IGNORE INTO session
(sessionhash, userid, host, idhash, lastactivity, location,
styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation,
useragent, bypass, profileupdate)
VALUES
('49778b903012cc3dba1481897dcb5749', 0, '62.68.61.2',
'ab1219e33a7fca1808ca880a806b6383', 1155125518,
'/showthread.php?t=5311&page=4', 0, 0, 0, 21, 5311, 0, 0, 'Mozilla/4.0
(compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)', 0, 0);
MySQL Error : MySQL server has gone away
Error Number : 2006
Date : Wednesday, August 9th 2006 @ 12:13:16 PM
Script : http://bb.wearab.net/showthread.php?t=5311&page=4
--
Database error in vBulletin 3.6.0:
Invalid SQL:
UPDATE session
SET lastactivity = 1155128141, inforum = 0, inthread = 0,
incalendar = 0, badlocation = 0
WHERE sessionhash = '72acdfba168f0c3d33e0728f4eff5326';
MySQL Error : MySQL server has gone away
Error Number : 2006
Date : Wednesday, August 9th 2006 @ 12:56:14 PM
Script :
http://bb.wearab.net/online.php?order=asc&sort=username&pp=200&page=1
Referrer :
IP Address : 82.148.97.67
--
Here is my server profile.
Server TypeFreeBSD
Web Server Apache v2.2.2
PHP5.1.4
PHP Max Post Size 8.00 MB
PHP Maximum Upload Size2.00 MB
PHP Memory Limit 16.00 MB
MySQL Version 5.0.24
MySQL Packet Size 32.00 MB
Data Usage 70.57 MB
Index Usage34.93 MB
Attachment Usage 17.01 MB
Avatar Usage 414.5 KB
Profile Picture Usage 429.2 KB
Thank you,
-Arabian
