I'm having trouble recreating my database on my new host. I updated my gallery on my old host and dumped the data into an sql file. I have uploaded all my pictures and recreated the gallery (both galleries where v1.4.9) but I get the following error code when trying to run the sql statement on my new host.
#1136 Column count doesn't match row count at row 1
My guess is this has something to do with a difference in the number of columns in the table on my db and the number of values I have in my sql string for that particular line. I got this sql statement from a dump of my old db that was updated to v1.4.9 though. Why am I getting this error and what can I do to fix it? Thanks.
A fresh install of 1.4.9 won't have the same database structure as one that has been updated from previous versions. You should import both the data and structure from the backup.
I see, that would mean that I need to also install the files/sub directories from v1.1 or whatever I was using before. Run the sql statement. Then go through the upgrade process?
Nothing to do with files. Just dump the data and structure from the database and then import them together.
I think I understand but perhaps I'm a little slow. Forgive me. When you say structure, what are you refering to? I know that when I installed v1.4.9 it created tables in my db starting with cpg149. All the tables/data in my dump file start with cpg11d. Do I need to dump my files on the new db that begin with cpg149 and then run the sql statement to recreate the db? Should I blow away the gallery on my new host, run the sql statement then re-install the gallery?
Follow the moving instructions at http://coppermine-gallery.net/demo/cpg14x/docs/faq.htm#moveGallery
Then update the gallery as normal once it has been moved.
I now get an error message when trying to access the gallery
While executing query "SELECT * FROM cpg149_config" on 0
mySQL error: Table 'ws40.cpg149_config' doesn't exist
You need to make sure include/config.inc.php contains the correct information to access the db coppermine is in.
Thanks. It's working now.