Group watch slow if hundreds of users: batch/cron instead?

------------------------------------------------------------------------------
The Palm PDK Hot Apps Program offers developers who use the
Plug-In Development Kit to bring their C/C++ apps to Palm for a share
of $1 Million in cash or HP Products. Visit us here for more details:
http://p.sf.net/sfu/dev2dev-palm

_______________________________________________
Tikiwiki-devel mailing list
Tikiwiki-devel@...
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel

Re: Problem to add anchor in a link using Smarty function {button}

------------------------------------------------------------------------------
The Palm PDK Hot Apps Program offers developers who use the
Plug-In Development Kit to bring their C/C++ apps to Palm for a share
of $1 Million in cash or HP Products. Visit us here for more details:
http://p.sf.net/sfu/dev2dev-palm

_______________________________________________
Tikiwiki-devel mailing list
Tikiwiki-devel@...
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel

Feature request: cache lastchanges.

The query generated by tiki-lastchanges.php is *disgusting*; shown
below.

It would be really nice if this was, at the very least, cached until
the next time something actually changes.

My site is getting hammered because GoogleBot won't stop crawling
it; I've opened a complaint with them
http://www.google.com/support/forum/p/Webmasters/thread?tid=1e2572e6f54e74e0&hl=en&fid=1e2572e6f54e74e000048cc7e56f218b

I'm not going to have time to do it myself, but thought I'd throw it
out there in case someone else does.

-Robin

EXPLAIN select distinct ta.`action`, ta.`lastModif`, ta.`user`, ta.`ip`, ta.`object`,
thf.`comment`, thf.`version`, thf.`versionlast` from `tiki_actionlog` ta inner join (select NULL as
version, `comment`, `pageName`, `lastModif`, '1' as versionlast from tiki_pages union select
`version`, `comment`, `pageName`, `lastModif`, '0' as versionlast from `tiki_history`) as thf on
ta.`object`=thf.`pageName` and ta.`lastModif`=thf.`lastModif` and ta.`objectType`='wiki page'
where true order by ta.`user` asc LIMIT 50 OFFSET 1754:

*** row 1 ***
          table:  <derived2>
           type:  ALL
  possible_keys:  NULL
            key:  NULL
        key_len:  NULL
            ref:  NULL
           rows:  8799
          Extra:  Using temporary; Using filesort
*** row 2 ***
          table:  ta
           type:  ref
  possible_keys:  lastModif,object
            key:  lastModif
        key_len:  5
            ref:  thf.lastModif
           rows:  2
          Extra:  Using where
*** row 3 ***
          table:  tiki_pages
           type:  ALL
  possible_keys:  NULL
            key:  NULL
        key_len:  NULL
            ref:  NULL
           rows:  2220
          Extra:  NULL
*** row 4 ***
          table:  tiki_history
           type:  ALL
  possible_keys:  NULL
            key:  NULL
        key_len:  NULL
            ref:  NULL
           rows:  6579
          Extra:  NULL
*** row 5 ***
          table:  <union2,3>
           type:  ALL
  possible_keys:  NULL
            key:  NULL
        key_len:  NULL
            ref:  NULL
           rows:  NULL
          Extra:  NULL

--

