Exception: 2024-04-28 17:32:23
Errorno: [42] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sort_date' in 'order clause', query was: SELECT DISTINCT `tblPages`.`id` FROM `tblPages` WHERE (type_id IN ('6')) AND (state_id = '1') AND (date_sort <= NOW()) ORDER BY `sort_date` DESC LIMIT 100
Line: [235] /home/op016400/www_root/library/Zend/Db/Statement/Pdo.php

#0 /home/op016400/www_root/library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/op016400/www_root/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#2 /home/op016400/www_root/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(Object(Zend_Db_Select), Array)
#3 /home/op016400/www_root/library/Zend/Db/Adapter/Abstract.php(737): Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Select), Array)
#4 /home/op016400/www_root/public/lib/pages/classes/pages.class.php(1016): Zend_Db_Adapter_Abstract->fetchAll(Object(Zend_Db_Select))
#5 /home/op016400/www_root/public/project/scripts/modules/project/export/atom.php(53): page::selectOneTypePages('6', '1', 'sort_date DESC', '100')
#6 {main}
Array
(
    [0] => Array
        (
            [file] => /home/op016400/www_root/library/Zend/Db/Statement.php
            [line] => 303
            [function] => _execute
            [class] => Zend_Db_Statement_Pdo
            [type] => ->
            [args] => Array
                (
                    [0] => Array
                        (
                        )

                )

        )

    [1] => Array
        (
            [file] => /home/op016400/www_root/library/Zend/Db/Adapter/Abstract.php
            [line] => 480
            [function] => execute
            [class] => Zend_Db_Statement
            [type] => ->
            [args] => Array
                (
                    [0] => Array
                        (
                        )

                )

        )

    [2] => Array
        (
            [file] => /home/op016400/www_root/library/Zend/Db/Adapter/Pdo/Abstract.php
            [line] => 238
            [function] => query
            [class] => Zend_Db_Adapter_Abstract
            [type] => ->
            [args] => Array
                (
                    [0] => Zend_Db_Select Object
                        (
                            [_bind:protected] => Array
                                (
                                )

                            [_adapter:protected] => Zend_Db_Adapter_Pdo_Mysql Object
                                (
                                    [_pdoType:protected] => mysql
                                    [_numericDataTypes:protected] => Array
                                        (
                                            [0] => 0
                                            [1] => 1
                                            [2] => 2
                                            [INT] => 0
                                            [INTEGER] => 0
                                            [MEDIUMINT] => 0
                                            [SMALLINT] => 0
                                            [TINYINT] => 0
                                            [BIGINT] => 1
                                            [SERIAL] => 1
                                            [DEC] => 2
                                            [DECIMAL] => 2
                                            [DOUBLE] => 2
                                            [DOUBLE PRECISION] => 2
                                            [FIXED] => 2
                                            [FLOAT] => 2
                                        )

                                    [_defaultStmtClass:protected] => Zend_Db_Statement_Pdo
                                    [_config:protected] => Array
                                        (
                                            [host] => 46.229.230.117
                                            [dbname] => op016400db
                                            [username] => op016400
                                            [password] => rzymizum
                                            [charset] => utf8
                                            [persistent] => 
                                            [options] => Array
                                                (
                                                    [caseFolding] => 0
                                                    [autoQuoteIdentifiers] => 1
                                                    [fetchMode] => 2
                                                )

                                            [driver_options] => Array
                                                (
                                                )

                                        )

                                    [_fetchMode:protected] => 2
                                    [_profiler:protected] => Zend_Db_Profiler Object
                                        (
                                            [_queryProfiles:protected] => Array
                                                (
                                                )

                                            [_enabled:protected] => 
                                            [_filterElapsedSecs:protected] => 
                                            [_filterTypes:protected] => 
                                        )

                                    [_defaultProfilerClass:protected] => Zend_Db_Profiler
                                    [_connection:protected] => PDO Object
                                        (
                                        )

                                    [_caseFolding:protected] => 0
                                    [_autoQuoteIdentifiers:protected] => 1
                                    [_allowSerialization:protected] => 1
                                    [_autoReconnectOnUnserialize:protected] => 
                                )

                            [_parts:protected] => Array
                                (
                                    [distinct] => 1
                                    [columns] => Array
                                        (
                                            [0] => Array
                                                (
                                                    [0] => tblPages
                                                    [1] => id
                                                    [2] => 
                                                )

                                        )

                                    [union] => Array
                                        (
                                        )

                                    [from] => Array
                                        (
                                            [tblPages] => Array
                                                (
                                                    [joinType] => from
                                                    [schema] => 
                                                    [tableName] => tblPages
                                                    [joinCondition] => 
                                                )

                                        )

                                    [where] => Array
                                        (
                                            [0] => (type_id IN ('6'))
                                            [1] => AND (state_id = '1')
                                            [2] => AND (date_sort <= NOW())
                                        )

                                    [group] => Array
                                        (
                                        )

                                    [having] => Array
                                        (
                                        )

                                    [order] => Array
                                        (
                                            [0] => Array
                                                (
                                                    [0] => sort_date
                                                    [1] => DESC
                                                )

                                        )

                                    [limitcount] => 100
                                    [limitoffset] => 0
                                    [forupdate] => 
                                )

                            [_tableCols:protected] => Array
                                (
                                )

                        )

                    [1] => Array
                        (
                        )

                )

        )

    [3] => Array
        (
            [file] => /home/op016400/www_root/library/Zend/Db/Adapter/Abstract.php
            [line] => 737
            [function] => query
            [class] => Zend_Db_Adapter_Pdo_Abstract
            [type] => ->
            [args] => Array
                (
                    [0] => Zend_Db_Select Object
                        (
                            [_bind:protected] => Array
                                (
                                )

                            [_adapter:protected] => Zend_Db_Adapter_Pdo_Mysql Object
                                (
                                    [_pdoType:protected] => mysql
                                    [_numericDataTypes:protected] => Array
                                        (
                                            [0] => 0
                                            [1] => 1
                                            [2] => 2
                                            [INT] => 0
                                            [INTEGER] => 0
                                            [MEDIUMINT] => 0
                                            [SMALLINT] => 0
                                            [TINYINT] => 0
                                            [BIGINT] => 1
                                            [SERIAL] => 1
                                            [DEC] => 2
                                            [DECIMAL] => 2
                                            [DOUBLE] => 2
                                            [DOUBLE PRECISION] => 2
                                            [FIXED] => 2
                                            [FLOAT] => 2
                                        )

                                    [_defaultStmtClass:protected] => Zend_Db_Statement_Pdo
                                    [_config:protected] => Array
                                        (
                                            [host] => 46.229.230.117
                                            [dbname] => op016400db
                                            [username] => op016400
                                            [password] => rzymizum
                                            [charset] => utf8
                                            [persistent] => 
                                            [options] => Array
                                                (
                                                    [caseFolding] => 0
                                                    [autoQuoteIdentifiers] => 1
                                                    [fetchMode] => 2
                                                )

                                            [driver_options] => Array
                                                (
                                                )

                                        )

                                    [_fetchMode:protected] => 2
                                    [_profiler:protected] => Zend_Db_Profiler Object
                                        (
                                            [_queryProfiles:protected] => Array
                                                (
                                                )

                                            [_enabled:protected] => 
                                            [_filterElapsedSecs:protected] => 
                                            [_filterTypes:protected] => 
                                        )

                                    [_defaultProfilerClass:protected] => Zend_Db_Profiler
                                    [_connection:protected] => PDO Object
                                        (
                                        )

                                    [_caseFolding:protected] => 0
                                    [_autoQuoteIdentifiers:protected] => 1
                                    [_allowSerialization:protected] => 1
                                    [_autoReconnectOnUnserialize:protected] => 
                                )

                            [_parts:protected] => Array
                                (
                                    [distinct] => 1
                                    [columns] => Array
                                        (
                                            [0] => Array
                                                (
                                                    [0] => tblPages
                                                    [1] => id
                                                    [2] => 
                                                )

                                        )

                                    [union] => Array
                                        (
                                        )

                                    [from] => Array
                                        (
                                            [tblPages] => Array
                                                (
                                                    [joinType] => from
                                                    [schema] => 
                                                    [tableName] => tblPages
                                                    [joinCondition] => 
                                                )

                                        )

                                    [where] => Array
                                        (
                                            [0] => (type_id IN ('6'))
                                            [1] => AND (state_id = '1')
                                            [2] => AND (date_sort <= NOW())
                                        )

                                    [group] => Array
                                        (
                                        )

                                    [having] => Array
                                        (
                                        )

                                    [order] => Array
                                        (
                                            [0] => Array
                                                (
                                                    [0] => sort_date
                                                    [1] => DESC
                                                )

                                        )

                                    [limitcount] => 100
                                    [limitoffset] => 0
                                    [forupdate] => 
                                )

                            [_tableCols:protected] => Array
                                (
                                )

                        )

                    [1] => Array
                        (
                        )

                )

        )

    [4] => Array
        (
            [file] => /home/op016400/www_root/public/lib/pages/classes/pages.class.php
            [line] => 1016
            [function] => fetchAll
            [class] => Zend_Db_Adapter_Abstract
            [type] => ->
            [args] => Array
                (
                    [0] => Zend_Db_Select Object
                        (
                            [_bind:protected] => Array
                                (
                                )

                            [_adapter:protected] => Zend_Db_Adapter_Pdo_Mysql Object
                                (
                                    [_pdoType:protected] => mysql
                                    [_numericDataTypes:protected] => Array
                                        (
                                            [0] => 0
                                            [1] => 1
                                            [2] => 2
                                            [INT] => 0
                                            [INTEGER] => 0
                                            [MEDIUMINT] => 0
                                            [SMALLINT] => 0
                                            [TINYINT] => 0
                                            [BIGINT] => 1
                                            [SERIAL] => 1
                                            [DEC] => 2
                                            [DECIMAL] => 2
                                            [DOUBLE] => 2
                                            [DOUBLE PRECISION] => 2
                                            [FIXED] => 2
                                            [FLOAT] => 2
                                        )

                                    [_defaultStmtClass:protected] => Zend_Db_Statement_Pdo
                                    [_config:protected] => Array
                                        (
                                            [host] => 46.229.230.117
                                            [dbname] => op016400db
                                            [username] => op016400
                                            [password] => rzymizum
                                            [charset] => utf8
                                            [persistent] => 
                                            [options] => Array
                                                (
                                                    [caseFolding] => 0
                                                    [autoQuoteIdentifiers] => 1
                                                    [fetchMode] => 2
                                                )

                                            [driver_options] => Array
                                                (
                                                )

                                        )

                                    [_fetchMode:protected] => 2
                                    [_profiler:protected] => Zend_Db_Profiler Object
                                        (
                                            [_queryProfiles:protected] => Array
                                                (
                                                )

                                            [_enabled:protected] => 
                                            [_filterElapsedSecs:protected] => 
                                            [_filterTypes:protected] => 
                                        )

                                    [_defaultProfilerClass:protected] => Zend_Db_Profiler
                                    [_connection:protected] => PDO Object
                                        (
                                        )

                                    [_caseFolding:protected] => 0
                                    [_autoQuoteIdentifiers:protected] => 1
                                    [_allowSerialization:protected] => 1
                                    [_autoReconnectOnUnserialize:protected] => 
                                )

                            [_parts:protected] => Array
                                (
                                    [distinct] => 1
                                    [columns] => Array
                                        (
                                            [0] => Array
                                                (
                                                    [0] => tblPages
                                                    [1] => id
                                                    [2] => 
                                                )

                                        )

                                    [union] => Array
                                        (
                                        )

                                    [from] => Array
                                        (
                                            [tblPages] => Array
                                                (
                                                    [joinType] => from
                                                    [schema] => 
                                                    [tableName] => tblPages
                                                    [joinCondition] => 
                                                )

                                        )

                                    [where] => Array
                                        (
                                            [0] => (type_id IN ('6'))
                                            [1] => AND (state_id = '1')
                                            [2] => AND (date_sort <= NOW())
                                        )

                                    [group] => Array
                                        (
                                        )

                                    [having] => Array
                                        (
                                        )

                                    [order] => Array
                                        (
                                            [0] => Array
                                                (
                                                    [0] => sort_date
                                                    [1] => DESC
                                                )

                                        )

                                    [limitcount] => 100
                                    [limitoffset] => 0
                                    [forupdate] => 
                                )

                            [_tableCols:protected] => Array
                                (
                                )

                        )

                )

        )

    [5] => Array
        (
            [file] => /home/op016400/www_root/public/project/scripts/modules/project/export/atom.php
            [line] => 53
            [function] => selectOneTypePages
            [class] => page
            [type] => ::
            [args] => Array
                (
                    [0] => 6
                    [1] => 1
                    [2] => sort_date DESC
                    [3] => 100
                )

        )

)