| upgrade from 3.07 to 3.09 fails [message #187548] |
Thu, 16 August 2018 13:42  |
 |
zbob
Messages: 19
Registered: February 2013
Karma: 0
|
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 |
|
|
|
| Re: upgrade from 3.07 to 3.09 fails [message #187549 is a reply to message #187548] |
Thu, 16 August 2018 15:23  |
 |
naudefj
Messages: 3772
Registered: December 2004
Karma: 28
|
Senior Member
Administrator
Core Developer |
|
|
We mainly test with MySQL, not with MS-SQL, as we don't have access to a MS-SQL database server.
What happens if you re-run the upgrade? Same error?
Also, try to drop the index before running the upgrade script.
PS: Just saw your update. The SQL changes are minor. If you don't get errors, I woudn't worry too much about it.
[Updated on: Thu, 16 August 2018 15:27] Report message to a moderator |
|
|
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]