CDbException

Loading "log" application component

Loading "request" application component

Loading "assetManager" application component

Loading "urlManager" application component

Loading "cache" application component

Loading "session" application component

Loading "db" application component

Opening DB connection

Querying SQL: SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod))
AS type, d.adsrc, a.attnotnull, a.atthasdef,
	pg_catalog.col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND
a.attnum = d.adnum
WHERE a.attnum > 0 AND NOT a.attisdropped
	AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
		AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname
= :schema))
ORDER BY a.attnum. Bound with :table='lime_settings_global',
:schema='public'

begin:system.db.CDbCommand.query(SELECT a.attname,
LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull,
a.atthasdef,
	pg_catalog.col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND
a.attnum = d.adnum
WHERE a.attnum > 0 AND NOT a.attisdropped
	AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
		AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname
= :schema))
ORDER BY a.attnum. Bound with :table='lime_settings_global',
:schema='public')

end:system.db.CDbCommand.query(SELECT a.attname,
LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull,
a.atthasdef,
	pg_catalog.col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND
a.attnum = d.adnum
WHERE a.attnum > 0 AND NOT a.attisdropped
	AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
		AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname
= :schema))
ORDER BY a.attnum. Bound with :table='lime_settings_global',
:schema='public')

Querying SQL: SELECT conname, consrc, contype, indkey FROM (
	SELECT
		conname,
		CASE WHEN contype='f' THEN
			pg_catalog.pg_get_constraintdef(oid)
		ELSE
			'CHECK (' || consrc || ')'
		END AS consrc,
		contype,
		conrelid AS relid,
		NULL AS indkey
	FROM
		pg_catalog.pg_constraint
	WHERE
		contype IN ('f', 'c')
	UNION ALL
	SELECT
		pc.relname,
		NULL,
		CASE WHEN indisprimary THEN
				'p'
		ELSE
				'u'
		END,
		pi.indrelid,
		indkey
	FROM
		pg_catalog.pg_class pc,
		pg_catalog.pg_index pi
	WHERE
		pc.oid=pi.indexrelid
		AND EXISTS (
			SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
			ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
			WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i'
AND c.contype IN ('u', 'p')
	)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
	AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
	WHERE nspname=:schema)). Bound with :table='lime_settings_global',
:schema='public'

begin:system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey
FROM (
	SELECT
		conname,
		CASE WHEN contype='f' THEN
			pg_catalog.pg_get_constraintdef(oid)
		ELSE
			'CHECK (' || consrc || ')'
		END AS consrc,
		contype,
		conrelid AS relid,
		NULL AS indkey
	FROM
		pg_catalog.pg_constraint
	WHERE
		contype IN ('f', 'c')
	UNION ALL
	SELECT
		pc.relname,
		NULL,
		CASE WHEN indisprimary THEN
				'p'
		ELSE
				'u'
		END,
		pi.indrelid,
		indkey
	FROM
		pg_catalog.pg_class pc,
		pg_catalog.pg_index pi
	WHERE
		pc.oid=pi.indexrelid
		AND EXISTS (
			SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
			ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
			WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i'
AND c.contype IN ('u', 'p')
	)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
	AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
	WHERE nspname=:schema)). Bound with :table='lime_settings_global',
:schema='public')

end:system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM
(
	SELECT
		conname,
		CASE WHEN contype='f' THEN
			pg_catalog.pg_get_constraintdef(oid)
		ELSE
			'CHECK (' || consrc || ')'
		END AS consrc,
		contype,
		conrelid AS relid,
		NULL AS indkey
	FROM
		pg_catalog.pg_constraint
	WHERE
		contype IN ('f', 'c')
	UNION ALL
	SELECT
		pc.relname,
		NULL,
		CASE WHEN indisprimary THEN
				'p'
		ELSE
				'u'
		END,
		pi.indrelid,
		indkey
	FROM
		pg_catalog.pg_class pc,
		pg_catalog.pg_index pi
	WHERE
		pc.oid=pi.indexrelid
		AND EXISTS (
			SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
			ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
			WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i'
AND c.contype IN ('u', 'p')
	)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
	AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
	WHERE nspname=:schema)). Bound with :table='lime_settings_global',
:schema='public')

Querying SQL: SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE
	attrelid=(
		SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND
relnamespace=(
			SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema
		)
	)
	AND attnum IN (1). Bound with :table='lime_settings_global',
:schema='public'

begin:system.db.CDbCommand.query(SELECT attnum, attname FROM
pg_catalog.pg_attribute WHERE
	attrelid=(
		SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND
relnamespace=(
			SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema
		)
	)
	AND attnum IN (1). Bound with :table='lime_settings_global',
:schema='public')

end:system.db.CDbCommand.query(SELECT attnum, attname FROM
pg_catalog.pg_attribute WHERE
	attrelid=(
		SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND
relnamespace=(
			SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema
		)
	)
	AND attnum IN (1). Bound with :table='lime_settings_global',
:schema='public')

SettingGlobal.findAll()

Querying SQL: SELECT * FROM "lime_settings_global" "t"

begin:system.db.CDbCommand.query(SELECT * FROM "lime_settings_global" "t")

end:system.db.CDbCommand.query(SELECT * FROM "lime_settings_global" "t")

Loading "bootstrap" application component

Loading "clientScript" application component

Loading "messages" application component

Loading "user" application component

Querying SQL: SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod))
AS type, d.adsrc, a.attnotnull, a.atthasdef,
	pg_catalog.col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND
a.attnum = d.adnum
WHERE a.attnum > 0 AND NOT a.attisdropped
	AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
		AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname
= :schema))
ORDER BY a.attnum. Bound with :table='lime_surveys', :schema='public'

begin:system.db.CDbCommand.query(SELECT a.attname,
LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull,
a.atthasdef,
	pg_catalog.col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND
a.attnum = d.adnum
WHERE a.attnum > 0 AND NOT a.attisdropped
	AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
		AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname
= :schema))
ORDER BY a.attnum. Bound with :table='lime_surveys', :schema='public')

