Application Log
Timestamp       Level   Category        Message
18:49:22.089474         trace   system.db.CDbConnection

Opening DB connection
in /var/www/test2/protected/controllers/PostController.php (228)
in /var/www/test2/index.php (13)

18:49:22.109872         trace   system.db.CDbCommand

Querying SQL: SELECT *
FROM "bm_auth_assignment"
WHERE userid=:userid. Bound with :userid=2
in /var/www/test2/protected/controllers/PostController.php (228)
in /var/www/test2/index.php (13)

18:49:22.112869         trace   system.db.CDbCommand

Querying SQL: SELECT *
FROM "bm_auth_item"
WHERE name=:name. Bound with :name='postCreate'
in /var/www/test2/protected/controllers/PostController.php (228)
in /var/www/test2/index.php (13)

18:49:22.116527         trace   system.db.CDbCommand

Querying SQL: SELECT "parent"
FROM "bm_auth_item_child"
WHERE child=:name. Bound with :name='postCreate'
in /var/www/test2/protected/controllers/PostController.php (228)
in /var/www/test2/index.php (13)

18:49:22.118127         trace   system.db.CDbCommand

Querying SQL: SELECT *
FROM "bm_auth_item"
WHERE name=:name. Bound with :name='postAuthor'
in /var/www/test2/protected/controllers/PostController.php (228)
in /var/www/test2/index.php (13)

18:49:22.128626         trace   system.db.CDbCommand

Querying SQL: SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod))
AS type, d.adsrc, a.attnotnull, a.atthasdef
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='bm_post', :schema='public'
in /var/www/test2/protected/controllers/PostController.php (230)
in /var/www/test2/index.php (13)

18:49:22.134632         trace   system.db.CDbCommand

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='bm_post', :schema='public'
in /var/www/test2/protected/controllers/PostController.php (230)
in /var/www/test2/index.php (13)

18:49:22.138951         trace   system.db.CDbCommand

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='bm_post', :schema='public'
in /var/www/test2/protected/controllers/PostController.php (230)
in /var/www/test2/index.php (13)

18:49:22.149919         trace   system.db.CDbCommand

Querying SQL: SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod))
AS type, d.adsrc, a.attnotnull, a.atthasdef
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='bm_category', :schema='public'
in /var/www/test2/protected/models/Category.php (18)
in /var/www/test2/protected/models/Post.php (142)
in /var/www/test2/protected/controllers/PostController.php (241)

18:49:22.152172         trace   system.db.CDbCommand

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='bm_category', :schema='public'
in /var/www/test2/protected/models/Category.php (18)
in /var/www/test2/protected/models/Post.php (142)
in /var/www/test2/protected/controllers/PostController.php (241)

18:49:22.155340         trace   system.db.CDbCommand

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='bm_category', :schema='public'
in /var/www/test2/protected/models/Category.php (18)
in /var/www/test2/protected/models/Post.php (142)
in /var/www/test2/protected/controllers/PostController.php (241)

18:49:22.156446         trace   system.db.ar.CActiveRecord

Category.exists()
in /var/www/test2/protected/models/Post.php (142)
in /var/www/test2/protected/controllers/PostController.php (241)
in /var/www/test2/index.php (13)

18:49:22.158860         trace   system.db.CDbCommand

Querying SQL: SELECT 1 FROM "bm_category" "t" WHERE id=:value LIMIT 1.
Bound with :value='600'
in /var/www/test2/protected/models/Post.php (142)
in /var/www/test2/protected/controllers/PostController.php (241)
in /var/www/test2/index.php (13)

18:49:22.160401         trace   system.db.CDbCommand

Querying SQL: SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod))
AS type, d.adsrc, a.attnotnull, a.atthasdef
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='bm_language', :schema='public'
in /var/www/test2/protected/models/Language.php (18)
in /var/www/test2/protected/models/Post.php (156)
in /var/www/test2/protected/controllers/PostController.php (241)

18:49:22.162267         trace   system.db.CDbCommand

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='bm_language', :schema='public'
in /var/www/test2/protected/models/Language.php (18)
in /var/www/test2/protected/models/Post.php (156)
in /var/www/test2/protected/controllers/PostController.php (241)

18:49:22.167499         trace   system.db.ar.CActiveRecord

Language.exists()
in /var/www/test2/protected/models/Post.php (156)
in /var/www/test2/protected/controllers/PostController.php (241)
in /var/www/test2/index.php (13)

18:49:22.167862         trace   system.db.CDbCommand

