coppermine-gallery.com/forum

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Installation & Setup => Topic started by: ISBB on March 13, 2006, 02:13:20 AM

Title: MySQL querry Error w/ login.php
Post by: ISBB on March 13, 2006, 02:13:20 AM
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?
Title: Re: MySQL querry Error w/ login.php
Post by: Nibbler on March 13, 2006, 02:15:33 AM
Enable debug mode and post the mysql error message that you receive.
Title: Re: MySQL querry Error w/ login.php
Post by: ISBB on March 13, 2006, 02:17:01 AM
Cant get to admin panel or anything of the such...  even index.php and all that fun jazz results in the same error
Title: Re: MySQL querry Error w/ login.php
Post by: Nibbler on March 13, 2006, 02:23:02 AM
Then you'll need to find your prefix_config table in your database using phpmyadmin and set debug_mode to 1
Title: Re: MySQL querry Error w/ login.php
Post by: ISBB on March 13, 2006, 02:26:50 AM
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.. :D
Title: Re: MySQL querry Error w/ login.php
Post by: ISBB on March 13, 2006, 02:27:51 AM
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.. :D
Title: Re: MySQL querry Error w/ login.php
Post by: ISBB on March 13, 2006, 02:36:46 AM
fresh files worked... thx fer the help..  ;D