end:system.db.CDbCommand.query(SELECT a.attname,
LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull,
a.atthasdef,
	pg_catalog.col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND
a.attnum = d.adnum
WHERE a.attnum > 0 AND NOT a.attisdropped
	AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
		AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname
= :schema))
ORDER BY a.attnum. Bound with :table='lime_surveys', :schema='public')

Querying SQL: SELECT conname, consrc, contype, indkey FROM (
	SELECT
		conname,
		CASE WHEN contype='f' THEN
			pg_catalog.pg_get_constraintdef(oid)
		ELSE
			'CHECK (' || consrc || ')'
		END AS consrc,
		contype,
		conrelid AS relid,
		NULL AS indkey
	FROM
		pg_catalog.pg_constraint
	WHERE
		contype IN ('f', 'c')
	UNION ALL
	SELECT
		pc.relname,
		NULL,
		CASE WHEN indisprimary THEN
				'p'
		ELSE
				'u'
		END,
		pi.indrelid,
		indkey
	FROM
		pg_catalog.pg_class pc,
		pg_catalog.pg_index pi
	WHERE
		pc.oid=pi.indexrelid
		AND EXISTS (
			SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
			ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
			WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i'
AND c.contype IN ('u', 'p')
	)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
	AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
	WHERE nspname=:schema)). Bound with :table='lime_surveys',
:schema='public'

begin:system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey
FROM (
	SELECT
		conname,
		CASE WHEN contype='f' THEN
			pg_catalog.pg_get_constraintdef(oid)
		ELSE
			'CHECK (' || consrc || ')'
		END AS consrc,
		contype,
		conrelid AS relid,
		NULL AS indkey
	FROM
		pg_catalog.pg_constraint
	WHERE
		contype IN ('f', 'c')
	UNION ALL
	SELECT
		pc.relname,
		NULL,
		CASE WHEN indisprimary THEN
				'p'
		ELSE
				'u'
		END,
		pi.indrelid,
		indkey
	FROM
		pg_catalog.pg_class pc,
		pg_catalog.pg_index pi
	WHERE
		pc.oid=pi.indexrelid
		AND EXISTS (
			SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
			ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
			WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i'
AND c.contype IN ('u', 'p')
	)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
	AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
	WHERE nspname=:schema)). Bound with :table='lime_surveys',
:schema='public')

end:system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM
(
	SELECT
		conname,
		CASE WHEN contype='f' THEN
			pg_catalog.pg_get_constraintdef(oid)
		ELSE
			'CHECK (' || consrc || ')'
		END AS consrc,
		contype,
		conrelid AS relid,
		NULL AS indkey
	FROM
		pg_catalog.pg_constraint
	WHERE
		contype IN ('f', 'c')
	UNION ALL
	SELECT
		pc.relname,
		NULL,
		CASE WHEN indisprimary THEN
				'p'
		ELSE
				'u'
		END,
		pi.indrelid,
		indkey
	FROM
		pg_catalog.pg_class pc,
		pg_catalog.pg_index pi
	WHERE
		pc.oid=pi.indexrelid
		AND EXISTS (
			SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
			ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
			WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i'
AND c.contype IN ('u', 'p')
	)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
	AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
	WHERE nspname=:schema)). Bound with :table='lime_surveys',
:schema='public')

Querying SQL: SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE
	attrelid=(
		SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND
relnamespace=(
			SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema
		)
	)
	AND attnum IN (1). Bound with :table='lime_surveys', :schema='public'

begin:system.db.CDbCommand.query(SELECT attnum, attname FROM
pg_catalog.pg_attribute WHERE
	attrelid=(
		SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND
relnamespace=(
			SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema
		)
	)
	AND attnum IN (1). Bound with :table='lime_surveys', :schema='public')

end:system.db.CDbCommand.query(SELECT attnum, attname FROM
pg_catalog.pg_attribute WHERE
	attrelid=(
		SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND
relnamespace=(
			SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema
		)
	)
	AND attnum IN (1). Bound with :table='lime_surveys', :schema='public')

Survey.findByPk()

Querying SQL: SELECT * FROM "lime_surveys" "t" WHERE "t"."sid"=723869 LIMIT
1

begin:system.db.CDbCommand.query(SELECT * FROM "lime_surveys" "t" WHERE
"t"."sid"=723869 LIMIT 1)

end:system.db.CDbCommand.query(SELECT * FROM "lime_surveys" "t" WHERE
"t"."sid"=723869 LIMIT 1)

Querying SQL: SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod))
AS type, d.adsrc, a.attnotnull, a.atthasdef,
	pg_catalog.col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND
a.attnum = d.adnum
WHERE a.attnum > 0 AND NOT a.attisdropped
	AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
		AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname
= :schema))
ORDER BY a.attnum. Bound with :table='lime_permissions', :schema='public'

begin:system.db.CDbCommand.query(SELECT a.attname,
LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull,
a.atthasdef,
	pg_catalog.col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND
a.attnum = d.adnum
WHERE a.attnum > 0 AND NOT a.attisdropped
	AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
		AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname
= :schema))
ORDER BY a.attnum. Bound with :table='lime_permissions', :schema='public')

end:system.db.CDbCommand.query(SELECT a.attname,
LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull,
a.atthasdef,
	pg_catalog.col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND
a.attnum = d.adnum
WHERE a.attnum > 0 AND NOT a.attisdropped
	AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
		AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname
= :schema))
ORDER BY a.attnum. Bound with :table='lime_permissions', :schema='public')

