Database convertion Database convertion
 

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

Main Menu

Database convertion

Started by Mr_Anderson, November 23, 2005, 10:07:23 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Mr_Anderson

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?

kegobeer

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

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

kegobeer

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.
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

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

Joachim Müller


Mr_Anderson

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

kegobeer

Supply a real link, not a dummy placeholder.
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

#8

Nibbler

"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.

Mr_Anderson


Nibbler


Mr_Anderson


Nibbler

Google it. Looks like a M$ issue.

Mr_Anderson

Installed cpg142 from scratch, copied old DB ... and it works. Dunno the reason  :)