SQL query error updating 3.4

InstantASP Community Forums

Home

Members

Calendar

Who's On

Welcome Guest ( Login | Register )

SQL query error updating 3.4 -...

Rate Topic

Display Mode

Topic Options

Author

Message

peewee

Posted 11/05/2007 07:08:50

Forum Newbie

Group: Forum Members
Last Login: 11/05/2007 07:00:10
Posts: 1, Visits: 2

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

Paul

Post #12754

Carlos Muniz

Posted 11/05/2007 14:17:35

Support Supremo

Group: Customers
Last Login: 09/09/2008 21:04:36
Posts: 568, Visits: 2,505

peewee (5/11/2007)

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

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.

Post #12756

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 (0 guests, 0 members, 0 anonymous members)

No members currently viewing this topic.

Forum Moderators: Ryan Healey, Mark Christianson, Bare, James Trott

Permissions

All times are GMT, Time now is 11:04pm