Querying SQL: SELECT conname, consrc, contype, indkey FROM (
	SELECT
		conname,
		CASE WHEN contype='f' THEN
			pg_catalog.pg_get_constraintdef(oid)
		ELSE
			'CHECK (' || consrc || ')'
		END AS consrc,
		contype,
		conrelid AS relid,
		NULL AS indkey
	FROM
		pg_catalog.pg_constraint
	WHERE
		contype IN ('f', 'c')
	UNION ALL
	SELECT
		pc.relname,
		NULL,
		CASE WHEN indisprimary THEN
				'p'
		ELSE
				'u'
		END,
		pi.indrelid,
		indkey
	FROM
		pg_catalog.pg_class pc,
		pg_catalog.pg_index pi
	WHERE
		pc.oid=pi.indexrelid
		AND EXISTS (
			SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
			ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
			WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i'
AND c.contype IN ('u', 'p')
	)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
	AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
	WHERE nspname=:schema)). Bound with :table='lime_permissions',
:schema='public'

begin:system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey
FROM (
	SELECT
		conname,
		CASE WHEN contype='f' THEN
			pg_catalog.pg_get_constraintdef(oid)
		ELSE
			'CHECK (' || consrc || ')'
		END AS consrc,
		contype,
		conrelid AS relid,
		NULL AS indkey
	FROM
		pg_catalog.pg_constraint
	WHERE
		contype IN ('f', 'c')
	UNION ALL
	SELECT
		pc.relname,
		NULL,
		CASE WHEN indisprimary THEN
				'p'
		ELSE
				'u'
		END,
		pi.indrelid,
		indkey
	FROM
		pg_catalog.pg_class pc,
		pg_catalog.pg_index pi
	WHERE
		pc.oid=pi.indexrelid
		AND EXISTS (
			SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
			ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
			WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i'
AND c.contype IN ('u', 'p')
	)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
	AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
	WHERE nspname=:schema)). Bound with :table='lime_permissions',
:schema='public')

end:system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM
(
	SELECT
		conname,
		CASE WHEN contype='f' THEN
			pg_catalog.pg_get_constraintdef(oid)
		ELSE
			'CHECK (' || consrc || ')'
		END AS consrc,
		contype,
		conrelid AS relid,
		NULL AS indkey
	FROM
		pg_catalog.pg_constraint
	WHERE
		contype IN ('f', 'c')
	UNION ALL
	SELECT
		pc.relname,
		NULL,
		CASE WHEN indisprimary THEN
				'p'
		ELSE
				'u'
		END,
		pi.indrelid,
		indkey
	FROM
		pg_catalog.pg_class pc,
		pg_catalog.pg_index pi
	WHERE
		pc.oid=pi.indexrelid
		AND EXISTS (
			SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
			ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
			WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i'
AND c.contype IN ('u', 'p')
	)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
	AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
	WHERE nspname=:schema)). Bound with :table='lime_permissions',
:schema='public')

Querying SQL: SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE
	attrelid=(
		SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND
relnamespace=(
			SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema
		)
	)
	AND attnum IN (1). Bound with :table='lime_permissions', :schema='public'

begin:system.db.CDbCommand.query(SELECT attnum, attname FROM
pg_catalog.pg_attribute WHERE
	attrelid=(
		SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND
relnamespace=(
			SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema
		)
	)
	AND attnum IN (1). Bound with :table='lime_permissions', :schema='public')

end:system.db.CDbCommand.query(SELECT attnum, attname FROM
pg_catalog.pg_attribute WHERE
	attrelid=(
		SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND
relnamespace=(
			SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema
		)
	)
	AND attnum IN (1). Bound with :table='lime_permissions', :schema='public')

Loading "pluginManager" application component

Plugin.findAllByAttributes()

Querying SQL: SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod))
AS type, d.adsrc, a.attnotnull, a.atthasdef,
	pg_catalog.col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND
a.attnum = d.adnum
WHERE a.attnum > 0 AND NOT a.attisdropped
	AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
		AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname
= :schema))
ORDER BY a.attnum. Bound with :table='lime_plugins', :schema='public'

begin:system.db.CDbCommand.query(SELECT a.attname,
LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull,
a.atthasdef,
	pg_catalog.col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND
a.attnum = d.adnum
WHERE a.attnum > 0 AND NOT a.attisdropped
	AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
		AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname
= :schema))
ORDER BY a.attnum. Bound with :table='lime_plugins', :schema='public')

end:system.db.CDbCommand.query(SELECT a.attname,
LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull,
a.atthasdef,
	pg_catalog.col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND
a.attnum = d.adnum
WHERE a.attnum > 0 AND NOT a.attisdropped
	AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
		AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname
= :schema))
ORDER BY a.attnum. Bound with :table='lime_plugins', :schema='public')

Querying SQL: SELECT conname, consrc, contype, indkey FROM (
	SELECT
		conname,
		CASE WHEN contype='f' THEN
			pg_catalog.pg_get_constraintdef(oid)
		ELSE
			'CHECK (' || consrc || ')'
		END AS consrc,
		contype,
		conrelid AS relid,
		NULL AS indkey
	FROM
		pg_catalog.pg_constraint
	WHERE
		contype IN ('f', 'c')
	UNION ALL
	SELECT
		pc.relname,
		NULL,
		CASE WHEN indisprimary THEN
				'p'
		ELSE
				'u'
		END,
		pi.indrelid,
		indkey
	FROM
		pg_catalog.pg_class pc,
		pg_catalog.pg_index pi
	WHERE
		pc.oid=pi.indexrelid
		AND EXISTS (
			SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
			ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
			WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i'
AND c.contype IN ('u', 'p')
	)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
	AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
	WHERE nspname=:schema)). Bound with :table='lime_plugins',
:schema='public'

