2026/06/17 16:23:35 [error] [system.db.CDbCommand] CDbCommand::execute() failed: SQLSTATE[42501]: Insufficient privilege: 7 ERROR: permission denied for schema public. The SQL statement executed was: CREATE OR REPLACE FUNCTION show_create_table(table_name text, join_char text = E' ' ) RETURNS text AS $BODY$ SELECT 'CREATE TABLE ' || $1 || ' (' || $2 || '' || string_agg(column_list.column_expr, ', ' || $2 || '') || '' || $2 || ');' FROM ( SELECT ' "' || column_name || '" ' || data_type || coalesce('(' || character_maximum_length || ')', '') || case when is_nullable = 'YES' then '' else ' NOT NULL' end as column_expr FROM information_schema.columns WHERE table_schema = 'public' AND table_name = $1 ORDER BY ordinal_position) column_list; $BODY$ LANGUAGE SQL STABLE ; . 2026/06/17 16:23:56 [error] [exception.CException] CException: Please fix this error in your database and try again in /var/www/html/limesurvey7/application/commands/UpdateDbCommand.php:51 Stack trace: #0 /var/www/html/limesurvey7/vendor/yiisoft/yii/framework/console/CConsoleCommandRunner.php(71): UpdateDBCommand->run() #1 /var/www/html/limesurvey7/vendor/yiisoft/yii/framework/console/CConsoleApplication.php(92): CConsoleCommandRunner->run() #2 /var/www/html/limesurvey7/vendor/yiisoft/yii/framework/base/CApplication.php(185): CConsoleApplication->processRequest() #3 /var/www/html/limesurvey7/application/commands/console.php(77): CApplication->run() #4 {main} --- 2026/06/17 16:31:34 [error] [system.db.CDbCommand] CDbCommand::execute() failed: SQLSTATE[42501]: Insufficient privilege: 7 ERROR: permission denied for schema public. The SQL statement executed was: CREATE OR REPLACE FUNCTION show_create_table(table_name text, join_char text = E' ' ) RETURNS text AS $BODY$ SELECT 'CREATE TABLE ' || $1 || ' (' || $2 || '' || string_agg(column_list.column_expr, ', ' || $2 || '') || '' || $2 || ');' FROM ( SELECT ' "' || column_name || '" ' || data_type || coalesce('(' || character_maximum_length || ')', '') || case when is_nullable = 'YES' then '' else ' NOT NULL' end as column_expr FROM information_schema.columns WHERE table_schema = 'public' AND table_name = $1 ORDER BY ordinal_position) column_list; $BODY$ LANGUAGE SQL STABLE ; . 2026/06/17 16:31:56 [error] [exception.CException] CException: Please fix this error in your database and try again in /var/www/html/limesurvey7/application/commands/UpdateDbCommand.php:51 Stack trace: #0 /var/www/html/limesurvey7/vendor/yiisoft/yii/framework/console/CConsoleCommandRunner.php(71): UpdateDBCommand->run() #1 /var/www/html/limesurvey7/vendor/yiisoft/yii/framework/console/CConsoleApplication.php(92): CConsoleCommandRunner->run() #2 /var/www/html/limesurvey7/vendor/yiisoft/yii/framework/base/CApplication.php(185): CConsoleApplication->processRequest() #3 /var/www/html/limesurvey7/application/commands/console.php(77): CApplication->run() #4 {main} --- 2026/06/17 16:44:13 [error] [system.db.CDbCommand] CDbCommand::execute() failed: SQLSTATE[53200]: Out of memory: 7 ERROR: out of shared memory HINT: You might need to increase "max_locks_per_transaction".. The SQL statement executed was: CREATE TABLE lime_responses_265375 ( "id" serial PRIMARY KEY, "submitdate" timestamp without time zone, "lastpage" integer, "startlanguage" character varying(20) NOT NULL, "seed" character varying(31), "startdate" timestamp without time zone NOT NULL, "datestamp" timestamp without time zone NOT NULL, "Q387650" timestamp without time zone, "Q387651" text, "Q387637" character varying(5), "Q387638" character varying(5), "Q387639" character varying(5), "Q387640" text, "Q387652" text, "Q387644" character varying(5), "Q387642" character varying(5), "Q387643" character varying(5), "Q387646" character varying(5), "Q387657" character varying(5), "Q387645" character varying(5), "Q387653" character varying(5), "Q387678" character varying(5), "Q387654" character varying(5), "Q387661" text, "Q387662" text, "Q387660" text, "Q387655" character varying(5), "Q387658" character varying(5), "Q387656" character varying(5), "Q387659" character varying(5), "Q387648" character varying(5), "Q387649" character varying(5) );. 2026/06/17 16:44:37 [error] [exception.CException] CException: Please fix this error in your database and try again in /var/www/html/limesurvey7/application/commands/UpdateDbCommand.php:51 Stack trace: #0 /var/www/html/limesurvey7/vendor/yiisoft/yii/framework/console/CConsoleCommandRunner.php(71): UpdateDBCommand->run() #1 /var/www/html/limesurvey7/vendor/yiisoft/yii/framework/console/CConsoleApplication.php(92): CConsoleCommandRunner->run() #2 /var/www/html/limesurvey7/vendor/yiisoft/yii/framework/base/CApplication.php(185): CConsoleApplication->processRequest() #3 /var/www/html/limesurvey7/application/commands/console.php(77): CApplication->run() #4 {main} --- 2026/06/17 17:02:46 [error] [system.db.CDbCommand] CDbCommand::execute() failed: SQLSTATE[42704]: Undefined object: 7 ERROR: index "lime_idx2_users" does not exist. The SQL statement executed was: DROP INDEX "lime_idx2_users". 2026/06/17 17:02:46 [error] [system.db.CDbCommand] CDbCommand::execute() failed: SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block. The SQL statement executed was: CREATE UNIQUE INDEX "lime_idx2_users" ON "lime_users" ("email"). 2026/06/17 17:03:14 [error] [exception.CException] CException: Please fix this error in your database and try again in /var/www/html/limesurvey7/application/commands/UpdateDbCommand.php:51 Stack trace: #0 /var/www/html/limesurvey7/vendor/yiisoft/yii/framework/console/CConsoleCommandRunner.php(71): UpdateDBCommand->run() #1 /var/www/html/limesurvey7/vendor/yiisoft/yii/framework/console/CConsoleApplication.php(92): CConsoleCommandRunner->run() #2 /var/www/html/limesurvey7/vendor/yiisoft/yii/framework/base/CApplication.php(185): CConsoleApplication->processRequest() #3 /var/www/html/limesurvey7/application/commands/console.php(77): CApplication->run() #4 {main} --- 2026/06/17 17:06:18 [error] [system.db.CDbCommand] CDbCommand::execute() failed: SQLSTATE[42704]: Undefined object: 7 ERROR: index "lime_idx2_users" does not exist. The SQL statement executed was: DROP INDEX "lime_idx2_users". 2026/06/17 17:06:18 [error] [system.db.CDbCommand] CDbCommand::execute() failed: SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block. The SQL statement executed was: CREATE UNIQUE INDEX "lime_idx2_users" ON "lime_users" ("email"). 2026/06/17 17:06:39 [error] [exception.CException] CException: Please fix this error in your database and try again in /var/www/html/limesurvey7/application/commands/UpdateDbCommand.php:51 Stack trace: #0 /var/www/html/limesurvey7/vendor/yiisoft/yii/framework/console/CConsoleCommandRunner.php(71): UpdateDBCommand->run() #1 /var/www/html/limesurvey7/vendor/yiisoft/yii/framework/console/CConsoleApplication.php(92): CConsoleCommandRunner->run() #2 /var/www/html/limesurvey7/vendor/yiisoft/yii/framework/base/CApplication.php(185): CConsoleApplication->processRequest() #3 /var/www/html/limesurvey7/application/commands/console.php(77): CApplication->run() #4 {main} ---