1064 - You have an error in your SQL syntax

[spoogy_123]

hi

 

Wonder if anyone has a solution to this issue:

 

OSC CRE Loaded 6.2

PHP version 5.2.5

MySQL version 4.1.22-standard

 

I am encountering this message at login to /admin.

 

 

"1064 - 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 '' at line 1

 

select a.admin_id, a.admin_firstname, a.admin_lastname, a.admin_email_address, a.admin_created, a.admin_modified, a.admin_logdate, a.admin_lognum, g.admin_groups_name from admin a, admin_groups g where a.admin_id= 1 and g.admin_groups_id=

 

[TEP STOP]"

 

I think my host may have upgraded the mysql version running on the server from 4.2.2

 

It was working fine before, but now this error.

 

Any help is much appreciated:)

 

Thanks

spoogy_123

[arietis]

OSC CRE Loaded 6.2

 

sorry, wrong forum. :) this is for oscommerce. you'll need to find support in the cre loaded forum.