Noticed that there is no primary key defined in the table FORUM_SUBSCRIPTIONS in MS-SQL databases. This doesn't matter until you try to migrate the MS-SQL database to MySQL.
I agree in principle but... All other tables has a primary key defined - even in MS-SQL. And it is required that tables with auto-increment fields have one in MySql.
My problem appeared when I used a script to migrate the database from MS-SQL to MySQL. The only table that could not be moved was _SUBSCRIPTIONS. Not a big issue. But next time someone tries the same manoeuvre it will fail. /Åke S
Our recomendation when migrating databases is to create the tables using the script supplied with the forum and then import only your data from your existing database, otherwise problems will occur.
Topic Locked
Posted - 15 February 2004 : 18:19:14
