apc-aa-coders — Discussion only useful to active developers.

Re: [Apc-aa-coders] Stable release - bug fix

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

Oh - this directory is really not in the file :-(

   I replaced the tgz file on Sourceforge by the fixed one.

      Thanks Zoltan,
=20
         Honza




On =C8t, 2003-11-06 at 20:29, Zoltan Varady wrote:
> Another bug I found in 2.6.0: I installed it into a new directory, and=20
> I got:
>=20
> Fatal error:  Failed opening required=20
> '/var/www/apc-aa/include/htmlMimeMail/htmlMimeMail.php'=20
> (include_path=3D'.:/usr/lib/php') in=20
> /Library/WebServer/Documents/apc-aa/include/mail.php3 on line 26
>=20
> It looks like the htmlMimeMail subdirectory is missing in the 2.6.0=20
> .tgz package - I copied the one I downloaded from a previous CVS=20
> version, and it worked...
>=20
> 	zzzz.
>=20
>=20
>=20
> -------------------------------------------------------
> This SF.net email is sponsored by: SF.net Giveback Program.
> Does SourceForge.net help you be more productive?  Does it
> help you create better code?   SHARE THE LOVE, and help us help
> YOU!  Click Here: http://sourceforge.net/donate/
> _______________________________________________
> Apc-aa-coders mailing list
> Apc...@li...
> https://lists.sourceforge.net/lists/listinfo/apc-aa-coders
--=20
Honza Malik <hon...@ec...>
Econnect

Re: [Apc-aa-coders] Stable release - bug fix

[Zoltan V. <dr...@zp...>]

Another bug I found in 2.6.0: I installed it into a new directory, and 
I got:

Fatal error:  Failed opening required 
'/var/www/apc-aa/include/htmlMimeMail/htmlMimeMail.php' 
(include_path='.:/usr/lib/php') in 
/Library/WebServer/Documents/apc-aa/include/mail.php3 on line 26

It looks like the htmlMimeMail subdirectory is missing in the 2.6.0 
.tgz package - I copied the one I downloaded from a previous CVS 
version, and it worked...

	zzzz.

[Apc-aa-coders] Stable release - bug fix

[Mitra <mi...@mi...>]

I see that there has been a release posted by Honza to CVS yesterday 
as a stable release v2.6

I've fixed a couple of bugs in it ....

1: In init_page has been around for a while, and occurs if someone 
tries to edit a slice they don't have permissions to edit.

2: In Discussion lists,  you had a field DiscussionMailList but 
nothing in it (e.g. an unshown field),  then it crashed (SQL error) 
when someone added a Discussion comment.

- Mitra

-- 
Mitra Technology Consulting -  www.mitra.biz - mi...@mi...
home 02-6684-8096  mobile 0414-648-722  office 02-6684-6182
Byron Community Knowledge Management Project www.byronkm.com

Life is a Mystery to be Lived, not a Problem to be Solved

Re: [Apc-aa-coders] Problems with Spanish characters in Pangea RSS feed.

[Mitra <mi...@ea...>]

Before any changes are made .....

I've been informed that ISO-8859-1 and UTF8 are orthogonal encodings, 
so we should be EITHER encoding in ISO-8859-1 or in UTF8.

I'm not sure how to
a) determine what encoding is in use in the slice
b) translate that into a standard encoding for our RSS feed.
c) Do this in a way that a typical slice admin could do with no problems.

I.e. f_r should do it automatically.

And .... the import function should read it automatically, which I 
presume means changing an incoming ISO-8859-1 or UTF8 feed into 
whatever coding the slice needs.

Anyone know what the appropriate functions are, and whether there is 
any functionality in AA to do this already?

- Mitra


At 12:48 PM +1000 24/10/03, Mitra wrote:
>Karel
>
>I think the problem you are having is that Pangea's RSS feed doesn't 
>appear to be UTF8 encoded,
>
>Do I assume they are using apc-aa?
>
>If so, then that "description" field should be output with an alias 
>that calls f_r , the default setting for _#RSS_IT_D uses f_r, so I'm 
>guessing that Pangea is not creating that feed using _#RSS_IT_D, 
>*or* they've changed the definition of _#RSS_IT_D.
>
>Can you check with Pangea (not sure who that would be) to find out 
>what their definition of _#RSS_IT_D is on that slice (Its in the 
>Abstract field) *and* the definition of the "Odd Rows" for that the 
>view being called behind "backend.php"
>
>- Mitra
>
>
>>Background ....
>>
>>In summary ...
>>
>>The RSS feed is at http://revista.pangea.org/backend.php
>>
>>It has a coding of
>><?xml version="1.0" encoding="ISO-8859-1"?>
>>
>>which Karel states includes support for Spanish characters.
>>
>>If you look at it closely, you'll see some spanish characters, for 
>>example note the "341"
>>
>>lynx -source "http://revista.pangea.org/backend.php" | grep Manuel | od -c
>>0000000    1   -       M   a   n   u   e   l       V 341   z   q   u   e
>>0000020    z       M   o   n   t   a   l   b 341   n  \r  \n
>>0000035
>>
>>This is then decoded using (xml_rssparse.php3:CharD -> decode -> 
>>php's utf8_decode)
>>
>>If I read the man page for this 
>>http://au2.php.net/manual/en/function.utf8-decode.php
>>
>>it says:
>>
>>  utf8_decode --       Converts a string with ISO-8859-1 characters 
>>encoded with UTF-8      to single-byte ISO-8859-1.
>>
>>Which implies to me that XML should be having that 341 encoded as 
>>UTF8, i.e. that the export function utf8_decode should be called 
>>from f_r , funny thing is that it is ... (f_r -> RSS_restrict -> 
>>utf8_encode).
>>
>>Following this through - decode returns a "?" for the 341 which 
>>then shows in an English version of an AA slice, which Karel thinks 
>>also uses ISO-8859-1, the slice is visible at 
>>http://www.apc.org/espanol/news/rss/pangea.shtml
>>
>>Looking at the specific line and notice the "?" in place of the 341.
>>
>>lynx -source "http://www.apc.org/espanol/news/rss/pangea.shtml" | 
>>grep Manuel | od -c
>>0000000    1   -       M   a   n   u   e   l       V   ?   u   e   z
>>0000020    M   o   n   t   a   l   b   ?   <   b   r       /   >  \n
>>0000037
>
>
>
>--
>Mitra Technology Consulting -  www.mitra.biz - mi...@mi...
>home 02-6684-8096  mobile 0414-648-722  office 02-6684-6182
>Byron Community Knowledge Management Project www.byronkm.com
>
>Life is a Mystery to be Lived, not a Problem to be Solved


-- 
Mitra Technology Consulting -  www.mitra.biz - mi...@mi...
home 02-6684-8096  mobile 0414-648-722  office 02-6684-6182
Byron Community Knowledge Management Project www.byronkm.com

Life is a Mystery to be Lived, not a Problem to be Solved

[Apc-aa-coders] Re: [Apc-aa-general] Importing RSS Feeds to AA

[Mitra <mi...@ea...>]

I've documented the mapping syntax in the FAQ as suggested:
http://apc-aa.sourceforge.net/faq/#1622

That looks like a good framework. It shouldn't be too hard to convert 
the RSS import to work through that structure, since its integrated 
with the AA import anything that works for AA should work for it, and 
the RSS code structure is to import into an intermediate structure 
and then apply the mapping code so the tasks would be:

1: Change the the importing and parsing to use your structure - do I 
assume the Input Item will be an a PhP class with its own methods? 
The only tricky part here is that the "content" function which 
intelligently looks for the content in the feed and whether its HTML 
or not needs to be moved into here from the mapping.

2: Add the RSS specific structures to the mapping process, the key 
functions needed are:

* the default structure which chooses the first of a series that is 
non-null., maybe just add it to {...} as
{first:ITEM/title:ITEM/description}

* date conversion, but this could be done in the parsing

* now - to get the current time/date as a number, trivial to add as {timenow}



- Mitra


At 4:03 PM +0200 20/10/03, Honza Malik wrote:
>Hi Mitra,
>
>>  We don't just have RSS 0.91 import, we've got RSS0.92 and 1.0 and 2.0 !
>
>That's really great.
>
>>  I like the idea of doing the unaliasing, but it
>>  wouldn't work with your syntax, because there is
>>  no "source.........1" field in an import from
>>  RSS, only from an import from another APC-AA
>>  system.
>
>Yes, that's right. The idea of new import API is following:
>
>You always imports ITEMS to the slice - doesn't matter if it is from
>CSV, RSS, XML, internal feeding, ...
>
>Each ITEM have its fields - they are called 'headline.......1' in AA,
>'title' in CSV or 'ITEM/HEADLINE' in RSS. So, basicaly it is possible to
>fill some data structure with one INPUT ITEM, then call some
>TRANSFORMATION FUNCTION (defined through Mapping page) and result store
>to the database with standard StoreItem() function:
>
>|--------------------------------|     
>|  Input item from RSS, CSV, ... |        Uses its own field names
>|--------------------------------|        ('title', 'Field1', ...)
>                |
>                |
>                |
>                |<---- TRANSFORMATION FUNCTIONS defined through Mapping
>                |           ('--Value--', Field content, ...)
>                |
>                v
>|--------------------------------|     
>|      Standard AA item          |        stored in ItemContent class
>|--------------------------------|      
>                |
>                |
>                |<---- StoreItem() function
>                |         
>                v
>           AA Database
>
>
>Fortunately, input ITEM could be stored also in ItemContent class.
>
>
>The big advantage of this approach is, that the only what you need to do
>is to write function, which grabs one ITEM from input and store it into
>ItemContent object. There is no problem with field names - you can use
>format specific names (like 'title' or 'ITEM/HEADLINE') there.
>
>So, for CSV you need to write CVS2ItemContent(), for RSS
>RSS2ItemContent(), XML2ItemContent(), FedItem2ItemContent(), ...
>
>Then you will be able to use THE SAME transformation functions for all
>this kind of input data.
>
>>   Instead , fields are epresented by where
>>  it they are in an XML parse - e.g. in my syntax I
>>  use
>>
>>  RSS: "ITEM/HEADLINE"
>
>OK, can you please describe this syntax to FAQ and/or to Mapping page?
>
>    Thanks again for your work.
>
>       Honza
>
>>  The syntax is much simpler than the full {....} syntax, e.g.
>>
>>  RSS: ITEM/HEADLINE|ITEM/DESCRIPTION
>>
>>  gets you the Headline, and if that isn't present
>>  then the Description.   This could be extended
>>  through your value *if* you extended the {....}
>>  syntax to recognize the XML elements instead of
>>  fields.
>>
>>  - Mitra
>>
>>  At 8:17 PM +0200 19/10/03, Honza Malik wrote:
>>  >Hi Mark,
>>  >
>  > >    thank you and Mitra very much for this work. I'm happy we have RSS
>  > >v0.91 import in AA. As I tested it, it works well, which is great.
>  > >
>  > >    I expected probably a little more work on the import, because I
>>  >planed to move RSS 0.91 (and 1.0) to newer data exchange interface
>>  >(which we are developing for CSV data import). In this interface would
>>  >be possible to use unaliasing for any field (I mean:
>>  >
>>  >    Value: {switch({source.........1})Ecn:1:4}
>>  >
>>  >  syntax described bellow) - just like it work for internal feeding.
>>  >Never mind  - I will save it on TODO list for the future.
>>  >
>>  >    Thank you again for this feature and its funding.
>>  >
>>  >       Honza


--
Mitra Technology Consulting -  www.mitra.biz - mi...@mi...
home 02-6684-8096  mobile 0414-648-722  office 02-6684-6182
Byron Community Knowledge Management Project www.byronkm.com

Life is a Mystery to be Lived, not a Problem to be Solved

[Apc-aa-coders] Problems with Spanish characters in Pangea RSS feed.

[Mitra <mi...@ea...>]

Karel

I think the problem you are having is that Pangea's RSS feed doesn't 
appear to be UTF8 encoded,

Do I assume they are using apc-aa?

If so, then that "description" field should be output with an alias 
that calls f_r , the default setting for _#RSS_IT_D uses f_r, so I'm 
guessing that Pangea is not creating that feed using _#RSS_IT_D, *or* 
they've changed the definition of _#RSS_IT_D.

Can you check with Pangea (not sure who that would be) to find out 
what their definition of _#RSS_IT_D is on that slice (Its in the 
Abstract field) *and* the definition of the "Odd Rows" for that the 
view being called behind "backend.php"