-- 
http://singinst.org/ :  Our last, best hope for a fantastic future.
Lojban (http://www.lojban.org/): The language in which "this parrot
is dead" is "ti poi spitaki cu morsi", but "this sentence is false"
is "na nei".   My personal page: http://www.digitalkingdom.org/rlp/

------------------------------------------------------------------------------
The Palm PDK Hot Apps Program offers developers who use the
Plug-In Development Kit to bring their C/C++ apps to Palm for a share
of $1 Million in cash or HP Products. Visit us here for more details:
http://p.sf.net/sfu/dev2dev-palm

Re: Updated screenshots & badges

Al 31/07/10 20:49, En/na Marc Laporte ha escrit:
(...)
> I know anyone can make screenshots.
Yes, and it's good (=more sustainable), imho.
>   But I think we want to avoid this.
>    
Not sure about this point. To me, I prefer seing some screenshot with a 
different theme style than no screenshot. Of course that I would prefer 
seing all screenshots with the same design, logos, theme style, etc.... 
But it won't be feasible, at least for a while... (doc.tw.o is huge).

So I would say +1 for any recommendation on a common style and general 
guidelines to make screenshots.

Like making them with the default theme style for that release?
(thenews for tiki3, strasa for tiki4, fivealive with some specific color 
for Tiki5?). What for Tiki6, then? (I've been doing some screenshots 
already for tiki6...). If the theme style has white bg, then there is 
not a huge difference in the screenshots even in the different default 
theme styles, which is good, to reuse screenshots where possible).

And red border to shapes with transparent bg to highlight/indicate 
specific parts from the screenshot?
(if plugin annotation worked with png, we could also work with/dogfood that)

My other basic recommendation would be to add screenshots of no much 
more than 600 px wide, so that whenever they are sent to pdf and paper, 
they fit in an A4 (or letter) without resizing them one by one.

Any more basic recommendations?

My 2 cents...

Xavi

------------------------------------------------------------------------------
The Palm PDK Hot Apps Program offers developers who use the
Plug-In Development Kit to bring their C/C++ apps to Palm for a share
of $1 Million in cash or HP Products. Visit us here for more details:
http://p.sf.net/sfu/dev2dev-palm

Re: Updated screenshots & badges

I've been trying to standardize the screenshots that I've been using on 
info.tw.o (see http://info.tikiwiki.org/Tiki+Feature+Checklist?bl=y) as well 
as our Wikipedia page, Sourceforge page, etc.

In my opinion:
- All screen shots should use the default theme (Fivealive in 5.x)
- All screen shots should reflect the default install -- no customizations
- Should have 1 screen shot per feature
- Should have screen shot for the installer

-R

---
Greetings from Sanford, NC, USA!
----- Original Message ----- 
From: "Xavier de Pedro" <xavier.depedro@...>
To: "Tikiwiki developers" <tikiwiki-devel@...>
Cc: <chealer@...>; "Simon Lussier"
<simonlussier@...>; 
"slj" <slj@...>; "Marc Laporte"
<marc@...>; "Rick 
Sapir" <ricks99@...>
Sent: Monday, August 02, 2010 4:44 AM
Subject: Re: [Tikiwiki-devel] Updated screenshots & badges

>
>
> Al 31/07/10 20:49, En/na Marc Laporte ha escrit:
> (...)
>> I know anyone can make screenshots.
> Yes, and it's good (=more sustainable), imho.
>>   But I think we want to avoid this.
>>
> Not sure about this point. To me, I prefer seing some screenshot with a
> different theme style than no screenshot. Of course that I would prefer
> seing all screenshots with the same design, logos, theme style, etc....
> But it won't be feasible, at least for a while... (doc.tw.o is huge).
>
> So I would say +1 for any recommendation on a common style and general
> guidelines to make screenshots.
>
> Like making them with the default theme style for that release?
> (thenews for tiki3, strasa for tiki4, fivealive with some specific color
> for Tiki5?). What for Tiki6, then? (I've been doing some screenshots
> already for tiki6...). If the theme style has white bg, then there is
> not a huge difference in the screenshots even in the different default
> theme styles, which is good, to reuse screenshots where possible).
>
> And red border to shapes with transparent bg to highlight/indicate
> specific parts from the screenshot?
> (if plugin annotation worked with png, we could also work with/dogfood 
> that)
>
> My other basic recommendation would be to add screenshots of no much
> more than 600 px wide, so that whenever they are sent to pdf and paper,
> they fit in an A4 (or letter) without resizing them one by one.
>
> Any more basic recommendations?
>
> My 2 cents...
>
> Xavi
>
>
> ------------------------------------------------------------------------------
> The Palm PDK Hot Apps Program offers developers who use the
> Plug-In Development Kit to bring their C/C++ apps to Palm for a share
> of $1 Million in cash or HP Products. Visit us here for more details:
> http://p.sf.net/sfu/dev2dev-palm
> _______________________________________________
> Tikiwiki-devel mailing list
> Tikiwiki-devel@...
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
> 

