coppermine-gallery.com/forum

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Miscellaneous => Topic started by: Mr_Anderson on November 23, 2005, 10:07:23 PM

Title: Database convertion
Post by: Mr_Anderson 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?
Title: Re: Database convertion
Post by: kegobeer on November 23, 2005, 10:18:01 PM
What difficulties?
Title: Re: Database convertion
Post by: Mr_Anderson on November 23, 2005, 10:19:04 PM
That is what I get: "There was an error while processing a database query"
Title: Re: Database convertion
Post by: kegobeer 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.
Title: Re: Database convertion
Post by: Mr_Anderson on November 23, 2005, 10:33:53 PM
For some reason it's started to work, however, instead of pictures I get empty rectangles
Title: Re: Database convertion
Post by: Joachim Müller on November 23, 2005, 11:18:05 PM
link?
Title: Re: Database convertion
Post by: Mr_Anderson on November 24, 2005, 06:20:00 AM
http://...IP.../photoAlbum/index.php
Title: Re: Database convertion
Post by: kegobeer on November 24, 2005, 03:32:17 PM
Supply a real link, not a dummy placeholder.
Title: Re: Database convertion
Post by: Mr_Anderson on November 24, 2005, 08:33:37 PM
http://www.demitch.net/foto/index.php
Title: Re: Database convertion
Post by: Nibbler 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.
Title: Re: Database convertion
Post by: Mr_Anderson on November 24, 2005, 09:10:18 PM
hosting it myself
Title: Re: Database convertion
Post by: Nibbler on November 24, 2005, 09:18:57 PM
That's convenient then. :)
Title: Re: Database convertion
Post by: Mr_Anderson on November 24, 2005, 09:21:05 PM
but what do I do?  ::)
Title: Re: Database convertion
Post by: Nibbler on November 24, 2005, 09:25:06 PM
Google it. Looks like a M$ issue.
Title: Re: Database convertion
Post by: Mr_Anderson on November 24, 2005, 10:15:14 PM
Installed cpg142 from scratch, copied old DB ... and it works. Dunno the reason  :)