thomas
|
| Posted: 01/05/2003, 3:25 PM |
|
sometimes it runs sometimes not, here is the error message
Database error: Invalid SQL: SELECT FROM users WHERE ='admin' AND ='admin'
MySQL Error: 1064 (You have an error in your SQL syntax near 'FROM users WHERE ='admin' AND ='admin'' at line 1)
Session halted.
is it of course a buggy version ? they lost informations, why ?
i built up 3 shops, after a while they got all the same problem. before that they run fine...
thomas
|
|
|
 |
RonB
|
| Posted: 01/07/2003, 2:48 PM |
|
You didn't state what language you are using. In PHP the login procedure can be found in the common.php file. The only way this can go wrong is when you altered the site and re published. The sql for the login is hardcoded in the common.php file so that would never mess up 'after a while'. Looks like CCS messes up the common.php file wich you then publish. The missing bits in the sql are the fields of your login table.
Go to common.php in CCS and check the CCLoginUser function (almost at the bottom of the page). If you imported the site from a previous CSS 1.0.7 version go to the common.php file in CCS and remove all code. Then regenerate the common page.
Ron
|
|
|
|
|
