Issue w/ Most Recent Build

More
2 years 8 months ago - 2 years 8 months ago #118206 by kripp88
kripp88 created the topic: Issue w/ Most Recent Build
When I try to access my admin panel this morning, I am getting the below error. It appears that it is trying to enter a value greater than 255 characters into the 'stg_value' column in lime_global_settings. I am not trying to actually install the latest build, it is just checking for updates I guess on the login page. Do I need to alter the column to be a larger size since it is only varchar(255)?

I am on 2.00+ 130802 using SQL Server

CDbCommand failed to execute the SQL statement: SQLSTATE[22001]: [Microsoft][SQL Server Native Client 11.0][SQL Server]String or binary data would be truncated.. The SQL statement executed was: UPDATE [dbo].[lime_settings_global] SET [stg_name]=:yp0, [stg_value]=:yp1 WHERE [dbo].[lime_settings_global].[stg_name]='updateversions'. Bound with :yp0='updateversions', :yp1='{"master":{"build":"150310","versionnumber":"2.05+","branch":"master","created":"2015-03-10 12:56:31"},"2.05":{"build":"131125","versionnumber":"2.05RC7","branch":"2.05","created":"2013-11-25 15:11:35"},"2.06":{"build":"150305","versionnumber":"2.06alpha1","branch":"2.06","created":"2015-03-05 12:13:07"}}'

Thanks,
Kyle
Last Edit: 2 years 8 months ago by kripp88.

Please Log in to join the conversation.

More
2 years 8 months ago #118208 by kripp88
kripp88 replied the topic: Issue w/ Most Recent Build
Ok nvm I fixed it by running the below on SQL Server

ALTER TABLE LIME_SETTINGS_GLOBAL
ALTER COLUMN [STG_VALUE] VARCHAR(500)

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!