Welcome to the LimeSurvey Community Forum

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

New Installation - Could Not Activate Survey

More
3 hours 4 minutes ago #274590 by markwb
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 );

Please Log in to join the conversation.

Moderators: holchtpartner

Lime-years ahead

Online-surveys for every purse and purpose