Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Issue w/ Most Recent Build

  • kripp88
  • kripp88's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
9 years 1 week ago - 9 years 1 week ago #118206 by kripp88
Issue w/ Most Recent Build was created by kripp88
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: 9 years 1 week ago by kripp88.
The topic has been locked.
  • kripp88
  • kripp88's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
9 years 1 week ago #118208 by kripp88
Replied by kripp88 on 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)
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose