MySQL Errors

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?

[snakes1100]

Did you upgrade googlemap_me to the latest version seeing as you upgraded the forum to 3.6.x?

This was probably a bug back in the older version of googlemap_me

[Paul M]

As you pretty much said yourself - the SET NAMES command is only available in MySQL 4.1 and above - so you will always get that error running while 4.0.27

[kansei]

Originally Posted by snakes1100

Did you upgrade googlemap_me to the latest version seeing as you upgraded the forum to 3.6.x?

This was probably a bug back in the older version of googlemap_me

It was the latest version of google maps. --that being said, it is disabled (or uninstalled.. I think I uninstalled it this morning trying to get rid of the flood of error e-mails to my phone ).

The errrors are showing up on all sorts of other pages. I was pretty sure I read requirements and 4.0.27 was above the minimum. I guess it's time to look into upgrading.

thanks guys! I'll let you know what fixes it.

[Marco van Herwaarden]

In your config.php file, what do you have for the following line:

PHP Code:

// $config['Mysqli']['charset'] = 'utf8'; 


?

If that line is uncommented, please comment it again.

[kansei]

All the mysqli stuff is commented out.

This is the next uncommented line:
$config['Mysqli']['ini_file'] = '';

the only two lines after that are image processing max dimensions stuff.