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

Upgrade from 3.0.4 to 3.0.5 fails [message #185567]

Fri, 11 April 2014 23:05

smcgee

Messages: 13
Registered: May 2013

Karma: 1

Junior Member

I have run the 3.0.5 upgrade.php script and I get the following error:

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 useragent in table fud30_ses.

Fatal error: Uncaught exception 'Exception' with message '102: [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'CHANGE'. @ ALTER TABLE fud30_ses CHANGE useragent useragent VARCHAR(64)' 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_ses', 'useragent', Array) #3 {main} thrown in C:\inetpub\wwwroot\refstat\forum\upgrade.php on line 170

So now, my forum is not accessible. When I try to open the forum I just get a blank page that says "The service is unavailable."

I'm running Microsoft SQL Server 2008 as the database. The operating system is Windows Server 2008 R2 Enterprise.

I don't know what to do now. Any ideas?

Report message to a moderator

Re: Upgrade from 3.0.4 to 3.0.5 fails [message #185568 is a reply to message #185567]

Fri, 11 April 2014 23:31

smcgee

Messages: 13
Registered: May 2013

Karma: 1

Junior Member

So from looking at the error message I posted above, it appears that the upgrade is trying to alter the data type to varchar(64) for the field named useragent in the table named fud30_ses.

I dug into the SQL side of this to see what I could find. Currently, for the fud30_ses table, the data type for the useragent field is set to varchar(32).

I thought I might try to change the data type manually in SQL Server Management Studio, but it does not have a data type of varchar(64). But it does have a data type of varchar(MAX) that can be selected. So I chose that and tried to save the table, but SQL Server wouldn't let me save the table. It said the table first had to be deleted and recreated.

I wonder if the data type for the useragent field of the fud30_ses table is the actual problem, or if it might be something else.

Any ideas?

Thanks,
Scott

Report message to a moderator

Re: Upgrade from 3.0.4 to 3.0.5 fails [message #185569 is a reply to message #185568]

Sat, 12 April 2014 06:56

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

Looks like a syntax error in the MS-SQL Driver. Syntax should be:

ALTER TABLE fud30_ses ALTER COLUMN useragent useragent VARCHAR(64);

instead of:

ALTER TABLE fud30_ses CHANGE useragent useragent VARCHAR(64);

You can change it manually on the DB and rerun the upgrade script.

Report message to a moderator

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

Report message to a moderator

Re: Upgrade from 3.0.4 to 3.0.5 fails [message #185611 is a reply to message #185579]

Mon, 21 April 2014 10:43

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

Have you managed to execute the SQL statements manually to bring your forum on-line?

Report message to a moderator

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

Re: Upgrade from 3.0.4 to 3.0.5 fails [message #186175 is a reply to message #186067]

Wed, 18 June 2014 16:53

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

Should be fixed in FUDforum 3.0.6RC2.
Try to 3.0.6RC2 instead.

Report message to a moderator

Re: Upgrade from 3.0.4 to 3.0.5 fails [message #186480 is a reply to message #186175]

Wed, 20 August 2014 17:33

zbob

Messages: 19
Registered: February 2013

Karma: 0

Junior Member

Hi naudefj, I tried that also and it gave same errors. BTW, we are looking for a consultant to assist us with this and some issues we are having. Would you be interested? If so please PM me.

Thanks
Bob

Report message to a moderator

Re: Upgrade from 3.0.4 to 3.0.5 fails [message #186579 is a reply to message #186480]

Fri, 03 October 2014 18:33

cpreston

Messages: 160
Registered: July 2012
Location: Oceanside

Karma: 6

Senior Member

Did you ever find a guy? I may have a guy. Email me at curtis at truthinit dot com.

Report message to a moderator

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 May 18 11:24:02 GMT 2024

Total time taken to generate the page: 0.03109 seconds