begin:system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey
FROM (
	SELECT
		conname,
		CASE WHEN contype='f' THEN
			pg_catalog.pg_get_constraintdef(oid)
		ELSE
			'CHECK (' || consrc || ')'
		END AS consrc,
		contype,
		conrelid AS relid,
		NULL AS indkey
	FROM
		pg_catalog.pg_constraint
	WHERE
		contype IN ('f', 'c')
	UNION ALL
	SELECT
		pc.relname,
		NULL,
		CASE WHEN indisprimary THEN
				'p'
		ELSE
				'u'
		END,
		pi.indrelid,
		indkey
	FROM
		pg_catalog.pg_class pc,
		pg_catalog.pg_index pi
	WHERE
		pc.oid=pi.indexrelid
		AND EXISTS (
			SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
			ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
			WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i'
AND c.contype IN ('u', 'p')
	)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
	AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
	WHERE nspname=:schema)). Bound with :table='lime_plugins',
:schema='public')

end:system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM
(
	SELECT
		conname,
		CASE WHEN contype='f' THEN
			pg_catalog.pg_get_constraintdef(oid)
		ELSE
			'CHECK (' || consrc || ')'
		END AS consrc,
		contype,
		conrelid AS relid,
		NULL AS indkey
	FROM
		pg_catalog.pg_constraint
	WHERE
		contype IN ('f', 'c')
	UNION ALL
	SELECT
		pc.relname,
		NULL,
		CASE WHEN indisprimary THEN
				'p'
		ELSE
				'u'
		END,
		pi.indrelid,
		indkey
	FROM
		pg_catalog.pg_class pc,
		pg_catalog.pg_index pi
	WHERE
		pc.oid=pi.indexrelid
		AND EXISTS (
			SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
			ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
			WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i'
AND c.contype IN ('u', 'p')
	)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
	AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
	WHERE nspname=:schema)). Bound with :table='lime_plugins',
:schema='public')

Querying SQL: SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE
	attrelid=(
		SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND
relnamespace=(
			SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema
		)
	)
	AND attnum IN (1). Bound with :table='lime_plugins', :schema='public'

begin:system.db.CDbCommand.query(SELECT attnum, attname FROM
pg_catalog.pg_attribute WHERE
	attrelid=(
		SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND
relnamespace=(
			SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema
		)
	)
	AND attnum IN (1). Bound with :table='lime_plugins', :schema='public')

end:system.db.CDbCommand.query(SELECT attnum, attname FROM
pg_catalog.pg_attribute WHERE
	attrelid=(
		SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND
relnamespace=(
			SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema
		)
	)
	AND attnum IN (1). Bound with :table='lime_plugins', :schema='public')

Querying SQL: SELECT * FROM "lime_plugins" "t" WHERE "t"."active"=:yp0.
Bound with :yp0=1

begin:system.db.CDbCommand.query(SELECT * FROM "lime_plugins" "t" WHERE
"t"."active"=:yp0. Bound with :yp0=1)

end:system.db.CDbCommand.query(SELECT * FROM "lime_plugins" "t" WHERE
"t"."active"=:yp0. Bound with :yp0=1)

Permission.findByAttributes()

Querying SQL: SELECT * FROM "lime_permissions" "t" WHERE
"t"."entity_id"=:yp0 AND "t"."entity"=:yp1 AND "t"."uid"=:yp2 AND
"t"."permission"=:yp3 LIMIT 1. Bound with :yp0=0, :yp1='global', :yp2=1,
:yp3='superadmin'

begin:system.db.CDbCommand.query(SELECT * FROM "lime_permissions" "t" WHERE
"t"."entity_id"=:yp0 AND "t"."entity"=:yp1 AND "t"."uid"=:yp2 AND
"t"."permission"=:yp3 LIMIT 1. Bound with :yp0=0, :yp1='global', :yp2=1,
:yp3='superadmin')

end:system.db.CDbCommand.query(SELECT * FROM "lime_permissions" "t" WHERE
"t"."entity_id"=:yp0 AND "t"."entity"=:yp1 AND "t"."uid"=:yp2 AND
"t"."permission"=:yp3 LIMIT 1. Bound with :yp0=0, :yp1='global', :yp2=1,
:yp3='superadmin')

Querying SQL: SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod))
AS type, d.adsrc, a.attnotnull, a.atthasdef,
	pg_catalog.col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND
a.attnum = d.adnum
WHERE a.attnum > 0 AND NOT a.attisdropped
	AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
		AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname
= :schema))
ORDER BY a.attnum. Bound with :table='lime_surveys_languagesettings',
:schema='public'

begin:system.db.CDbCommand.query(SELECT a.attname,
LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull,
a.atthasdef,
	pg_catalog.col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND
a.attnum = d.adnum
WHERE a.attnum > 0 AND NOT a.attisdropped
	AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
		AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname
= :schema))
ORDER BY a.attnum. Bound with :table='lime_surveys_languagesettings',
:schema='public')

end:system.db.CDbCommand.query(SELECT a.attname,
LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull,
a.atthasdef,
	pg_catalog.col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND
a.attnum = d.adnum
WHERE a.attnum > 0 AND NOT a.attisdropped
	AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
		AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname
= :schema))
ORDER BY a.attnum. Bound with :table='lime_surveys_languagesettings',
:schema='public')

Querying SQL: SELECT conname, consrc, contype, indkey FROM (
	SELECT
		conname,
		CASE WHEN contype='f' THEN
			pg_catalog.pg_get_constraintdef(oid)
		ELSE
			'CHECK (' || consrc || ')'
		END AS consrc,
		contype,
		conrelid AS relid,
		NULL AS indkey
	FROM
		pg_catalog.pg_constraint
	WHERE
		contype IN ('f', 'c')
	UNION ALL
	SELECT
		pc.relname,
		NULL,
		CASE WHEN indisprimary THEN
				'p'
		ELSE
				'u'
		END,
		pi.indrelid,
		indkey
	FROM
		pg_catalog.pg_class pc,
		pg_catalog.pg_index pi
	WHERE
		pc.oid=pi.indexrelid
		AND EXISTS (
			SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
			ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
			WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i'
AND c.contype IN ('u', 'p')
	)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
	AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
	WHERE nspname=:schema)). Bound with
:table='lime_surveys_languagesettings', :schema='public'

