forum.coppermine-gallery.net

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

Code: [Select]

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