MySQL querry Error w/ login.php

[ISBB]

cant get past step 2.1 in the instruction manual...

Have set up numerous CPG gallerys but have never ran across this issue... am using cpg135 and doing a standalone install.. the tables are created in the db and all that is fine but as soon as you try to access login.php i get a

Fatal error :
There was an error while processing a database query

Ideas?

[Nibbler]

Enable debug mode and post the mysql error message that you receive.

[ISBB]

Cant get to admin panel or anything of the such...  even index.php and all that fun jazz results in the same error

[Nibbler]

Then you'll need to find your prefix_config table in your database using phpmyadmin and set debug_mode to 1

[ISBB]

Code Select Expand

While executing query "SELECT user_id, username as user_name, user_level FROM `ddr`.phpbb_users WHERE user_id='0' AND user_password='*' AND user_active='1'" on Resource id #6

mySQL error:


something tells me that one of the files i uploaded has some stuff from another install of CPG... im thinking my best bet would be to redownload and re-install..

[ISBB]

the user_level FROM 'ddr'.phpbb_users gives it away... thats another cpg install of mine... i think some stuff may have got cross contaminated..

[ISBB]

fresh files worked... thx fer the help..