| upgrade from 3.07 to 3.09 fails [message #187548] |
Thu, 16 August 2018 13:42  |
 |
zbob
Messages: 19
Registered: February 2013
Karma:
|
Junior Member |
|
|
I am running FudForm on Windows server 2012 R2 using MS SQL Server 2014. This site has been active for about 6 years. I always seem to have issues upgrading. I suppose it may have to do with using Windows and MS SQL Server but they are supported.. correct?
Anyway see error below. Its a database issue. So I tried to run the upgrade checking "Skip database changes", and got same result.
Thanks for any assistance that can be provided.
UPDATE: I was able to get the site up and running again by going into admin and running the "Forum Consistency" tool. Also when checking system info it said the version was 3.09. So it seems the upgrade worked even though it showed those errors. Not sure how critical those DB changes are. Anyone know?
Thanks
Bob
===============================
Step 2: Perform upgrade
Beginning to decompress the archive.
Finished decompressing the archive.
File upgrade completed.
Checking SQL permissions.
Add new database index fud30_karma_i_mu to table fud30_karma_rate_track(msg_id,user_id).
Fatal error: Uncaught exception 'Exception' with message '1913: [Microsoft][SQL Server Native Client 11.0][SQL Server]The operation failed because an index or statistics with name 'fud30_karma_i_mu' already exists on table 'fud30_karma_rate_track'. @ CREATE INDEX fud30_karma_i_mu ON fud30_karma_rate_track (msg_id,user_id)' in C:\inetpub\dhsforumtest\upgrade.php:178 Stack trace: #0 C:\inetpub\dhsforumtest\sql\sqlsrv\db.inc(97): fud_sql_error_handler('CREATE INDEX f...', '[Microsoft][SQL...', 1913, '12.00.4100') #1 C:\inetpub\dhsforumtest\include\dbadmin.inc(645): q('CREATE INDEX f...') #2 C:\inetpub\dhsforumtest\upgrade.php(961): create_index('fud30_karma_rat...', 'fud30_karma_i_m...', 0, 'msg_id,user_id') #3 {main} thrown in C:\inetpub\dhsforumtest\upgrade.php on line 178
[Updated on: Thu, 16 August 2018 15:06] Report message to a moderator |
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]