Decoração
Warning: mysql_data_seek() [function.mysql-data-seek]: Offset 60 is invalid for MySQL result index 24 (or the query data is unbuffered) in /home/decorfer/public_html/_admin/classes/db.php on line 94
A linha 60 não existe no fetch resultante de
select produtos.* from produtos, produtos_has_categorias, categorias where categorias.url = 'Decoracao' and ( (produtos_has_categorias.idcategorias = categorias.idcategorias and produtos.idprodutos = produtos_has_categorias.idprodutos) or (produtos.idcategorias = categorias.idcategorias) ) group by produtos.idprodutos order by ordem asc
Array
(
[0] => Array
(
[file] => /home/decorfer/public_html/_produtos_listagem.php
[line] => 7
[function] => moveFetch
[class] => db
[type] => ->
[object] => db Object
(
[banco] => decorfer_decorfer
[erro] =>
[inserted_id] =>
[affected_rows] =>
[rows] => 41
[resources] => 13
[resourceAtual] => 13
[qr] => Array
(
[1] => Resource id #8
[2] => Resource id #10
[3] => Resource id #11
[4] => Resource id #12
[5] => Resource id #13
[6] => Resource id #14
[7] => Resource id #15
[8] => Resource id #16
[9] => Resource id #17
[10] => Resource id #21
[11] => Resource id #22
[12] => Resource id #23
[13] => Resource id #24
)
[sql] => Array
(
[1] => show table status
[2] => select * from configuracoes
[3] => describe canais
[4] => select * from canais where url = 'Moveis-Objetos'
[5] => show tables like 'canais_has_%'
[6] => select * from canais_has_atributos_de_canais left join atributos_de_canais on atributos_de_canais.idatributos_de_canais = canais_has_atributos_de_canais.idatributos_de_canais where canais_has_atributos_de_canais.idcanais = '83'
[7] => describe fotos
[8] => select idfotos,legenda,nome_arquivo from fotos where idcanais = '83' order by ordem asc
[9] => describe arquivos
[10] => describe categorias
[11] => select * from categorias where url = 'Decoracao'
[12] => show tables like 'categorias_has_%'
[13] => select
produtos.*
from
produtos, produtos_has_categorias, categorias
where
categorias.url = 'Decoracao' and
(
(produtos_has_categorias.idcategorias = categorias.idcategorias and produtos.idprodutos = produtos_has_categorias.idprodutos)
or
(produtos.idcategorias = categorias.idcategorias)
)
group by produtos.idprodutos
order by ordem asc
)
[tabelas] => Array
(
[_entradas] => Array
(
[Name] => _entradas
[Engine] => InnoDB
[Version] => 10
[Row_format] => Compact
[Rows] => 115
[Avg_row_length] => 142
[Data_length] => 16384
[Max_data_length] => 0
[Index_length] => 0
[Data_free] => 0
[Auto_increment] => 116
[Create_time] => 2010-07-26 18:32:58
[Update_time] =>
[Check_time] =>
[Collation] => latin1_swedish_ci
[Checksum] =>
[Create_options] =>
[Comment] =>
)
[_logs] => Array
(
[Name] => _logs
[Engine] => InnoDB
[Version] => 10
[Row_format] => Compact
[Rows] => 3300
[Avg_row_length] => 799
[Data_length] => 2637824
[Max_data_length] => 0
[Index_length] => 65536
[Data_free] => 4194304
[Auto_increment] => 2504
[Create_time] => 2010-07-26 18:32:58
[Update_time] =>
[Check_time] =>
[Collation] => latin1_swedish_ci
[Checksum] =>
[Create_options] =>
[Comment] =>
)
[_tabelas] => Array
(
[Name] => _tabelas
[Engine] => InnoDB
[Version] => 10
[Row_format] => Compact
[Rows] => 3
[Avg_row_length] => 5461
[Data_length] => 16384
[Max_data_length] => 0
[Index_length] => 16384
[Data_free] => 0
[Auto_increment] => 6
[Create_time] => 2010-07-26 18:32:58
[Update_time] =>
[Check_time] =>
[Collation] => utf8_general_ci
[Checksum] =>
[Create_options] =>
[Comment] =>
)
[albuns] => Array
(
[Name] => albuns
[Engine] => InnoDB
[Version] => 10
[Row_format] => Compact
[Rows] => 1
[Avg_row_length] => 16384
[Data_length] => 16384
[Max_data_length] => 0
[Index_length] => 0
[Data_free] => 0
[Auto_increment] => 2
[Create_time] => 2010-07-26 18:32:58
[Update_time] =>
[Check_time] =>
[Collation] => latin1_swedish_ci
[Checksum] =>
[Create_options] =>
[Comment] =>
)
[arquivos] => Array
(
[Name] => arquivos
[Engine] => InnoDB
[Version] => 10
[Row_format] => Compact
[Rows] => 40
[Avg_row_length] => 409
[Data_length] => 16384
[Max_data_length] => 0
[Index_length] => 16384
[Data_free] => 0
[Auto_increment] => 43
[Create_time] => 2010-07-26 18:32:58
[Update_time] =>
[Check_time] =>
[Collation] => latin1_swedish_ci
[Checksum] =>
[Create_options] =>
[Comment] =>
)
[atributos_de_canais] => Array
(
[Name] => atributos_de_canais
[Engine] => InnoDB
[Version] => 10
[Row_format] => Compact
[Rows] => 14
[Avg_row_length] => 1170
[Data_length] => 16384
[Max_data_length] => 0
[Index_length] => 32768
[Data_free] => 0
[Auto_increment] => 18
[Create_time] => 2010-07-26 18:32:58
[Update_time] =>
[Check_time] =>
[Collation] => latin1_swedish_ci
[Checksum] =>
[Create_options] =>
[Comment] =>
)
[canais] => Array
(
[Name] => canais
[Engine] => InnoDB
[Version] => 10
[Row_format] => Compact
[Rows] => 7
[Avg_row_length] => 2340
[Data_length] => 16384
[Max_data_length] => 0
[Index_length] => 32768
[Data_free] => 0
[Auto_increment] => 85
[Create_time] => 2010-07-26 18:32:58
[Update_time] =>
[Check_time] =>
[Collation] => latin1_swedish_ci
[Checksum] =>
[Create_options] =>
[Comment] =>
)
[canais_has_atributos_de_canais] => Array
(
[Name] => canais_has_atributos_de_canais
[Engine] => InnoDB
[Version] => 10
[Row_format] => Compact
[Rows] => 5
[Avg_row_length] => 3276
[Data_length] => 16384
[Max_data_length] => 0
[Index_length] => 16384
[Data_free] => 0
[Auto_increment] =>
[Create_time] => 2010-07-26 18:32:58
[Update_time] =>
[Check_time] =>
[Collation] => latin1_swedish_ci
[Checksum] =>
[Create_options] =>
[Comment] =>
)
[caracteristicas] => Array
(
[Name] => caracteristicas
[Engine] => InnoDB
[Version] => 10
[Row_format] => Compact
[Rows] => 1
[Avg_row_length] => 16384
[Data_length] => 16384
[Max_data_length] => 0
[Index_length] => 0
[Data_free] => 0
[Auto_increment] => 26
[Create_time] => 2010-07-26 18:32:58
[Update_time] =>
[Check_time] =>
[Collation] => latin1_swedish_ci
[Checksum] =>
[Create_options] =>
[Comment] =>
)
[categorias] => Array
(
[Name] => categorias
[Engine] => InnoDB
[Version] => 10
[Row_format] => Compact
[Rows] => 4
[Avg_row_length] => 4096
[Data_length] => 16384
[Max_data_length] => 0
[Index_length] => 16384
[Data_free] => 0
[Auto_increment] => 28
[Create_time] => 2010-07-26 18:32:58
[Update_time] =>
[Check_time] =>
[Collation] => latin1_swedish_ci
[Checksum] =>
[Create_options] =>
[Comment] =>
)
[clientes] => Array
(
[Name] => clientes
[Engine] => InnoDB
[Version] => 10
[Row_format] => Compact
[Rows] => 1
[Avg_row_length] => 16384
[Data_length] => 16384
[Max_data_length] => 0
[Index_length] => 0
[Data_free] => 0
[Auto_increment] => 2
[Create_time] => 2010-07-26 18:32:58
[Update_time] =>
[Check_time] =>
[Collation] => latin1_swedish_ci
[Checksum] =>
[Create_options] =>
[Comment] =>
)
[configuracoes] => Array
(
[Name] => configuracoes
[Engine] => MyISAM
[Version] => 10
[Row_format] => Dynamic
[Rows] => 8
[Avg_row_length] => 40
[Data_length] => 320
[Max_data_length] => 281474976710655
[Index_length] => 2048
[Data_free] => 0
[Auto_increment] => 36
[Create_time] => 2010-07-13 16:40:11
[Update_time] => 2010-07-13 16:40:11
[Check_time] =>
[Collation] => latin1_swedish_ci
[Checksum] =>
[Create_options] =>
[Comment] =>
)
[dimensoes] => Array
(
[Name] => dimensoes
[Engine] => InnoDB
[Version] => 10
[Row_format] => Compact
[Rows] => 191
[Avg_row_length] => 85
[Data_length] => 16384
[Max_data_length] => 0
[Index_length] => 16384
[Data_free] => 0
[Auto_increment] => 194
[Create_time] => 2010-07-26 18:32:58
[Update_time] =>
[Check_time] =>
[Collation] => latin1_swedish_ci
[Checksum] =>
[Create_options] =>
[Comment] =>
)
[entradas] => Array
(
[Name] => entradas
[Engine] => InnoDB
[Version] => 10
[Row_format] => Compact
[Rows] => 0
[Avg_row_length] => 0
[Data_length] => 16384
[Max_data_length] => 0
[Index_length] => 16384
[Data_free] => 0
[Auto_increment] => 1
[Create_time] => 2010-07-26 18:32:58
[Update_time] =>
[Check_time] =>
[Collation] => latin1_swedish_ci
[Checksum] =>
[Create_options] =>
[Comment] =>
)
[estados] => Array
(
[Name] => estados
[Engine] => InnoDB
[Version] => 10
[Row_format] => Compact
[Rows] => 27
[Avg_row_length] => 606
[Data_length] => 16384
[Max_data_length] => 0
[Index_length] => 0
[Data_free] => 0
[Auto_increment] => 28
[Create_time] => 2010-07-26 18:32:58
[Update_time] =>
[Check_time] =>
[Collation] => latin1_swedish_ci
[Checksum] =>
[Create_options] =>
[Comment] =>
)
[formularios] => Array
(
[Name] => formularios
[Engine] => InnoDB
[Version] => 10
[Row_format] => Compact
[Rows] => 449
[Avg_row_length] => 875
[Data_length] => 393216
[Max_data_length] => 0
[Index_length] => 16384
[Data_free] => 0
[Auto_increment] => 473
[Create_time] => 2010-07-26 18:32:58
[Update_time] =>
[Check_time] =>
[Collation] => latin1_swedish_ci
[Checksum] =>
[Create_options] =>
[Comment] =>
)
[fotos] => Array
(
[Name] => fotos
[Engine] => InnoDB
[Version] => 10
[Row_format] => Compact
[Rows] => 2533
[Avg_row_length] => 17186
[Data_length] => 43532288
[Max_data_length] => 0
[Index_length] => 98304
[Data_free] => 3145728
[Auto_increment] => 619
[Create_time] => 2010-07-26 18:32:58
[Update_time] =>
[Check_time] =>
[Collation] => latin1_swedish_ci
[Checksum] =>
[Create_options] =>
[Comment] =>
)
[galerias] => Array
(
[Name] => galerias
[Engine] => InnoDB
[Version] => 10
[Row_format] => Compact
[Rows] => 1
[Avg_row_length] => 16384
[Data_length] => 16384
[Max_data_length] => 0
[Index_length] => 0
[Data_free] => 0
[Auto_increment] => 2
[Create_time] => 2010-07-26 18:32:58
[Update_time] =>
[Check_time] =>
[Collation] => latin1_swedish_ci
[Checksum] =>
[Create_options] =>
[Comment] =>
)
[icones] => Array
(
[Name] => icones
[Engine] => MyISAM
[Version] => 10
[Row_format] => Dynamic
[Rows] => 189
[Avg_row_length] => 81
[Data_length] => 15440
[Max_data_length] => 281474976710655
[Index_length] => 4096
[Data_free] => 0
[Auto_increment] => 192
[Create_time] => 2010-07-13 16:41:56
[Update_time] => 2010-07-13 16:41:56
[Check_time] =>
[Collation] => latin1_swedish_ci
[Checksum] =>
[Create_options] =>
[Comment] =>
)
[leitores] => Array
(
[Name] => leitores
[Engine] => MyISAM
[Version] => 10
[Row_format] => Dynamic
[Rows] => 3
[Avg_row_length] => 80
[Data_length] => 240
[Max_data_length] => 281474976710655
[Index_length] => 3072
[Data_free] => 0
[Auto_increment] => 4
[Create_time] => 2010-07-13 16:41:57
[Update_time] => 2010-07-13 16:41:57
[Check_time] =>
[Collation] => utf8_general_ci
[Checksum] =>
[Create_options] =>
[Comment] =>
)
[menus] => Array
(
[Name] => menus
[Engine] => InnoDB
[Version] => 10
[Row_format] => Compact
[Rows] => 16
[Avg_row_length] => 1024
[Data_length] => 16384
[Max_data_length] => 0
[Index_length] => 32768
[Data_free] => 0
[Auto_increment] => 101
[Create_time] => 2010-07-26 18:32:58
[Update_time] =>
[Check_time] =>
[Collation] => latin1_swedish_ci
[Checksum] =>
[Create_options] =>
[Comment] =>
)
[noticias] => Array
(
[Name] => noticias
[Engine] => InnoDB
[Version] => 10
[Row_format] => Compact
[Rows] => 1
[Avg_row_length] => 16384
[Data_length] => 16384
[Max_data_length] => 0
[Index_length] => 16384
[Data_free] => 0
[Auto_increment] => 2
[Create_time] => 2010-07-26 18:32:58
[Update_time] =>
[Check_time] =>
[Collation] => latin1_swedish_ci
[Checksum] =>
[Create_options] =>
[Comment] =>
)
[opcoes] => Array
(
[Name] => opcoes
[Engine] => InnoDB
[Version] => 10
[Row_format] => Compact
[Rows] => 5
[Avg_row_length] => 3276
[Data_length] => 16384
[Max_data_length] => 0
[Index_length] => 16384
[Data_free] => 0
[Auto_increment] => 52
[Create_time] => 2010-07-26 18:32:58
[Update_time] =>
[Check_time] =>
[Collation] => latin1_swedish_ci
[Checksum] =>
[Create_options] =>
[Comment] =>
)
[parceiros] => Array
(
[Name] => parceiros
[Engine] => InnoDB
[Version] => 10
[Row_format] => Compact
[Rows] => 0
[Avg_row_length] => 0
[Data_length] => 16384
[Max_data_length] => 0
[Index_length] => 0
[Data_free] => 0
[Auto_increment] => 1
[Create_time] => 2010-07-26 18:32:58
[Update_time] =>
[Check_time] =>
[Collation] => latin1_swedish_ci
[Checksum] =>
[Create_options] =>
[Comment] =>
)
[produtos] => Array
(
[Name] => produtos
[Engine] => InnoDB
[Version] => 10
[Row_format] => Compact
[Rows] => 85
[Avg_row_length] => 578
[Data_length] => 49152
[Max_data_length] => 0
[Index_length] => 65536
[Data_free] => 0
[Auto_increment] => 328
[Create_time] => 2010-07-26 18:32:58
[Update_time] =>
[Check_time] =>
[Collation] => latin1_swedish_ci
[Checksum] =>
[Create_options] =>
[Comment] =>
)
[produtos_has_categorias] => Array
(
[Name] => produtos_has_categorias
[Engine] => InnoDB
[Version] => 10
[Row_format] => Compact
[Rows] => 102
[Avg_row_length] => 160
[Data_length] => 16384
[Max_data_length] => 0
[Index_length] => 32768
[Data_free] => 0
[Auto_increment] =>
[Create_time] => 2010-07-26 18:32:58
[Update_time] =>
[Check_time] =>
[Collation] => latin1_swedish_ci
[Checksum] =>
[Create_options] =>
[Comment] =>
)
[produtos_has_opcoes] => Array
(
[Name] => produtos_has_opcoes
[Engine] => InnoDB
[Version] => 10
[Row_format] => Compact
[Rows] => 323
[Avg_row_length] => 50
[Data_length] => 16384
[Max_data_length] => 0
[Index_length] => 16384
[Data_free] => 0
[Auto_increment] =>
[Create_time] => 2010-07-26 18:32:58
[Update_time] =>
[Check_time] =>
[Collation] => latin1_swedish_ci
[Checksum] =>
[Create_options] =>
[Comment] =>
)
[tags] => Array
(
[Name] => tags
[Engine] => InnoDB
[Version] => 10
[Row_format] => Compact
[Rows] => 11
[Avg_row_length] => 1489
[Data_length] => 16384
[Max_data_length] => 0
[Index_length] => 0
[Data_free] => 0
[Auto_increment] => 23
[Create_time] => 2010-07-26 18:32:58
[Update_time] =>
[Check_time] =>
[Collation] => latin1_swedish_ci
[Checksum] =>
[Create_options] =>
[Comment] =>
)
[tags_relacionadas] => Array
(
[Name] => tags_relacionadas
[Engine] => InnoDB
[Version] => 10
[Row_format] => Compact
[Rows] => 6
[Avg_row_length] => 2730
[Data_length] => 16384
[Max_data_length] => 0
[Index_length] => 114688
[Data_free] => 0
[Auto_increment] =>
[Create_time] => 2010-07-26 18:32:58
[Update_time] =>
[Check_time] =>
[Collation] => latin1_swedish_ci
[Checksum] =>
[Create_options] =>
[Comment] =>
)
[tipos_de_campos] => Array
(
[Name] => tipos_de_campos
[Engine] => MyISAM
[Version] => 10
[Row_format] => Dynamic
[Rows] => 3
[Avg_row_length] => 42
[Data_length] => 128
[Max_data_length] => 281474976710655
[Index_length] => 2048
[Data_free] => 0
[Auto_increment] => 4
[Create_time] => 2010-07-13 16:42:15
[Update_time] => 2010-07-13 16:42:15
[Check_time] =>
[Collation] => latin1_swedish_ci
[Checksum] =>
[Create_options] =>
[Comment] =>
)
[tipos_de_canais] => Array
(
[Name] => tipos_de_canais
[Engine] => InnoDB
[Version] => 10
[Row_format] => Compact
[Rows] => 8
[Avg_row_length] => 2048
[Data_length] => 16384
[Max_data_length] => 0
[Index_length] => 0
[Data_free] => 0
[Auto_increment] => 32
[Create_time] => 2010-07-26 18:32:58
[Update_time] =>
[Check_time] =>
[Collation] => latin1_swedish_ci
[Checksum] =>
[Create_options] =>
[Comment] =>
)
[usuarios] => Array
(
[Name] => usuarios
[Engine] => InnoDB
[Version] => 10
[Row_format] => Compact
[Rows] => 3
[Avg_row_length] => 5461
[Data_length] => 16384
[Max_data_length] => 0
[Index_length] => 0
[Data_free] => 0
[Auto_increment] => 19
[Create_time] => 2010-07-26 18:32:58
[Update_time] =>
[Check_time] =>
[Collation] => latin1_swedish_ci
[Checksum] =>
[Create_options] =>
[Comment] =>
)
[usuarios_has_configuracoes] => Array
(
[Name] => usuarios_has_configuracoes
[Engine] => InnoDB
[Version] => 10
[Row_format] => Compact
[Rows] => 2
[Avg_row_length] => 8192
[Data_length] => 16384
[Max_data_length] => 0
[Index_length] => 0
[Data_free] => 0
[Auto_increment] =>
[Create_time] => 2010-07-26 18:32:58
[Update_time] =>
[Check_time] =>
[Collation] => latin1_swedish_ci
[Checksum] =>
[Create_options] =>
[Comment] =>
)
[usuarios_has_menus] => Array
(
[Name] => usuarios_has_menus
[Engine] => InnoDB
[Version] => 10
[Row_format] => Compact
[Rows] => 34
[Avg_row_length] => 481
[Data_length] => 16384
[Max_data_length] => 0
[Index_length] => 16384
[Data_free] => 0
[Auto_increment] =>
[Create_time] => 2010-07-26 18:32:58
[Update_time] =>
[Check_time] =>
[Collation] => latin1_swedish_ci
[Checksum] =>
[Create_options] =>
[Comment] =>
)
)
[num_rows] => Array
(
[1] => 34
[2] => 8
[3] => 10
[4] => 1
[5] => 1
[6] => 0
[7] => 17
[8] => 0
[9] => 13
[10] => 6
[11] => 1
[12] => 0
[13] => 41
)
)
[args] => Array
(
[0] => 60
)
)
[1] => Array
(
[file] => /home/decorfer/public_html/_produtos.php
[line] => 9
[args] => Array
(
[0] => /home/decorfer/public_html/_produtos_listagem.php
)
[function] => include
)
[2] => Array
(
[file] => /home/decorfer/public_html/index.php
[line] => 22
[args] => Array
(
[0] => /home/decorfer/public_html/_produtos.php
)
[function] => include
)
)
