Re: [Apc-aa-coders] strange impossible WHERE clause error

[Honza M. <hon...@ec...>]

Hi,

"Impossible WHERE noticed after reading const tables" is the sentence
from EXPLAIN command in MySQL (displayed by AA for debug purposes). =20
I think the message says something like "I can't find the item with the
given criteria" - which could be pretty normal.

Are you sure, that the "Related" items (the items with ids in the
relation........ field) is not expired or deleted?

Looks like SQL command:

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

do not find any item.

   Honza



Michael Moritz p=C3=AD=C5=A1e v So 19. 02. 2005 v 02:32 +0000:
> Hi
>=20
> I have come across a very strange error which happens with a related=20
> items view,
>=20
> It's called like this
> view.php3?vid=3D32&cmd[32]=3Dx-32-21d4f12036ceefbd1929e0dadc6eb140&debu=
g=3D1&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
>=20
> The odd thing is that with some items it displays this error, with=20
> others it doesnt.
>=20
> Here is the ouput from the debug -- any ideas what this means?
>=20
> Thanks,
> mimo
>=20
> Starting view
> ParseViewParameters: vid=3D32, query_string=3Dcmd:Array
> (
> [32] =3D> x-32-21d4f12036ceefbd1929e0dadc6eb140
> )
> set:als:
>=20
> ParseCommand - cmd:x-32-21d4f12036ceefbd1929e0dadc6eb140
>=20
> ParseViewParameters - command:Array
> (
> [0] =3D> x
> [1] =3D> 32
> [2] =3D> 21d4f12036ceefbd1929e0dadc6eb140
> )
>=20
> 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
> (
> )
>=20
> [vid] =3D> 32
> [conds] =3D>
> [slices] =3D>
> [mapslices] =3D>
> [param_conds] =3D>
> [zids] =3D> zids Object
> (
> [a] =3D> Array
> (
> [0] =3D> 21d4f12036ceefbd1929e0dadc6eb140
> )
>=20
> [type] =3D> l
> [l2s] =3D>
> [s2l] =3D>
> )
>=20
> )
>=20
>=20
> Pagecache->get(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 action:1
>=20
> Pagecache: return false - nocache
>=20
> SELECT view.*, module.deleted, module.lang_file FROM view, module WHERE=
=20
> module.id=3Dview.slice_id AND view.id=3D'32'
>=20
> table
> type
> possible_keys
> key
> key_len
> ref
> rows
> Extra
>=20
>=20
> view
> const
> PRIMARY,slice_id
> PRIMARY
> 4
> const
> 1
>=20
>=20
> module
> const
> PRIMARY
> PRIMARY
> 16
> const
> 1
>=20
>=20
> 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
> )
>=20
>=20
> SELECT * FROM slice WHERE id =3D '=EF=BF=BD=1652=C5=A0:hk}Db'
>=20
> table
> type
> possible_keys
> key
> key_len
> ref
> rows
> Extra
>=20
>=20
> slice
> const
> PRIMARY
> PRIMARY
> 16
> const
> 1
>=20
>=20
> 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 se=
lect_group=3D
>=20
> 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') =
AND=20
> (item.expiry_date > '1108780000') ) ) -- AA slice_id: , vid: 32
>=20
> table
> type
> possible_keys
> key
> key_len
> ref
> rows
> Extra
>=20
>=20
> Impossible WHERE noticed after reading const tables
>=20
>=20
> Query duration: 0.000310897827148
> Rows returned: 0
> GetViewFromDB retrieved IDS
> GetViewFromDB: Filtered ids=3Dzids object: type=3Dp (Empty)
>=20
> Pagecache->store(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_=
conds";N;s:4:"zids";O:4:"zids":4:{s:1:"a";a:1:{i:0;s:32:"21d4f12036ceefbd=
1929e0dadc6eb140";}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:
>=20
> Pagecache->store(): - storing
>=20
> 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
>=20
>=20
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now.
> http://ads.osdn.com/?ad_ide95&alloc_id=14396&opk
> _______________________________________________
> Apc-aa-coders mailing list
> Apc...@li...
> https://lists.sourceforge.net/lists/listinfo/apc-aa-coders
>=20