begin:system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey
FROM (
	SELECT
		conname,
		CASE WHEN contype='f' THEN
			pg_catalog.pg_get_constraintdef(oid)
		ELSE
			'CHECK (' || consrc || ')'
		END AS consrc,
		contype,
		conrelid AS relid,
		NULL AS indkey
	FROM
		pg_catalog.pg_constraint
	WHERE
		contype IN ('f', 'c')
	UNION ALL
	SELECT
		pc.relname,
		NULL,
		CASE WHEN indisprimary THEN
				'p'
		ELSE
				'u'
		END,
		pi.indrelid,
		indkey
	FROM
		pg_catalog.pg_class pc,
		pg_catalog.pg_index pi
	WHERE
		pc.oid=pi.indexrelid
		AND EXISTS (
			SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
			ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
			WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i'
AND c.contype IN ('u', 'p')
	)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
	AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
	WHERE nspname=:schema)). Bound with
:table='lime_surveys_languagesettings', :schema='public')

end:system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM
(
	SELECT
		conname,
		CASE WHEN contype='f' THEN
			pg_catalog.pg_get_constraintdef(oid)
		ELSE
			'CHECK (' || consrc || ')'
		END AS consrc,
		contype,
		conrelid AS relid,
		NULL AS indkey
	FROM
		pg_catalog.pg_constraint
	WHERE
		contype IN ('f', 'c')
	UNION ALL
	SELECT
		pc.relname,
		NULL,
		CASE WHEN indisprimary THEN
				'p'
		ELSE
				'u'
		END,
		pi.indrelid,
		indkey
	FROM
		pg_catalog.pg_class pc,
		pg_catalog.pg_index pi
	WHERE
		pc.oid=pi.indexrelid
		AND EXISTS (
			SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
			ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
			WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i'
AND c.contype IN ('u', 'p')
	)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
	AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
	WHERE nspname=:schema)). Bound with
:table='lime_surveys_languagesettings', :schema='public')

Querying SQL: SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE
	attrelid=(
		SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND
relnamespace=(
			SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema
		)
	)
	AND attnum IN (1, 2). Bound with :table='lime_surveys_languagesettings',
:schema='public'

begin:system.db.CDbCommand.query(SELECT attnum, attname FROM
pg_catalog.pg_attribute WHERE
	attrelid=(
		SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND
relnamespace=(
			SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema
		)
	)
	AND attnum IN (1, 2). Bound with :table='lime_surveys_languagesettings',
:schema='public')

end:system.db.CDbCommand.query(SELECT attnum, attname FROM
pg_catalog.pg_attribute WHERE
	attrelid=(
		SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND
relnamespace=(
			SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema
		)
	)
	AND attnum IN (1, 2). Bound with :table='lime_surveys_languagesettings',
:schema='public')

SurveyLanguageSetting.findByPk()

Querying SQL: SELECT "t"."surveyls_survey_id" AS "t0_c0",
"t"."surveyls_language" AS "t0_c1", "t"."surveyls_title" AS "t0_c2",
"t"."surveyls_description" AS "t0_c3", "t"."surveyls_welcometext" AS
"t0_c4", "t"."surveyls_endtext" AS "t0_c5", "t"."surveyls_url" AS "t0_c6",
"t"."surveyls_urldescription" AS "t0_c7", "t"."surveyls_email_invite_subj"
AS "t0_c8", "t"."surveyls_email_invite" AS "t0_c9",
"t"."surveyls_email_remind_subj" AS "t0_c10", "t"."surveyls_email_remind"
AS "t0_c11", "t"."surveyls_email_register_subj" AS "t0_c12",
"t"."surveyls_email_register" AS "t0_c13",
"t"."surveyls_email_confirm_subj" AS "t0_c14", "t"."surveyls_email_confirm"
AS "t0_c15", "t"."surveyls_dateformat" AS "t0_c16",
"t"."surveyls_attributecaptions" AS "t0_c17",
"t"."email_admin_notification_subj" AS "t0_c18",
"t"."email_admin_notification" AS "t0_c19",
"t"."email_admin_responses_subj" AS "t0_c20", "t"."email_admin_responses"
AS "t0_c21", "t"."surveyls_numberformat" AS "t0_c22", "t"."attachments" AS
"t0_c23", "survey"."sid" AS "t1_c0", "survey"."owner_id" AS "t1_c1",
"survey"."admin" AS "t1_c2", "survey"."active" AS "t1_c3",
"survey"."expires" AS "t1_c4", "survey"."startdate" AS "t1_c5",
"survey"."adminemail" AS "t1_c6", "survey"."anonymized" AS "t1_c7",
"survey"."faxto" AS "t1_c8", "survey"."format" AS "t1_c9",
"survey"."savetimings" AS "t1_c10", "survey"."template" AS "t1_c11",
"survey"."language" AS "t1_c12", "survey"."additional_languages" AS
"t1_c13", "survey"."datestamp" AS "t1_c14", "survey"."usecookie" AS
"t1_c15", "survey"."allowregister" AS "t1_c16", "survey"."allowsave" AS
"t1_c17", "survey"."autonumber_start" AS "t1_c18", "survey"."autoredirect"
AS "t1_c19", "survey"."allowprev" AS "t1_c20", "survey"."printanswers" AS
"t1_c21", "survey"."ipaddr" AS "t1_c22", "survey"."refurl" AS "t1_c23",
"survey"."datecreated" AS "t1_c24", "survey"."publicstatistics" AS
"t1_c25", "survey"."publicgraphs" AS "t1_c26", "survey"."listpublic" AS
"t1_c27", "survey"."htmlemail" AS "t1_c28", "survey"."sendconfirmation" AS
"t1_c29", "survey"."tokenanswerspersistence" AS "t1_c30",
"survey"."assessments" AS "t1_c31", "survey"."usecaptcha" AS "t1_c32",
"survey"."usetokens" AS "t1_c33", "survey"."bounce_email" AS "t1_c34",
"survey"."attributedescriptions" AS "t1_c35", "survey"."emailresponseto" AS
"t1_c36", "survey"."emailnotificationto" AS "t1_c37",
"survey"."tokenlength" AS "t1_c38", "survey"."showxquestions" AS "t1_c39",
"survey"."showgroupinfo" AS "t1_c40", "survey"."shownoanswer" AS "t1_c41",
"survey"."showqnumcode" AS "t1_c42", "survey"."bouncetime" AS "t1_c43",
"survey"."bounceprocessing" AS "t1_c44", "survey"."bounceaccounttype" AS
"t1_c45", "survey"."bounceaccounthost" AS "t1_c46",
"survey"."bounceaccountpass" AS "t1_c47",
"survey"."bounceaccountencryption" AS "t1_c48",
"survey"."bounceaccountuser" AS "t1_c49", "survey"."showwelcome" AS
"t1_c50", "survey"."showprogress" AS "t1_c51", "survey"."questionindex" AS
"t1_c52", "survey"."navigationdelay" AS "t1_c53", "survey"."nokeyboard" AS
"t1_c54", "survey"."alloweditaftercompletion" AS "t1_c55",
"survey"."googleanalyticsstyle" AS "t1_c56",
"survey"."googleanalyticsapikey" AS "t1_c57" FROM
"lime_surveys_languagesettings" "t"  LEFT OUTER JOIN "lime_surveys"
"survey" ON (t.surveyls_survey_id = survey.sid)  WHERE
("t"."surveyls_survey_id"=723869 AND "t"."surveyls_language"='es')

