Run error / installed fine

[hirlas]

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

[MrZeropage]

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 ?

[hirlas]

I downloaded and installed the latest version:

v2.6.9+ (Released 28th November 2009)

[MrZeropage]

...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...

[hirlas]

I will pm you the info. Thank you!

[MrZeropage]

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 :)

[hirlas]

I'm sending a little thank you your way! ;)