[Sadie Frost]

Originally Posted by Alien

Hey!

I went over the table structure carefully, and I have everything you showed above in your table structure EXCEPT for this in the quotes table:

date => INT (10) UNSIGNED NOT NULL DEFAULT 0
views => INT (10) UNSIGNED NOT NULL DEFAULT 0
categoryid => INT (10) UNSIGNED DEFAULT NULL
postid => INT (10) UNSIGNED DEFAULT NULL

I upgraded from the 3.5 version (version 2.1 it says in the Product Manager?) on 5 boards (lol), and it worked fine on 4 of them. The fifth though I seem to be having the same problem as Alien did above (page 9/10 of this thread).

I tried to add the missing fields to the tables but I get this error in phpmyadmin:

ALTER TABLE `quotes` ADD `date` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
ADD `views` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
ADD `categoryid` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
ADD `postid` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0'

MySQL said:

#1060 - Duplicate column name 'quoteid'

I am using MySql version 4.1.21 there. I also get the same errors if I try to use the latest version from the 3.5 version thread. I also did choose the allow overwrite.

Does anyone have any ideas for me? Is it jsut a MySQL version problem?

Also I know that I read this somewhere but I just read through the thread again and couldn't find it, so I'm sorry. But all my dates on my quotes are "12-31-1969"? Is that just because I've just installed the new version?

Thanks