begin:system.db.CDbCommand.query(SELECT "t"."surveyls_survey_id" AS
"t0_c0", "t"."surveyls_language" AS "t0_c1", "t"."surveyls_title" AS
"t0_c2", "t"."surveyls_description" AS "t0_c3", "t"."surveyls_welcometext"
AS "t0_c4", "t"."surveyls_endtext" AS "t0_c5", "t"."surveyls_url" AS
"t0_c6", "t"."surveyls_urldescription" AS "t0_c7",
"t"."surveyls_email_invite_subj" AS "t0_c8", "t"."surveyls_email_invite" AS
"t0_c9", "t"."surveyls_email_remind_subj" AS "t0_c10",
"t"."surveyls_email_remind" AS "t0_c11", "t"."surveyls_email_register_subj"
AS "t0_c12", "t"."surveyls_email_register" AS "t0_c13",
"t"."surveyls_email_confirm_subj" AS "t0_c14", "t"."surveyls_email_confirm"
AS "t0_c15", "t"."surveyls_dateformat" AS "t0_c16",
"t"."surveyls_attributecaptions" AS "t0_c17",
"t"."email_admin_notification_subj" AS "t0_c18",
"t"."email_admin_notification" AS "t0_c19",
"t"."email_admin_responses_subj" AS "t0_c20", "t"."email_admin_responses"
AS "t0_c21", "t"."surveyls_numberformat" AS "t0_c22", "t"."attachments" AS
"t0_c23", "survey"."sid" AS "t1_c0", "survey"."owner_id" AS "t1_c1",
"survey"."admin" AS "t1_c2", "survey"."active" AS "t1_c3",
"survey"."expires" AS "t1_c4", "survey"."startdate" AS "t1_c5",
"survey"."adminemail" AS "t1_c6", "survey"."anonymized" AS "t1_c7",
"survey"."faxto" AS "t1_c8", "survey"."format" AS "t1_c9",
"survey"."savetimings" AS "t1_c10", "survey"."template" AS "t1_c11",
"survey"."language" AS "t1_c12", "survey"."additional_languages" AS
"t1_c13", "survey"."datestamp" AS "t1_c14", "survey"."usecookie" AS
"t1_c15", "survey"."allowregister" AS "t1_c16", "survey"."allowsave" AS
"t1_c17", "survey"."autonumber_start" AS "t1_c18", "survey"."autoredirect"
AS "t1_c19", "survey"."allowprev" AS "t1_c20", "survey"."printanswers" AS
"t1_c21", "survey"."ipaddr" AS "t1_c22", "survey"."refurl" AS "t1_c23",
"survey"."datecreated" AS "t1_c24", "survey"."publicstatistics" AS
"t1_c25", "survey"."publicgraphs" AS "t1_c26", "survey"."listpublic" AS
"t1_c27", "survey"."htmlemail" AS "t1_c28", "survey"."sendconfirmation" AS
"t1_c29", "survey"."tokenanswerspersistence" AS "t1_c30",
"survey"."assessments" AS "t1_c31", "survey"."usecaptcha" AS "t1_c32",
"survey"."usetokens" AS "t1_c33", "survey"."bounce_email" AS "t1_c34",
"survey"."attributedescriptions" AS "t1_c35", "survey"."emailresponseto" AS
"t1_c36", "survey"."emailnotificationto" AS "t1_c37",
"survey"."tokenlength" AS "t1_c38", "survey"."showxquestions" AS "t1_c39",
"survey"."showgroupinfo" AS "t1_c40", "survey"."shownoanswer" AS "t1_c41",
"survey"."showqnumcode" AS "t1_c42", "survey"."bouncetime" AS "t1_c43",
"survey"."bounceprocessing" AS "t1_c44", "survey"."bounceaccounttype" AS
"t1_c45", "survey"."bounceaccounthost" AS "t1_c46",
"survey"."bounceaccountpass" AS "t1_c47",
"survey"."bounceaccountencryption" AS "t1_c48",
"survey"."bounceaccountuser" AS "t1_c49", "survey"."showwelcome" AS
"t1_c50", "survey"."showprogress" AS "t1_c51", "survey"."questionindex" AS
"t1_c52", "survey"."navigationdelay" AS "t1_c53", "survey"."nokeyboard" AS
"t1_c54", "survey"."alloweditaftercompletion" AS "t1_c55",
"survey"."googleanalyticsstyle" AS "t1_c56",
"survey"."googleanalyticsapikey" AS "t1_c57" FROM
"lime_surveys_languagesettings" "t"  LEFT OUTER JOIN "lime_surveys"
"survey" ON (t.surveyls_survey_id = survey.sid)  WHERE
("t"."surveyls_survey_id"=723869 AND "t"."surveyls_language"='es'))

