Menu
▾
▴
[Apc-aa-coders] strange impossible WHERE clause error
|
From: Michael M. <mi...@gn...> - 2005-02-19 02:32:46
|
Hi
I have come across a very strange error which happens with a related=20
items view,
It's called like this
view.php3?vid=3D32&cmd[32]=3Dx-32-21d4f12036ceefbd1929e0dadc6eb140&debug=3D=
1&nocache=3D1
where view 32 looks like this:
{view.php3?vid=3D30&cmd[30]=3Do-30-{@relation........:-}&set[30]=3Dmlx-{l=
}}
View 30 is basically _#HEADLINE
The odd thing is that with some items it displays this error, with=20
others it doesnt.
Here is the ouput from the debug -- any ideas what this means?
Thanks,
mimo
Starting view
ParseViewParameters: vid=3D32, query_string=3Dcmd:Array
(
[32] =3D> x-32-21d4f12036ceefbd1929e0dadc6eb140
)
set:als:
ParseCommand - cmd:x-32-21d4f12036ceefbd1929e0dadc6eb140
ParseViewParameters - command:Array
(
[0] =3D> x
[1] =3D> 32
[2] =3D> 21d4f12036ceefbd1929e0dadc6eb140
)
Array
(
[all_ids] =3D>
[ids] =3D>
[sel_ids] =3D>
[add_disc] =3D>
[sh_itm] =3D>
[parent_id] =3D>
[disc_ids] =3D>
[disc_type] =3D>
[cat] =3D>
[show_subcat] =3D>
[als] =3D> Array
(
)
[vid] =3D> 32
[conds] =3D>
[slices] =3D>
[mapslices] =3D>
[param_conds] =3D>
[zids] =3D> zids Object
(
[a] =3D> Array
(
[0] =3D> 21d4f12036ceefbd1929e0dadc6eb140
)
[type] =3D> l
[l2s] =3D>
[s2l] =3D>
)
)
Pagecache->get(keyString):a:17:{s:7:"all_ids";N;s:3:"ids";N;s:7:"sel_ids"=
;N;s:8:"add_disc";N;s:6:"sh_itm";N;s:9:"parent_id";N;s:8:"disc_ids";N;s:9=
:"disc_type";N;s:3:"cat";N;s:11:"show_subcat";N;s:3:"als";a:0:{}s:3:"vid"=
;s:2:"32";s:5:"conds";N;s:6:"slices";N;s:9:"mapslices";N;s:11:"param_cond=
s";N;s:4:"zids";O:4:"zids":4:{s:1:"a";a:1:{i:0;s:32:"21d4f12036ceefbd1929=
e0dadc6eb140";}s:4:"type";s:1:"l";s:3:"l2s";N;s:3:"s2l";N;}}
Pagecache key:fd99e3910df2af1982c369bc23d06427
Pagecache action:1
Pagecache: return false - nocache
SELECT view.*, module.deleted, module.lang_file FROM view, module WHERE=20
module.id=3Dview.slice_id AND view.id=3D'32'
table
type
possible_keys
key
key_len
ref
rows
Extra
view
const
PRIMARY,slice_id
PRIMARY
4
const
1
module
const
PRIMARY
PRIMARY
16
const
1
Query duration: 0.000557899475098
Rows returned: 1
GetViewFromDB:view_info=3DArray
(
[id] =3D> 32
[slice_id] =3D> =EF=BF=BD=1652=C5=A0:hk}Db
[name] =3D> Also in this Issue View
[type] =3D> list
[before] =3D>
[even] =3D>
[odd] =3D>=20
{view.php3?vid=3D30&cmd[30]=3Do-30-{@relation........:-}&set[30]=3Dmlx-{l=
}}
[even_odd_differ] =3D> 0
[after] =3D>
[remove_string] =3D>
[group_title] =3D>
[order1] =3D>
[o1_direction] =3D> 1
[order2] =3D>
[o2_direction] =3D> 1
[group_by1] =3D>
[g1_direction] =3D> 1
[group_by2] =3D>
[g2_direction] =3D>
[cond1field] =3D>
[cond1op] =3D> =3D
[cond1cond] =3D>
[cond2field] =3D>
[cond2op] =3D> <
[cond2cond] =3D>
[cond3field] =3D>
[cond3op] =3D> <
[cond3cond] =3D>
[listlen] =3D> 1
[scroller] =3D>
[selected_item] =3D>
[modification] =3D>
[parameter] =3D>
[img1] =3D>
[img2] =3D>
[img3] =3D>
[img4] =3D>
[flag] =3D>
[aditional] =3D>
[aditional2] =3D>
[aditional3] =3D>
[aditional4] =3D>
[aditional5] =3D>
[aditional6] =3D>
[noitem_msg] =3D>
[group_bottom] =3D>
[field1] =3D>
[field2] =3D>
[field3] =3D>
[calendar_type] =3D> mon
[deleted] =3D> 0
[lang_file] =3D> en-utf8_news_lang.php3
)
SELECT * FROM slice WHERE id =3D '=EF=BF=BD=1652=C5=A0:hk}Db'
table
type
possible_keys
key
key_len
ref
rows
Extra
slice
const
PRIMARY
PRIMARY
16
const
1
Query duration: 0.000584125518799
Rows returned: 1
Conds=3DSort=3DGroup by=3DSlices=3D
QueryZIDs:slice_id=3D select_tabs=3D select_conds=3D select_order=3D sele=
ct_group=3D
SELECT DISTINCT item.id as itemid FROM item WHERE item.id =3D "!=EF=BF=BD=
6=EF=BF=BD=19)=EF=BF=BD=EF=BF=BD@"=20
AND ( ( item.status_code=3D1 AND (item.publish_date <=3D '1108780000') AN=
D=20
(item.expiry_date > '1108780000') ) ) -- AA slice_id: , vid: 32
table
type
possible_keys
key
key_len
ref
rows
Extra
Impossible WHERE noticed after reading const tables
Query duration: 0.000310897827148
Rows returned: 0
GetViewFromDB retrieved IDS
GetViewFromDB: Filtered ids=3Dzids object: type=3Dp (Empty)
Pagecache->store(keyString):a:17:{s:7:"all_ids";N;s:3:"ids";N;s:7:"sel_id=
s";N;s:8:"add_disc";N;s:6:"sh_itm";N;s:9:"parent_id";N;s:8:"disc_ids";N;s=
:9:"disc_type";N;s:3:"cat";N;s:11:"show_subcat";N;s:3:"als";a:0:{}s:3:"vi=
d";s:2:"32";s:5:"conds";N;s:6:"slices";N;s:9:"mapslices";N;s:11:"param_co=
nds";N;s:4:"zids";O:4:"zids":4:{s:1:"a";a:1:{i:0;s:32:"21d4f12036ceefbd19=
29e0dadc6eb140";}s:4:"type";s:1:"l";s:3:"l2s";N;s:3:"s2l";N;}}
Pagecache key:fd99e3910df2af1982c369bc23d06427
Pagecache str2find:Object
Pagecache content (length):24
Pagecache cache_nostore:
Pagecache->store(): - storing
DELETE FROM pagecache_str2find WHERE=20
pagecache_id=3D'fd99e3910df2af1982c369bc23d06427'
Query duration: 0.00113296508789
Affected rows: 1
INSERT INTO pagecache_str2find ( `pagecache_id`, `str2find` ) VALUES (=20
'fd99e3910df2af1982c369bc23d06427',=20
'slice_id=3Dec411635328cc28ab03a68956b7d4462' )
Query duration: 0.000808954238892
Affected rows: 1
REPLACE pagecache SET `content`=3D'
No item found
', `stored`=3D'1108779609', `id`=3D'fd99e3910df2af1982c369bc23d06427'
Query duration: 0.000694990158081
Affected rows: 2
No item found
Completed view
|
