Menu
▾
▴
apc-aa-coders
|
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
|
|
From: Honza M. <hon...@ec...> - 2005-02-21 22:55:41
|
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
|
|
From: Michael M. <mi...@gn...> - 2005-02-22 16:37:45
|
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
|
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X