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 #186067 is a reply to message #185611]

Mon, 09 June 2014 14:51

zbob

Messages: 19
Registered: February 2013

Karma:

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

[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: Wed Nov 27 10:10:17 GMT 2024

Total time taken to generate the page: 0.07553 seconds