kansei
12-03-2007, 07:41 PM
I'm very new to vbulletin admin stuff (i.e. just started this past week) and am trying to eliminate some mysql errors I've been getting (I get e-mailed this same error about 30x a day).
-----------------------------------------------------
Here's the basic config:
Server Type Linux
Web Server Apache v1.3.37 (cgi-fcgi)
PHP 4.4.7
PHP Max Post Size 8.00 MB
PHP Maximum Upload Size 2.00 MB
MySQL Version 4.0.27-standard
MySQL Packet Size 16.00 MB
-------------------------------------------------------
The server was set up a few days before I came on board to start the site so I didn't question the use of MySQL 4 instead of 5. From my experience with MySQL this error (below) that I'm receiving is related to using 4.0 and should be fixed in 4.1.
I'm 90% sure my sftp credentials for the site give me full shell access but to tell the truth, I don't know the hosting situation at all so I'd have to get back to you guys on that if more info is needed. If a mysql upgrade will fix it, I'll go through with that (unless it's some weird hosting situation and we can't at all).
Here's the e-mail I keep getting --feel free to probe the site to try and provoke the errors if you want. The only time I myself have been able to trigger the error is with the 'googlemaps me' mod which is disabled until I sort this out. The errors were going on back with 3.5... whatever it was, and I just upgraded to 3.6.8 patch level 2 last night.
Database error in vBulletin 3.6.8:
Invalid SQL:
SET NAMES 'utf8';
MySQL Error : Unknown system variable 'NAMES'
Error Number : 1193
Date : Monday, December 3rd 2007 @ 09:15:43 AM
Script : http://www.themazdaforum.com/cron.php?&rand=303382
Referrer : http://www.themazdaforum.com/
IP Address : 71.252.26.64
Username : Unregistered
Classname : vb_database
I could force utf8 for everything which in theory should fix it but of course.. drawbacks. It's an english language site right now but any members are free to speak whatever language they want and are free to use whatever characters they want.
Any pointers?
-----------------------------------------------------
Here's the basic config:
Server Type Linux
Web Server Apache v1.3.37 (cgi-fcgi)
PHP 4.4.7
PHP Max Post Size 8.00 MB
PHP Maximum Upload Size 2.00 MB
MySQL Version 4.0.27-standard
MySQL Packet Size 16.00 MB
-------------------------------------------------------
The server was set up a few days before I came on board to start the site so I didn't question the use of MySQL 4 instead of 5. From my experience with MySQL this error (below) that I'm receiving is related to using 4.0 and should be fixed in 4.1.
I'm 90% sure my sftp credentials for the site give me full shell access but to tell the truth, I don't know the hosting situation at all so I'd have to get back to you guys on that if more info is needed. If a mysql upgrade will fix it, I'll go through with that (unless it's some weird hosting situation and we can't at all).
Here's the e-mail I keep getting --feel free to probe the site to try and provoke the errors if you want. The only time I myself have been able to trigger the error is with the 'googlemaps me' mod which is disabled until I sort this out. The errors were going on back with 3.5... whatever it was, and I just upgraded to 3.6.8 patch level 2 last night.
Database error in vBulletin 3.6.8:
Invalid SQL:
SET NAMES 'utf8';
MySQL Error : Unknown system variable 'NAMES'
Error Number : 1193
Date : Monday, December 3rd 2007 @ 09:15:43 AM
Script : http://www.themazdaforum.com/cron.php?&rand=303382
Referrer : http://www.themazdaforum.com/
IP Address : 71.252.26.64
Username : Unregistered
Classname : vb_database
I could force utf8 for everything which in theory should fix it but of course.. drawbacks. It's an english language site right now but any members are free to speak whatever language they want and are free to use whatever characters they want.
Any pointers?