Anyone else have this issue? The install went without any issues, but when trying to run the arcade I get this error. Is mysql too old? Or because I have added az in front of all of my tables? (to prevent issues on the server from multiple VB instances)
I am running php 5.29 / mysql 4.027
<error below>
mySQL query error: SELECT user.userid, user.avatarid, user.avatarrevision, avatar.avatarpath, customavatar.filename, NOT ISNULL(filedata) AS hascustom, customavatar.dateline FROM (SELECT * FROM azuser WHERE userid=2) AS user LEFT JOIN azavatar AS avatar ON avatar.avatarid = user.avatarid LEFT JOIN azcustomavatar AS customavatar ON customavatar.userid = user.userid WHERE customavatar.userid=2 OR user.userid=2
mySQL 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 'SELECT * FROM azuser WHERE userid=2) AS user LEFT JOIN azavatar
mySQL error code:
Date: Saturday 05th 2009f December 2009 09:55:09 AM
you are using mySQL < 4.1 and this means the optimized query can not be used.
Normally ibProArcade tries to detect your mySQL-version and use the corresponding query, but this seem to fail on your site.
This version of ibProArcade are you using ?
I downloaded and installed the latest version:
v2.6.9+ (Released 28th November 2009)
...and it was a fresh install ?
Please provide access to your FTP via PM to me and I will try to find out what the problem is and why mySQL-version-detection does not work here...
I will pm you the info. Thank you!
Problem solved - mySQL 4.0.27 running, but mysql_get_client_info() gives back 4.1.22
Now implemented a new config-setting to avoid such problems... in ibProArcade v2.7.0+ you will find (in /arcade/functions/dbclass.php)$force_oldsql = false;set this to TRUE to force using the "old" SQL-command for mySQL < 4.1 and if mySQL-version-detection fails
@hirlas:
this is already implemented and activated on your site :)