Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: login page - database error  (Read 21128 times)

0 Members and 1 Guest are viewing this topic.

markblewis32177

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
login page - database error
« 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


Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: login page - database error
« Reply #1 on: January 08, 2016, 03:40:46 pm »

Do you still need help or where you able to login after 30 minutes?
Logged

markblewis32177

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: login page - database error
« Reply #2 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
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: login page - database error
« Reply #3 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.
Logged

markblewis32177

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: login page - database error
« Reply #4 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
Logged

markblewis32177

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: login page - database error
« Reply #5 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 .



Logged

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4885
    • Windsurf.me
Re: login page - database error
« Reply #6 on: February 12, 2016, 11:09:26 pm »

could you try an alternative browser and see if you are getting the same error
Logged
It is a mistake to think you can solve any major problems just with potatoes.

markblewis32177

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: login page - database error
« Reply #7 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?
Logged

gmc

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 785
    • GMC Design Photo Gallery
Re: login page - database error
« Reply #8 on: February 13, 2016, 04:05:16 am »

I get the database error message, but indicates gallery is offline (rather than ban message)
Logged
Thanks!
Greg
My Coppermine Gallery
Need a web hosting account? See my gallery for an offer for CPG Forum users.
Send me money

ron4mac

  • Administrator
  • Coppermine addict
  • *****
  • Country: us
  • Offline Offline
  • Posts: 2026
Re: login page - database error
« Reply #9 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.
Logged

lurkalot

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 947
  • +Tinyportal Support team.
Re: Re: login page - database error
« Reply #10 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)-->
Logged
Running SMF 2.1.4  / Tinyportal 3.0.0, bridged with Coppermine 1.6.25, plus cpmfetch 2.0.0

markblewis32177

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: login page - database error
« Reply #11 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
Logged

markblewis32177

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: login page - database error
« Reply #12 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?
Logged

gmc

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 785
    • GMC Design Photo Gallery
Re: login page - database error
« Reply #13 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.

Logged
Thanks!
Greg
My Coppermine Gallery
Need a web hosting account? See my gallery for an offer for CPG Forum users.
Send me money

markblewis32177

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: login page - database error
« Reply #14 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?


Logged

gmc

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 785
    • GMC Design Photo Gallery
Re: login page - database error
« Reply #15 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
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

Logged
Thanks!
Greg
My Coppermine Gallery
Need a web hosting account? See my gallery for an offer for CPG Forum users.
Send me money
Pages: [1]   Go Up
 

Page created in 0.025 seconds with 20 queries.