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: Database convertion  (Read 6574 times)

0 Members and 1 Guest are viewing this topic.

Mr_Anderson

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 29
Database convertion
« on: November 23, 2005, 10:07:23 pm »

I used MySQL 4.0, however, after upgrading MySQL to 4.1 I have ran into difficulties with database.
How do I convert the old database into new one?
Can anyone help on this one?
« Last Edit: November 24, 2005, 10:20:06 pm by Nibbler »
Logged

kegobeer

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 4637
  • Beer - it does a body good!
    • The Kazebeer Family Website
Re: Database convertion
« Reply #1 on: November 23, 2005, 10:18:01 pm »

What difficulties?
Logged
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots

Mr_Anderson

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 29
Re: Database convertion
« Reply #2 on: November 23, 2005, 10:19:04 pm »

That is what I get: "There was an error while processing a database query"
Logged

kegobeer

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 4637
  • Beer - it does a body good!
    • The Kazebeer Family Website
Re: Database convertion
« Reply #3 on: November 23, 2005, 10:20:32 pm »

Enable debug mode and post the actual SQL error message.  If you can't access your config page, use phpMyAdmin to set debug_mode to 1 in the cpg_config table.
Logged
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots

Mr_Anderson

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 29
Re: Database convertion
« Reply #4 on: November 23, 2005, 10:33:53 pm »

For some reason it's started to work, however, instead of pictures I get empty rectangles
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Database convertion
« Reply #5 on: November 23, 2005, 11:18:05 pm »

link?
Logged

Mr_Anderson

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 29
Re: Database convertion
« Reply #6 on: November 24, 2005, 06:20:00 am »

http://...IP.../photoAlbum/index.php
Logged

kegobeer

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 4637
  • Beer - it does a body good!
    • The Kazebeer Family Website
Re: Database convertion
« Reply #7 on: November 24, 2005, 03:32:17 pm »

Supply a real link, not a dummy placeholder.
Logged
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots

Mr_Anderson

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 29
Re: Database convertion
« Reply #8 on: November 24, 2005, 08:33:37 pm »

« Last Edit: November 24, 2005, 10:15:47 pm by Mr_Anderson »
Logged

Nibbler

  • Guest
Re: Database convertion
« Reply #9 on: November 24, 2005, 09:09:18 pm »

"Logon failure: user account restriction. Possible reasons are blank passwords not allowed, logon hour restrictions, or a policy restriction has been enforced."

I suggest you contact your host.
Logged

Mr_Anderson

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 29
Re: Database convertion
« Reply #10 on: November 24, 2005, 09:10:18 pm »

hosting it myself
Logged

Nibbler

  • Guest
Re: Database convertion
« Reply #11 on: November 24, 2005, 09:18:57 pm »

That's convenient then. :)
Logged

Mr_Anderson

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 29
Re: Database convertion
« Reply #12 on: November 24, 2005, 09:21:05 pm »

but what do I do?  ::)
Logged

Nibbler

  • Guest
Re: Database convertion
« Reply #13 on: November 24, 2005, 09:25:06 pm »

Google it. Looks like a M$ issue.
Logged

Mr_Anderson

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 29
Re: Database convertion
« Reply #14 on: November 24, 2005, 10:15:14 pm »

Installed cpg142 from scratch, copied old DB ... and it works. Dunno the reason  :)
Logged
Pages: [1]   Go Up
 

Page created in 0.021 seconds with 20 queries.