Menu
▾
▴
apc-aa-coders — Discussion only useful to active developers.
You can subscribe to this list here.
| 2002 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(21) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2003 |
Jan
(136) |
Feb
(104) |
Mar
(80) |
Apr
(21) |
May
(36) |
Jun
(18) |
Jul
(22) |
Aug
(5) |
Sep
(11) |
Oct
(7) |
Nov
(3) |
Dec
(12) |
| 2004 |
Jan
(5) |
Feb
|
Mar
(3) |
Apr
(1) |
May
|
Jun
(1) |
Jul
(3) |
Aug
(6) |
Sep
(3) |
Oct
(4) |
Nov
(4) |
Dec
|
| 2005 |
Jan
(1) |
Feb
(4) |
Mar
|
Apr
(7) |
May
(4) |
Jun
(7) |
Jul
(4) |
Aug
(4) |
Sep
|
Oct
(8) |
Nov
(4) |
Dec
(1) |
| 2006 |
Jan
|
Feb
(3) |
Mar
(2) |
Apr
(4) |
May
|
Jun
(6) |
Jul
(2) |
Aug
(1) |
Sep
|
Oct
(3) |
Nov
|
Dec
|
| 2007 |
Jan
|
Feb
(4) |
Mar
(7) |
Apr
(4) |
May
(4) |
Jun
(8) |
Jul
(2) |
Aug
(2) |
Sep
|
Oct
|
Nov
(2) |
Dec
|
| 2009 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(2) |
Jun
(1) |
Jul
(3) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2010 |
Jan
|
Feb
(1) |
Mar
|
Apr
(2) |
May
|
Jun
|
Jul
|
Aug
(1) |
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Honza M. <hon...@ec...> - 2005-04-20 21:53:47
|
Current CVS state: quite stable (used on our production server)
Last Changes:
04/20/05 - change value of constant with "propagation to items" is much quicker
(honzam) on Slice Admin -> Fileds - Edit -> Constants - Edit, now
constant value could be 255 characters long (instead of 149)
(you do not need to update database tables for this change)
- fixed bug - content of the view was wrong modified by slices[] url
parameter. Now it is not modified by slices[] parameter.
You can still use set[23]=slices-6556666355368859... parameter
04/19/05 - HTML generated by AA on public pages (pagescroller, ...) is valid
(honzam) (& in urls are replaced by &)
- Hint, how to add HTMLArea to anonymous form is added to the anonymous
wizard code
- fixed left admin menu for Bulk e-mail sending (Reader slice)
04/15/05 - new possibility to Enable/Disable specified spots in the site module
(honzam) interface
- small bugfixes in site module code; code cleaned
|
|
From: Norbert B. <br...@ch...> - 2005-04-19 09:59:13
|
From: "Honza Malik" <hon...@ec...> > I will try to refresh old habit - post descriptions of all changes = in > ActionApps code to apc-aa-coders list. Such descriptions are also = placed > in /CHANGES file. I'm asking all developers to do so, as well. Yes! It is one of the things that might help to revive developers. Some = of the changes are really exciting. It would be also great to announce short-term development plans (e.g. if = you are about to start working on some feature, you might mention that = here too). norbert br...@ch... |
|
From: Honza M. <hon...@ec...> - 2005-04-19 09:27:09
|
Hi,
I will try to refresh old habit - post descriptions of all changes in
ActionApps code to apc-aa-coders list. Such descriptions are also placed
in /CHANGES file. I'm asking all developers to do so, as well.
Regards,
Honza
Current CVS state: quite stable (used on our production server)
Today Changes:
04/11/05 - new possibility to specify "group limit". Group limit is used
(honzam) for limiting number of items from one category. If you want to list
items grouped by category.......1, but you want to see just first
three items from each category, then you could use "group limit".
You can specify it as:
3category.......1-
(limit to three items from category.......1 - descending)
for "order" slice.php3 parameter, or "sort" view.php3 parameter.
Another usage is:
sort[0][category.......1]=d&sort[0][limit]=3
for slice.php3
(it is also good in case you want to list all categories header,
in which is at least one item - you can just set limit to 1)
- conditions (conds[]) now could contain also long (unpacked) ids
for id item field
- new possibility to define, how the Related Selection Window listing
should look - define view for it
- the records with the same key and value is not listed twice
in the inputform selectboxes
- fixed dicussion caching - the cache is now invalidated correctly
after user sendinds the post to the discussion
- fixed slice.php3 content caching - it was broken since we added
_#SESSION_ alias, which was different each time the slice.php3
was called. Now it is done better way (f_e:session) function
- searchbar now uses better help texts for date fields (the help text
is in "value" field, not in "operator" field)
- fixed counting of links in categories (Links module)
- new possibility to generete standard gettext .PO language files
- used longer database types for some fields (sql_update.php3)
(like fulltext_format of slice, view - 2^16 is not enough for some
aplications)
- removed all mysql specific functions from perm_sql.php3 (it was last
place in AA, where we did not use database abstract layer)
- fixed author/editor security problem in Related Selection Window
(thanks to Norbert Brazda)
- category_sort field is now filled by 0 and converted to group_by
field, when compact view is edited (for very old AA slices). This
field is there only for backward compatibility - now we use better
approach (at least three years) - group_by
- corrected some database queries for easier migration to other
database engines
- hierarchical constants are now better handled in inputform - we use
alias for javascript, which defines the constants, so it is possible
to change the look of the form without specifying the constants there
- small speed optimalizations (split() -> explode())
- imagecopyresampled used instead of imagecopyresized - better image
(thumbnail) quality generated (based on Norbert Brazda suggestion)
- new cacheDb(), cacheMemDb(), cacheMem() functions, which joins
pagecache and contentcache together
- speed optimalization, set bigger time limit for dictionary aliases
- improved toexecute class - time measurement implemented so we can run
as many tasks within given time as possible
- it allows execute many small tasks or only one big one
- RSS feeds is able to decode diferent character encoding
(thanks to Norbert Brazda)
- better logging of alerts
- fixed typo in category description cat-description field
- laguage files updated
- small fixes/security fixes
--
Honza Malik <hon...@ec...>
Econnect
|
|
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
|
|
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-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: Michael M. <mi...@gn...> - 2005-02-16 15:29:45
|
Hi Honza
I found this one in the changelogs and it works great. Thanks it's
useful feature but it would be most useful for related items so that you
can display something else than the headline of a related item. Because
all the types it supports at the moment are not very good when used with
many items. Now I wonder is that difficult to do or is it just about a
couple of lines?
11/23/04 - any AA format-string could be used for displaying selects from
(honzam) related slice (not only 1 field like headline........). You
can place
the format-string in "slice field" parameter for the Input Type.
It works for all Input Types allowing displaying selections from
a slice, like Selectbox, Two windows, Multiple Selectboxes,
Radiobuttons, Multiple checkboxes...
Thanks,
Michael
|
|
From: Michael M. <mi...@gn...> - 2005-01-26 17:39:16
|
Hi,
I have noticed that the number field types are defined as store as text
rather than numeric what I expected. Here it is the last '1',
sqlupdate.php3 line 1101 in CVS
e.g. $SQL_aacore[] = "INSERT INTO field (id, type, slice_id, name,
input_pri, input_help, input_morehlp, input_default, required, feed,
multiple, input_show_func, content_id, search_pri, search_type,
search_help, search_before, search_more_help, search_show,
search_ft_show, search_ft_default, alias1, alias1_func, alias1_help,
alias2, alias2_func, alias2_help, alias3, alias3_func, alias3_help,
input_before, aditional, content_edit, html_default, html_show,
in_item_tbl, input_validate, input_insert_func, input_show, text_stored)
VALUES( 'number', '', 'AA_Core_Fields..', 'Number', '100', '',
'${AA_DOC_URL}help.html', 'qte', '1', '0', '0', 'fld', '', '100', '',
'', '', '', '1', '1', '1', '_#UNDEFINE', 'f_h', 'alias undefined - see
Admin pages - Field setting', '', '', '', '', '', '', '', '', '0', '0',
'0', '', 'number', 'num', '1', '1')";
This makes it impossible to sort numerically in searches. Am I using the
wrong field type? I have changed it on my installation but there are
probably implications for 'live' installations.
Thanks,
Michael
|
|
From: Michael M. <mi...@gn...> - 2004-11-05 18:27:16
|
I have noticed some mistakes in this message, imroved documentation and screenshots are here: http://mimo.gn.apc.org/index.php/MLXGetText mimo |
|
From: Michael M. <mi...@gn...> - 2004-11-05 16:42:25
|
Thanks to Honza and Marek I have added a new multilingual feature to AA CVS.
This is a AA database driven gettext that allows to translate short
strings (with parameters) similiar to GNU gettext.
Nice about it is that it allows to edit translations in AA admin
interface and secondly that it can automatically add items for unknown
texts.
Quickstart:
* create a slice to hold the short texts
- fields:
# headline (required) and of type headline...... -- set the name to
the default language (e.g. EN)
# one field for each other language, set name to the language, eg. DE,
FR, ES
That was easy, now the complicated bit.
* In one of the 'early' views of your slice add this:
{mlx:addslice:(id of the slice you just created):(some text to identify
your MLXGetText domain):learn}
e.g. {mlx:addslice:3a0c44958b1c6ad697804cfdbccd8b09:{l}:IWPR Site:learn}
'early' means that this has to be parsed by AA before {_m gets first
used. It's probably worth creating an extra view just to make sure this
is the case. I have noticed that if it is in the same view but before
the first {_m it can still be parsed after the {_m. It will not work in
this case. You can use ?errcheck=1 to check for errors.
* You should be ready to start using {_m:bla} in views etc.
It goes like this: once you use {_m:some text} MLX will automatically
add an item to the slice. You can then edit the translations in AA
admin. MLX makes sure it doesnt get added twice or overwritten.
Using the MLX view parameter, MLXGetText will figure out which
translation is available and print it accordingly. So in a view that has
e.g. ?vid=11&set[11]=mlx-DE MLXGetText will automatically use the Geramn
translation from your translations slice if available.
Additional features:
MLXGetText supports unlimited number of parameters in strings. This goes
like:
{_m:Today's date is %1.%2.%3:5.11.2004}
will print (in EN)
Today's date is 5.11.2004
in DE it will print
Das heutige Datum ist 5.11.2004
As usual, MLX is untested and I would appreciate any feedback.
Have fun with it and again thanks to Honza who already programmed
something very similiar before and gave me all of his code and Marek for
discussing the idea with him in Cape Town.
mimo aka Michael
|
|
From: Honza M. <hon...@ec...> - 2004-11-03 09:33:45
|
Hi Davide,
thanks you for your posting and thank you for the work on ActionApps.
I'm unfortunately not able to understand to your Spanish documentation,
so I just tried to look at the code. The questions:=20
- Can you please summarize what are the main advantages of using your
module than using current ReaderManager/Alerts module?
- Is this module used in real life and do you plan to possibly
extend/maintain it in the future (or it was just "thesis work")?=20
(as I see there is quite limited possibility to format the e-mail
- hardcoded headline........, abstract........ and category........
fields ...)
Thank you for the work and I hope I will see you in growing AA
development community.
=20
Honza
V =DAt, 02. 11. 2004 v 14:39, Davide.rinaldi p=ED=B9e:
> Hi all
> I'm Davide Rinaldi from Italy and for my Thesis I have developed a
> mailing list service for the APC ACtion Applications. It provides user
> account administracion, users to choose the category of the articles
> to receive and the frequency, resending of lost passwords, deleting of
> inactive accounts and automatic generation and sending of e-mail
> messages.
> If you would like to check it out , go to http://lafarga.upc.es and
> search for aamail.(the software is in english, the docs and the site
> in spanish)
>=20
>=20
> ----
> Email.it, the professional e-mail, gratis per te: clicca qui
>=20
> Sponsor:
> Acquista online videogiochi multipiattaforma e risparmi fino al 30% !!
> Spedizione in 24h, prezzi ECCEZIONALI clicca subito!
> Clicca qui
--=20
Honza Malik <hon...@ec...>
Econnect
|
|
From: Davide.rinaldi <dav...@em...> - 2004-11-02 13:40:05
|
Hi all I\'m Davide Rinaldi from Italy and for my Thesis I have developed a maili= ng list service for the APC ACtion Applications. It provides user account administracion, users to choose the category of the articles to receive a= nd the frequency, resending of lost passwords, deleting of inactive accounts and automatic generation and sending of e-mail messages. If you would like to check it out , go to http://lafarga.upc.es and searc= h for aamail.(the software is in english, the docs and the site in spanish)= =20 -- Email.it, the professional e-mail, gratis per te: http://www.email.it/f =20 Sponsor: Acquista online videogiochi multipiattaforma e risparmi fino al 30% !! Spedizione in 24h, prezzi ECCEZIONALI clicca subito! Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=3D2458&d=3D20041= 102 |
|
From: Honza M. <hon...@ec...> - 2004-10-19 12:53:14
|
Hi Michael, Thank you for this feature and thank you for the documentation for it. I found a minute to test it. I installed it without problems and it seems it really works. NICE! That shame we can't met in SA. I didn't study the code deeply, yet, so for now I have just a minor notes for you. 1) Wouldn't it be better to store the "MLX slice ID" in slice.mlxctrl field packed to 16 Bytes instead of using 32 characters long slice ID? It will allow us to make relation between slices on SQL level (sometimes in the future). 2) The install description is great, as well as screenshots. But, I found two of them quite confusing -=20 http://mimo.gn.apc.org/index.php/MLX%20Screenshots?p=3D60mlx-patch-0.1_02= _mlx-control-slice-fields.png and=20 http://mimo.gn.apc.org/index.php/MLX%20Screenshots?p=3D60mlx-patch-0.1_03= _content-slice-fields.png The lang_code field is in wrong slice on it. Anyway, thank you for the patch! Honza V Ne, 03. 10. 2004 v 23:09, Michael Moritz p=ED=B9e: > Hi >=20 > I have done some more development of my multilingual extension. >=20 > Features include: >=20 > * Tab style interface in the item manager > * slice.php3 now uses the MLX information in index views. It now does=20 > automatic fall back to other language versions >=20 > For more information, the patch and some nice screenshots see=20 > http://mimo.gn.apc.org/mlx/ >=20 > I have also set up section for feedback (see bottom of that page). It=20 > would be could to hear what other people think of this and whether it's= =20 > worth opening it to the wider APC-AA community. >=20 > On a sidenote, is it possible to upload this into CVS? There is a dange= r=20 > for me to patch a version that is below current CVS.... >=20 > Thanks, >=20 > mimo >=20 >=20 >=20 > ------------------------------------------------------- > This SF.net email is sponsored by: IT Product Guide on ITManagersJourna= l > Use IT products in your business? Tell us what you think of them. Give = us > Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out = more > http://productguide.itmanagersjournal.com/guidepromo.tmpl > _______________________________________________ > Apc-aa-coders mailing list > Apc...@li... > https://lists.sourceforge.net/lists/listinfo/apc-aa-coders --=20 Honza Malik <hon...@ec...> Econnect |
|
From: Mitra <mi...@mi...> - 2004-10-05 00:20:37
|
It looks like aa is leaving losts of processes around. What I can't figure out, is whether these are a normal part of caching, or a symptom of a problem with the AA code. If its the latter, then I'm wondering if we need a standard cleanup process that closes down all AA DB threads at the end of each of the main programs (view.php3, slice.php3 etc). - Mitra >Date: Mon, 04 Oct 2004 20:39:56 +0530 >From: Ram Prasad <ra...@me...> >X-Accept-Language: en-us, en >To: Mitra <mi...@mi...> >Subject: MySQL Culprit >Status: > >Looks like AA is the culprit. Check out the processlist. > >- Ram > > >Received: from path.net (localhost.localdomain [127.0.0.1]) > by pandora.sf.ca.us (8.13.0/8.12.9) with ESMTP id i94F7DYV004676; > Mon, 4 Oct 2004 08:07:13 -0700 >Received: (from root@localhost) > by path.net (8.13.0/8.12.9/Submit) id i94F7D8B004675; > Mon, 4 Oct 2004 08:07:13 -0700 >Date: Mon, 4 Oct 2004 08:07:13 -0700 >Message-Id: <200...@pa...> >From: mys...@pa... >To: apa...@pa... >CC: ra...@gm... >X-Spam-Checker-Version: SpamAssassin 3.0.0 (2004-09-13) on pandora.path.net >X-Spam-Level: >X-Spam-Status: No, score=-3.5 required=5.0 tests=ALL_TRUSTED,AWL,BAYES_00, > MISSING_SUBJECT,NO_REAL_NAME,UNIQUE_WORDS autolearn=no version=3.0.0 > >MySQL is running too many processes. Here is the list >Id User Host db Command Time State Info >34 aadbkm localhost aadbkm Sleep 242365 NULL >35 aadbuser localhost aadb Sleep 66405 NULL >36 aadbkm localhost aadbkm Sleep 65146 NULL >37 aadbkm localhost aadbkm Sleep 115478 NULL >38 aadbuser localhost aadb Sleep 195 NULL >39 aadbkm localhost NULL Sleep 242337 NULL >40 aadbuser localhost aadb Sleep 235701 NULL >42 aadbuser localhost aadb Sleep 65938 NULL >44 aadbuser localhost aadb Sleep 115668 NULL >46 aadbuser localhost aadb Sleep 114098 NULL >47 aadbuser localhost aadb Sleep 135391 NULL >48 aadbuser localhost aadb Sleep 183 NULL >59 aadbkm localhost aadbkm Sleep 4762 NULL >60 aadbkm localhost NULL Sleep 241463 NULL >76 aadbkm localhost aadbkm Sleep 134369 NULL >86 aadbkm localhost NULL Sleep 239591 NULL >101 aadbkm localhost aadbkm Sleep 113672 NULL >109 aadbkm localhost NULL Sleep 237972 NULL >119 aadbkm localhost NULL Sleep 237072 NULL >128 aadbkm localhost aadbkm Sleep 235157 NULL >136 aadbkm localhost aadbkm Sleep 64260 NULL >139 aadbkm localhost NULL Sleep 235023 NULL >140 aadbkm localhost NULL Sleep 235023 NULL >141 aadbkm localhost NULL Sleep 235022 NULL >155 aadbkm localhost aadbkm Sleep 213577 NULL >164 aadbuser localhost aadb Sleep 214242 NULL >167 aadbkm localhost NULL Sleep 232469 NULL >174 aadbkm localhost NULL Sleep 231671 NULL >187 aadbkm localhost NULL Sleep 230405 NULL >195 aadbuser localhost aadb Sleep 200831 NULL >216 aadbkm localhost NULL Sleep 228072 NULL >231 aadbkm localhost NULL Sleep 226272 NULL >239 aadbkm localhost aadbkm Sleep 159574 NULL >241 aadbkm localhost NULL Sleep 225267 NULL >264 aadbkm localhost aadbkm Sleep 201868 NULL >317 aadbuser localhost aadb Sleep 159772 NULL >326 aadbkm localhost NULL Sleep 214465 NULL >334 aadbkm localhost NULL Sleep 213516 NULL >354 aadbkm localhost aadbkm Sleep 197375 NULL >359 aadbuser localhost aadb Sleep 197901 NULL >421 aadbkm localhost NULL Sleep 203772 NULL >431 aadbkm localhost NULL Sleep 202873 NULL >450 aadbkm localhost NULL Sleep 201073 NULL >466 aadbkm localhost NULL Sleep 199175 NULL >481 aadbkm localhost NULL Sleep 197351 NULL >486 aadbuser localhost aadb Sleep 41522 NULL >492 aadbkm localhost NULL Sleep 196478 NULL >505 aadbkm localhost NULL Sleep 195477 NULL >519 aadbkm localhost NULL Sleep 194408 NULL >536 aadbkm localhost NULL Sleep 192970 NULL >545 aadbkm localhost NULL Sleep 191936 NULL >553 aadbkm localhost NULL Sleep 191172 NULL >556 aadbkm localhost NULL Sleep 190893 NULL >563 aadbkm localhost NULL Sleep 190272 NULL >567 aadbuser localhost aadb Sleep 173227 NULL >580 aadbkm localhost NULL Sleep 188472 NULL >581 aadbkm localhost aadbkm Sleep 174869 NULL >623 aadbkm localhost NULL Sleep 184760 NULL >636 aadbkm localhost NULL Sleep 183073 NULL >651 aadbkm localhost NULL Sleep 181272 NULL >660 aadbkm localhost NULL Sleep 180268 NULL >696 aadbkm localhost NULL Sleep 175873 NULL >715 aadbkm localhost NULL Sleep 174071 NULL >724 aadbkm localhost NULL Sleep 173011 NULL >742 aadbkm localhost NULL Sleep 171372 NULL >754 aadbkm localhost NULL Sleep 170471 NULL >784 aadbkm localhost aadbkm Sleep 43505 NULL >787 aadbuser localhost aadb Sleep 156520 NULL >788 aadbuser localhost aadb Sleep 63540 NULL >799 aadbkm localhost aadbkm Sleep 158673 NULL >827 aadbkm localhost aadbkm Sleep 64993 NULL >842 aadbkm localhost NULL Sleep 161379 NULL >865 aadbuser localhost aadb Sleep 65724 NULL >870 aadbuser localhost aadb Sleep 70 NULL >874 aadbuser localhost aadb Sleep 41897 NULL >878 aadbkm localhost aadbkm Sleep 41663 NULL >901 aadbkm localhost aadbkm Sleep 2064 NULL >913 aadbkm localhost NULL Sleep 155172 NULL >914 aadbkm localhost aadbkm Sleep 65026 NULL >930 aadbkm localhost NULL Sleep 153272 NULL >937 aadbkm localhost NULL Sleep 152379 NULL >953 aadbkm localhost NULL Sleep 150672 NULL >1003 aadbkm localhost NULL Sleep 145272 NULL >1030 aadbkm localhost NULL Sleep 142470 NULL >1064 aadbkm localhost NULL Sleep 138867 NULL >1093 aadbkm localhost NULL Sleep 135372 NULL >1102 aadbkm localhost NULL Sleep 134338 NULL >1142 aadbkm localhost NULL Sleep 130613 NULL >1148 aadbkm localhost NULL Sleep 129973 NULL >1164 aadbkm localhost NULL Sleep 128173 NULL >1186 aadbkm localhost NULL Sleep 126255 NULL >1220 aadbkm localhost NULL Sleep 122650 NULL >1282 aadbkm localhost NULL Sleep 116472 NULL >1303 aadbuser localhost aadb Sleep 108631 NULL >1316 aadbkm localhost NULL Sleep 112872 NULL >1331 aadbkm localhost NULL Sleep 111746 NULL >1355 aadbkm localhost NULL Sleep 109271 NULL >1363 aadbkm localhost aadbkm Sleep 108270 NULL >1394 aadbkm localhost NULL Sleep 104771 NULL >1462 aadbkm localhost NULL Sleep 97571 NULL >1537 aadbkm localhost NULL Sleep 91272 NULL >1577 aadbkm localhost NULL Sleep 87568 NULL >1586 aadbkm localhost NULL Sleep 86640 NULL >1596 aadbuser localhost aadb Sleep 172 NULL >1614 aadbkm localhost aadbkm Sleep 100 NULL >1616 aadbkm localhost NULL Sleep 83958 NULL >1624 aadbkm localhost NULL Sleep 83173 NULL >1639 aadbkm localhost NULL Sleep 82272 NULL >1647 aadbkm localhost NULL Sleep 81273 NULL >1664 aadbkm localhost NULL Sleep 79573 NULL >1689 aadbkm localhost NULL Sleep 76872 NULL >1707 aadbkm localhost NULL Sleep 74975 NULL >1740 aadbkm localhost NULL Sleep 72373 NULL >1774 aadbkm localhost aadbkm Sleep 2946 NULL >1779 aadbuser localhost aadb Sleep 817 NULL >1786 aadbkm localhost NULL Sleep 68453 NULL >1826 aadbkm localhost NULL Sleep 65456 NULL >1827 aadbkm localhost NULL Sleep 65456 NULL >1828 aadbkm localhost NULL Sleep 65455 NULL >1829 aadbkm localhost NULL Sleep 65288 NULL >1830 aadbkm localhost NULL Sleep 65282 NULL >1831 aadbkm localhost NULL Sleep 65279 NULL >1832 aadbkm localhost NULL Sleep 65278 NULL >1833 aadbkm localhost NULL Sleep 65275 NULL >1834 aadbkm localhost NULL Sleep 65273 NULL >1835 aadbkm localhost NULL Sleep 65270 NULL >1837 aadbkm localhost NULL Sleep 65266 NULL >1839 aadbkm localhost NULL Sleep 65259 NULL >1841 aadbkm localhost NULL Sleep 65252 NULL >1842 aadbkm localhost NULL Sleep 65244 NULL >1843 aadbkm localhost NULL Sleep 65238 NULL >1845 aadbkm localhost NULL Sleep 65219 NULL >1846 aadbkm localhost NULL Sleep 65213 NULL >1847 aadbkm localhost NULL Sleep 65207 NULL >1848 aadbkm localhost NULL Sleep 65201 NULL >1849 aadbkm localhost NULL Sleep 65195 NULL >1850 aadbkm localhost NULL Sleep 65183 NULL >1852 aadbkm localhost NULL Sleep 65159 NULL >1853 aadbkm localhost NULL Sleep 65167 NULL >1854 aadbkm localhost NULL Sleep 65160 NULL >1856 aadbkm localhost NULL Sleep 65145 NULL >1869 aadbkm localhost NULL Sleep 64272 NULL >1880 aadbuser localhost aadb Sleep 16050 NULL >1885 aadbkm localhost aadbkm Sleep 17352 NULL >1886 aadbkm localhost aadbkm Sleep 4742 NULL >1887 aadbuser localhost aadb Sleep 40333 NULL >1899 aadbkm localhost NULL Sleep 62472 NULL >1900 aadbkm localhost aadbkm Sleep 40762 NULL >1915 aadbkm localhost NULL Sleep 61241 NULL >1942 aadbkm localhost NULL Sleep 58872 NULL >1943 aadbuser localhost aadb Sleep 241 NULL >1966 aadbkm localhost NULL Sleep 57838 NULL >1984 aadbkm localhost NULL Sleep 56172 NULL >2000 aadbkm localhost NULL Sleep 55273 NULL >2046 aadbkm localhost NULL Sleep 51671 NULL >2062 aadbkm localhost NULL Sleep 49873 NULL >2106 aadbkm localhost NULL Sleep 45372 NULL >2117 aadbkm localhost NULL Sleep 44473 NULL >2156 aadbkm localhost NULL Sleep 40762 NULL >2208 aadbkm localhost NULL Sleep 36372 NULL >2211 aadbkm localhost NULL Sleep 36083 NULL >2235 aadbkm localhost NULL Sleep 33574 NULL >2289 aadbkm localhost NULL Sleep 28153 NULL >2325 aadbkm localhost NULL Sleep 24672 NULL >2334 aadbkm localhost NULL Sleep 23773 NULL >2339 aadbuser localhost aadb Sleep 3055 NULL >2350 aadbkm localhost aadbkm Sleep 1972 NULL >2358 aadbkm localhost NULL Sleep 21974 NULL >2414 aadbkm localhost NULL Sleep 20951 NULL >2456 aadbkm localhost NULL Sleep 19274 NULL >2485 aadbuser localhost aadb Sleep 310 NULL >2490 aadbuser localhost aadb Sleep 510 NULL >2492 aadbkm localhost aadbkm Sleep 342 NULL >2493 aadbkm localhost NULL Sleep 15556 NULL >2506 aadbkm localhost NULL Sleep 14771 NULL >2514 aadbkm localhost NULL Sleep 14527 NULL >2521 aadbkm localhost NULL Sleep 13873 NULL >2535 aadbkm localhost aadbkm Sleep 2964 NULL >2572 aadbkm localhost NULL Sleep 9267 NULL >2583 aadbkm localhost NULL Sleep 8357 NULL >2590 aadbkm localhost NULL Sleep 7572 NULL >2594 aadbkm localhost NULL Sleep 7311 NULL >2618 aadbuser localhost aadb Sleep 396 NULL >2637 aadbkm localhost NULL Sleep 3973 NULL >2648 aadbkm localhost NULL Sleep 2946 NULL >2662 aadbkm localhost NULL Sleep 1271 NULL >2676 aadbkm localhost NULL Sleep 370 NULL >2677 aadbkm localhost NULL Sleep 342 NULL >2681 aadbkm localhost NULL Sleep 2 NULL >2683 root localhost NULL Query 0 NULL show >processlist -- Mitra Ardron: home/office +61-2-6684-8096 mobile +61-414-648-722 mi...@mi... Natural Innovation: www.naturalinnovation.org Personal site: www.mitra.biz My new blog is at: blog.mitra.biz Skype: mitra_earth Life is a Mystery to be Lived, not a Problem to be Solved |
|
From: Marek T. <ma...@gn...> - 2004-10-04 09:58:10
|
Dear Michael Schumacher, (sorry, your subject line "MLX patchelevel 2" somewhat evokes F1 racing) You should have a developer access to the CVS repository now. Best Marek > > > On a sidenote, is it possible to upload this into CVS? There is a > danger for me to patch a version that is below current CVS.... > > Thanks, > > mimo > > > > ------------------------------------------------------- > This SF.net email is sponsored by: IT Product Guide on ITManagersJournal > Use IT products in your business? Tell us what you think of them. Give us > Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out > more > http://productguide.itmanagersjournal.com/guidepromo.tmpl > _______________________________________________ > Apc-aa-coders mailing list > Apc...@li... > https://lists.sourceforge.net/lists/listinfo/apc-aa-coders > > -- ------------------------------- Marek Tichy GreenNet Systems Administrator tel. 08450554011 +44 (0)20 70650935 (office) +44 (0)20 70650939 (my desk) ------------------------------- |
|
From: Michael M. <mi...@gn...> - 2004-10-03 21:33:18
|
Hi I have done some more development of my multilingual extension. Features include: * Tab style interface in the item manager * slice.php3 now uses the MLX information in index views. It now does automatic fall back to other language versions For more information, the patch and some nice screenshots see http://mimo.gn.apc.org/mlx/ I have also set up section for feedback (see bottom of that page). It would be could to hear what other people think of this and whether it's worth opening it to the wider APC-AA community. On a sidenote, is it possible to upload this into CVS? There is a danger for me to patch a version that is below current CVS.... Thanks, mimo |
|
From: Davide R. <dav...@em...> - 2004-09-29 18:14:05
|
Hi all, I'd need to build an email message to be sent to users that desire receive it (something like a simpler version of an alert), this message should be made of the fields 'headline' and 'abstract' of all selected items taken from the table 'content' , according to the item IDs that satisfy some conditions(above all the category and the publish date). That' s the point: once I have selected all the text I need(for example having a vector with 'headline' and 'abstract' fields for every item) how can I build the resulting email message? I don' t know if all I've written is very clear, but if anybody can suggest me something, thanks in advance! -- Email.it, the professional e-mail, gratis per te: http://www.email.it/f Sponsor: Vuoi ricevere gratuitamente, ogni giovedì, manuali e guide per il tuo PC? Aggiornati gratis con Manuali.net! Clicca qui Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=2733&d=29-9 |
|
From: Michael M. <mi...@gn...> - 2004-09-29 16:10:47
|
Hi to answer my own post. I have patched AA to do these things. Let me know if you think it's worthy of CVS... My SF account is 'mimo'. I have put the patch and some instructions here: http://mimo.gn.apc.org/mlx/ Please tell me what you think. I also accept bug reports but remember to use the power of the source.... Greetings, mimo aka Michael mi...@gn... wrote: >Hi, > >I have been thinking about extending AA to accomodate multilingual content. We >have done this before using related items and apparently there are otehr >approaches as well. One problem I found with these is the useability point of >view. It's very frustrating and complex to explain how users and admins are >supposed to add items or translations in these setups. So this is an idea for >an approach that takes into account the user's point of view. As I am not going >to be in South Africa I hope we can have a fruitful discussion on this idea on >the list. > >Organistation of Information: > >A) Control Slice (or Metadata slice but I cannot pronounce this correctly) >B) Content Slice > >How it should work: > >Every slice has a line Language Control Slice in the Slice settings. If this is >filled with a valid Slice Id then the Slice with this Id will be the Control >Slice for this slice. > >Add Item / Edit Item: > >On top of the normal inputform display the list of enabled languages (where the >enabling of languages happen or where they are defined I dont know yet). This >list could look like this: > >| English | Edit Czech translation | Insert German translation | etc... > >This information is read from the Control Slice. The Control Slice should look >like this > >Translations: list( <language abbreviation> => <item id in Content Slice>, ) > (Optional: Default language for item) > >I think this would need a new field type. > > >The Content Slice would contain the same new field type, linking back to the >item in the Control Slice so that on deletion this can be modified. > > > >So far so good. Let me know if this as too brief and also what you think about >it, whether it would work, etc. >I am currently working on a project where this would be required so I could >implement it and then put it in the official AA CVS. > > >Thanks in advance, > > >mimo aka Michael > > > > > > > > > >---------------------------------------------------------------- >This message was sent using IMP, the Internet Messaging Program. > > >------------------------------------------------------- >This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170 >Project Admins to receive an Apple iPod Mini FREE for your judgement on >who ports your project to Linux PPC the best. Sponsored by IBM. >Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php >_______________________________________________ >Apc-aa-coders mailing list >Apc...@li... >https://lists.sourceforge.net/lists/listinfo/apc-aa-coders > > > > |
|
From: <mi...@gn...> - 2004-09-24 14:50:10
|
Hi,
I have been thinking about extending AA to accomodate multilingual content. We
have done this before using related items and apparently there are otehr
approaches as well. One problem I found with these is the useability point of
view. It's very frustrating and complex to explain how users and admins are
supposed to add items or translations in these setups. So this is an idea for
an approach that takes into account the user's point of view. As I am not going
to be in South Africa I hope we can have a fruitful discussion on this idea on
the list.
Organistation of Information:
A) Control Slice (or Metadata slice but I cannot pronounce this correctly)
B) Content Slice
How it should work:
Every slice has a line Language Control Slice in the Slice settings. If this is
filled with a valid Slice Id then the Slice with this Id will be the Control
Slice for this slice.
Add Item / Edit Item:
On top of the normal inputform display the list of enabled languages (where the
enabling of languages happen or where they are defined I dont know yet). This
list could look like this:
| English | Edit Czech translation | Insert German translation | etc...
This information is read from the Control Slice. The Control Slice should look
like this
Translations: list( <language abbreviation> => <item id in Content Slice>, )
(Optional: Default language for item)
I think this would need a new field type.
The Content Slice would contain the same new field type, linking back to the
item in the Control Slice so that on deletion this can be modified.
So far so good. Let me know if this as too brief and also what you think about
it, whether it would work, etc.
I am currently working on a project where this would be required so I could
implement it and then put it in the official AA CVS.
Thanks in advance,
mimo aka Michael
----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.
|
|
From: Mitra <mi...@mi...> - 2004-08-13 06:07:36
|
Thanks - that worked. - Mitra At 1:17 PM +0200 12/8/04, Pep Turro wrote: >Hi Mitra, > >On Thu, 12 Aug, 2004 at 08:58 +1000, Mitra wrote: >> None of my cvs installations will update any more, I get the error message > >sourceforge did a restructuring a while ago... now the cvs Root has >changed, and there were some other changes (I think ssh keys are >mandatory now, not sure). > >I have this cvs Root working: > :ext:pe...@cv...:/cvsroot/apc-aa > >Complete info at: > https://sourceforge.net/docman/display_doc.php?docid=768&group_id=1 > >pep > >> >Cannot access /cvsroot/apc-aa/CVSROOT >> >No such file or directory >> >> Its going to cvs.apc-aa.sourceforge.net >> >> I haven't been doing any AA coding for a while, has something >> changed? or is this a temporary hiccup. >> >> - Mitra >> >> >> >> -- >> home/office +61-2-6684-8096 mobile +61-414-648-722 mi...@mi... >> www.naturalinnovation.org or www.mitra.biz >> Life is a Mystery to be Lived, not a Problem to be Solved >> >> >> ------------------------------------------------------- >> SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media >> 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 >> Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift. >> http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 >> _______________________________________________ >> Apc-aa-coders mailing list >> Apc...@li... >> https://lists.sourceforge.net/lists/listinfo/apc-aa-coders > > >------------------------------------------------------- >SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media >100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 >Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift. >http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 >_______________________________________________ >Apc-aa-coders mailing list >Apc...@li... >https://lists.sourceforge.net/lists/listinfo/apc-aa-coders -- home/office +61-2-6684-8096 mobile +61-414-648-722 mi...@mi... www.naturalinnovation.org or www.mitra.biz Life is a Mystery to be Lived, not a Problem to be Solved |
|
From: Pep T. <pe...@tu...> - 2004-08-12 11:19:14
|
Hi Mitra, On Thu, 12 Aug, 2004 at 08:58 +1000, Mitra wrote: > None of my cvs installations will update any more, I get the error message sourceforge did a restructuring a while ago... now the cvs Root has changed, and there were some other changes (I think ssh keys are mandatory now, not sure). I have this cvs Root working: :ext:pe...@cv...:/cvsroot/apc-aa Complete info at: https://sourceforge.net/docman/display_doc.php?docid=768&group_id=1 pep > >Cannot access /cvsroot/apc-aa/CVSROOT > >No such file or directory > > Its going to cvs.apc-aa.sourceforge.net > > I haven't been doing any AA coding for a while, has something > changed? or is this a temporary hiccup. > > - Mitra > > > > -- > home/office +61-2-6684-8096 mobile +61-414-648-722 mi...@mi... > www.naturalinnovation.org or www.mitra.biz > Life is a Mystery to be Lived, not a Problem to be Solved > > > ------------------------------------------------------- > SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media > 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 > Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift. > http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 > _______________________________________________ > Apc-aa-coders mailing list > Apc...@li... > https://lists.sourceforge.net/lists/listinfo/apc-aa-coders |
|
From: Michael M. <mi...@gn...> - 2004-08-12 10:22:46
|
Thanks Mitra! It was my own script and we do have an older version of AA=20
but not easily updateable. So, for the record, I found a workaround=20
getting the short id with GetContent.
Again, thanks for explanation -- make things clearer.
mimo
Mitra wrote:
> Hi Mimo
>
> You don't say what you were doing when you tried to do this ... were=20
> you writing code, or running the AA interface.
>
> This should of course never happen in the AA code.
>
> If its something you are writing ...
>
> The idea of the Zids structure is to covert between the far-to-many=20
> ways that IDs are stored and used within the system, i.e. long, short,=20
> packed and tagged and three variants of quoting packed ids.
>
> Essentially the idea is that any part of the code can use the zids=20
> structure, without caring what form the ids are actually stored in,=20
> and then extract from the zids structure the ids in the form it needs.
>
> However not all the possible translations are actually coded.
>
> What you are doing, is presumably working somewhere where you need=20
> shortids, but whatever created the array of shortids created it with=20
> packed ids.
>
> Unfortunately I can't get my installation to update from CVS (see=20
> separate message) so I can't be 100% sure, but the copy I've got does=20
> NOT contain this error message in shortids, which it looks like could=20
> handle packed ids (type p). I'd suggest updating your aa installation=20
> and trying again. Otherwise, please email me a copy of =20
> apc-aa/include/zids.php3 , and/or check its at or later than version=20
> 1.26 (second line of zids.php3).
>
> - Mitra
>
>
>
> At 4:51 PM +0100 11/8/04, Michael Moritz wrote:
>
>> Hi Mitra,
>>
>> how can I convert long item ids to short item ids in case I needed=20
>> to? This is what my script returned:
>>
>> Query duration: 0.17414784431458
>> Rows returned: 1object(zids)(2) { ["a"]=3D> array(1) { [0]=3D>=20
>> string(16) ""=C6=CD=B0=E6=03=0C*=CA=19'HU=D1>t" } ["type"]=3D> string(=
1) "p" } ERROR -=20
>> zids:shortids(): can't handle type p conversion to shortids - ask mitr=
a
>>
>>
>> Thanks,
>>
>>
>> mimo
>>
|
|
From: Mitra <mi...@mi...> - 2004-08-11 23:05:36
|
None of my cvs installations will update any more, I get the error message >Cannot access /cvsroot/apc-aa/CVSROOT >No such file or directory Its going to cvs.apc-aa.sourceforge.net I haven't been doing any AA coding for a while, has something changed? or is this a temporary hiccup. - Mitra -- home/office +61-2-6684-8096 mobile +61-414-648-722 mi...@mi... www.naturalinnovation.org or www.mitra.biz Life is a Mystery to be Lived, not a Problem to be Solved |
|
From: Mitra <mi...@mi...> - 2004-08-11 23:05:33
|
Hi Mimo
You don't say what you were doing when you tried=20
to do this ... were you writing code, or running=20
the AA interface.
This should of course never happen in the AA code.
If its something you are writing ...
The idea of the Zids structure is to covert=20
between the far-to-many ways that IDs are stored=20
and used within the system, i.e. long, short,=20
packed and tagged and three variants of quoting=20
packed ids.
Essentially the idea is that any part of the code=20
can use the zids structure, without caring what=20
form the ids are actually stored in, and then=20
extract from the zids structure the ids in the=20
form it needs.
However not all the possible translations are actually coded.
What you are doing, is presumably working=20
somewhere where you need shortids, but whatever=20
created the array of shortids created it with=20
packed ids.
Unfortunately I can't get my installation to=20
update from CVS (see separate message) so I can't=20
be 100% sure, but the copy I've got does NOT=20
contain this error message in shortids, which it=20
looks like could handle packed ids (type p). I'd=20
suggest updating your aa installation and trying=20
again. Otherwise, please email me a copy of=20
apc-aa/include/zids.php3 , and/or check its at=20
or later than version 1.26 (second line of=20
zids.php3).
- Mitra
At 4:51 PM +0100 11/8/04, Michael Moritz wrote:
>Hi Mitra,
>
>how can I convert long item ids to short item=20
>ids in case I needed to? This is what my script=20
>returned:
>
>Query duration: 0.17414784431458
>Rows returned: 1object(zids)(2) { ["a"]=3D>=20
>array(1) { [0]=3D> string(16) "=93=C6=CD=B0=E6=03=0C*=CA=19'HU=D1=9Bt" }=20
>["type"]=3D> string(1) "p" } ERROR -=20
>zids:shortids(): can't handle type p conversion=20
>to shortids - ask mitra
>
>
>Thanks,
>
>
>mimo
>
>
>-------------------------------------------------------
>SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
>100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
>Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
>http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
>_______________________________________________
>Apc-aa-coders mailing list
>Apc...@li...
>https://lists.sourceforge.net/lists/listinfo/apc-aa-coders
--
home/office +61-2-6684-8096 mobile +61-414-648-722 mi...@mi...
www.naturalinnovation.org or www.mitra.biz
Life is a Mystery to be Lived, not a Problem to be Solved |
|
From: Michael M. <mi...@gn...> - 2004-08-11 16:15:16
|
Hi Mitra,
how can I convert long item ids to short item ids in case I needed to?=20
This is what my script returned:
Query duration: 0.17414784431458
Rows returned: 1object(zids)(2) { ["a"]=3D> array(1) { [0]=3D>=20
string(16) "=E2=80=9E=D0=83=D0=BA=C2=B0=D0=8A=03=0C*=D0=B6=19=E2=80=99HU=D0=
=94=D1=8Dt" } ["type"]=3D> string(1) "p" } ERROR -=20
zids:shortids(): can't handle type p conversion to shortids - ask mitra
Thanks,
mimo
|
3 messages has been excluded from this view by a project administrator.
