SQLException Object
(
    [codes] => Array
        (
            [0] => Uknown database error
            [1045] => Connection failed
            [1452] => Invalid identifier relation
            [1062] => Duplicate entry
            [1267] => Illegal character encoding
        )

    [message:protected] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND g.publish_playthq=1
                       AND g.published=1  AND COALESCE(' at line 37
    [string:private] => 
    [code:protected] => 1064
    [file:protected] => /mnt/www/playthq.com/dao/DAO.php
    [line:protected] => 33
    [trace:private] => Array
        (
            [0] => Array
                (
                    [file] => /mnt/www/playthq.com/dao/DAO.php
                    [line] => 86
                    [function] => select
                    [class] => DAO
                    [type] => ->
                    [args] => Array
                        (
                            [0] => SELECT
                    g.id,
                    gp.parent_id AS global_id,
                    g.title,
                    g.strapline,
                    g.features,
                    IF(g.description_playthq IS NOT NULL AND LENGTH(g.description_playthq)>20,g.description_playthq,g.description) AS description,
                    g.legals,
                    UNIX_TIMESTAMP(g.release_date) AS release_ts,
                    g.release_date,
                    g.release_flag,
                    g.packshot,
                    g.packshot_front,
                    g.packshot_front_thumb,
                    g.packshot_back,
                    g.packshot_back_thumb,
                    g.official_site_href,
                    g.official_game_banner,
                    g.official_game_banner_playthq,
                    g.genre_id,
                    g.platform_id,
                    g.territory_id AS locale_id,
                    ar.id AS age_rating_id,
                    ar.resource AS age_rating_name,
                    ar.`icon` AS `age_rating_icon`,
                    g.`age_rating_description`,
                    d.id AS developer_id,
                    d.resource AS developer_name,
                    d.image AS developer_logo,
                    g.kids,
                    g.show_age_rating_icon,
                    g.metaboli_link
                FROM games g
                LEFT JOIN games gp ON (gp.id = g.parent_id)
                LEFT JOIN age_rating ar ON (ar.id = g.age_rating_id)
                LEFT JOIN developer d ON (d.id = g.developer_id)
                WHERE g.id= AND g.publish_playthq=1
                       AND g.published=1  AND COALESCE(g.published_date,NOW()) <= NOW()  
                        )

                )

            [1] => Array
                (
                    [file] => /mnt/www/playthq.com/dao/GameDAO.php
                    [line] => 154
                    [function] => uniqueResult
                    [class] => DAO
                    [type] => ->
                    [args] => Array
                        (
                            [0] => SELECT
                    g.id,
                    gp.parent_id AS global_id,
                    g.title,
                    g.strapline,
                    g.features,
                    IF(g.description_playthq IS NOT NULL AND LENGTH(g.description_playthq)>20,g.description_playthq,g.description) AS description,
                    g.legals,
                    UNIX_TIMESTAMP(g.release_date) AS release_ts,
                    g.release_date,
                    g.release_flag,
                    g.packshot,
                    g.packshot_front,
                    g.packshot_front_thumb,
                    g.packshot_back,
                    g.packshot_back_thumb,
                    g.official_site_href,
                    g.official_game_banner,
                    g.official_game_banner_playthq,
                    g.genre_id,
                    g.platform_id,
                    g.territory_id AS locale_id,
                    ar.id AS age_rating_id,
                    ar.resource AS age_rating_name,
                    ar.`icon` AS `age_rating_icon`,
                    g.`age_rating_description`,
                    d.id AS developer_id,
                    d.resource AS developer_name,
                    d.image AS developer_logo,
                    g.kids,
                    g.show_age_rating_icon,
                    g.metaboli_link
                FROM games g
                LEFT JOIN games gp ON (gp.id = g.parent_id)
                LEFT JOIN age_rating ar ON (ar.id = g.age_rating_id)
                LEFT JOIN developer d ON (d.id = g.developer_id)
                WHERE g.id= AND g.publish_playthq=1
                       AND g.published=1  AND COALESCE(g.published_date,NOW()) <= NOW()  
                        )

                )

            [2] => Array
                (
                    [file] => /mnt/www/playthq.com/controllers/GameController.php
                    [line] => 24
                    [function] => getGame
                    [class] => GameDAO
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
                        )

                )

            [3] => Array
                (
                    [file] => /mnt/www/playthq.com/controllers/Controller.php
                    [line] => 26
                    [function] => index
                    [class] => GameController
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

            [4] => Array
                (
                    [file] => /mnt/www/playthq.com/lib/framework.php
                    [line] => 46
                    [function] => execute
                    [class] => Controller
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

            [5] => Array
                (
                    [file] => /mnt/www/playthq.com/index.php
                    [line] => 33
                    [function] => process
                    [args] => Array
                        (
                        )

                )

        )

)
1