I need help on the SQL query stuff, what does it mean? Extension:GlobalUserrights gives me instructions that don't work and give me error code #1064.
Topic on Project:Support desk
Hi Jeff,
MySQL error code 0164 only is a generic error message for "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax at ...".
To get more information, try setting $wgShowSQLErrors = TRUE; in LocalSettings.php, then reproduce the error. This should show you the actual query, which causes the problem.
That really helped. I use phpMyAdmin and I'm on Dreamhost. So, what could this mean? Oh, and $wgShowSQLErrors is useless, thank you very much.
Hi again,
the error message alone does not help you much. Could be anything. You need to know the SQL query, which caused the error; then you can check why the error happens.
If MediaWiki does not allow you to see the query, you can still find it in the MySQL error log.
If you're talking about the initial import, and its failing, could be that the extension simply doesn't support your version of MySQL.