FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » FUDforum Installation Issues » Upgrade from 3.0.4 to 3.0.5 fails
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Upgrade from 3.0.4 to 3.0.5 fails [message #185567] Fri, 11 April 2014 19:05 Go to next message
smcgee is currently offline  smcgee   United States
Messages: 13
Registered: May 2013
Karma: 1
Junior Member
add to buddy list
ignore all messages by this user
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?


Re: Upgrade from 3.0.4 to 3.0.5 fails [message #185568 is a reply to message #185567] Fri, 11 April 2014 19:31 Go to previous messageGo to next message
smcgee is currently offline  smcgee   United States
Messages: 13
Registered: May 2013
Karma: 1
Junior Member
add to buddy list
ignore all messages by this user
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
Re: Upgrade from 3.0.4 to 3.0.5 fails [message #185569 is a reply to message #185568] Sat, 12 April 2014 02:56 Go to previous messageGo to next message
naudefj is currently offline  naudefj   
Messages: 3663
Registered: December 2004
Karma: 19
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
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.
Re: Upgrade from 3.0.4 to 3.0.5 fails [message #185579 is a reply to message #185569] Mon, 14 April 2014 19:08 Go to previous messageGo to next message
smcgee is currently offline  smcgee   United States
Messages: 13
Registered: May 2013
Karma: 1
Junior Member
add to buddy list
ignore all messages by this user
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 #185611 is a reply to message #185579] Mon, 21 April 2014 06:43 Go to previous messageGo to next message
naudefj is currently offline  naudefj   
Messages: 3663
Registered: December 2004
Karma: 19
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Have you managed to execute the SQL statements manually to bring your forum on-line?
Re: Upgrade from 3.0.4 to 3.0.5 fails [message #186067 is a reply to message #185611] Mon, 09 June 2014 10:51 Go to previous messageGo to next message
zbob is currently offline  zbob   United States
Messages: 14
Registered: February 2013
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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 11: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 12:53 Go to previous messageGo to next message
naudefj is currently offline  naudefj   
Messages: 3663
Registered: December 2004
Karma: 19
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Should be fixed in FUDforum 3.0.6RC2.
Try to 3.0.6RC2 instead.
Re: Upgrade from 3.0.4 to 3.0.5 fails [message #186480 is a reply to message #186175] Wed, 20 August 2014 13:33 Go to previous messageGo to next message
zbob is currently offline  zbob   United States
Messages: 14
Registered: February 2013
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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
Re: Upgrade from 3.0.4 to 3.0.5 fails [message #186579 is a reply to message #186480] Fri, 03 October 2014 14:33 Go to previous message
cpreston is currently offline  cpreston   United States
Messages: 160
Registered: June 2012
Location: Oceanside
Karma: 6
Senior Member
add to buddy list
ignore all messages by this user
Did you ever find a guy? I may have a guy. Email me at curtis at truthinit dot com.
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Is FUDforum2go still viable
Next Topic: Connecting to non-localhost MySQL server
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 16 10:48:39 EDT 2018

Total time taken to generate the page: 0.00786 seconds