forum.coppermine-gallery.net

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  :)