MySQL Syntax Error

ezyweb

At installation I'm getting this error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where name = 'GDN_Tag'' at line 1|Gdn_Database|Query|show table status where name = 'GDN_Tag'

I've installed other versions of Vanilla on the same host (mediatemple) in the past, but it seems to be something wrong with the latest.

ezyweb

any suggestions at all?

ezyweb

could it possibly have something to do with a php version? Its kind of a big deal if noboddy on Mediatemple can use Vanilla!!

cdavid

That seems to me as a MySQL problem. Mainly the only mention of "show table status" is in library/database/class.mysql.structure.php -- line 327.

Not quite sure what this means though. Are you importing data from a previous installation / Vanilla 1 or is this a fresh installation?

More debugging to come, but can't realize what happens for now.
/cd

Linc

@Todd Might want to look at this one. I've seen a few Tag table-related issues now so I'm wondering if it's something about the structure.

Linc

@ezyweb Can you confirm your server has PHP 5.2, MySQL 5, and PDO installed?

Todd

That table status is used to figure out which storage engine a table uses. It looks like the syntax we use is supported from MySQL 5, but not MySQL 4.

Looking at the documentation I can change this to support MySQL 4, but to be honest we don't test on that version of MySQL that much. I'm also pretty sure MediaTemple supports MySQL 5.1.26.

Can you do the following from your accounts phpmyadmin? Run these commands and tell me what you get:

SHOW VARIABLES LIKE "%version%";

show table status like 'GDN_User';

show table status where name = 'GDN_User';

ezyweb

todd: this is the response:

SQL query:

SHOW TABLE STATUS WHERE name = 'GDN_User'

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where name = 'GDN_User'' at line 1

btw: Mediatemple only supports MySQL4 - users on the grid can pay extra for the mysql5 but I was hoping I didn't have to do that.

Mark

Vanilla 2 requires MySQL 5 or newer: http://vanillaforums.org/page/Installation-Requirements

mt_Sara

Actually, you can request to be added to the MySQL5 program - at no cost. You would need to open a support request within the AccountCenter and request the upgrade.

(mt) Sara