I was running 3.04 on one server when the site had to be moved to another. I copied all files to the new server, and edited config.php to reflect the connection to the new MySQL database.
I exported the sql database for all of the old site (other scripts besides wsn) and the other scripts work, but I get a blank page on wsnlinks.
When I run the SQL restore query, I get this error: #1060 - Duplicate column name 'title'
Do you know what might be causing this?
Also, I installed the newest version in a 2nd directory that works fine, so if the first install cannot be fixed, is there a way to copy the data from the old version sql to the new version tables?
It says you have two columns named 'title'. When you look at the file, do you see 'title' listed twice on lines?
Or maybe it's just talking oddly about an index, and you could take the index off the table.
Did you do the database move with phpmyadmin or the WSN mechanism? Back a year or two ago in the late 2.x and early 3.x I remember there were some issues with the WSN backup option, and I was advising people at the time to use phpmyadmin to be safe.
0/5
1
2
3
4
5
This thread is closed, so you cannot post a reply.
Comments on IMport database Problem
Beginner
Usergroup: Customer
Joined: May 28, 2003
Total Topics: 1
Total Comments: 1
Hi,
I was running 3.04 on one server when the site had to be moved to another. I copied all files to the new server, and edited config.php to reflect the connection to the new MySQL database.
I exported the sql database for all of the old site (other scripts besides wsn) and the other scripts work, but I get a blank page on wsnlinks.
When I run the SQL restore query, I get this error:
#1060 - Duplicate column name 'title'
Do you know what might be causing this?
Also, I installed the newest version in a 2nd directory that works fine, so if the first install cannot be fixed, is there a way to copy the data from the old version sql to the new version tables?
Thanks!
Bob
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
It says you have two columns named 'title'. When you look at the file, do you see 'title' listed twice on lines?
Or maybe it's just talking oddly about an index, and you could take the index off the table.
Did you do the database move with phpmyadmin or the WSN mechanism? Back a year or two ago in the late 2.x and early 3.x I remember there were some issues with the WSN backup option, and I was advising people at the time to use phpmyadmin to be safe.