FUDforum: FUDforum Installation Issues » Upgrade from 3.0.4 to 3.0.5 fails

Home » FUDforum » FUDforum Installation Issues » Upgrade from 3.0.4 to 3.0.5 fails

Show: Today's Messages :: Polls :: Message Navigator

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:

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

Report message to a moderator

[Message index]

		Upgrade from 3.0.4 to 3.0.5 fails By: smcgee on Fri, 11 April 2014 23:05
		Re: Upgrade from 3.0.4 to 3.0.5 fails By: smcgee on Fri, 11 April 2014 23:31
		Re: Upgrade from 3.0.4 to 3.0.5 fails By: naudefj on Sat, 12 April 2014 06:56
		Re: Upgrade from 3.0.4 to 3.0.5 fails By: smcgee on Mon, 14 April 2014 23:08
		Re: Upgrade from 3.0.4 to 3.0.5 fails By: naudefj on Mon, 21 April 2014 10:43
		Re: Upgrade from 3.0.4 to 3.0.5 fails By: zbob on Mon, 09 June 2014 14:51
		Re: Upgrade from 3.0.4 to 3.0.5 fails By: naudefj on Wed, 18 June 2014 16:53
		Re: Upgrade from 3.0.4 to 3.0.5 fails By: zbob on Wed, 20 August 2014 17:33
		Re: Upgrade from 3.0.4 to 3.0.5 fails By: cpreston on Fri, 03 October 2014 18:33

Previous Topic:	Is FUDforum2go still viable
Next Topic:	Connecting to non-localhost MySQL server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 28 23:16:17 GMT 2024

Total time taken to generate the page: 0.05498 seconds