Querying SQL: SELECT 1 FROM "bm_language" "t" WHERE code=:value LIMIT 1.
Bound with :value='en_US'
in /var/www/test2/protected/models/Post.php (156)
in /var/www/test2/protected/controllers/PostController.php (241)
in /var/www/test2/index.php (13)

18:49:22.169369         trace   system.db.CDbConnection

Starting transaction
in /var/www/test2/protected/controllers/PostController.php (243)
in /var/www/test2/index.php (13)

18:49:22.170391         trace   system.db.ar.CActiveRecord

Post.insert()
in /var/www/test2/protected/controllers/PostController.php (247)
in /var/www/test2/index.php (13)

18:49:22.170937         trace   system.db.CDbCommand

Executing SQL: INSERT INTO "bm_post" ("likes", "dislikes", "category_id",
"title", "content", "lang", "tags", "status", "user_id", "username") VALUES
(:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9). Bound with
:yp0=0, :yp1=0, :yp2=600, :yp3='Phone 1 title', :yp4='Phone 1 content',
:yp5='en_US', :yp6='', :yp7=0, :yp8=2, :yp9='u1'
in /var/www/test2/protected/controllers/PostController.php (247)
in /var/www/test2/index.php (13)

18:49:22.173774         trace   system.db.CDbCommand

Querying SQL: SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod))
AS type, d.adsrc, a.attnotnull, a.atthasdef
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='tag', :schema='public'
in /var/www/test2/protected/extensions/taggable/ETaggableBehavior.php
(363)
in /var/www/test2/protected/models/Post.php (273)
in /var/www/test2/protected/controllers/PostController.php (247)

18:49:22.176331         trace   system.db.CDbCommand

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='tag', :schema='public'
in /var/www/test2/protected/extensions/taggable/ETaggableBehavior.php
(363)
in /var/www/test2/protected/models/Post.php (273)
in /var/www/test2/protected/controllers/PostController.php (247)

18:49:22.182976         trace   system.db.CDbCommand

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='tag', :schema='public'
in /var/www/test2/protected/extensions/taggable/ETaggableBehavior.php
(363)
in /var/www/test2/protected/models/Post.php (273)
in /var/www/test2/protected/controllers/PostController.php (247)

18:49:22.184897         trace   system.db.CDbCommand

Querying SQL: SELECT t.id FROM "tag" "t" WHERE t.name = :tag . Bound with
:tag='fdsfdsfds'
in /var/www/test2/protected/extensions/taggable/ETaggableBehavior.php
(363)
in /var/www/test2/protected/models/Post.php (273)
in /var/www/test2/protected/controllers/PostController.php (247)

18:49:22.187845         trace   system.db.ar.CActiveRecord

Tag.insert()
in /var/www/test2/protected/extensions/taggable/EARTaggableBehavior.php
(27)
in /var/www/test2/protected/extensions/taggable/ETaggableBehavior.php
(367)
in /var/www/test2/protected/models/Post.php (273)

18:49:22.188189         trace   system.db.CDbCommand

Executing SQL: INSERT INTO "tag" ("count", "name") VALUES (:yp0, :yp1).
Bound with :yp0=1, :yp1='fdsfdsfds'
in /var/www/test2/protected/extensions/taggable/EARTaggableBehavior.php
(27)
in /var/www/test2/protected/extensions/taggable/ETaggableBehavior.php
(367)
in /var/www/test2/protected/models/Post.php (273)

18:49:22.191447         trace   system.db.CDbTransaction

Rolling back transaction
in /var/www/test2/protected/controllers/PostController.php (257)
in /var/www/test2/index.php (13)

18:49:22.202941         trace   system.db.ar.CActiveRecord

Category.findAll()
in /var/www/test2/protected/models/Category.php (31)
in /var/www/test2/protected/views/post/_form.php (23)
in /var/www/test2/protected/views/post/create.php (13)

18:49:22.203147         trace   system.db.CDbCommand

Querying SQL: SELECT * FROM "bm_category" "t"
in /var/www/test2/protected/models/Category.php (31)
in /var/www/test2/protected/views/post/_form.php (23)
in /var/www/test2/protected/views/post/create.php (13)

18:49:22.209193         trace   system.db.ar.CActiveRecord

Language.findAll()
in /var/www/test2/protected/models/Language.php (70)
in /var/www/test2/protected/views/post/_form.php (50)
in /var/www/test2/protected/views/post/create.php (13)

18:49:22.209383         trace   system.db.CDbCommand

Querying SQL: SELECT * FROM "bm_language" "t"
in /var/www/test2/protected/models/Language.php (70)
in /var/www/test2/protected/views/post/_form.php (50)
in /var/www/test2/protected/views/post/create.php (13)