- Mitra


>Background ....
>
>In summary ...
>
>The RSS feed is at http://revista.pangea.org/backend.php
>
>It has a coding of
><?xml version="1.0" encoding="ISO-8859-1"?>
>
>which Karel states includes support for Spanish characters.
>
>If you look at it closely, you'll see some spanish characters, for 
>example note the "341"
>
>lynx -source "http://revista.pangea.org/backend.php" | grep Manuel | od -c
>0000000    1   -       M   a   n   u   e   l       V 341   z   q   u   e
>0000020    z       M   o   n   t   a   l   b 341   n  \r  \n
>0000035
>
>This is then decoded using (xml_rssparse.php3:CharD -> decode -> 
>php's utf8_decode)
>
>If I read the man page for this 
>http://au2.php.net/manual/en/function.utf8-decode.php
>
>it says:
>
>  utf8_decode --       Converts a string with ISO-8859-1 characters 
>encoded with UTF-8      to single-byte ISO-8859-1.
>
>Which implies to me that XML should be having that 341 encoded as 
>UTF8, i.e. that the export function utf8_decode should be called 
>from f_r , funny thing is that it is ... (f_r -> RSS_restrict -> 
>utf8_encode).
>
>Following this through - decode returns a "?" for the 341 which then 
>shows in an English version of an AA slice, which Karel thinks also 
>uses ISO-8859-1, the slice is visible at 
>http://www.apc.org/espanol/news/rss/pangea.shtml
>
>Looking at the specific line and notice the "?" in place of the 341.
>
>lynx -source "http://www.apc.org/espanol/news/rss/pangea.shtml" | 
>grep Manuel | od -c
>0000000    1   -       M   a   n   u   e   l       V   ?   u   e   z
>0000020    M   o   n   t   a   l   b   ?   <   b   r       /   >  \n
>0000037



--
Mitra Technology Consulting -  www.mitra.biz - mi...@mi...
home 02-6684-8096  mobile 0414-648-722  office 02-6684-6182
Byron Community Knowledge Management Project www.byronkm.com

Life is a Mystery to be Lived, not a Problem to be Solved

[Apc-aa-coders] Re: [Apc-aa-general] Importing RSS Feeds to AA

[Mitra <mi...@ea...>]

I've documented the mapping syntax in the FAQ as suggested:
http://apc-aa.sourceforge.net/faq/#1622

That looks like a good framework. It shouldn't be too hard to convert 
the RSS import to work through that structure, since its integrated 
with the AA import anything that works for AA should work for it, and 
the RSS code structure is to import into an intermediate structure 
and then apply the mapping code so the tasks would be:

1: Change the the importing and parsing to use your structure - do I 
assume the Input Item will be an a PhP class with its own methods? 
The only tricky part here is that the "content" function which 
intelligently looks for the content in the feed and whether its HTML 
or not needs to be moved into here from the mapping.

2: Add the RSS specific structures to the mapping process, the key 
functions needed are:

* the default structure which chooses the first of a series that is 
non-null., maybe just add it to {...} as
{first:ITEM/title:ITEM/description}

* date conversion, but this could be done in the parsing

* now - to get the current time/date as a number, trivial to add as {timenow}



- Mitra


At 4:03 PM +0200 20/10/03, Honza Malik wrote:
>Hi Mitra,
>
>>  We don't just have RSS 0.91 import, we've got RSS0.92 and 1.0 and 2.0 !
>
>That's really great.
>
>>  I like the idea of doing the unaliasing, but it
>>  wouldn't work with your syntax, because there is
>>  no "source.........1" field in an import from
>>  RSS, only from an import from another APC-AA
>>  system.
>
>Yes, that's right. The idea of new import API is following:
>
>You always imports ITEMS to the slice - doesn't matter if it is from
>CSV, RSS, XML, internal feeding, ...
>
>Each ITEM have its fields - they are called 'headline.......1' in AA,
>'title' in CSV or 'ITEM/HEADLINE' in RSS. So, basicaly it is possible to
>fill some data structure with one INPUT ITEM, then call some
>TRANSFORMATION FUNCTION (defined through Mapping page) and result store
>to the database with standard StoreItem() function:
>
>|--------------------------------|      
>|  Input item from RSS, CSV, ... |        Uses its own field names
>|--------------------------------|        ('title', 'Field1', ...)
>                |
>                |
>                |
>                |<---- TRANSFORMATION FUNCTIONS defined through Mapping
>                |           ('--Value--', Field content, ...)
>                |
>                v
>|--------------------------------|      
>|      Standard AA item          |        stored in ItemContent class
>|--------------------------------|       
>                |
>                |
>                |<---- StoreItem() function
>                |          
>                v
>           AA Database
>
>
>Fortunately, input ITEM could be stored also in ItemContent class.
>
>
>The big advantage of this approach is, that the only what you need to do
>is to write function, which grabs one ITEM from input and store it into
>ItemContent object. There is no problem with field names - you can use
>format specific names (like 'title' or 'ITEM/HEADLINE') there.
>
>So, for CSV you need to write CVS2ItemContent(), for RSS
>RSS2ItemContent(), XML2ItemContent(), FedItem2ItemContent(), ...
>
>Then you will be able to use THE SAME transformation functions for all
>this kind of input data.
>
>>   Instead , fields are epresented by where
>>  it they are in an XML parse - e.g. in my syntax I
>>  use
>>
>>  RSS: "ITEM/HEADLINE"
>
>OK, can you please describe this syntax to FAQ and/or to Mapping page?
>
>    Thanks again for your work.
>
>       Honza
>
>>  The syntax is much simpler than the full {....} syntax, e.g.
>>
>>  RSS: ITEM/HEADLINE|ITEM/DESCRIPTION
>>
>>  gets you the Headline, and if that isn't present
>>  then the Description.   This could be extended
>>  through your value *if* you extended the {....}
>>  syntax to recognize the XML elements instead of
>>  fields.
>>
>>  - Mitra
>>
>>  At 8:17 PM +0200 19/10/03, Honza Malik wrote:
>>  >Hi Mark,
>>  >
>  > >    thank you and Mitra very much for this work. I'm happy we have RSS
>  > >v0.91 import in AA. As I tested it, it works well, which is great.
>  > >
>  > >    I expected probably a little more work on the import, because I
>>  >planed to move RSS 0.91 (and 1.0) to newer data exchange interface
>>  >(which we are developing for CSV data import). In this interface would
>>  >be possible to use unaliasing for any field (I mean:
>>  >
>>  >    Value: {switch({source.........1})Ecn:1:4}
>>  >
>>  >  syntax described bellow) - just like it work for internal feeding.
>>  >Never mind  - I will save it on TODO list for the future.
>>  >
>>  >    Thank you again for this feature and its funding.
>>  >
>>  >       Honza


-- 
Mitra Technology Consulting -  www.mitra.biz - mi...@mi...
home 02-6684-8096  mobile 0414-648-722  office 02-6684-6182
Byron Community Knowledge Management Project www.byronkm.com

Life is a Mystery to be Lived, not a Problem to be Solved

[Apc-aa-coders] Re: [Apc-aa-general] Importing RSS Feeds to AA

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

Hi Mitra,

> We don't just have RSS 0.91 import, we've got RSS0.92 and 1.0 and 2.0 !

That's really great.

> I like the idea of doing the unaliasing, but it 
> wouldn't work with your syntax, because there is 
> no "source.........1" field in an import from 
> RSS, only from an import from another APC-AA 
> system.

Yes, that's right. The idea of new import API is following:

You always imports ITEMS to the slice - doesn't matter if it is from
CSV, RSS, XML, internal feeding, ... 

Each ITEM have its fields - they are called 'headline.......1' in AA,
'title' in CSV or 'ITEM/HEADLINE' in RSS. So, basicaly it is possible to
fill some data structure with one INPUT ITEM, then call some
TRANSFORMATION FUNCTION (defined through Mapping page) and result store
to the database with standard StoreItem() function:

|--------------------------------|       
|  Input item from RSS, CSV, ... |        Uses its own field names
|--------------------------------|        ('title', 'Field1', ...)
               |
               |
               |
               |<---- TRANSFORMATION FUNCTIONS defined through Mapping
               |           ('--Value--', Field content, ...)
               |
               v
|--------------------------------|       
|      Standard AA item          |        stored in ItemContent class
|--------------------------------|        
               |
               |
               |<---- StoreItem() function
               |           
               v
          AA Database


Fortunately, input ITEM could be stored also in ItemContent class.


The big advantage of this approach is, that the only what you need to do
is to write function, which grabs one ITEM from input and store it into
ItemContent object. There is no problem with field names - you can use
format specific names (like 'title' or 'ITEM/HEADLINE') there.

So, for CSV you need to write CVS2ItemContent(), for RSS
RSS2ItemContent(), XML2ItemContent(), FedItem2ItemContent(), ... 

Then you will be able to use THE SAME transformation functions for all
this kind of input data.

>  Instead , fields are epresented by where 
> it they are in an XML parse - e.g. in my syntax I 
> use
> 
> RSS: "ITEM/HEADLINE"

OK, can you please describe this syntax to FAQ and/or to Mapping page?

   Thanks again for your work.
 
      Honza

> The syntax is much simpler than the full {....} syntax, e.g.
> 
> RSS: ITEM/HEADLINE|ITEM/DESCRIPTION
> 
> gets you the Headline, and if that isn't present 
> then the Description.   This could be extended 
> through your value *if* you extended the {....} 
> syntax to recognize the XML elements instead of 
> fields.
> 
> - Mitra
> 
> At 8:17 PM +0200 19/10/03, Honza Malik wrote:
> >Hi Mark,
> >
> >    thank you and Mitra very much for this work. I'm happy we have RSS
> >v0.91 import in AA. As I tested it, it works well, which is great.
> >
> >    I expected probably a little more work on the import, because I
> >planed to move RSS 0.91 (and 1.0) to newer data exchange interface
> >(which we are developing for CSV data import). In this interface would
> >be possible to use unaliasing for any field (I mean:
> >
> >    Value: {switch({source.........1})Ecn:1:4}
> >
> >  syntax described bellow) - just like it work for internal feeding.
> >Never mind  - I will save it on TODO list for the future.
> >
> >    Thank you again for this feature and its funding.
> >
> >       Honza

Re: [Apc-aa-coders] possible bug in QueryZids

[Michael M. <mi...@gn...>]

Ok - I know a bit more now:

unpack_id gives this =D35=EE=F8=C5=DDOv=D15;

but really the id is =D35=9A=EE=F8=C5=DDO=92=82=05v=D15;=9B
   =20

(Note the > at the end)

mm


Michael Moritz wrote:

>> SELECT DISTINCT item.id FROM item LEFT JOIN content as c0
>> ON (c0.item_id=3Ditem.id
>> AND (c0.field_id=3D'switch.........3' OR c0.field_id is NULL)) WHERE=20
>> item.slice_id IN ( '=D35=EE=F8=C5=DDOv=D15;ND item.status_code=3D1 AND
>> ( item.publish_date <=3D '1065902550' OR item.publish_date IS NULL )=20
>> AND (item.expiry_date > '1065902550' OR item.expiry_date IS NULL) AND=20
>> ( (c0.number =3D "1") ) ORDER BY item.publish_date=20
>> DESC<table><tr><td><b>table</b></td>=20
>> <td><b>type</b></td><td><b>possible_keys</b></td><td><b>key</b></td><t=
d><b>key_len</b></td><td><b>ref</b></td><td><b>rows</b></td><td><b>Extra<=
/b></td></tr><tr><td>item</td><td>range</td><td>slice_id_2,expiry_date</t=
d><td>slice_id_2</td><td>27</td><td></td><td>9</td><td>where=20
>> used; Using temporary; Using=20
>> filesort</td></tr><tr><td>c0</td><td>ref</td><td>item_id</td><td>item_=
id</td><td>16</td><td>item.id</td><td>22</td><td>where=20
>> used; Distinct</td></tr></table><br>Query duration:=20
>> 0.0024969577789307<br>Rows returned: 0--end--
>
>
>
> Note the
>
>> item.slice_id IN ( '=D35=EE=F8=C5=DDOv=D15;ND item.status_code=3D1 AND
>
>
>
> I think that somewhere in the AA search the slice ID messes up the SQL=20
> query and that messes up the AND
> It's probably because of the slice id - since this has changed....
>
> I have unpacked the slice id and it is =D35=EE=F8=C5=DDOv=D15;
>
>
> Any help appreciated,
>
> mm
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: SF.net Giveback Program.
> SourceForge.net hosts over 70,000 Open Source Projects.
> See the people who have HELPED US provide better services:
> Click here: http://sourceforge.net/supporters.php
> _______________________________________________
> Apc-aa-coders mailing list
> Apc...@li...
> https://lists.sourceforge.net/lists/listinfo/apc-aa-coders
>
>

[Apc-aa-coders] possible bug in QueryZids

[Michael M. <mi...@gn...>]

> SELECT DISTINCT item.id FROM item  LEFT JOIN content as c0
>                                    ON (c0.item_id=3Ditem.id
>                                    AND (c0.field_id=3D'switch.........3=
'=20
> OR c0.field_id is NULL)) WHERE  item.slice_id IN ( '=D35=EE=F8=C5=DDOv=D1=
5;ND =20
> item.status_code=3D1 AND
>         ( item.publish_date <=3D '1065902550' OR item.publish_date IS=20
> NULL )  AND (item.expiry_date > '1065902550' OR item.expiry_date IS=20
> NULL)  AND ( (c0.number =3D "1") )  ORDER BY item.publish_date=20
> DESC<table><tr><td><b>table</b></td>=20
> <td><b>type</b></td><td><b>possible_keys</b></td><td><b>key</b></td><td=
><b>key_len</b></td><td><b>ref</b></td><td><b>rows</b></td><td><b>Extra</=
b></td></tr><tr><td>item</td><td>range</td><td>slice_id_2,expiry_date</td=
><td>slice_id_2</td><td>27</td><td></td><td>9</td><td>where=20
> used; Using temporary; Using=20
> filesort</td></tr><tr><td>c0</td><td>ref</td><td>item_id</td><td>item_i=
d</td><td>16</td><td>item.id</td><td>22</td><td>where=20
> used; Distinct</td></tr></table><br>Query duration:=20
> 0.0024969577789307<br>Rows returned: 0--end--


Note the

> item.slice_id IN ( '=D35=EE=F8=C5=DDOv=D15;ND  item.status_code=3D1 AND


I think that somewhere in the AA search the slice ID messes up the SQL=20
query and that messes up the AND
It's probably because of the slice id - since this has changed....

I have unpacked the slice id and it is =D35=EE=F8=C5=DDOv=D15;


Any help appreciated,

mm

[Apc-aa-coders] changing folder of an item

[Michael M. <mi...@gn...>]

I am jus tworking on a set of import scripts which are being run on a 
daily basis to synchronise a database with AA. I have noticed that when 
I call StoreItem I have to pass status_code which specifies the folder 
the new item is going to. Now, I want to import everyting into holding 
bin first, then remove all items from active, and then move everything 
from holding bin to the active bin. In the mySQL table item there is a 
field status_code. My question is: is it sufficient to change this 
status_code to 1 or are there any other places where I need to change 
the status_code to get the imported items/articles into teh active bin?

Thanks

mm

[Apc-aa-coders] Permissions on links

[Mitra <mi...@ea...>]

Hi

Is there a way to set permissions on a Links Slice?

- Mitra

-- 
Mitra Technology Consulting -  www.mitra.biz - mi...@mi...
home 02-6684-8096  mobile 0414-648-722  office 02-6684-6182
Byron Community Knowledge Management Project www.byronkm.com

Life is a Mystery to be Lived, not a Problem to be Solved

[Apc-aa-coders] Three ids in Links

[Mitra <mi...@ea...>]

Hi Honza

What are the three links at the bottom of the Link Admin page ..

It seems to me that the top link is the first category allocated, and 
the bottom one is the top of the tree for cross-referencing, but what 
is the middle one.

Also - how do you make sure that the top category id is a new empty 
category?  It always comes up as the SAME as the slice being copied 
when I use it.

It seems that the process for creating a new slice would be...

Links Root -> Link Manager -> Edit Cat -> Add -> NewRootName
Hover over NewRootName to get Categ number (e.g. 8)
AA -> Create New -> LinkExample
- owner=mitra;  ids = 8 1 8
Links Manager -> Edit Category -> Add all the new categories


Is that correct, or is there a simpler way to do this?

- Mitra

-- 
Mitra Technology Consulting -  www.mitra.biz - mi...@mi...
home 02-6684-8096  mobile 0414-648-722  office 02-6684-6182
Byron Community Knowledge Management Project www.byronkm.com

Life is a Mystery to be Lived, not a Problem to be Solved

Re: [Apc-aa-coders] No-Item HTML code - why not expanded / unaliased

[Mitra <mi...@ea...>]

Ok - this is done, this section now expands on Links Views, and 
probably (so far untested) on other views.

- Mitra


At 12:58 AM +0200 5/9/03, Honza Malik wrote:
>No objections, good idea, definitely. Go ahead.
>
>    Honza
>
>Mitra wrote:
>>Is there any reason why the No-Item code in views is not expanded?
>  >
>>For example .... I've got a Links view, that I want to put 
>>_#C_PATH__ into for the case of there being no links in the 
>>category.
>>
>>I also want to use {view.php3?vid=8} in that string, so this needs 
>>to go through the whole expansion, rather than just unaliasing?
>>
>>Before I make this change (or someone else does) I just wanted to 
>>check there isn't some reason that this particular field is not 
>>expanded/unalisases?
>>
>>- Mitra
>>
>
>
>
>
>-------------------------------------------------------
>This sf.net email is sponsored by:ThinkGeek
>Welcome to geek heaven.
>http://thinkgeek.com/sf
>_______________________________________________
>Apc-aa-coders mailing list
>Apc...@li...
>https://lists.sourceforge.net/lists/listinfo/apc-aa-coders


--
Mitra Technology Consulting -  www.mitra.biz - mi...@mi...
home 02-6684-8096  mobile 0414-648-722  office 02-6684-6182
Byron Community Knowledge Management Project www.byronkm.com

Life is a Mystery to be Lived, not a Problem to be Solved

RE: [Apc-aa-coders] MS converter

[Mitra <mi...@ea...>]

Marek

Did you complete work on this?

Even if we don't put it in the distribution=20
(which I agree) we could put it in the FAQ with=20
some directions on how to compile, integrate and=20
then use?

- Mitra


At 10:40 AM +0200 3/6/03, Marek Tichy wrote:
>Hi Mitra,
>MS converter in the misc directory is just an=20
>experimental php interface to free command line=20
>converters like vwHtml
>http://www.wvware.com/, pdftohtml, xlhtml etc...
>The idea is that you as an editor can upload a=20
>file, the converter converts it to html and=20
>pastes it to the fulltext window and sets
>the html/plain swith to html.
>We have been testing mainly vwHtml for a while,=20
>it has certain problems, but in general can be a=20
>great time saver for editors.
>It needs further work to integrate it properly=20
>into AA, though I doubt we will ever include=20
>foreign tools that need to be compiled
>(which is in this case tricky enough) to AA distribution.
>I'll try to free some time to finish it off soon.
>
>  Marek
>
>>  -----Original Message-----
>>  From: apc...@li...
>>  [mailto:apc...@li...]On Behalf Of Mitra
>>  Sent: 3. =E8ervna 2003 0:41
>>  To: apc...@so...
>>  Subject: [Apc-aa-coders] MS converter
>>
>>
>>  There is mention in the PHP wizzard of a MS Word converter in
>>  apc-aa/misc/msconvert
>>
>>  Where do you get that, and is there any reason its not part of the
>>  distribution?
>>
>>  - mitra
>>
>>  --
>>  Mitra Technology Consulting -  www.mitra.biz - mi...@mi...
>>  home office 02-6684-8096  mobile 0414-648-722  work 02-6684-6182
>>
>>  Life is a Mystery to be Lived, not a Problem to be Solved
>>
>>
>>
>>  -------------------------------------------------------
>>  This SF.net email is sponsored by: eBay
>>  Get office equipment for less on eBay!
>>  http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5
>>  _______________________________________________
>>  Apc-aa-coders mailing list
>>  Apc...@li...
>>  https://lists.sourceforge.net/lists/listinfo/apc-aa-coders
>>
>
>
>
>-------------------------------------------------------
>This SF.net email is sponsored by: eBay
>Get office equipment for less on eBay!
>http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5
>_______________________________________________
>Apc-aa-coders mailing list
>Apc...@li...
>https://lists.sourceforge.net/lists/listinfo/apc-aa-coders


--
Mitra Technology Consulting -  www.mitra.biz - mi...@mi...
home 02-6684-8096  mobile 0414-648-722  office 02-6684-6182
Byron Community Knowledge Management Project www.byronkm.com

Life is a Mystery to be Lived, not a Problem to be Solved

Re: [Apc-aa-coders] No-Item HTML code - why not expanded / unaliased

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

No objections, good idea, definitely. Go ahead.

    Honza

Mitra wrote:
> Is there any reason why the No-Item code in views is not expanded?
 >
> For example .... I've got a Links view, that I want to put _#C_PATH__ 
> into for the case of there being no links in the category.
> 
> I also want to use {view.php3?vid=8} in that string, so this needs to go 
> through the whole expansion, rather than just unaliasing?
> 
> Before I make this change (or someone else does) I just wanted to check 
> there isn't some reason that this particular field is not 
> expanded/unalisases?
> 
> - Mitra
> 

[Apc-aa-coders] No-Item HTML code - why not expanded / unaliased

[Mitra <mi...@ea...>]

Is there any reason why the No-Item code in views is not expanded?

For example .... I've got a Links view, that I want to put _#C_PATH__ 
into for the case of there being no links in the category.

I also want to use {view.php3?vid=8} in that string, so this needs to 
go through the whole expansion, rather than just unaliasing?

Before I make this change (or someone else does) I just wanted to 
check there isn't some reason that this particular field is not 
expanded/unalisases?

- Mitra

-- 
Mitra Technology Consulting -  www.mitra.biz - mi...@mi...
home 02-6684-8096  mobile 0414-648-722  office 02-6684-6182
Byron Community Knowledge Management Project www.byronkm.com

Life is a Mystery to be Lived, not a Problem to be Solved

Re: [Apc-aa-coders] Links - how to display

[Mitra <mi...@ea...>]

At 1:47 AM +0200 3/9/03, Honza Malik wrote:
>Hi Mitra,
>
>    as I told you - Links module is still in testing state, so there 
>are not documentation yet (except the Czech manual: 
>http://kormidlo.cz/manual.shtml :-)

Thanks Honza,

Sorry, I thought Links Module had been relesaed, .. so I won't 
complain about lack of documentation, but will ask questions :-)

>>I'd like to be able to use this, and remember seeing a really nice 
>>demo somewhere or other.
>
>    You can see a demo on http://kormidlo.cz/kormidlo.shtml, for 
>example. There is a testing view to real data. We plan to have the 
>site up at the end of September (with new and better design).

This looks great - can I have access to see how it is setup, I 
promise not to change anything, but looking at the Views would remove 
much of the necessity to ask questions.

>>I'm trying to create a Link module - first time. I'm really 
>>confused - and can't find anything in the FAQ to un-confuse me.
>>
>>I have figured out how to add links, and how to get them categorised, but
>>
>>I can't figure out how to display them,  the Link Admin page says ...
>>/apc-aa/modules/links/links.php3?link_id=324c696e6b7342234234823234293489
>>But the file links.php doesn't exist
>
>    You are right - it is confusing. I will write better 
>instructions. We decided not to use another special script for 
>links/category display and we use standard view.php3. So, all you 
>have to do is create two views - one for links and one for 
>categories. Then you can put it on one page - like this:
>
><h2>Categories</h2>
><!--#include virtual="/aa/view.php3?vid=789" -->
><h2>Links</h2>
><!--#include virtual="/aa/view.php3?vid=790" -->
>
>Views now have new parameter - 'cat' and it is applicated to both 
>views - category as well as link view. So, if you access the 
>kormidlo.shtml&cat=4, both views displays content for category # 4 - 
>categories under this one as well as links which belongs to it.

OK - that makes sense now, and almost works fine ... see below.

>
>>  And ... one more question .. the list of Links shows numbers down the
>>  right - for example all of my links
>>
>>  31.8.2003
>>  1
>>  1
>>       0
>>
>>  With the 0 in Green. I think the date is the date of entry, but what
>>  are the other numbers - shouldn't there be a legend of some kind?
>
>Date is the date of last modification.
>Second two 'ones' are user_ids (author's and last modifier's). We 
>use LDAP permission system in Econnect, where it is easy to extract 
>login names from user_ids, so on our instalation we see there 
>readable names like 'alena', ... We plan to write translation 
>function for sql-permision users as well, but in this case it needs 
>additional database access.

OK - that would explain why these user numbers appear in other places 
- like the FAQ!

>The last zero is 'link health'. Each link is checked by AA cron, 
>which means the link is accessed and the HTTP return code is stored 
>to database. There are stored 10 last return codes (like 404 Not 
>Exist, 200 OK). From this values are computed the health of links (0 
>- health, 1000 - dead).
>There is modules/links/linkcheck.php3 script in cron.php3 setting, 
>which checks each hour 100 links (by default).

This sounds like a great idea,  one thing to do better would be to 
check the link as soon as it is entered, so that if its down (e.g. 
mis-typed) then it will show up as dead immediately.

I see on your example that you have thousands of links - checking 100 
per hour on smaller lists (which would be the case for any of my 
work) would  mean that some links get checked every hour, which would 
generate a lot of unnecessary traffic on, for example, the 
destination site. Maybe there needs to be a limit (e.g. in 
config.php3) on how frequently it starts at the beginning of the 
list.  And also it might want to run through 100 links per hour 
selected from all the Links in the database, rather than a specific 
slice, so that on a machine with a lot of short lists, it is not 
overloading with unneccessary checks because it is checking 
100*NoOfLinkSlices per hour?

>The design improvements are highly welcomen. There is a plan to do 
>the design configurable (as it is in Item Manager) - it should be 
>quite easy done - it is in manager.class object.
>
>>  And ..... what does "checking" mean, does it mean checking the link
>>  exists ? I have a deliberately bad link in my list, but it shows up
>  > the same as all the others, and when I do "Select All" "Check Link"
>  > there is no indication of any differences.
>
>Checking means, that you search the database, if there is no such 
>link (in order you do not have there the same link twice).

That is in the input screen, what does it mean in the menu on left hand side?

I've come across a couple of other problems,

1: _#C_PATH makes the assumption that it can just link to something 
strange .. for example in
http://mitra.local/apc-aa/view.php3?vid=8&cat=4
"Top of Tree" links to
http://mitra.local/?cat=2

Which obviously doesn't work ...

I'm not sure there is an easy answer to this ... I'm going to be 
calling these views from within the "Site" module, where its going to 
be even harder to get the URL calling correct.

This next is more of a comment than a bug ....
I really like the Hierarchical Category editor, but ... it would be 
even better if .
1: It also applied to Regions, and those regions were configurable, 
you have "Australia" as one region, while clearly for locally based 
groups, they will want a breakdown to the "town" level - e.g. World, 
Australia, NSW, Northern Rivers, Byron Bay.

2: If Region and Language were optional, again they aren't really 
relevant for local links.

3: If we could use this category editor in other slices. For example, 
imaging the FAQ being searchable via the hierarchical categories. 
(This relates to the conversation we were having with Jason recently).

- Mitra


-- 
Mitra Technology Consulting -  www.mitra.biz - mi...@mi...
home 02-6684-8096  mobile 0414-648-722  office 02-6684-6182
Byron Community Knowledge Management Project www.byronkm.com

Life is a Mystery to be Lived, not a Problem to be Solved

Re: [Apc-aa-coders] Links - how to display

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

Hi Mitra,

    as I told you - Links module is still in testing state, so there are 
not documentation yet (except the Czech manual: 
http://kormidlo.cz/manual.shtml :-)

Mitra wrote:
> Hi Honza , or anyone who has used the Links module.
> 
> I'd like to be able to use this, and remember seeing a really nice demo 
> somewhere or other.

    You can see a demo on http://kormidlo.cz/kormidlo.shtml, for 
example. There is a testing view to real data. We plan to have the site 
up at the end of September (with new and better design).

> I'm trying to create a Link module - first time. I'm really confused - 
> and can't find anything in the FAQ to un-confuse me.
> 
> I have figured out how to add links, and how to get them categorised, but
> 
> I can't figure out how to display them,  the Link Admin page says ...
> /apc-aa/modules/links/links.php3?link_id=324c696e6b7342234234823234293489
> But the file links.php doesn't exist

    You are right - it is confusing. I will write better instructions. 
We decided not to use another special script for links/category display 
and we use standard view.php3. So, all you have to do is create two 
views - one for links and one for categories. Then you can put it on one 
page - like this:

<h2>Categories</h2>
<!--#include virtual="/aa/view.php3?vid=789" -->
<h2>Links</h2>
<!--#include virtual="/aa/view.php3?vid=790" -->

Views now have new parameter - 'cat' and it is applicated to both views 
- category as well as link view. So, if you access the 
kormidlo.shtml&cat=4, both views displays content for category # 4 - 
categories under this one as well as links which belongs to it.

 > And ... one more question .. the list of Links shows numbers down the
 > right - for example all of my links
 >
 > 31.8.2003
 > 1
 > 1
 >      0
 >
 > With the 0 in Green. I think the date is the date of entry, but what
 > are the other numbers - shouldn't there be a legend of some kind?

Date is the date of last modification.
Second two 'ones' are user_ids (author's and last modifier's). We use 
LDAP permission system in Econnect, where it is easy to extract login 
names from user_ids, so on our instalation we see there readable names 
like 'alena', ... We plan to write translation function for 
sql-permision users as well, but in this case it needs additional 
database access.

The last zero is 'link health'. Each link is checked by AA cron, which 
means the link is accessed and the HTTP return code is stored to 
database. There are stored 10 last return codes (like 404 Not Exist, 200 
OK). From this values are computed the health of links (0 - health, 1000 
- dead).
There is modules/links/linkcheck.php3 script in cron.php3 setting, which 
checks each hour 100 links (by default).

The design improvements are highly welcomen. There is a plan to do the 
design configurable (as it is in Item Manager) - it should be quite easy 
done - it is in manager.class object.

 > And ..... what does "checking" mean, does it mean checking the link
 > exists ? I have a deliberately bad link in my list, but it shows up
 > the same as all the others, and when I do "Select All" "Check Link"
 > there is no indication of any differences.

Checking means, that you search the database, if there is no such link 
(in order you do not have there the same link twice).

    That's for now,
                        Honza


> I also tried using views,  created a Link view -  but
> http://mitra.local/apc-aa/view.php3?vid=7
> doesn't work, it says  - "No item found" , which I presume means this is 
> like a "Full text view"  and needs a link id?
> 
> So ... I created a Category view, vid=8, but
> http://mitra.local/apc-aa/view.php3?vid=8
> just displays a list of categories (_#C_NAME__)  but not any of the 
> links IN the categories. How do you get these, they aren't represented 
> by any of the aliases shown in the View editor for this Categoriy view.
> 
> Also ... when I switch to Links Root, from the Views screen on Links 
> Example I get the error message
> Fatal error :  Cannot redeclare get_aamenus() (previously declared in 
> /Users/mitra/Sites/mitra.local/apc-aa/modules/links/menu.php3:58) in 
> /Users/mitra/Sites/mitra.local/apc-aa/include/menu.php3 on line 43
> 
> And ... one more question .. the list of Links shows numbers down the 
> right - for example all of my links
> 
> 31.8.2003
> 1
> 1
>      0   
> 
> With the 0 in Green. I think the date is the date of entry, but what are 
> the other numbers - shouldn't there be a legend of some kind?
> 
> And ..... what does "checking" mean, does it mean checking the link 
> exists ? I have a deliberately bad link in my list, but it shows up the 
> same as all the others, and when I do "Select All" "Check Link" there is 
> no indication of any differences.
> 
> Any help appreciated?
> 
> - Mitra
> 
> 
> -- 
> 
> Mitra Technology Consulting -  www.mitra.biz - mi...@mi...
> home 02-6684-8096  mobile 0414-648-722  office 02-6684-6182
> Byron Community Knowledge Management Project www.byronkm.com
> 
> Life is a Mystery to be Lived, not a Problem to be Solved

[Apc-aa-coders] Links - how to display

[Mitra <mi...@ea...>]

Hi Honza , or anyone who has used the Links module.

I'd like to be able to use this, and remember seeing a really nice 
demo somewhere or other.

I'm trying to create a Link module - first time. I'm really confused 
- and can't find anything in the FAQ to un-confuse me.

I have figured out how to add links, and how to get them categorised, but

I can't figure out how to display them,  the Link Admin page says ...
/apc-aa/modules/links/links.php3?link_id=324c696e6b7342234234823234293489
But the file links.php doesn't exist

I also tried using views,  created a Link view -  but
http://mitra.local/apc-aa/view.php3?vid=7
doesn't work, it says  - "No item found" , which I presume means this 
is like a "Full text view"  and needs a link id?

So ... I created a Category view, vid=8, but
http://mitra.local/apc-aa/view.php3?vid=8
just displays a list of categories (_#C_NAME__)  but not any of the 
links IN the categories. How do you get these, they aren't 
represented by any of the aliases shown in the View editor for this 
Categoriy view.

Also ... when I switch to Links Root, from the Views screen on Links 
Example I get the error message
Fatal error :  Cannot redeclare get_aamenus() (previously declared in 
/Users/mitra/Sites/mitra.local/apc-aa/modules/links/menu.php3:58) in 
/Users/mitra/Sites/mitra.local/apc-aa/include/menu.php3 on line 43

And ... one more question .. the list of Links shows numbers down the 
right - for example all of my links

31.8.2003
1
1
      0

With the 0 in Green. I think the date is the date of entry, but what 
are the other numbers - shouldn't there be a legend of some kind?

And ..... what does "checking" mean, does it mean checking the link 
exists ? I have a deliberately bad link in my list, but it shows up 
the same as all the others, and when I do "Select All" "Check Link" 
there is no indication of any differences.

Any help appreciated?

- Mitra


-- 
Mitra Technology Consulting -  www.mitra.biz - mi...@mi...
home 02-6684-8096  mobile 0414-648-722  office 02-6684-6182
Byron Community Knowledge Management Project www.byronkm.com

Life is a Mystery to be Lived, not a Problem to be Solved

Re: [Apc-aa-coders] include/sessionobj.php3 missing in CVS ?

[Mitra <mi...@ea...>]

=46ixed in CVS

No idea what that file was, I'm guessing there=20
were ways to get to this line without $sess being=20
defined, but seeing its use further up the file=20
I'm presuming that is no longer the case.

- Mitra

At 2:53 PM +0200 22/8/03, Honza Malik wrote:
>Hi Setu,
>
>    you ae right, this file is missing. This bug is in AA quite long, but
>it apperas only in very special cases, so we did'n found it so far.
>
>    The bug comes from Mitra's posting (2003/02/16), when he tried to
>clarify error messages, so I think Mitra has the file.
>
>    The special case, when this message apper is: "You do not have
>permission to edit items in the slice".
>
>    Honza
>
>--------------- Diff - include/init_page.php3   ---------------------
>
>$ cvs diff -r1.37 -r1.38 include/init_page.php3
>Index: include/init_page.php3
>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>RCS file: /cvsroot/apc-aa/apc-aa/include/init_page.php3,v
>retrieving revision 1.37
>retrieving revision 1.38
>diff -r1.37 -r1.38
>23c23
><  * @version $Id: init_page.php3,v 1.37 2003/02/05 14:54:05 jakubadamek=
 Exp $
>---
>>   * @version $Id: init_page.php3,v 1.38 2003/02/16 09:55:20 mitraearth=
 Exp $
>148,150c148,152
>< if( !$no_slice_id AND !IsSuperadmin() AND !$perm_slices [$slice_id] ) {
><=20
>MsgPage($sess->url(self_base())."index.php3",=20
>_m("You do not have permission to edit items in=20
>this slice"), "standalone");
><   exit;
>---
>>  if( !$no_slice_id AND !IsSuperadmin() AND=20
>>!$perm_slices[$slice_id] AND !$after_login ) {
>>      require_once $GLOBALS["AA_INC_PATH"] . "sessionobj.php3";
>>      MsgPage($sess->url(self_base())."index.php3",
>>          _m("You do not have permission to edit=20
>>items in the slice").":=20
>>".slice2name($slice_id),"standalone");
>>      exit;
>
>
>
>On =E2t, 2003-08-21 at 20:41, Setu, Prem wrote:
>>  Hi Friends
>>
>>  I just made an update from CVS. I am getting this message:
>>
>>  Fatal error: Failed opening required
>>  '/home/aa/www/html/apc-aa/include/sessionobj.php3'
>>  (include_path=3D'.:/php/includes:/usr/share/php:/etc/httpd/phplib') in
>>  /home/aa/www/apc-aa/include/init_page.php3 on line 151
>>
>>
>>  any idea ?
>>
>>  Love
>>  Setu
>>  *
>>  *
>>
>>
>>
>>  -------------------------------------------------------
>>  This SF.net email is sponsored by: VM Ware
>>  With VMware you can run multiple operating systems on a single machine.
>>  WITHOUT REBOOTING! Mix Linux / Windows / Novell virtual machines
>>  at the same time. Free trial click here:http://www.vmware.com/wl/offer/3=
58/0
>>  _______________________________________________
>>  Apc-aa-coders mailing list
>>  Apc...@li...
>>  https://lists.sourceforge.net/lists/listinfo/apc-aa-coders
>>
>
>
>
>
>-------------------------------------------------------
>This SF.net email is sponsored by: VM Ware
>With VMware you can run multiple operating systems on a single machine.
>WITHOUT REBOOTING! Mix Linux / Windows / Novell virtual machines
>at the same time. Free trial click here:http://www.vmware.com/wl/offer/358/=
0
>_______________________________________________
>Apc-aa-coders mailing list
>Apc...@li...
>https://lists.sourceforge.net/lists/listinfo/apc-aa-coders


-- 
Mitra Technology Consulting -  www.mitra.biz - mi...@mi...
home 02-6684-8096  mobile 0414-648-722  office 02-6684-6182
Byron Community Knowledge Management Project www.byronkm.com

Life is a Mystery to be Lived, not a Problem to be Solved

Re: [Apc-aa-coders] include/sessionobj.php3 missing in CVS ?

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

Hi Setu,

   you ae right, this file is missing. This bug is in AA quite long, but
it apperas only in very special cases, so we did'n found it so far.

   The bug comes from Mitra's posting (2003/02/16), when he tried to
clarify error messages, so I think Mitra has the file.

   The special case, when this message apper is: "You do not have
permission to edit items in the slice".

   Honza

--------------- Diff - include/init_page.php3   ---------------------

$ cvs diff -r1.37 -r1.38 include/init_page.php3
Index: include/init_page.php3
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
RCS file: /cvsroot/apc-aa/apc-aa/include/init_page.php3,v
retrieving revision 1.37
retrieving revision 1.38
diff -r1.37 -r1.38
23c23
<  * @version $Id: init_page.php3,v 1.37 2003/02/05 14:54:05 jakubadamek Ex=
p $
---
>  * @version $Id: init_page.php3,v 1.38 2003/02/16 09:55:20 mitraearth Exp=
 $
148,150c148,152
< if( !$no_slice_id AND !IsSuperadmin() AND !$perm_slices [$slice_id] ) {
<   MsgPage($sess->url(self_base())."index.php3", _m("You do not have permi=
ssion to edit items in this slice"), "standalone");
<   exit;
---
> if( !$no_slice_id AND !IsSuperadmin() AND !$perm_slices[$slice_id] AND !$=
after_login ) {
>     require_once $GLOBALS["AA_INC_PATH"] . "sessionobj.php3";
>     MsgPage($sess->url(self_base())."index.php3",
>         _m("You do not have permission to edit items in the slice").": ".=
slice2name($slice_id),"standalone");
>     exit;



On =C8t, 2003-08-21 at 20:41, Setu, Prem wrote:
> Hi Friends
>=20
> I just made an update from CVS. I am getting this message:
>=20
> Fatal error: Failed opening required
> '/home/aa/www/html/apc-aa/include/sessionobj.php3'
> (include_path=3D'.:/php/includes:/usr/share/php:/etc/httpd/phplib') in
> /home/aa/www/apc-aa/include/init_page.php3 on line 151
>=20
>=20
> any idea ?
>=20
> Love
> Setu
> *
> *
>=20
>=20
>=20
> -------------------------------------------------------
> This SF.net email is sponsored by: VM Ware
> With VMware you can run multiple operating systems on a single machine.
> WITHOUT REBOOTING! Mix Linux / Windows / Novell virtual machines
> at the same time. Free trial click here:http://www.vmware.com/wl/offer/35=
8/0
> _______________________________________________
> Apc-aa-coders mailing list
> Apc...@li...
> https://lists.sourceforge.net/lists/listinfo/apc-aa-coders
>=20

[Apc-aa-coders] include/sessionobj.php3 missing in CVS ?

[Setu, P. <se...@oh...>]

Hi Friends

I just made an update from CVS. I am getting this message:

Fatal error: Failed opening required
'/home/aa/www/html/apc-aa/include/sessionobj.php3'
(include_path='.:/php/includes:/usr/share/php:/etc/httpd/phplib') in
/home/aa/www/apc-aa/include/init_page.php3 on line 151


any idea ?

Love
Setu
*
*

Re: [Apc-aa-coders] eb_functions syntax, sliceobj.php

[Mitra <mi...@ea...>]

I really don't like putting "function or fnct or f inside the {}, 
that's the whole point of the {} to say that its something to be 
expanded.

I agree with you on the problem with multiple evaluation, I'm hoping 
that if it gets simplified in the way I suggested then it will make 
it easier to rewrite any parser without breaking all the existing 
sites.

- Mitra


At 1:44 AM +0200 11/8/03, Honza Malik wrote:
>Hi Mitra,
>
>I think this solution is good and seems to be safe enough.
>
>If I have to say truth, I still will be more happy with some prefix
>before function name (like {function: {fnct: or just {f:), which will be
>surely fastest for parsing, but you are right - is_callable shoud be
>fast enough, since it is hopefully only hash table lookup.
>
>I'm also trying to think about the future of stringexpang.php3. I'm
>quite sure we have to rewrite it in near future and use real parser
>techniques. The current code of stringexpand is good, but it has some
>limits, which is hard to overcome. For example all switch parts are
>evaluated in example below, but we need just one:
>    {switch(0)0:nothing_included:1:{include(table.html)}}
>It would be probably easier to parse prefixed functions, but maybe just
>a bit.
>
>    Honza
>
>
>
>   
>
>14. 07. 2003 v 00:00, Mitra:
>>  Hi Honza
>>
>>  I didn't hear back on this one ....
>>
>>  I was thinking about this a bit, and figured that using an array
>>  "eb_functions" might not be the best idea, although I still think the
>>  syntax {functionname:arg1:arg2:arg3:arg4} is the way to go.
>>
>>  Instead ... I was wondering if we should use something like the
>>  insert_fnc_name  method.
>>
>>  We would define  a set of functions like
>>  expand_alias
>>  expand_switch
>>  expand_user
>>  expand_math
>>
>>  and the site designer in their modules/site/sites/site_xxx.php3 could
>>  also define any functions they want.
>>
>>  Then the string expansion becomes simple
>>  1: Parse the syntax  into functionname,arg1, arg2 etc
>>  2:check "is_callable(functionname)"
>>  3: If so call it
>>  4: If not, then look for a field or file or the other examples by nam.
>>  5: If still not, then parse the legacy syntaxes like 
>>  switch(arg1)arg2:arg3:arg4:arg5
>>
>>  The advantage would be that the most common cases would be at the
>>  beginning of the parse, and caught by the is_callable.
>>
>>  What do you think?  I'm assuming that "is_callable" is fairly quick.
>>
>>  - Mitra
>>
>>
>>
>>  At 7:52 AM +1000 3/7/03, Mitra wrote:
>>  > At 2:19 PM +0200 2/7/03, Honza Malik wrote:
>>  > > Hi Mitra (and Norbert),
>>  > >
>>  > > 1) *eb_functions*
>>  > >
>>  > > I checked the eb_function syntax:
>>  > >
>>  > > {<fnctn>:xxx:yyyy}, where <fnctn> is php function permitted in
>>  > > $eb_function[] array.
>>  > >
>>  > > I want to ask you, if it will not be so big problem, if I change
>>  > > the
>>  > > syntax to:
>>  > >
>>  > > {function:<fnctn>:xxx:yyyy} or something similar. The reason is,
>>  > > that
>>  > > current syntax needs regular expressions for parsing (which is
>>  > > slower)
>>  > > and it could also be a problem, when we will be rewriting alias
>>  > > parser
>>  > > (stringexpand) in the future.
>>  > >
>>  > > eb_functions are new - not documented yet, so I hope it should not
>>  > > be
>>  > > problem for other AA users.
>>  > Are regular expressions really that much slower? But if regular
>>  > expressions are slower then I don't see that this syntax takes any
>>  > more complex parsing than {function:aaaa:xxxx:yyyy}, they both need
>>  > a string broken up at the colons ?  So I think speed of parsing is
>>  > independent of the syntax chosen.
>>  > We use this same format in lots of places - e.g. {scroller:xxxxx}  I
>>  > would guess that if we could get the syntax consistent - e.g.
>>  > {xxx:yyy:zzz} then a single expression at the top would make it much
>>  > simpler.
>>  > I'm not sure that it is a good idea to change the syntax  from
>>  > {aaa:bbb:ccc}  to {function:aaa:bbbb:cccc}  , part of my idea of
>>  > doing this is to make it easier for the code to be readable and
>  > > obvious, instead of having to remember the syntax of all the
>>  > possible things.  So for example I have a function {morefull} 
>>  > which is defined in site_xxx.php3 to be a quite complex switch
>>  > statement  based on whether there is more full text or not.   Being
>>  > able to put {morefull} inside a view, is quite a bit more elegant
>>  > than {function:morefull} ,  also it allows easy expansion without
>>  > extending expand_bracketed   e.g.  {substr:{headline........}:1:40}
>>  > which is quite a bit more elegant than
>>  > {function:substr:{headline........}:1:40}
>>  > stringexpand is quite intelligent, it will check for "morefull"  in
>>  > eb_functions, and in aliases etc etc, it might even give us quicker
>>  > code if we turned for example include and scroller and alias into
>>  > eb_functions so that they didn't have to be parsed individually?
>>  > Also we have the legacy issue ... if we change it we'll have to
>>  > support the old syntax as well - like we still have to support the
>>  > {include(file)}  syntax for include.   Maybe I'm the only one to use
>>  > eb_functions,  but there are examples of this scattered all through
>>  > my sites,  so at least I would need a commented in version of the
>>  > old syntax.
>>  >
>>  > > 2) *slice class*
>>  > >
>>  > > I'm going to use slice objects defined in sliceobj.php3. It is
>>  > > great we
>>  > > have such object - very useful. I also love the lazy evaluation
>>  > > approach
>>  > > which saves time OR memory.
>>  > >
>>  > > In sliceobj you use lazy evaluation, which (by default) saves
>>  > > memory,
>>  > > but is database intensive (one query for each field in slice
>>  > > table).
>>  > > Do you use slice object with huge amount of slices, where such
>>  > > memory
>>  > > savings is crucial and if, is it somewhere outside of 'slices'
>>  > > class?
>>  > > If not, I plan to rewrite the class to load all slice records in
>>  > > one DB
>>  > > query by default.
>>  > I think that is a good idea.  I think this lazy evaluation actually
>>  > makes it slower in this case. What I suggest is to still make it
>>  > lazy, but load all the slice records in a DB query when the FIRST
>>  > field is accessed. That way a sliceobj can be used in some place
>>  > where the fields are never accessed without any penalty on
>>  > performance.
>>  > - Mitra
>>  > --
>>  > Mitra Technology Consulting -  www.mitra.biz - mi...@mi...
>>  > home office 02-6684-8096  mobile 0414-648-722  work 02-6684-6182
>>  >
>>  > Life is a Mystery to be Lived, not a Problem to be Solved
>>
>>
>>
>>  --
>>  Mitra Technology Consulting -  www.mitra.biz - mi...@mi...
>>  home office 02-6684-8096  mobile 0414-648-722  work 02-6684-6182
>>
>>  Life is a Mystery to be Lived, not a Problem to be Solved
>>
>
>
>
>-------------------------------------------------------
>This SF.Net email sponsored by: Free pre-built ASP.NET sites including
>Data Reports, E-commerce, Portals, and Forums are available now.
>Download today and enter to win an XBOX or Visual Studio .NET.
>http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
>_______________________________________________
>Apc-aa-coders mailing list
>Apc...@li...
>https://lists.sourceforge.net/lists/listinfo/apc-aa-coders


-- 
Mitra Technology Consulting -  www.mitra.biz - mi...@mi...
home 02-6684-8096  mobile 0414-648-722  office 02-6684-6182
Byron Community Knowledge Management Project www.byronkm.com

Life is a Mystery to be Lived, not a Problem to be Solved

Re: [Apc-aa-coders] eb_functions syntax, sliceobj.php

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

Hi Mitra,

I think this solution is good and seems to be safe enough.

If I have to say truth, I still will be more happy with some prefix
before function name (like {function: {fnct: or just {f:), which will be
surely fastest for parsing, but you are right - is_callable shoud be
fast enough, since it is hopefully only hash table lookup. 

I'm also trying to think about the future of stringexpang.php3. I'm
quite sure we have to rewrite it in near future and use real parser
techniques. The current code of stringexpand is good, but it has some
limits, which is hard to overcome. For example all switch parts are
evaluated in example below, but we need just one:
   {switch(0)0:nothing_included:1:{include(table.html)}}
It would be probably easier to parse prefixed functions, but maybe just
a bit.

   Honza



   

14. 07. 2003 v 00:00, Mitra:
> Hi Honza
> 
> I didn't hear back on this one ....
> 
> I was thinking about this a bit, and figured that using an array
> "eb_functions" might not be the best idea, although I still think the
> syntax {functionname:arg1:arg2:arg3:arg4} is the way to go.
> 
> Instead ... I was wondering if we should use something like the
> insert_fnc_name  method.
> 
> We would define  a set of functions like
> expand_alias
> expand_switch
> expand_user
> expand_math
> 
> and the site designer in their modules/site/sites/site_xxx.php3 could
> also define any functions they want.
> 
> Then the string expansion becomes simple
> 1: Parse the syntax  into functionname,arg1, arg2 etc
> 2:check "is_callable(functionname)"
> 3: If so call it
> 4: If not, then look for a field or file or the other examples by nam.
> 5: If still not, then parse the legacy syntaxes like  
> switch(arg1)arg2:arg3:arg4:arg5
> 
> The advantage would be that the most common cases would be at the
> beginning of the parse, and caught by the is_callable.
> 
> What do you think?  I'm assuming that "is_callable" is fairly quick.
> 
> - Mitra
> 
> 
> 
> At 7:52 AM +1000 3/7/03, Mitra wrote:
> > At 2:19 PM +0200 2/7/03, Honza Malik wrote: 
> > > Hi Mitra (and Norbert),
> > > 
> > > 1) *eb_functions*
> > > 
> > > I checked the eb_function syntax:
> > > 
> > > {<fnctn>:xxx:yyyy}, where <fnctn> is php function permitted in
> > > $eb_function[] array.
> > > 
> > > I want to ask you, if it will not be so big problem, if I change
> > > the
> > > syntax to:
> > > 
> > > {function:<fnctn>:xxx:yyyy} or something similar. The reason is,
> > > that
> > > current syntax needs regular expressions for parsing (which is
> > > slower)
> > > and it could also be a problem, when we will be rewriting alias
> > > parser
> > > (stringexpand) in the future.
> > > 
> > > eb_functions are new - not documented yet, so I hope it should not
> > > be
> > > problem for other AA users.
> > Are regular expressions really that much slower? But if regular
> > expressions are slower then I don't see that this syntax takes any
> > more complex parsing than {function:aaaa:xxxx:yyyy}, they both need
> > a string broken up at the colons ?  So I think speed of parsing is
> > independent of the syntax chosen. 
> > We use this same format in lots of places - e.g. {scroller:xxxxx}  I
> > would guess that if we could get the syntax consistent - e.g.
> > {xxx:yyy:zzz} then a single expression at the top would make it much
> > simpler.
> > I'm not sure that it is a good idea to change the syntax  from
> > {aaa:bbb:ccc}  to {function:aaa:bbbb:cccc}  , part of my idea of
> > doing this is to make it easier for the code to be readable and
> > obvious, instead of having to remember the syntax of all the
> > possible things.  So for example I have a function {morefull}  
> > which is defined in site_xxx.php3 to be a quite complex switch
> > statement  based on whether there is more full text or not.   Being
> > able to put {morefull} inside a view, is quite a bit more elegant
> > than {function:morefull} ,  also it allows easy expansion without
> > extending expand_bracketed   e.g.  {substr:{headline........}:1:40}
> > which is quite a bit more elegant than
> > {function:substr:{headline........}:1:40}
> > stringexpand is quite intelligent, it will check for "morefull"  in
> > eb_functions, and in aliases etc etc, it might even give us quicker
> > code if we turned for example include and scroller and alias into
> > eb_functions so that they didn't have to be parsed individually?
> > Also we have the legacy issue ... if we change it we'll have to
> > support the old syntax as well - like we still have to support the
> > {include(file)}  syntax for include.   Maybe I'm the only one to use
> > eb_functions,  but there are examples of this scattered all through
> > my sites,  so at least I would need a commented in version of the
> > old syntax.
> > 
> > > 2) *slice class*
> > > 
> > > I'm going to use slice objects defined in sliceobj.php3. It is
> > > great we
> > > have such object - very useful. I also love the lazy evaluation
> > > approach
> > > which saves time OR memory.
> > > 
> > > In sliceobj you use lazy evaluation, which (by default) saves
> > > memory,
> > > but is database intensive (one query for each field in slice
> > > table).
> > > Do you use slice object with huge amount of slices, where such
> > > memory
> > > savings is crucial and if, is it somewhere outside of 'slices'
> > > class?
> > > If not, I plan to rewrite the class to load all slice records in
> > > one DB
> > > query by default.
> > I think that is a good idea.  I think this lazy evaluation actually
> > makes it slower in this case. What I suggest is to still make it
> > lazy, but load all the slice records in a DB query when the FIRST
> > field is accessed. That way a sliceobj can be used in some place
> > where the fields are never accessed without any penalty on
> > performance.
> > - Mitra
> > --
> > Mitra Technology Consulting -  www.mitra.biz - mi...@mi...
> > home office 02-6684-8096  mobile 0414-648-722  work 02-6684-6182
> > 
> > Life is a Mystery to be Lived, not a Problem to be Solved
> 
> 
> 
> -- 
> Mitra Technology Consulting -  www.mitra.biz - mi...@mi...
> home office 02-6684-8096  mobile 0414-648-722  work 02-6684-6182
> 
> Life is a Mystery to be Lived, not a Problem to be Solved
>