RE: SQL query error updating 3.4 - 4.1.4

Carlos Muniz — Fri, 11 May 2007 14:17:35 GMT

[quote][b]peewee (5/11/2007)[/b][hr]I'm trying to update an existing 3.4 database to then latest 4.1.4 version.
When running the very first update script (3.4_to_4.0.sql) I get the following error in the results windows.

An explicit DROP INDEX is not allowed on index 'InstantForum_Forums.PK_InstantForum_Forums_ForumID'. It is being used for PRIMARY KEY constraint enforcement.

Couldn't find anything in the forum or KB about this, hope someone can help me.

Kind regards,
Niels van Dijk[/quote]

Hi Niels,

Could you please open a ticket in our ticketing system (my.instantasp.co.uk) and attach there your original database (version 3.4) so that I can investigate if there is any problem in the upgrade script or any bad data.

SQL query error updating 3.4 - 4.1.4

peewee — Fri, 11 May 2007 07:08:50 GMT

I'm trying to update an existing 3.4 database to then latest 4.1.4 version.
When running the very first update script (3.4_to_4.0.sql) I get the following error in the results windows.

Kind regards,
Niels van Dijk

InstantASP Community Forums / Old Forums / InstantForum.NET 3.x / Installation & Upgrades / SQL query error updating 3.4 - 4.1.4 / Latest Posts

RE: SQL query error updating 3.4 - 4.1.4

SQL query error updating 3.4 - 4.1.4