end:system.db.CDbCommand.query(SELECT "t"."surveyls_survey_id" AS "t0_c0",
"t"."surveyls_language" AS "t0_c1", "t"."surveyls_title" AS "t0_c2",
"t"."surveyls_description" AS "t0_c3", "t"."surveyls_welcometext" AS
"t0_c4", "t"."surveyls_endtext" AS "t0_c5", "t"."surveyls_url" AS "t0_c6",
"t"."surveyls_urldescription" AS "t0_c7", "t"."surveyls_email_invite_subj"
AS "t0_c8", "t"."surveyls_email_invite" AS "t0_c9",
"t"."surveyls_email_remind_subj" AS "t0_c10", "t"."surveyls_email_remind"
AS "t0_c11", "t"."surveyls_email_register_subj" AS "t0_c12",
"t"."surveyls_email_register" AS "t0_c13",
"t"."surveyls_email_confirm_subj" AS "t0_c14", "t"."surveyls_email_confirm"
AS "t0_c15", "t"."surveyls_dateformat" AS "t0_c16",
"t"."surveyls_attributecaptions" AS "t0_c17",
"t"."email_admin_notification_subj" AS "t0_c18",
"t"."email_admin_notification" AS "t0_c19",
"t"."email_admin_responses_subj" AS "t0_c20", "t"."email_admin_responses"
AS "t0_c21", "t"."surveyls_numberformat" AS "t0_c22", "t"."attachments" AS
"t0_c23", "survey"."sid" AS "t1_c0", "survey"."owner_id" AS "t1_c1",
"survey"."admin" AS "t1_c2", "survey"."active" AS "t1_c3",
"survey"."expires" AS "t1_c4", "survey"."startdate" AS "t1_c5",
"survey"."adminemail" AS "t1_c6", "survey"."anonymized" AS "t1_c7",
"survey"."faxto" AS "t1_c8", "survey"."format" AS "t1_c9",
"survey"."savetimings" AS "t1_c10", "survey"."template" AS "t1_c11",
"survey"."language" AS "t1_c12", "survey"."additional_languages" AS
"t1_c13", "survey"."datestamp" AS "t1_c14", "survey"."usecookie" AS
"t1_c15", "survey"."allowregister" AS "t1_c16", "survey"."allowsave" AS
"t1_c17", "survey"."autonumber_start" AS "t1_c18", "survey"."autoredirect"
AS "t1_c19", "survey"."allowprev" AS "t1_c20", "survey"."printanswers" AS
"t1_c21", "survey"."ipaddr" AS "t1_c22", "survey"."refurl" AS "t1_c23",
"survey"."datecreated" AS "t1_c24", "survey"."publicstatistics" AS
"t1_c25", "survey"."publicgraphs" AS "t1_c26", "survey"."listpublic" AS
"t1_c27", "survey"."htmlemail" AS "t1_c28", "survey"."sendconfirmation" AS
"t1_c29", "survey"."tokenanswerspersistence" AS "t1_c30",
"survey"."assessments" AS "t1_c31", "survey"."usecaptcha" AS "t1_c32",
"survey"."usetokens" AS "t1_c33", "survey"."bounce_email" AS "t1_c34",
"survey"."attributedescriptions" AS "t1_c35", "survey"."emailresponseto" AS
"t1_c36", "survey"."emailnotificationto" AS "t1_c37",
"survey"."tokenlength" AS "t1_c38", "survey"."showxquestions" AS "t1_c39",
"survey"."showgroupinfo" AS "t1_c40", "survey"."shownoanswer" AS "t1_c41",
"survey"."showqnumcode" AS "t1_c42", "survey"."bouncetime" AS "t1_c43",
"survey"."bounceprocessing" AS "t1_c44", "survey"."bounceaccounttype" AS
"t1_c45", "survey"."bounceaccounthost" AS "t1_c46",
"survey"."bounceaccountpass" AS "t1_c47",
"survey"."bounceaccountencryption" AS "t1_c48",
"survey"."bounceaccountuser" AS "t1_c49", "survey"."showwelcome" AS
"t1_c50", "survey"."showprogress" AS "t1_c51", "survey"."questionindex" AS
"t1_c52", "survey"."navigationdelay" AS "t1_c53", "survey"."nokeyboard" AS
"t1_c54", "survey"."alloweditaftercompletion" AS "t1_c55",
"survey"."googleanalyticsstyle" AS "t1_c56",
"survey"."googleanalyticsapikey" AS "t1_c57" FROM
"lime_surveys_languagesettings" "t"  LEFT OUTER JOIN "lime_surveys"
"survey" ON (t.surveyls_survey_id = survey.sid)  WHERE
("t"."surveyls_survey_id"=723869 AND "t"."surveyls_language"='es'))

Querying SQL: SELECT table_name, table_schema FROM
information_schema.tables
WHERE table_schema=:schema AND table_type='BASE TABLE'. Bound with
:schema='public'

begin:system.db.CDbCommand.query(SELECT table_name, table_schema FROM
information_schema.tables
WHERE table_schema=:schema AND table_type='BASE TABLE'. Bound with
:schema='public')

end:system.db.CDbCommand.query(SELECT table_name, table_schema FROM
information_schema.tables
WHERE table_schema=:schema AND table_type='BASE TABLE'. Bound with
:schema='public')

