LimeSurvey version:
LimeSurvey Community Edition
Version 6.17.10+260622
When I attempted to activate my first survey:
CDbCommand failed to execute the SQL statement: SQLSTATE[42704]: Undefined object: 7 ERROR: type "string" does not exist at character 81. The SQL statement executed was: CREATE TABLE "lime_survey_864997" ( "id" serial NOT NULL PRIMARY KEY, "token" string(36), "submitdate" timestamp, "lastpage" integer, "startlanguage" string(20) NOT NULL, "seed" string(31), "startdate" timestamp NOT NULL, "datestamp" timestamp NOT NULL, "864997X2X18NM01" string(5), "864997X2X18NM02" string(5), "864997X2X18NM03" string(5), "864997X1X1SQ001" string(5), "864997X1X1SQ002" string(5), "864997X1X1SQ003" string(5), "864997X1X5SQ001" string(5), "864997X1X5SQ002" string(5), "864997X1X11SQ001" string(5), "864997X1X11SQ002" string(5), "864997X1X11SQ003" string(5) )
postgres=# SELECT version();
version
PostgreSQL 18.4 (Ubuntu 18.4-1.pgdg24.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 13.3.0-6ubuntu2~24.04.1) 13.3.0, 64-bit
(1 row)
I got around the problem with this (provided by Gemini LLM):
=14pxCREATE=14px =14pxOR=14px =14pxREPLACE=14px =14pxFUNCTION=14px =14pxstring_in=14px(=14pxcstring=14px) =14pxRETURNS=14px =14pxstring=14px =14pxAS=14px =14px'varcharin'=14px =14pxLANGUAGE=14px internal =14pxIMMUTABLE=14px =14pxSTRICT=14px;
=14pxCREATE=14px =14pxOR=14px =14pxREPLACE=14px =14pxFUNCTION=14px =14pxstring_out=14px(=14pxstring=14px) =14pxRETURNS=14px =14pxcstring=14px =14pxAS=14px =14px'varcharout'=14px =14pxLANGUAGE=14px internal =14pxIMMUTABLE=14px =14pxSTRICT=14px;
=14pxCREATE=14px =14pxOR=14px =14pxREPLACE=14px =14pxFUNCTION=14px string_mod_in(cstring[]) =14pxRETURNS=14px integer =14pxAS=14px =14px'varchartypmodin'=14px =14pxLANGUAGE=14px internal =14pxIMMUTABLE=14px =14pxSTRICT=14px;
=14pxCREATE=14px =14pxOR=14px =14pxREPLACE=14px =14pxFUNCTION=14px =14pxstring_mod_out=14px(=14pxinteger=14px) =14pxRETURNS=14px =14pxcstring=14px =14pxAS=14px =14px'varchartypmodout'=14px =14pxLANGUAGE=14px internal =14pxIMMUTABLE=14px =14pxSTRICT=14px;
=14pxCREATE=14px =14pxTYPE=14px string ( =14pxINPUT=14px = string_in, =14pxOUTPUT=14px = string_out, TYPMOD_IN = string_mod_in, TYPMOD_OUT = string_mod_out, =14pxLIKE=14px = varchar );