------------------------------------------------------------------------------
The Palm PDK Hot Apps Program offers developers who use the
Plug-In Development Kit to bring their C/C++ apps to Palm for a share
of $1 Million in cash or HP Products. Visit us here for more details:
http://p.sf.net/sfu/dev2dev-palm

Releasing 5.1 today (Monday 2nd August)

Dear all - sorry for the lack of notice (heavy weekend ;)

We need to get 5.1 out __now__ and so i am proposing we do it later today. I suggest in about 4 hours time - 15:00
UTC which seems to be good for most of us (currently on IRC)

	http://tinyurl.com/33qr546

Therefore, as of now:

***** NO MORE COMMITS TO 5.x except for genuine "can't live without" [FIX]es please! *****

Once we have released 5.1, the new branch "proposals/5.x" will be created and the Quality Team will
miraculously spring back into life (like something from a cheap horror film) and proposals for new stuff
to go in 5.2 will be back-ported there after testing in trunk as we did with 3.x and 4.x.

Oh, and Rick asks me to say; please read, review and improve the news release here:

	http://tikiwiki.org/Communications+Team&pagenum=2#August_2010

and the release notes here:

	http://tikiwiki.org/ReleaseNotes5.1

Meanwhile, i'm going to chase down the last few little bug i have seen, please join us on IRC to help test and do
the release stuff, or just to contribute moral support (see http://tikiwiki.org/IRC for info)

Thanks - onwards and upward!

jonny

------------------------------------------------------------------------------
The Palm PDK Hot Apps Program offers developers who use the
Plug-In Development Kit to bring their C/C++ apps to Palm for a share
of $1 Million in cash or HP Products. Visit us here for more details:
http://p.sf.net/sfu/dev2dev-palm

installer 6.0 error

------------------------------------------------------------------------------
The Palm PDK Hot Apps Program offers developers who use the
Plug-In Development Kit to bring their C/C++ apps to Palm for a share
of $1 Million in cash or HP Products. Visit us here for more details:
http://p.sf.net/sfu/dev2dev-palm

_______________________________________________
Tikiwiki-devel mailing list
Tikiwiki-devel@...
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel

Re: Updated screenshots & badges

These are great suggestions, can this conversation be on the wiki?
http://branding.tikiwiki.org/Screenshots

Thanks!

On Mon, Aug 2, 2010 at 6:42 AM, Rick Sapir <rick.sapir@...> wrote:
> I've been trying to standardize the screenshots that I've been using on
> info.tw.o (see http://info.tikiwiki.org/Tiki+Feature+Checklist?bl=y) as well
> as our Wikipedia page, Sourceforge page, etc.
>
> In my opinion:
> - All screen shots should use the default theme (Fivealive in 5.x)
> - All screen shots should reflect the default install -- no customizations
> - Should have 1 screen shot per feature
> - Should have screen shot for the installer
>
> -R
>
> ---
> Greetings from Sanford, NC, USA!
> ----- Original Message ----- From: "Xavier de Pedro" <xavier.depedro <at> ub.edu>
> To: "Tikiwiki developers" <tikiwiki-devel@...>
> Cc: <chealer@...>; "Simon Lussier" <simonlussier@...>;
> "slj" <slj@...>; "Marc Laporte"
<marc@...>; "Rick
> Sapir" <ricks99@...>
> Sent: Monday, August 02, 2010 4:44 AM
> Subject: Re: [Tikiwiki-devel] Updated screenshots & badges
>
>
>>
>>
>> Al 31/07/10 20:49, En/na Marc Laporte ha escrit:
>> (...)
>>>
>>> I know anyone can make screenshots.
>>
>> Yes, and it's good (=more sustainable), imho.
>>>
>>>  But I think we want to avoid this.
>>>
>> Not sure about this point. To me, I prefer seing some screenshot with a
>> different theme style than no screenshot. Of course that I would prefer
>> seing all screenshots with the same design, logos, theme style, etc....
>> But it won't be feasible, at least for a while... (doc.tw.o is huge).
>>
>> So I would say +1 for any recommendation on a common style and general
>> guidelines to make screenshots.
>>
>> Like making them with the default theme style for that release?
>> (thenews for tiki3, strasa for tiki4, fivealive with some specific color
>> for Tiki5?). What for Tiki6, then? (I've been doing some screenshots
>> already for tiki6...). If the theme style has white bg, then there is
>> not a huge difference in the screenshots even in the different default
>> theme styles, which is good, to reuse screenshots where possible).
>>
>> And red border to shapes with transparent bg to highlight/indicate
>> specific parts from the screenshot?
>> (if plugin annotation worked with png, we could also work with/dogfood
>> that)
>>
>> My other basic recommendation would be to add screenshots of no much
>> more than 600 px wide, so that whenever they are sent to pdf and paper,
>> they fit in an A4 (or letter) without resizing them one by one.
>>
>> Any more basic recommendations?
>>
>> My 2 cents...
>>
>> Xavi
>>
>>
>>
>> ------------------------------------------------------------------------------
>> The Palm PDK Hot Apps Program offers developers who use the
>> Plug-In Development Kit to bring their C/C++ apps to Palm for a share
>> of $1 Million in cash or HP Products. Visit us here for more details:
>> http://p.sf.net/sfu/dev2dev-palm
>> _______________________________________________
>> Tikiwiki-devel mailing list
>> Tikiwiki-devel@...
>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>>
>
>

--

-- 
Marc Laporte

http://MarcLaporte.com
http://TikiWiki.org/MarcLaporte
http://AvanTech.net
http://OurWiki.net

------------------------------------------------------------------------------
The Palm PDK Hot Apps Program offers developers who use the
Plug-In Development Kit to bring their C/C++ apps to Palm for a share
of $1 Million in cash or HP Products. Visit us here for more details:
http://p.sf.net/sfu/dev2dev-palm

Re: Updated screenshots & badges

Good point. moved there
Xavi

Al 02/08/10 14:41, En/na Marc Laporte ha escrit:
> These are great suggestions, can this conversation be on the wiki?
> http://branding.tikiwiki.org/Screenshots
>
> Thanks!
>
> On Mon, Aug 2, 2010 at 6:42 AM, Rick Sapir<rick.sapir@...>  wrote:
>    
>> I've been trying to standardize the screenshots that I've been using on
>> info.tw.o (see http://info.tikiwiki.org/Tiki+Feature+Checklist?bl=y) as well
>> as our Wikipedia page, Sourceforge page, etc.
>>
>> In my opinion:
>> - All screen shots should use the default theme (Fivealive in 5.x)
>> - All screen shots should reflect the default install -- no customizations
>> - Should have 1 screen shot per feature
>> - Should have screen shot for the installer
>>
>> -R
>>
>> ---
>> Greetings from Sanford, NC, USA!
>> ----- Original Message ----- From: "Xavier de Pedro"<xavier.depedro@...>
>> To: "Tikiwiki developers"<tikiwiki-devel@...>
>> Cc:<chealer@...>; "Simon Lussier"<simonlussier@...>;
>> "slj"<slj@...>; "Marc
Laporte"<marc@...>; "Rick
>> Sapir"<ricks99@...>
>> Sent: Monday, August 02, 2010 4:44 AM
>> Subject: Re: [Tikiwiki-devel] Updated screenshots&  badges
>>
>>
>>      
>>>
>>> Al 31/07/10 20:49, En/na Marc Laporte ha escrit:
>>> (...)
>>>        
>>>> I know anyone can make screenshots.
>>>>          
>>> Yes, and it's good (=more sustainable), imho.
>>>        
>>>>   But I think we want to avoid this.
>>>>
>>>>          
>>> Not sure about this point. To me, I prefer seing some screenshot with a
>>> different theme style than no screenshot. Of course that I would prefer
>>> seing all screenshots with the same design, logos, theme style, etc....
>>> But it won't be feasible, at least for a while... (doc.tw.o is huge).
>>>
>>> So I would say +1 for any recommendation on a common style and general
>>> guidelines to make screenshots.
>>>
>>> Like making them with the default theme style for that release?
>>> (thenews for tiki3, strasa for tiki4, fivealive with some specific color
>>> for Tiki5?). What for Tiki6, then? (I've been doing some screenshots
>>> already for tiki6...). If the theme style has white bg, then there is
>>> not a huge difference in the screenshots even in the different default
>>> theme styles, which is good, to reuse screenshots where possible).
>>>
>>> And red border to shapes with transparent bg to highlight/indicate
>>> specific parts from the screenshot?
>>> (if plugin annotation worked with png, we could also work with/dogfood
>>> that)
>>>
>>> My other basic recommendation would be to add screenshots of no much
>>> more than 600 px wide, so that whenever they are sent to pdf and paper,
>>> they fit in an A4 (or letter) without resizing them one by one.
>>>
>>> Any more basic recommendations?
>>>
>>> My 2 cents...
>>>
>>> Xavi
>>>
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> The Palm PDK Hot Apps Program offers developers who use the
>>> Plug-In Development Kit to bring their C/C++ apps to Palm for a share
>>> of $1 Million in cash or HP Products. Visit us here for more details:
>>> http://p.sf.net/sfu/dev2dev-palm
>>> _______________________________________________
>>> Tikiwiki-devel mailing list
>>> Tikiwiki-devel@...
>>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>>>
>>>        
>>
>>      
>
>
>    

------------------------------------------------------------------------------
The Palm PDK Hot Apps Program offers developers who use the
Plug-In Development Kit to bring their C/C++ apps to Palm for a share
of $1 Million in cash or HP Products. Visit us here for more details:
http://p.sf.net/sfu/dev2dev-palm

Re: installer 6.0 error

I saw also complain about this - 
The installer is tricky -  because I committed
installer/schema/20100721_todo_notif_tiki.sql
installer/schema/20100721_todo_tiki.sql
notif should be executed after the other one
the same day - and the installer does not sort on file dates as I
thought -  but on the names and I am unlucky
- I have no idea how to fix that???
If I rename the file to 20100722_todo_notif_tiki.sql - People that have
already run the script will have an error .....
Has somebody a better idea?
Thanks

On Mon, 2010-08-02 at 13:33 +0100, geoff <at> enmore wrote:
> just ran the installer for a test site synch'd to trunk and have this
> error
>  
> 20100721_todonotif_tiki
>  
> ALTER TABLE `tiki_todo_notif` ADD COLUMN `objectType` VARCHAR(50)
> AFTER `todoId`;
> Duplicate column name 'objectType'
> 
>  
> Anyone else seeing this - I clicked to continue and it all seems OK -
> but I don't recognise this table?
>  
> cheers
>  
> geoff
> ------------------------------------------------------------------------------
> The Palm PDK Hot Apps Program offers developers who use the
> Plug-In Development Kit to bring their C/C++ apps to Palm for a share
> of $1 Million in cash or HP Products. Visit us here for more details:
> http://p.sf.net/sfu/dev2dev-palm
> _______________________________________________ Tikiwiki-devel mailing list
Tikiwiki-devel@... https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel

------------------------------------------------------------------------------
The Palm PDK Hot Apps Program offers developers who use the
Plug-In Development Kit to bring their C/C++ apps to Palm for a share
of $1 Million in cash or HP Products. Visit us here for more details:
http://p.sf.net/sfu/dev2dev-palm