mysql problem

intramanga · Joined: 28 Nov 2004 Posts: 10

testing with mysql > adding , deleting connecting users seems to be OK , PPAL not tested yet but Show User Log gives following error :

Warning: odbc_exec(): SQL error: [MySQL][ODBC 3.51 Driver][mysqld-3.23.53-max-nt]You have an error in your SQL syntax near 'UNION SELECT '*anonymous' as name, logintime, logouttime, duration, ipo' at line 3, SQL state 37000 in SQLExecDirect in c:\program files\firstspot\cfgmgr\userlog.php on line 35

Warning: odbc_fetch_row(): supplied argument is not a valid ODBC result resource in c:\program files\firstspot\cfgmgr\userlog.php on line 41

Any ideas ?
Thanks,
Ed,

hans · **Forum facilitator** Joined: 14 May 2004 Posts: 63

we recommend you to use MySQL 4.0.x database and MySQL ODBC driver 3.51.04 because we have done most of testing on them.

intramanga · Joined: 28 Nov 2004 Posts: 10

Indeed , MySQL 4.0 did the job , no more errors now , still using ODBC 3.51.06 , but this seems to be OK , cant find 3.51.04 anymore.
Still to test with PPAL , if this works out OK I will consider buying the adv. version.
Thanks,
Ed,

alan · **Forum facilitator** Joined: 26 Sep 2003 Posts: 4435

You can download MySQL ODBC 3.51.04 at:

http://downloads.mysql.com/archives/myodbc-3.51/MyODBC-3.51.04.exe
_________________
~ Patronsoft Limited ~