Erro:
EXCEPTION_OTHER
Zend_Controller_Request_Http Object
(
[_paramSources:protected] => Array
(
[0] => _GET
[1] => _POST
)
[_requestUri:protected] => /produtos/dormitorios.html
[_baseUrl:protected] =>
[_basePath:protected] =>
[_pathInfo:protected] => /produtos/dormitorios.html
[_params:protected] => Array
(
[nome_sistema] => dormitorios.html
[controller] => produtos
[action] => mais-detalhes
)
[_rawBody:protected] =>
[_aliases:protected] => Array
(
)
[_dispatched:protected] => 1
[_module:protected] => site
[_moduleKey:protected] => module
[_controller:protected] => produtos
[_controllerKey:protected] => controller
[_action:protected] => mais-detalhes
[_actionKey:protected] => action
)
Zend_Db_Statement_Exception Object
(
[_previous:Zend_Exception:private] =>
[message:protected] => SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near ")"
LINE 1: ....* FROM "site"."produto" WHERE (pro_codigo not in() AND prc_...
^
[string:Exception:private] =>
[code:protected] => 42601
[file:protected] => /home/scdecor/www/library/Zend/Db/Statement/Pdo.php
[line:protected] => 234
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /home/scdecor/www/library/Zend/Db/Statement.php
[line] => 300
[function] => _execute
[class] => Zend_Db_Statement_Pdo
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[1] => Array
(
[file] => /home/scdecor/www/library/Zend/Db/Adapter/Abstract.php
[line] => 481
[function] => execute
[class] => Zend_Db_Statement
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[2] => Array
(
[file] => /home/scdecor/www/library/Zend/Db/Adapter/Pdo/Abstract.php
[line] => 238
[function] => query
[class] => Zend_Db_Adapter_Abstract
[type] => ->
[args] => Array
(
[0] => Zend_Db_Table_Select Object
(
[_info:protected] => Array
(
[schema] => site
[name] => produto
[cols] => Array
(
[0] => pro_codigo
[1] => pro_nome
[2] => pro_imagem
[3] => prc_codigo
[4] => pro_thumb
[5] => pro_url_video
[6] => pro_nome_sistema
[7] => pro_descricao
[8] => pro_descricao_breve
)
[primary] => Array
(
[1] => pro_codigo
)
[metadata] => Array
(
[pro_codigo] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_codigo
[COLUMN_POSITION] => 1
[DATA_TYPE] => int4
[DEFAULT] => nextval('produto_pro_codigo_seq'::regclass)
[NULLABLE] =>
[LENGTH] => 4
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] => 1
[PRIMARY_POSITION] => 1
[IDENTITY] => 1
)
[pro_nome] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_nome
[COLUMN_POSITION] => 2
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_imagem] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_imagem
[COLUMN_POSITION] => 3
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[prc_codigo] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => prc_codigo
[COLUMN_POSITION] => 4
[DATA_TYPE] => int4
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => 4
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_thumb] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_thumb
[COLUMN_POSITION] => 5
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_url_video] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_url_video
[COLUMN_POSITION] => 6
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_nome_sistema] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_nome_sistema
[COLUMN_POSITION] => 7
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_descricao] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_descricao
[COLUMN_POSITION] => 8
[DATA_TYPE] => text
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => -1
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_descricao_breve] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_descricao_breve
[COLUMN_POSITION] => 9
[DATA_TYPE] => text
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => -1
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
)
[rowClass] => Zend_Db_Table_Row
[rowsetClass] => Zend_Db_Table_Rowset
[referenceMap] => Array
(
)
[dependentTables] => Array
(
)
[sequence] => "site"."produto_pro_codigo_seq"
)
[_integrityCheck:protected] => 1
[_table:protected] => ProdutoDAO Object
(
[_name:protected] => produto
[_primary:protected] => Array
(
[1] => pro_codigo
)
[_schema:protected] => site
[_definition:protected] =>
[_definitionConfigName:protected] =>
[_db:protected] => Zend_Db_Adapter_Pdo_Pgsql Object
(
[_pdoType:protected] => pgsql
[_numericDataTypes:protected] => Array
(
[0] => 0
[1] => 1
[2] => 2
[INTEGER] => 0
[SERIAL] => 0
[SMALLINT] => 0
[BIGINT] => 1
[BIGSERIAL] => 1
[DECIMAL] => 2
[DOUBLE PRECISION] => 2
[NUMERIC] => 2
[REAL] => 2
)
[_defaultStmtClass:protected] => Zend_Db_Statement_Pdo
[_config:protected] => Array
(
[host] => pgsql.scdecor.com.br
[dbname] => scdecor
[username] => scdecor
[password] => 321rje
[options] => Array
(
[caseFolding] => 2
[autoQuoteIdentifiers] => 1
[fetchMode] => 2
[ReturnDatesAsStrings] => 0
)
[charset] =>
[persistent] =>
[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] => 2
[_autoQuoteIdentifiers:protected] => 1
[_allowSerialization:protected] => 1
[_autoReconnectOnUnserialize:protected] =>
)
[_cols:protected] => Array
(
[0] => pro_codigo
[1] => pro_nome
[2] => pro_imagem
[3] => prc_codigo
[4] => pro_thumb
[5] => pro_url_video
[6] => pro_nome_sistema
[7] => pro_descricao
[8] => pro_descricao_breve
)
[_identity:protected] => 1
[_sequence:protected] => "site"."produto_pro_codigo_seq"
[_metadata:protected] => Array
(
[pro_codigo] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_codigo
[COLUMN_POSITION] => 1
[DATA_TYPE] => int4
[DEFAULT] => nextval('produto_pro_codigo_seq'::regclass)
[NULLABLE] =>
[LENGTH] => 4
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] => 1
[PRIMARY_POSITION] => 1
[IDENTITY] => 1
)
[pro_nome] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_nome
[COLUMN_POSITION] => 2
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_imagem] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_imagem
[COLUMN_POSITION] => 3
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[prc_codigo] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => prc_codigo
[COLUMN_POSITION] => 4
[DATA_TYPE] => int4
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => 4
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_thumb] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_thumb
[COLUMN_POSITION] => 5
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_url_video] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_url_video
[COLUMN_POSITION] => 6
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_nome_sistema] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_nome_sistema
[COLUMN_POSITION] => 7
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_descricao] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_descricao
[COLUMN_POSITION] => 8
[DATA_TYPE] => text
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => -1
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_descricao_breve] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_descricao_breve
[COLUMN_POSITION] => 9
[DATA_TYPE] => text
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => -1
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
)
[_metadataCache:protected] =>
[_metadataCacheInClass:protected] => 1
[_rowClass:protected] => Zend_Db_Table_Row
[_rowsetClass:protected] => Zend_Db_Table_Rowset
[_referenceMap:protected] => Array
(
)
[_dependentTables:protected] => Array
(
)
[_defaultSource:protected] => defaultNone
[_defaultValues:protected] => Array
(
)
)
[_bind:protected] => Array
(
)
[_adapter:protected] => Zend_Db_Adapter_Pdo_Pgsql Object
(
[_pdoType:protected] => pgsql
[_numericDataTypes:protected] => Array
(
[0] => 0
[1] => 1
[2] => 2
[INTEGER] => 0
[SERIAL] => 0
[SMALLINT] => 0
[BIGINT] => 1
[BIGSERIAL] => 1
[DECIMAL] => 2
[DOUBLE PRECISION] => 2
[NUMERIC] => 2
[REAL] => 2
)
[_defaultStmtClass:protected] => Zend_Db_Statement_Pdo
[_config:protected] => Array
(
[host] => pgsql.scdecor.com.br
[dbname] => scdecor
[username] => scdecor
[password] => 321rje
[options] => Array
(
[caseFolding] => 2
[autoQuoteIdentifiers] => 1
[fetchMode] => 2
[ReturnDatesAsStrings] => 0
)
[charset] =>
[persistent] =>
[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] => 2
[_autoQuoteIdentifiers:protected] => 1
[_allowSerialization:protected] => 1
[_autoReconnectOnUnserialize:protected] =>
)
[_parts:protected] => Array
(
[distinct] =>
[columns] => Array
(
[0] => Array
(
[0] => produto
[1] => *
[2] =>
)
)
[union] => Array
(
)
[from] => Array
(
[produto] => Array
(
[joinType] => inner join
[schema] => site
[tableName] => produto
[joinCondition] =>
)
)
[where] => Array
(
[0] => (pro_codigo not in() AND prc_codigo = )
)
[group] => Array
(
)
[having] => Array
(
)
[order] => Array
(
)
[limitcount] =>
[limitoffset] =>
[forupdate] =>
)
[_tableCols:protected] => Array
(
)
)
[1] => Array
(
)
)
)
[3] => Array
(
[file] => /home/scdecor/www/library/Zend/Db/Table/Abstract.php
[line] => 1529
[function] => query
[class] => Zend_Db_Adapter_Pdo_Abstract
[type] => ->
[args] => Array
(
[0] => Zend_Db_Table_Select Object
(
[_info:protected] => Array
(
[schema] => site
[name] => produto
[cols] => Array
(
[0] => pro_codigo
[1] => pro_nome
[2] => pro_imagem
[3] => prc_codigo
[4] => pro_thumb
[5] => pro_url_video
[6] => pro_nome_sistema
[7] => pro_descricao
[8] => pro_descricao_breve
)
[primary] => Array
(
[1] => pro_codigo
)
[metadata] => Array
(
[pro_codigo] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_codigo
[COLUMN_POSITION] => 1
[DATA_TYPE] => int4
[DEFAULT] => nextval('produto_pro_codigo_seq'::regclass)
[NULLABLE] =>
[LENGTH] => 4
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] => 1
[PRIMARY_POSITION] => 1
[IDENTITY] => 1
)
[pro_nome] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_nome
[COLUMN_POSITION] => 2
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_imagem] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_imagem
[COLUMN_POSITION] => 3
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[prc_codigo] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => prc_codigo
[COLUMN_POSITION] => 4
[DATA_TYPE] => int4
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => 4
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_thumb] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_thumb
[COLUMN_POSITION] => 5
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_url_video] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_url_video
[COLUMN_POSITION] => 6
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_nome_sistema] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_nome_sistema
[COLUMN_POSITION] => 7
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_descricao] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_descricao
[COLUMN_POSITION] => 8
[DATA_TYPE] => text
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => -1
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_descricao_breve] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_descricao_breve
[COLUMN_POSITION] => 9
[DATA_TYPE] => text
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => -1
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
)
[rowClass] => Zend_Db_Table_Row
[rowsetClass] => Zend_Db_Table_Rowset
[referenceMap] => Array
(
)
[dependentTables] => Array
(
)
[sequence] => "site"."produto_pro_codigo_seq"
)
[_integrityCheck:protected] => 1
[_table:protected] => ProdutoDAO Object
(
[_name:protected] => produto
[_primary:protected] => Array
(
[1] => pro_codigo
)
[_schema:protected] => site
[_definition:protected] =>
[_definitionConfigName:protected] =>
[_db:protected] => Zend_Db_Adapter_Pdo_Pgsql Object
(
[_pdoType:protected] => pgsql
[_numericDataTypes:protected] => Array
(
[0] => 0
[1] => 1
[2] => 2
[INTEGER] => 0
[SERIAL] => 0
[SMALLINT] => 0
[BIGINT] => 1
[BIGSERIAL] => 1
[DECIMAL] => 2
[DOUBLE PRECISION] => 2
[NUMERIC] => 2
[REAL] => 2
)
[_defaultStmtClass:protected] => Zend_Db_Statement_Pdo
[_config:protected] => Array
(
[host] => pgsql.scdecor.com.br
[dbname] => scdecor
[username] => scdecor
[password] => 321rje
[options] => Array
(
[caseFolding] => 2
[autoQuoteIdentifiers] => 1
[fetchMode] => 2
[ReturnDatesAsStrings] => 0
)
[charset] =>
[persistent] =>
[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] => 2
[_autoQuoteIdentifiers:protected] => 1
[_allowSerialization:protected] => 1
[_autoReconnectOnUnserialize:protected] =>
)
[_cols:protected] => Array
(
[0] => pro_codigo
[1] => pro_nome
[2] => pro_imagem
[3] => prc_codigo
[4] => pro_thumb
[5] => pro_url_video
[6] => pro_nome_sistema
[7] => pro_descricao
[8] => pro_descricao_breve
)
[_identity:protected] => 1
[_sequence:protected] => "site"."produto_pro_codigo_seq"
[_metadata:protected] => Array
(
[pro_codigo] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_codigo
[COLUMN_POSITION] => 1
[DATA_TYPE] => int4
[DEFAULT] => nextval('produto_pro_codigo_seq'::regclass)
[NULLABLE] =>
[LENGTH] => 4
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] => 1
[PRIMARY_POSITION] => 1
[IDENTITY] => 1
)
[pro_nome] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_nome
[COLUMN_POSITION] => 2
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_imagem] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_imagem
[COLUMN_POSITION] => 3
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[prc_codigo] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => prc_codigo
[COLUMN_POSITION] => 4
[DATA_TYPE] => int4
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => 4
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_thumb] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_thumb
[COLUMN_POSITION] => 5
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_url_video] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_url_video
[COLUMN_POSITION] => 6
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_nome_sistema] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_nome_sistema
[COLUMN_POSITION] => 7
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_descricao] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_descricao
[COLUMN_POSITION] => 8
[DATA_TYPE] => text
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => -1
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_descricao_breve] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_descricao_breve
[COLUMN_POSITION] => 9
[DATA_TYPE] => text
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => -1
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
)
[_metadataCache:protected] =>
[_metadataCacheInClass:protected] => 1
[_rowClass:protected] => Zend_Db_Table_Row
[_rowsetClass:protected] => Zend_Db_Table_Rowset
[_referenceMap:protected] => Array
(
)
[_dependentTables:protected] => Array
(
)
[_defaultSource:protected] => defaultNone
[_defaultValues:protected] => Array
(
)
)
[_bind:protected] => Array
(
)
[_adapter:protected] => Zend_Db_Adapter_Pdo_Pgsql Object
(
[_pdoType:protected] => pgsql
[_numericDataTypes:protected] => Array
(
[0] => 0
[1] => 1
[2] => 2
[INTEGER] => 0
[SERIAL] => 0
[SMALLINT] => 0
[BIGINT] => 1
[BIGSERIAL] => 1
[DECIMAL] => 2
[DOUBLE PRECISION] => 2
[NUMERIC] => 2
[REAL] => 2
)
[_defaultStmtClass:protected] => Zend_Db_Statement_Pdo
[_config:protected] => Array
(
[host] => pgsql.scdecor.com.br
[dbname] => scdecor
[username] => scdecor
[password] => 321rje
[options] => Array
(
[caseFolding] => 2
[autoQuoteIdentifiers] => 1
[fetchMode] => 2
[ReturnDatesAsStrings] => 0
)
[charset] =>
[persistent] =>
[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] => 2
[_autoQuoteIdentifiers:protected] => 1
[_allowSerialization:protected] => 1
[_autoReconnectOnUnserialize:protected] =>
)
[_parts:protected] => Array
(
[distinct] =>
[columns] => Array
(
[0] => Array
(
[0] => produto
[1] => *
[2] =>
)
)
[union] => Array
(
)
[from] => Array
(
[produto] => Array
(
[joinType] => inner join
[schema] => site
[tableName] => produto
[joinCondition] =>
)
)
[where] => Array
(
[0] => (pro_codigo not in() AND prc_codigo = )
)
[group] => Array
(
)
[having] => Array
(
)
[order] => Array
(
)
[limitcount] =>
[limitoffset] =>
[forupdate] =>
)
[_tableCols:protected] => Array
(
)
)
)
)
[4] => Array
(
[file] => /home/scdecor/www/library/Zend/Db/Table/Abstract.php
[line] => 1344
[function] => _fetch
[class] => Zend_Db_Table_Abstract
[type] => ->
[args] => Array
(
[0] => Zend_Db_Table_Select Object
(
[_info:protected] => Array
(
[schema] => site
[name] => produto
[cols] => Array
(
[0] => pro_codigo
[1] => pro_nome
[2] => pro_imagem
[3] => prc_codigo
[4] => pro_thumb
[5] => pro_url_video
[6] => pro_nome_sistema
[7] => pro_descricao
[8] => pro_descricao_breve
)
[primary] => Array
(
[1] => pro_codigo
)
[metadata] => Array
(
[pro_codigo] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_codigo
[COLUMN_POSITION] => 1
[DATA_TYPE] => int4
[DEFAULT] => nextval('produto_pro_codigo_seq'::regclass)
[NULLABLE] =>
[LENGTH] => 4
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] => 1
[PRIMARY_POSITION] => 1
[IDENTITY] => 1
)
[pro_nome] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_nome
[COLUMN_POSITION] => 2
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_imagem] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_imagem
[COLUMN_POSITION] => 3
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[prc_codigo] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => prc_codigo
[COLUMN_POSITION] => 4
[DATA_TYPE] => int4
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => 4
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_thumb] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_thumb
[COLUMN_POSITION] => 5
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_url_video] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_url_video
[COLUMN_POSITION] => 6
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_nome_sistema] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_nome_sistema
[COLUMN_POSITION] => 7
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_descricao] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_descricao
[COLUMN_POSITION] => 8
[DATA_TYPE] => text
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => -1
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_descricao_breve] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_descricao_breve
[COLUMN_POSITION] => 9
[DATA_TYPE] => text
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => -1
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
)
[rowClass] => Zend_Db_Table_Row
[rowsetClass] => Zend_Db_Table_Rowset
[referenceMap] => Array
(
)
[dependentTables] => Array
(
)
[sequence] => "site"."produto_pro_codigo_seq"
)
[_integrityCheck:protected] => 1
[_table:protected] => ProdutoDAO Object
(
[_name:protected] => produto
[_primary:protected] => Array
(
[1] => pro_codigo
)
[_schema:protected] => site
[_definition:protected] =>
[_definitionConfigName:protected] =>
[_db:protected] => Zend_Db_Adapter_Pdo_Pgsql Object
(
[_pdoType:protected] => pgsql
[_numericDataTypes:protected] => Array
(
[0] => 0
[1] => 1
[2] => 2
[INTEGER] => 0
[SERIAL] => 0
[SMALLINT] => 0
[BIGINT] => 1
[BIGSERIAL] => 1
[DECIMAL] => 2
[DOUBLE PRECISION] => 2
[NUMERIC] => 2
[REAL] => 2
)
[_defaultStmtClass:protected] => Zend_Db_Statement_Pdo
[_config:protected] => Array
(
[host] => pgsql.scdecor.com.br
[dbname] => scdecor
[username] => scdecor
[password] => 321rje
[options] => Array
(
[caseFolding] => 2
[autoQuoteIdentifiers] => 1
[fetchMode] => 2
[ReturnDatesAsStrings] => 0
)
[charset] =>
[persistent] =>
[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] => 2
[_autoQuoteIdentifiers:protected] => 1
[_allowSerialization:protected] => 1
[_autoReconnectOnUnserialize:protected] =>
)
[_cols:protected] => Array
(
[0] => pro_codigo
[1] => pro_nome
[2] => pro_imagem
[3] => prc_codigo
[4] => pro_thumb
[5] => pro_url_video
[6] => pro_nome_sistema
[7] => pro_descricao
[8] => pro_descricao_breve
)
[_identity:protected] => 1
[_sequence:protected] => "site"."produto_pro_codigo_seq"
[_metadata:protected] => Array
(
[pro_codigo] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_codigo
[COLUMN_POSITION] => 1
[DATA_TYPE] => int4
[DEFAULT] => nextval('produto_pro_codigo_seq'::regclass)
[NULLABLE] =>
[LENGTH] => 4
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] => 1
[PRIMARY_POSITION] => 1
[IDENTITY] => 1
)
[pro_nome] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_nome
[COLUMN_POSITION] => 2
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_imagem] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_imagem
[COLUMN_POSITION] => 3
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[prc_codigo] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => prc_codigo
[COLUMN_POSITION] => 4
[DATA_TYPE] => int4
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => 4
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_thumb] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_thumb
[COLUMN_POSITION] => 5
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_url_video] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_url_video
[COLUMN_POSITION] => 6
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_nome_sistema] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_nome_sistema
[COLUMN_POSITION] => 7
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_descricao] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_descricao
[COLUMN_POSITION] => 8
[DATA_TYPE] => text
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => -1
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_descricao_breve] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_descricao_breve
[COLUMN_POSITION] => 9
[DATA_TYPE] => text
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => -1
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
)
[_metadataCache:protected] =>
[_metadataCacheInClass:protected] => 1
[_rowClass:protected] => Zend_Db_Table_Row
[_rowsetClass:protected] => Zend_Db_Table_Rowset
[_referenceMap:protected] => Array
(
)
[_dependentTables:protected] => Array
(
)
[_defaultSource:protected] => defaultNone
[_defaultValues:protected] => Array
(
)
)
[_bind:protected] => Array
(
)
[_adapter:protected] => Zend_Db_Adapter_Pdo_Pgsql Object
(
[_pdoType:protected] => pgsql
[_numericDataTypes:protected] => Array
(
[0] => 0
[1] => 1
[2] => 2
[INTEGER] => 0
[SERIAL] => 0
[SMALLINT] => 0
[BIGINT] => 1
[BIGSERIAL] => 1
[DECIMAL] => 2
[DOUBLE PRECISION] => 2
[NUMERIC] => 2
[REAL] => 2
)
[_defaultStmtClass:protected] => Zend_Db_Statement_Pdo
[_config:protected] => Array
(
[host] => pgsql.scdecor.com.br
[dbname] => scdecor
[username] => scdecor
[password] => 321rje
[options] => Array
(
[caseFolding] => 2
[autoQuoteIdentifiers] => 1
[fetchMode] => 2
[ReturnDatesAsStrings] => 0
)
[charset] =>
[persistent] =>
[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] => 2
[_autoQuoteIdentifiers:protected] => 1
[_allowSerialization:protected] => 1
[_autoReconnectOnUnserialize:protected] =>
)
[_parts:protected] => Array
(
[distinct] =>
[columns] => Array
(
[0] => Array
(
[0] => produto
[1] => *
[2] =>
)
)
[union] => Array
(
)
[from] => Array
(
[produto] => Array
(
[joinType] => inner join
[schema] => site
[tableName] => produto
[joinCondition] =>
)
)
[where] => Array
(
[0] => (pro_codigo not in() AND prc_codigo = )
)
[group] => Array
(
)
[having] => Array
(
)
[order] => Array
(
)
[limitcount] =>
[limitoffset] =>
[forupdate] =>
)
[_tableCols:protected] => Array
(
)
)
)
)
[5] => Array
(
[file] => /home/scdecor/www/application/modules/site/controllers/ProdutosController.php
[line] => 40
[function] => fetchAll
[class] => Zend_Db_Table_Abstract
[type] => ->
[args] => Array
(
[0] => pro_codigo not in() AND prc_codigo =
)
)
[6] => Array
(
[file] => /home/scdecor/www/library/Zend/Controller/Action.php
[line] => 516
[function] => maisDetalhesAction
[class] => Site_ProdutosController
[type] => ->
[args] => Array
(
)
)
[7] => Array
(
[file] => /home/scdecor/www/library/Zend/Controller/Dispatcher/Standard.php
[line] => 295
[function] => dispatch
[class] => Zend_Controller_Action
[type] => ->
[args] => Array
(
[0] => maisDetalhesAction
)
)
[8] => Array
(
[file] => /home/scdecor/www/library/Zend/Controller/Front.php
[line] => 954
[function] => dispatch
[class] => Zend_Controller_Dispatcher_Standard
[type] => ->
[args] => Array
(
[0] => Zend_Controller_Request_Http Object
(
[_paramSources:protected] => Array
(
[0] => _GET
[1] => _POST
)
[_requestUri:protected] => /produtos/dormitorios.html
[_baseUrl:protected] =>
[_basePath:protected] =>
[_pathInfo:protected] => /produtos/dormitorios.html
[_params:protected] => Array
(
[nome_sistema] => dormitorios.html
[controller] => produtos
[action] => mais-detalhes
[error_handler] => ArrayObject Object
(
[storage:ArrayObject:private] => Array
(
[exception] => Zend_Db_Statement_Exception Object
*RECURSION*
[type] => EXCEPTION_OTHER
[request] => Zend_Controller_Request_Http Object
(
[_paramSources:protected] => Array
(
[0] => _GET
[1] => _POST
)
[_requestUri:protected] => /produtos/dormitorios.html
[_baseUrl:protected] =>
[_basePath:protected] =>
[_pathInfo:protected] => /produtos/dormitorios.html
[_params:protected] => Array
(
[nome_sistema] => dormitorios.html
[controller] => produtos
[action] => mais-detalhes
)
[_rawBody:protected] =>
[_aliases:protected] => Array
(
)
[_dispatched:protected] => 1
[_module:protected] => site
[_moduleKey:protected] => module
[_controller:protected] => produtos
[_controllerKey:protected] => controller
[_action:protected] => mais-detalhes
[_actionKey:protected] => action
)
)
)
)
[_rawBody:protected] =>
[_aliases:protected] => Array
(
)
[_dispatched:protected] => 1
[_module:protected] => site
[_moduleKey:protected] => module
[_controller:protected] => error
[_controllerKey:protected] => controller
[_action:protected] => error
[_actionKey:protected] => action
)
[1] => Zend_Controller_Response_Http Object
(
[_body:protected] => Array
(
)
[_exceptions:protected] => Array
(
[0] => Zend_Db_Statement_Exception Object
*RECURSION*
)
[_headers:protected] => Array
(
)
[_headersRaw:protected] => Array
(
)
[_httpResponseCode:protected] => 500
[_isRedirect:protected] =>
[_renderExceptions:protected] =>
[headersSentThrowsException] => 1
)
)
)
[9] => Array
(
[file] => /home/scdecor/www/library/Zend/Application/Bootstrap/Bootstrap.php
[line] => 97
[function] => dispatch
[class] => Zend_Controller_Front
[type] => ->
[args] => Array
(
)
)
[10] => Array
(
[file] => /home/scdecor/www/library/Zend/Application.php
[line] => 366
[function] => run
[class] => Zend_Application_Bootstrap_Bootstrap
[type] => ->
[args] => Array
(
)
)
[11] => Array
(
[file] => /home/scdecor/www/public/index.php
[line] => 34
[function] => run
[class] => Zend_Application
[type] => ->
[args] => Array
(
)
)
)
[previous:Exception:private] => PDOException Object
(
[message:protected] => SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near ")"
LINE 1: ....* FROM "site"."produto" WHERE (pro_codigo not in() AND prc_...
^
[string:Exception:private] =>
[code:protected] => 42601
[file:protected] => /home/scdecor/www/library/Zend/Db/Statement/Pdo.php
[line:protected] => 228
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /home/scdecor/www/library/Zend/Db/Statement/Pdo.php
[line] => 228
[function] => execute
[class] => PDOStatement
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[1] => Array
(
[file] => /home/scdecor/www/library/Zend/Db/Statement.php
[line] => 300
[function] => _execute
[class] => Zend_Db_Statement_Pdo
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[2] => Array
(
[file] => /home/scdecor/www/library/Zend/Db/Adapter/Abstract.php
[line] => 481
[function] => execute
[class] => Zend_Db_Statement
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[3] => Array
(
[file] => /home/scdecor/www/library/Zend/Db/Adapter/Pdo/Abstract.php
[line] => 238
[function] => query
[class] => Zend_Db_Adapter_Abstract
[type] => ->
[args] => Array
(
[0] => Zend_Db_Table_Select Object
(
[_info:protected] => Array
(
[schema] => site
[name] => produto
[cols] => Array
(
[0] => pro_codigo
[1] => pro_nome
[2] => pro_imagem
[3] => prc_codigo
[4] => pro_thumb
[5] => pro_url_video
[6] => pro_nome_sistema
[7] => pro_descricao
[8] => pro_descricao_breve
)
[primary] => Array
(
[1] => pro_codigo
)
[metadata] => Array
(
[pro_codigo] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_codigo
[COLUMN_POSITION] => 1
[DATA_TYPE] => int4
[DEFAULT] => nextval('produto_pro_codigo_seq'::regclass)
[NULLABLE] =>
[LENGTH] => 4
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] => 1
[PRIMARY_POSITION] => 1
[IDENTITY] => 1
)
[pro_nome] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_nome
[COLUMN_POSITION] => 2
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_imagem] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_imagem
[COLUMN_POSITION] => 3
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[prc_codigo] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => prc_codigo
[COLUMN_POSITION] => 4
[DATA_TYPE] => int4
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => 4
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_thumb] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_thumb
[COLUMN_POSITION] => 5
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_url_video] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_url_video
[COLUMN_POSITION] => 6
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_nome_sistema] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_nome_sistema
[COLUMN_POSITION] => 7
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_descricao] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_descricao
[COLUMN_POSITION] => 8
[DATA_TYPE] => text
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => -1
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_descricao_breve] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_descricao_breve
[COLUMN_POSITION] => 9
[DATA_TYPE] => text
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => -1
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
)
[rowClass] => Zend_Db_Table_Row
[rowsetClass] => Zend_Db_Table_Rowset
[referenceMap] => Array
(
)
[dependentTables] => Array
(
)
[sequence] => "site"."produto_pro_codigo_seq"
)
[_integrityCheck:protected] => 1
[_table:protected] => ProdutoDAO Object
(
[_name:protected] => produto
[_primary:protected] => Array
(
[1] => pro_codigo
)
[_schema:protected] => site
[_definition:protected] =>
[_definitionConfigName:protected] =>
[_db:protected] => Zend_Db_Adapter_Pdo_Pgsql Object
(
[_pdoType:protected] => pgsql
[_numericDataTypes:protected] => Array
(
[0] => 0
[1] => 1
[2] => 2
[INTEGER] => 0
[SERIAL] => 0
[SMALLINT] => 0
[BIGINT] => 1
[BIGSERIAL] => 1
[DECIMAL] => 2
[DOUBLE PRECISION] => 2
[NUMERIC] => 2
[REAL] => 2
)
[_defaultStmtClass:protected] => Zend_Db_Statement_Pdo
[_config:protected] => Array
(
[host] => pgsql.scdecor.com.br
[dbname] => scdecor
[username] => scdecor
[password] => 321rje
[options] => Array
(
[caseFolding] => 2
[autoQuoteIdentifiers] => 1
[fetchMode] => 2
[ReturnDatesAsStrings] => 0
)
[charset] =>
[persistent] =>
[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] => 2
[_autoQuoteIdentifiers:protected] => 1
[_allowSerialization:protected] => 1
[_autoReconnectOnUnserialize:protected] =>
)
[_cols:protected] => Array
(
[0] => pro_codigo
[1] => pro_nome
[2] => pro_imagem
[3] => prc_codigo
[4] => pro_thumb
[5] => pro_url_video
[6] => pro_nome_sistema
[7] => pro_descricao
[8] => pro_descricao_breve
)
[_identity:protected] => 1
[_sequence:protected] => "site"."produto_pro_codigo_seq"
[_metadata:protected] => Array
(
[pro_codigo] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_codigo
[COLUMN_POSITION] => 1
[DATA_TYPE] => int4
[DEFAULT] => nextval('produto_pro_codigo_seq'::regclass)
[NULLABLE] =>
[LENGTH] => 4
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] => 1
[PRIMARY_POSITION] => 1
[IDENTITY] => 1
)
[pro_nome] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_nome
[COLUMN_POSITION] => 2
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_imagem] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_imagem
[COLUMN_POSITION] => 3
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[prc_codigo] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => prc_codigo
[COLUMN_POSITION] => 4
[DATA_TYPE] => int4
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => 4
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_thumb] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_thumb
[COLUMN_POSITION] => 5
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_url_video] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_url_video
[COLUMN_POSITION] => 6
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_nome_sistema] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_nome_sistema
[COLUMN_POSITION] => 7
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_descricao] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_descricao
[COLUMN_POSITION] => 8
[DATA_TYPE] => text
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => -1
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_descricao_breve] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_descricao_breve
[COLUMN_POSITION] => 9
[DATA_TYPE] => text
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => -1
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
)
[_metadataCache:protected] =>
[_metadataCacheInClass:protected] => 1
[_rowClass:protected] => Zend_Db_Table_Row
[_rowsetClass:protected] => Zend_Db_Table_Rowset
[_referenceMap:protected] => Array
(
)
[_dependentTables:protected] => Array
(
)
[_defaultSource:protected] => defaultNone
[_defaultValues:protected] => Array
(
)
)
[_bind:protected] => Array
(
)
[_adapter:protected] => Zend_Db_Adapter_Pdo_Pgsql Object
(
[_pdoType:protected] => pgsql
[_numericDataTypes:protected] => Array
(
[0] => 0
[1] => 1
[2] => 2
[INTEGER] => 0
[SERIAL] => 0
[SMALLINT] => 0
[BIGINT] => 1
[BIGSERIAL] => 1
[DECIMAL] => 2
[DOUBLE PRECISION] => 2
[NUMERIC] => 2
[REAL] => 2
)
[_defaultStmtClass:protected] => Zend_Db_Statement_Pdo
[_config:protected] => Array
(
[host] => pgsql.scdecor.com.br
[dbname] => scdecor
[username] => scdecor
[password] => 321rje
[options] => Array
(
[caseFolding] => 2
[autoQuoteIdentifiers] => 1
[fetchMode] => 2
[ReturnDatesAsStrings] => 0
)
[charset] =>
[persistent] =>
[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] => 2
[_autoQuoteIdentifiers:protected] => 1
[_allowSerialization:protected] => 1
[_autoReconnectOnUnserialize:protected] =>
)
[_parts:protected] => Array
(
[distinct] =>
[columns] => Array
(
[0] => Array
(
[0] => produto
[1] => *
[2] =>
)
)
[union] => Array
(
)
[from] => Array
(
[produto] => Array
(
[joinType] => inner join
[schema] => site
[tableName] => produto
[joinCondition] =>
)
)
[where] => Array
(
[0] => (pro_codigo not in() AND prc_codigo = )
)
[group] => Array
(
)
[having] => Array
(
)
[order] => Array
(
)
[limitcount] =>
[limitoffset] =>
[forupdate] =>
)
[_tableCols:protected] => Array
(
)
)
[1] => Array
(
)
)
)
[4] => Array
(
[file] => /home/scdecor/www/library/Zend/Db/Table/Abstract.php
[line] => 1529
[function] => query
[class] => Zend_Db_Adapter_Pdo_Abstract
[type] => ->
[args] => Array
(
[0] => Zend_Db_Table_Select Object
(
[_info:protected] => Array
(
[schema] => site
[name] => produto
[cols] => Array
(
[0] => pro_codigo
[1] => pro_nome
[2] => pro_imagem
[3] => prc_codigo
[4] => pro_thumb
[5] => pro_url_video
[6] => pro_nome_sistema
[7] => pro_descricao
[8] => pro_descricao_breve
)
[primary] => Array
(
[1] => pro_codigo
)
[metadata] => Array
(
[pro_codigo] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_codigo
[COLUMN_POSITION] => 1
[DATA_TYPE] => int4
[DEFAULT] => nextval('produto_pro_codigo_seq'::regclass)
[NULLABLE] =>
[LENGTH] => 4
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] => 1
[PRIMARY_POSITION] => 1
[IDENTITY] => 1
)
[pro_nome] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_nome
[COLUMN_POSITION] => 2
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_imagem] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_imagem
[COLUMN_POSITION] => 3
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[prc_codigo] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => prc_codigo
[COLUMN_POSITION] => 4
[DATA_TYPE] => int4
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => 4
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_thumb] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_thumb
[COLUMN_POSITION] => 5
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_url_video] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_url_video
[COLUMN_POSITION] => 6
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_nome_sistema] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_nome_sistema
[COLUMN_POSITION] => 7
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_descricao] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_descricao
[COLUMN_POSITION] => 8
[DATA_TYPE] => text
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => -1
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_descricao_breve] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_descricao_breve
[COLUMN_POSITION] => 9
[DATA_TYPE] => text
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => -1
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
)
[rowClass] => Zend_Db_Table_Row
[rowsetClass] => Zend_Db_Table_Rowset
[referenceMap] => Array
(
)
[dependentTables] => Array
(
)
[sequence] => "site"."produto_pro_codigo_seq"
)
[_integrityCheck:protected] => 1
[_table:protected] => ProdutoDAO Object
(
[_name:protected] => produto
[_primary:protected] => Array
(
[1] => pro_codigo
)
[_schema:protected] => site
[_definition:protected] =>
[_definitionConfigName:protected] =>
[_db:protected] => Zend_Db_Adapter_Pdo_Pgsql Object
(
[_pdoType:protected] => pgsql
[_numericDataTypes:protected] => Array
(
[0] => 0
[1] => 1
[2] => 2
[INTEGER] => 0
[SERIAL] => 0
[SMALLINT] => 0
[BIGINT] => 1
[BIGSERIAL] => 1
[DECIMAL] => 2
[DOUBLE PRECISION] => 2
[NUMERIC] => 2
[REAL] => 2
)
[_defaultStmtClass:protected] => Zend_Db_Statement_Pdo
[_config:protected] => Array
(
[host] => pgsql.scdecor.com.br
[dbname] => scdecor
[username] => scdecor
[password] => 321rje
[options] => Array
(
[caseFolding] => 2
[autoQuoteIdentifiers] => 1
[fetchMode] => 2
[ReturnDatesAsStrings] => 0
)
[charset] =>
[persistent] =>
[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] => 2
[_autoQuoteIdentifiers:protected] => 1
[_allowSerialization:protected] => 1
[_autoReconnectOnUnserialize:protected] =>
)
[_cols:protected] => Array
(
[0] => pro_codigo
[1] => pro_nome
[2] => pro_imagem
[3] => prc_codigo
[4] => pro_thumb
[5] => pro_url_video
[6] => pro_nome_sistema
[7] => pro_descricao
[8] => pro_descricao_breve
)
[_identity:protected] => 1
[_sequence:protected] => "site"."produto_pro_codigo_seq"
[_metadata:protected] => Array
(
[pro_codigo] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_codigo
[COLUMN_POSITION] => 1
[DATA_TYPE] => int4
[DEFAULT] => nextval('produto_pro_codigo_seq'::regclass)
[NULLABLE] =>
[LENGTH] => 4
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] => 1
[PRIMARY_POSITION] => 1
[IDENTITY] => 1
)
[pro_nome] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_nome
[COLUMN_POSITION] => 2
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_imagem] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_imagem
[COLUMN_POSITION] => 3
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[prc_codigo] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => prc_codigo
[COLUMN_POSITION] => 4
[DATA_TYPE] => int4
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => 4
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_thumb] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_thumb
[COLUMN_POSITION] => 5
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_url_video] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_url_video
[COLUMN_POSITION] => 6
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_nome_sistema] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_nome_sistema
[COLUMN_POSITION] => 7
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_descricao] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_descricao
[COLUMN_POSITION] => 8
[DATA_TYPE] => text
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => -1
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_descricao_breve] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_descricao_breve
[COLUMN_POSITION] => 9
[DATA_TYPE] => text
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => -1
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
)
[_metadataCache:protected] =>
[_metadataCacheInClass:protected] => 1
[_rowClass:protected] => Zend_Db_Table_Row
[_rowsetClass:protected] => Zend_Db_Table_Rowset
[_referenceMap:protected] => Array
(
)
[_dependentTables:protected] => Array
(
)
[_defaultSource:protected] => defaultNone
[_defaultValues:protected] => Array
(
)
)
[_bind:protected] => Array
(
)
[_adapter:protected] => Zend_Db_Adapter_Pdo_Pgsql Object
(
[_pdoType:protected] => pgsql
[_numericDataTypes:protected] => Array
(
[0] => 0
[1] => 1
[2] => 2
[INTEGER] => 0
[SERIAL] => 0
[SMALLINT] => 0
[BIGINT] => 1
[BIGSERIAL] => 1
[DECIMAL] => 2
[DOUBLE PRECISION] => 2
[NUMERIC] => 2
[REAL] => 2
)
[_defaultStmtClass:protected] => Zend_Db_Statement_Pdo
[_config:protected] => Array
(
[host] => pgsql.scdecor.com.br
[dbname] => scdecor
[username] => scdecor
[password] => 321rje
[options] => Array
(
[caseFolding] => 2
[autoQuoteIdentifiers] => 1
[fetchMode] => 2
[ReturnDatesAsStrings] => 0
)
[charset] =>
[persistent] =>
[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] => 2
[_autoQuoteIdentifiers:protected] => 1
[_allowSerialization:protected] => 1
[_autoReconnectOnUnserialize:protected] =>
)
[_parts:protected] => Array
(
[distinct] =>
[columns] => Array
(
[0] => Array
(
[0] => produto
[1] => *
[2] =>
)
)
[union] => Array
(
)
[from] => Array
(
[produto] => Array
(
[joinType] => inner join
[schema] => site
[tableName] => produto
[joinCondition] =>
)
)
[where] => Array
(
[0] => (pro_codigo not in() AND prc_codigo = )
)
[group] => Array
(
)
[having] => Array
(
)
[order] => Array
(
)
[limitcount] =>
[limitoffset] =>
[forupdate] =>
)
[_tableCols:protected] => Array
(
)
)
)
)
[5] => Array
(
[file] => /home/scdecor/www/library/Zend/Db/Table/Abstract.php
[line] => 1344
[function] => _fetch
[class] => Zend_Db_Table_Abstract
[type] => ->
[args] => Array
(
[0] => Zend_Db_Table_Select Object
(
[_info:protected] => Array
(
[schema] => site
[name] => produto
[cols] => Array
(
[0] => pro_codigo
[1] => pro_nome
[2] => pro_imagem
[3] => prc_codigo
[4] => pro_thumb
[5] => pro_url_video
[6] => pro_nome_sistema
[7] => pro_descricao
[8] => pro_descricao_breve
)
[primary] => Array
(
[1] => pro_codigo
)
[metadata] => Array
(
[pro_codigo] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_codigo
[COLUMN_POSITION] => 1
[DATA_TYPE] => int4
[DEFAULT] => nextval('produto_pro_codigo_seq'::regclass)
[NULLABLE] =>
[LENGTH] => 4
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] => 1
[PRIMARY_POSITION] => 1
[IDENTITY] => 1
)
[pro_nome] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_nome
[COLUMN_POSITION] => 2
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_imagem] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_imagem
[COLUMN_POSITION] => 3
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[prc_codigo] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => prc_codigo
[COLUMN_POSITION] => 4
[DATA_TYPE] => int4
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => 4
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_thumb] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_thumb
[COLUMN_POSITION] => 5
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_url_video] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_url_video
[COLUMN_POSITION] => 6
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_nome_sistema] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_nome_sistema
[COLUMN_POSITION] => 7
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_descricao] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_descricao
[COLUMN_POSITION] => 8
[DATA_TYPE] => text
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => -1
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_descricao_breve] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_descricao_breve
[COLUMN_POSITION] => 9
[DATA_TYPE] => text
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => -1
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
)
[rowClass] => Zend_Db_Table_Row
[rowsetClass] => Zend_Db_Table_Rowset
[referenceMap] => Array
(
)
[dependentTables] => Array
(
)
[sequence] => "site"."produto_pro_codigo_seq"
)
[_integrityCheck:protected] => 1
[_table:protected] => ProdutoDAO Object
(
[_name:protected] => produto
[_primary:protected] => Array
(
[1] => pro_codigo
)
[_schema:protected] => site
[_definition:protected] =>
[_definitionConfigName:protected] =>
[_db:protected] => Zend_Db_Adapter_Pdo_Pgsql Object
(
[_pdoType:protected] => pgsql
[_numericDataTypes:protected] => Array
(
[0] => 0
[1] => 1
[2] => 2
[INTEGER] => 0
[SERIAL] => 0
[SMALLINT] => 0
[BIGINT] => 1
[BIGSERIAL] => 1
[DECIMAL] => 2
[DOUBLE PRECISION] => 2
[NUMERIC] => 2
[REAL] => 2
)
[_defaultStmtClass:protected] => Zend_Db_Statement_Pdo
[_config:protected] => Array
(
[host] => pgsql.scdecor.com.br
[dbname] => scdecor
[username] => scdecor
[password] => 321rje
[options] => Array
(
[caseFolding] => 2
[autoQuoteIdentifiers] => 1
[fetchMode] => 2
[ReturnDatesAsStrings] => 0
)
[charset] =>
[persistent] =>
[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] => 2
[_autoQuoteIdentifiers:protected] => 1
[_allowSerialization:protected] => 1
[_autoReconnectOnUnserialize:protected] =>
)
[_cols:protected] => Array
(
[0] => pro_codigo
[1] => pro_nome
[2] => pro_imagem
[3] => prc_codigo
[4] => pro_thumb
[5] => pro_url_video
[6] => pro_nome_sistema
[7] => pro_descricao
[8] => pro_descricao_breve
)
[_identity:protected] => 1
[_sequence:protected] => "site"."produto_pro_codigo_seq"
[_metadata:protected] => Array
(
[pro_codigo] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_codigo
[COLUMN_POSITION] => 1
[DATA_TYPE] => int4
[DEFAULT] => nextval('produto_pro_codigo_seq'::regclass)
[NULLABLE] =>
[LENGTH] => 4
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] => 1
[PRIMARY_POSITION] => 1
[IDENTITY] => 1
)
[pro_nome] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_nome
[COLUMN_POSITION] => 2
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_imagem] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_imagem
[COLUMN_POSITION] => 3
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[prc_codigo] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => prc_codigo
[COLUMN_POSITION] => 4
[DATA_TYPE] => int4
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => 4
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_thumb] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_thumb
[COLUMN_POSITION] => 5
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_url_video] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_url_video
[COLUMN_POSITION] => 6
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_nome_sistema] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_nome_sistema
[COLUMN_POSITION] => 7
[DATA_TYPE] => varchar
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_descricao] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_descricao
[COLUMN_POSITION] => 8
[DATA_TYPE] => text
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => -1
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
[pro_descricao_breve] => Array
(
[SCHEMA_NAME] => site
[TABLE_NAME] => produto
[COLUMN_NAME] => pro_descricao_breve
[COLUMN_POSITION] => 9
[DATA_TYPE] => text
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => -1
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] =>
[IDENTITY] =>
)
)
[_metadataCache:protected] =>
[_metadataCacheInClass:protected] => 1
[_rowClass:protected] => Zend_Db_Table_Row
[_rowsetClass:protected] => Zend_Db_Table_Rowset
[_referenceMap:protected] => Array
(
)
[_dependentTables:protected] => Array
(
)
[_defaultSource:protected] => defaultNone
[_defaultValues:protected] => Array
(
)
)
[_bind:protected] => Array
(
)
[_adapter:protected] => Zend_Db_Adapter_Pdo_Pgsql Object
(
[_pdoType:protected] => pgsql
[_numericDataTypes:protected] => Array
(
[0] => 0
[1] => 1
[2] => 2
[INTEGER] => 0
[SERIAL] => 0
[SMALLINT] => 0
[BIGINT] => 1
[BIGSERIAL] => 1
[DECIMAL] => 2
[DOUBLE PRECISION] => 2
[NUMERIC] => 2
[REAL] => 2
)
[_defaultStmtClass:protected] => Zend_Db_Statement_Pdo
[_config:protected] => Array
(
[host] => pgsql.scdecor.com.br
[dbname] => scdecor
[username] => scdecor
[password] => 321rje
[options] => Array
(
[caseFolding] => 2
[autoQuoteIdentifiers] => 1
[fetchMode] => 2
[ReturnDatesAsStrings] => 0
)
[charset] =>
[persistent] =>
[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] => 2
[_autoQuoteIdentifiers:protected] => 1
[_allowSerialization:protected] => 1
[_autoReconnectOnUnserialize:protected] =>
)
[_parts:protected] => Array
(
[distinct] =>
[columns] => Array
(
[0] => Array
(
[0] => produto
[1] => *
[2] =>
)
)
[union] => Array
(
)
[from] => Array
(
[produto] => Array
(
[joinType] => inner join
[schema] => site
[tableName] => produto
[joinCondition] =>
)
)
[where] => Array
(
[0] => (pro_codigo not in() AND prc_codigo = )
)
[group] => Array
(
)
[having] => Array
(
)
[order] => Array
(
)
[limitcount] =>
[limitoffset] =>
[forupdate] =>
)
[_tableCols:protected] => Array
(
)
)
)
)
[6] => Array
(
[file] => /home/scdecor/www/application/modules/site/controllers/ProdutosController.php
[line] => 40
[function] => fetchAll
[class] => Zend_Db_Table_Abstract
[type] => ->
[args] => Array
(
[0] => pro_codigo not in() AND prc_codigo =
)
)
[7] => Array
(
[file] => /home/scdecor/www/library/Zend/Controller/Action.php
[line] => 516
[function] => maisDetalhesAction
[class] => Site_ProdutosController
[type] => ->
[args] => Array
(
)
)
[8] => Array
(
[file] => /home/scdecor/www/library/Zend/Controller/Dispatcher/Standard.php
[line] => 295
[function] => dispatch
[class] => Zend_Controller_Action
[type] => ->
[args] => Array
(
[0] => maisDetalhesAction
)
)
[9] => Array
(
[file] => /home/scdecor/www/library/Zend/Controller/Front.php
[line] => 954
[function] => dispatch
[class] => Zend_Controller_Dispatcher_Standard
[type] => ->
[args] => Array
(
[0] => Zend_Controller_Request_Http Object
(
[_paramSources:protected] => Array
(
[0] => _GET
[1] => _POST
)
[_requestUri:protected] => /produtos/dormitorios.html
[_baseUrl:protected] =>
[_basePath:protected] =>
[_pathInfo:protected] => /produtos/dormitorios.html
[_params:protected] => Array
(
[nome_sistema] => dormitorios.html
[controller] => produtos
[action] => mais-detalhes
[error_handler] => ArrayObject Object
(
[storage:ArrayObject:private] => Array
(
[exception] => Zend_Db_Statement_Exception Object
*RECURSION*
[type] => EXCEPTION_OTHER
[request] => Zend_Controller_Request_Http Object
(
[_paramSources:protected] => Array
(
[0] => _GET
[1] => _POST
)
[_requestUri:protected] => /produtos/dormitorios.html
[_baseUrl:protected] =>
[_basePath:protected] =>
[_pathInfo:protected] => /produtos/dormitorios.html
[_params:protected] => Array
(
[nome_sistema] => dormitorios.html
[controller] => produtos
[action] => mais-detalhes
)
[_rawBody:protected] =>
[_aliases:protected] => Array
(
)
[_dispatched:protected] => 1
[_module:protected] => site
[_moduleKey:protected] => module
[_controller:protected] => produtos
[_controllerKey:protected] => controller
[_action:protected] => mais-detalhes
[_actionKey:protected] => action
)
)
)
)
[_rawBody:protected] =>
[_aliases:protected] => Array
(
)
[_dispatched:protected] => 1
[_module:protected] => site
[_moduleKey:protected] => module
[_controller:protected] => error
[_controllerKey:protected] => controller
[_action:protected] => error
[_actionKey:protected] => action
)
[1] => Zend_Controller_Response_Http Object
(
[_body:protected] => Array
(
)
[_exceptions:protected] => Array
(
[0] => Zend_Db_Statement_Exception Object
*RECURSION*
)
[_headers:protected] => Array
(
)
[_headersRaw:protected] => Array
(
)
[_httpResponseCode:protected] => 500
[_isRedirect:protected] =>
[_renderExceptions:protected] =>
[headersSentThrowsException] => 1
)
)
)
[10] => Array
(
[file] => /home/scdecor/www/library/Zend/Application/Bootstrap/Bootstrap.php
[line] => 97
[function] => dispatch
[class] => Zend_Controller_Front
[type] => ->
[args] => Array
(
)
)
[11] => Array
(
[file] => /home/scdecor/www/library/Zend/Application.php
[line] => 366
[function] => run
[class] => Zend_Application_Bootstrap_Bootstrap
[type] => ->
[args] => Array
(
)
)
[12] => Array
(
[file] => /home/scdecor/www/public/index.php
[line] => 34
[function] => run
[class] => Zend_Application
[type] => ->
[args] => Array
(
)
)
)
[previous:Exception:private] =>
[errorInfo] => Array
(
[0] => 42601
[1] => 7
[2] => ERROR: syntax error at or near ")"
LINE 1: ....* FROM "site"."produto" WHERE (pro_codigo not in() AND prc_...
^
)
)
)