Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Database convertion  (Read 5935 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.02 seconds with 19 queries.