forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 permissions => Topic started by: markblewis32177 on December 25, 2015, 06:06:05 pm

Title: login page - database error
Post by: markblewis32177 on December 25, 2015, 06:06:05 pm
total newbie to CPG & i know nothing, nothing.

Coppermine version: 1.5.34 was working fine up until a month ago.
all functions worked & no problems admin gallery.
then went to login for admin work & login screen showed
what i call a system crash screen: [image attached]

so solution must lie thru fixing code in some config file.
have no clue, and thought reading all install doc's would
not result in solution.

i appreciate your support.

what a day to post CPG prob's!!! Happy 2016 Year!

marklewis


Title: Re: login page - database error
Post by: Αndré on January 08, 2016, 03:40:46 pm
Do you still need help or where you able to login after 30 minutes?
Title: Re: login page - database error
Post by: markblewis32177 on February 08, 2016, 10:34:12 pm
Yes, still need HELP.

No, not able to login 30 minutes later, or ever.
page stays same.

screenshot of webpage attached.

marklewis
Title: Re: login page - database error
Post by: Αndré on February 10, 2016, 12:38:25 pm
Please post a link to your gallery. In the meantime, try to flush the ban table in the MySQL database with a tool like phpMyAdmin.
Title: Re: login page - database error
Post by: markblewis32177 on February 12, 2016, 04:36:04 pm
gallery link: http://www.gainesvillehog.org/photos/index.php

not sure what a "ban table" is, but assuming if i get into MySQL it will be obvious. would be looking for database table in gallery MySQL tagged "ban."

marklewis
Title: Re: login page - database error
Post by: markblewis32177 on February 12, 2016, 05:39:59 pm
just as i thought, "ban" table was clearly obvious.

cpg_banned has been Empty>TRUNCATE cpg_banned>OK, which i figure means "flush."

however, not change accessing app. still have Error screen .



Title: Re: login page - database error
Post by: phill104 on February 12, 2016, 11:09:26 pm
could you try an alternative browser and see if you are getting the same error
Title: Re: login page - database error
Post by: markblewis32177 on February 12, 2016, 11:34:18 pm
my standard browser is Chrome.
that's browser i've been using to report these problems.

just loaded Firefox & result same: Database Error screen & app not accepting administrator login.

also, used IE 11 to access photo page. same result as Chrome & Firefox: Database Error screen & app not accepting administrator login.

what do you see when you access gainesvillehog.org/photos?
Title: Re: login page - database error
Post by: gmc on February 13, 2016, 04:05:16 am
I get the database error message, but indicates gallery is offline (rather than ban message)
Title: Re: login page - database error
Post by: ron4mac on February 13, 2016, 02:44:49 pm
It is possible that your host changed the default version of PHP to one that is not compatible with your current version of Coppermine Photo Gallery.
Title: Re: Re: login page - database error
Post by: lurkalot on February 13, 2016, 10:31:01 pm
It is possible that your host changed the default version of PHP to one that is not compatible with your current version of Coppermine Photo Gallery.

 Possible, what version is it?  Looking at the source code, at the top it says,

SVN version info:
  Coppermine version: 1.4.25

And at the bottom it says, <!--Coppermine Photo Gallery 1.5.34 (stable)-->
Title: Re: login page - database error
Post by: markblewis32177 on February 16, 2016, 03:23:52 am
from hosting Versions:
   PHP   5.2.17,
   MySQL 5.5.42,
   running on Apache 2.2.31

don't know how to determine CPG version.
oh, already know it's CPG 1.4.25

looks pretty old.
need to upgrade to CPG 1.5.34 & see what happens?

thanx for all sleuthing.

marklewis
Title: Re: login page - database error
Post by: markblewis32177 on February 16, 2016, 03:32:25 am
Download link indicates 1.5.40 as available version.
is this stable for release to a newbie f/upgrade?
Title: Re: login page - database error
Post by: gmc on February 16, 2016, 04:55:45 am
1.5.40 is the recommended upgrade...
If you are running 1.4.x, it will certainly have issues with PHP V5.

I see signs of 1.5.34 - which you also mentioned in your first post. This should work fine with PHP V5.

I don't see any harm in upgrading, and will provide a known base.

Title: Re: login page - database error
Post by: markblewis32177 on February 17, 2016, 02:47:04 am
So ... got bold with trying to get this cpg back online.
since upgrading seemed to be option, i thought why not run "upgrade" on current version 1.5.34?
in browser went to cpg folder & replaced index.php with install.php. mssg return that install had been run & locked. to run again, need to delete a file.
using ftp app, deleted specified file, then went back to cpg folder & ran install.php.
using classic cpg installation, filled in textboxes, then clicked Next, or whatever, and mssg returned [see attached]. this is only topof mssg dialog, install portion not shown for security purposes.

original install had table prefix cpg_
to avoid creating another cpg install, used same prefix cpg_ & error mssg appeared.
now browser cpg link takes to installation routine.

suggestions?


Title: Re: login page - database error
Post by: gmc on February 17, 2016, 02:57:53 am
I'd suggest following the 'upgrade' instructions - which do not include replacing index.php with install.php, running install.php or deleting lock files...
Since you replaced index.php with install.php - I'd expect your cpg link would now take you into installer.

See instructions at http://documentation.coppermine-gallery.net/en/upgrading.htm#upgrade_any (http://documentation.coppermine-gallery.net/en/upgrading.htm#upgrade_any)
If this is the first time running a 1.5.x upgrade - see the sections about upgrading from 1.4.x as well...
(just a little bit down from the upgrade steps or at http://documentation.coppermine-gallery.net/en/upgrading.htm#upgrade_14 (http://documentation.coppermine-gallery.net/en/upgrading.htm#upgrade_14)