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 #185568 is a reply to message #185567]

Fri, 11 April 2014 23:31

smcgee

Messages: 13
Registered: May 2013

Karma:

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

[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:17:51 GMT 2024

Total time taken to generate the page: 0.07730 seconds