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

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Hi Honza

yes that's true, the item simply didnt exist. But what else was strange=20
was that with mysql-server-4.1 a search for content.text=3D'' returned no=
=20
content. Odd, no?

Michael

Honza Malik wrote:
> Hi,
>=20
> "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.
>=20
> Are you sure, that the "Related" items (the items with ids in the
> relation........ field) is not expired or deleted?
>=20
> Looks like SQL command:
>=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
> do not find any item.
>=20
>    Honza
>=20
>=20
>=20
> Michael Moritz p=C3=AD=C5=A1e v So 19. 02. 2005 v 02:32 +0000:
>=20
>>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&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
>>
>>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_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
>>
>>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 se=
lect_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') =
AND=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_=
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:
>>
>>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
>>
>>
>>-------------------------------------------------------
>>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
>=20
>=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&op=3Dclick
> _______________________________________________
> Apc-aa-coders mailing list
> Apc...@li...
> https://lists.sourceforge.net/lists/listinfo/apc-aa-coders
>=20
>=20

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

ActionApps - easy and automated publishing and sharing for websites

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