Executing SQL: CREATE TABLE "lime_tokens_723869" (
	"tid" serial NOT NULL PRIMARY KEY,
	"participant_id" string(50),
	"firstname" string(40),
	"lastname" string(40),
	"email" text,
	"emailstatus" text,
	"token" string(35),
	"language" string(25),
	"blacklisted" string(17),
	"sent" string(17) DEFAULT 'N',
	"remindersent" string(17) DEFAULT 'N',
	"remindercount" integer DEFAULT 0,
	"completed" string(17) DEFAULT 'N',
	"usesleft" integer DEFAULT 1,
	"validfrom" timestamp,
	"validuntil" timestamp,
	"mpid" integer
)

begin:system.db.CDbCommand.execute(CREATE TABLE "lime_tokens_723869" (
	"tid" serial NOT NULL PRIMARY KEY,
	"participant_id" string(50),
	"firstname" string(40),
	"lastname" string(40),
	"email" text,
	"emailstatus" text,
	"token" string(35),
	"language" string(25),
	"blacklisted" string(17),
	"sent" string(17) DEFAULT 'N',
	"remindersent" string(17) DEFAULT 'N',
	"remindercount" integer DEFAULT 0,
	"completed" string(17) DEFAULT 'N',
	"usesleft" integer DEFAULT 1,
	"validfrom" timestamp,
	"validuntil" timestamp,
	"mpid" integer
))

end:system.db.CDbCommand.execute(CREATE TABLE "lime_tokens_723869" (
	"tid" serial NOT NULL PRIMARY KEY,
	"participant_id" string(50),
	"firstname" string(40),
	"lastname" string(40),
	"email" text,
	"emailstatus" text,
	"token" string(35),
	"language" string(25),
	"blacklisted" string(17),
	"sent" string(17) DEFAULT 'N',
	"remindersent" string(17) DEFAULT 'N',
	"remindercount" integer DEFAULT 0,
	"completed" string(17) DEFAULT 'N',
	"usesleft" integer DEFAULT 1,
	"validfrom" timestamp,
	"validuntil" timestamp,
	"mpid" integer
))

Loading "coreMessages" application component

CDbCommand::execute() falló: SQLSTATE[42704]: Undefined object: 7 ERROR: 
type "string" does not exist
LINE 3:  "participant_id" string(50),
                          ^. La sentencia SQL ejecutada fue: CREATE TABLE
"lime_tokens_723869" (
	"tid" serial NOT NULL PRIMARY KEY,
	"participant_id" string(50),
	"firstname" string(40),
	"lastname" string(40),
	"email" text,
	"emailstatus" text,
	"token" string(35),
	"language" string(25),
	"blacklisted" string(17),
	"sent" string(17) DEFAULT 'N',
	"remindersent" string(17) DEFAULT 'N',
	"remindercount" integer DEFAULT 0,
	"completed" string(17) DEFAULT 'N',
	"usesleft" integer DEFAULT 1,
	"validfrom" timestamp,
	"validuntil" timestamp,
	"mpid" integer
).

exception 'CDbException' with message 'CDbCommand falló al ejecutar la
sentencia SQL: SQLSTATE[42704]: Undefined object: 7 ERROR:  type "string"
does not exist
LINE 3:  "participant_id" string(50),
                          ^. The SQL statement executed was: CREATE TABLE
"lime_tokens_723869" (
	"tid" serial NOT NULL PRIMARY KEY,
	"participant_id" string(50),
	"firstname" string(40),
	"lastname" string(40),
	"email" text,
	"emailstatus" text,
	"token" string(35),
	"language" string(25),
	"blacklisted" string(17),
	"sent" string(17) DEFAULT 'N',
	"remindersent" string(17) DEFAULT 'N',
	"remindercount" integer DEFAULT 0,
	"completed" string(17) DEFAULT 'N',
	"usesleft" integer DEFAULT 1,
	"validfrom" timestamp,
	"validuntil" timestamp,
	"mpid" integer
)' in /usr/share/nginx/html/limesurvey/framework/db/CDbCommand.php:358
Stack trace:
#0 /usr/share/nginx/html/limesurvey/framework/db/CDbCommand.php(1324):
CDbCommand->execute()
#1 /usr/share/nginx/html/limesurvey/application/models/Token.php(116):
CDbCommand->createTable('{{tokens_723869...', Array)
#2
/usr/share/nginx/html/limesurvey/application/controllers/admin/tokens.php(2479):
Token::createTable('723869')
#3
/usr/share/nginx/html/limesurvey/application/controllers/admin/tokens.php(49):
tokens->_newtokentable('723869')
#4 [internal function]: tokens->index('723869')
#5 /usr/share/nginx/html/limesurvey/framework/web/actions/CAction.php(108):
ReflectionMethod->invokeArgs(Object(tokens), Array)
#6
/usr/share/nginx/html/limesurvey/application/core/Survey_Common_Action.php(99):
CAction->runWithParamsInternal(Object(tokens), Object(ReflectionMethod),
Array)
#7 /usr/share/nginx/html/limesurvey/framework/web/CController.php(308):
Survey_Common_Action->runWithParams(Array)
#8 /usr/share/nginx/html/limesurvey/framework/web/CController.php(286):
CController->runAction(Object(tokens))
#9 /usr/share/nginx/html/limesurvey/framework/web/CController.php(265):
CController->runActionWithFilters(Object(tokens), Array)
#10
/usr/share/nginx/html/limesurvey/application/controllers/AdminController.php(164):
CController->run('tokens')
#11
/usr/share/nginx/html/limesurvey/framework/web/CWebApplication.php(282):
AdminController->run('tokens')
#12
/usr/share/nginx/html/limesurvey/framework/web/CWebApplication.php(141):
CWebApplication->runController('admin/tokens/sa...')
#13 /usr/share/nginx/html/limesurvey/framework/base/CApplication.php(180):
CWebApplication->processRequest()
#14 /usr/share/nginx/html/limesurvey/index.php(200): CApplication->run()
#15 {main}
REQUEST_URI=/limesurvey/index.php/admin/tokens/sa/index/surveyid/723869/createtable/Y
HTTP_REFERER=http://localhost/limesurvey/index.php/admin/tokens/sa/index/surveyid/723869
---

Loading "errorHandler" application component