|
|
|
Re: Upgrade from 3.0.4 to 3.0.5 fails [message #185579 is a reply to message #185569] |
Mon, 14 April 2014 23:08 |
|
smcgee
Messages: 13 Registered: May 2013
Karma: 1
|
Junior Member |
|
|
Thanks for the information.
I tried running the command exactly as you specified: ALTER TABLE fud30_ses ALTER COLUMN useragent useragent VARCHAR(64);
But it reported a syntax error. It didn't like the second useragent. So this is what I was able to successfully run: ALTER TABLE fud30_ses ALTER COLUMN useragent VARCHAR(64);
I then re-ran upgrade.php, and got this SQL error message:
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).
Alter database column reset_key in table fud30_users.
Fatal error: Uncaught exception 'Exception' with message '102: [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'CHANGE'. @ ALTER TABLE fud30_users CHANGE reset_key reset_key VARCHAR(32)' in C:\inetpub\wwwroot\refstat\forum\upgrade.php:170 Stack trace: #0 C:\FUDforum\sql\sqlsrv\db.inc(97): fud_sql_error_handler('ALTER TABLE fud...', '[Microsoft][SQL...', 102, '10.00.4067') #1 C:\FUDforum\include\dbadmin.inc(855): q('ALTER TABLE fud...') #2 C:\inetpub\wwwroot\refstat\forum\upgrade.php(916): alter_column('fud30_users', 'reset_key', Array) #3 {main} thrown in C:\inetpub\wwwroot\refstat\forum\upgrade.php on line 170
I then looked at the fud30_users table, and the reset_key field was already set to VARCHAR(32).
So, there appears to be the following problem in the 3.0.4-to-3.0.5 upgrade.php script:
--It appears to be using the incorrect SQL syntax. It is using CHANGE instead of ALTER COLUMN, and it is specifying the column name twice, instead of just once, which is what SQL Server 2008 wants.
So the upgrade has not been successful, and my forum is still not available. Ideas?
Thanks much!
Scott
|
|
|
|
Re: Upgrade from 3.0.4 to 3.0.5 fails [message #186067 is a reply to message #185611] |
Mon, 09 June 2014 14:51 |
|
zbob
Messages: 19 Registered: February 2013
Karma: 0
|
Junior Member |
|
|
Hello, I am having similar problems as the original poster upgrading from 3.0.4 to 3.0.5. Using database SQL Server 2008 R2 Express and Windows server 2008.
Here is the error I am getting:
Alter database column word in table fud30_search.
Fatal error: Uncaught exception 'Exception' with message '102: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near 'CHANGE'. @ ALTER TABLE fud30_search CHANGE word word VARCHAR(50) NOT NULL' in C:\inetpub\dhsforum\upgrade.php:170 Stack trace: #0 C:\inetpub\dhsforum\sql\sqlsrv\db.inc(97): fud_sql_error_handler('ALTER TABLE fud...', '[Microsoft][SQL...', 102, '10.50.1600') #1 C:\inetpub\dhsforum\include\dbadmin.inc(855): q('ALTER TABLE fud...') #2 C:\inetpub\dhsforum\upgrade.php(916): alter_column('fud30_search', 'word', Array) #3 {main} thrown in C:\inetpub\dhsforum\upgrade.php on line 170
It looks like some of the SQL statements are not in correct syntax for MS SQL Server.
Is SQL Server no longer supported?
Is it possible to alter the SQL statements in the upgrade.php to try to get it to work?
Thanks for the assistance.
Bob
[Updated on: Mon, 09 June 2014 15:06] Report message to a moderator
|
|
|
|
|
|