SearchSearch   ProfileProfile   Log inLog in   RegisterRegister 

mysql problem

 
Post new topic   Reply to topic    FirstSpot Forum Index -> Pre-sales Support Forum
View previous topic :: View next topic  
Author Message
intramanga



Joined: 28 Nov 2004
Posts: 10

PostPosted: Tue Nov 30, 2004 12:36 am    
Post subject: mysql problem

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,
Back to top
hans
Forum facilitator


Joined: 14 May 2004
Posts: 63

PostPosted: Tue Nov 30, 2004 3:06 am    
Post subject:

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.
Back to top
intramanga



Joined: 28 Nov 2004
Posts: 10

PostPosted: Tue Nov 30, 2004 1:19 pm    
Post subject: mysql

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,
Back to top
alan
Forum facilitator


Joined: 26 Sep 2003
Posts: 4435

PostPosted: Fri Dec 03, 2004 5:23 am    
Post subject:

You can download MySQL ODBC 3.51.04 at:

http://downloads.mysql.com/archives/myodbc-3.51/MyODBC-3.51.04.exe
_________________
~ Patronsoft Limited ~
Back to top
Display posts from previous:   
Post new topic   Reply to topic    FirstSpot Forum Index -> Pre-sales Support Forum All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group