History: Tiki9

Tiki9 was planned for --April-- --May-- June 2012, as per ((Roadmap)) and ((Version lifecycle)) and it was released as Tiki 9.0 on June 26th. It is planned to become a ((Long Term Support)) version.

For documentation about the new features, please see: ((doc:Tiki9))

!! Release Planning Meeting
''To discuss the release process, the co-ordinators' duties and schedule''
;__When:__ Friday 23rd March 2012 at 15:00 UTC
;__Where:__ On BBB at http://tiki.org/live
__Attending:__
* Robert Plummer
* Jean-Marc Libs
* Jonny Bradley
* You?
__Agenda:__
* Schedule & docs
* Slush/Freeze enforcement
* Merge scripts and conflict handling
* Packaging when necessary (but don't try and do everything!)
* Organising meetings like this? (:wink:)

!!- Roles
For a list what is expected, please see ((tw:Release Roles)) and put your name below. Ideally at least 2 people per role.
* Release coordinator: 
** Robert Plummer
* Release assistants
** Jean-Marc Libs (Jyhem)
** Jonny
* Developer(s):
** Robert Plummer
** Jean-Marc Libs (Jyhem)
** Jonny
** ''Add your name here''
* Packaging:
** 
* Security:
** the security team
** ''Add your name here''
* Wishlist:
** 
* Testing: 
** Geoff
** Xavi
** marclaporte
* Documentation:
** Xavi
**
* Communications:
** 
* Community:
** 
* Profiles:
** 
* UI & Themes:
** 
* i18n:
** 
* Infrastructure: 
** 
* Legal:
** 
* merging to trunk
** 

!! Schedule
{sheet id="12" simple="y" editable="y" class="collapse"}

!! Test
* For deprecated features and [http://php.net/releases/5_4_0.php|5.4]

!! Regressions
* See ((Regressions in 9x))
* --((Minify)) issue--
** Minify crash in trunk see [http://sourceforge.net/mailarchive/forum.php?thread_name=4E946991.2060102%40gmail.com&forum_name=tikiwiki-cvs|this thread] in SVN list for more details. Rodrigo Primo 2011-10-26
** Was this in a specific language? (jb)
** Fixed some time ago (March 2012?) by not minifying files that cause an exception. Seemed to be the experimental "jQuery Sortable Tables" - anyone still getting issues? ''(jb)''
* --Structure revamp - when trying to edit the Documentation TOC structure at [http://trunkdoc.tiki.org/tiki-edit_structure.php?&page_ref_id=2], all of the other structures for the site appear but not Documentation TOC--
** Seems the data is weird there - the structure id apparently is 0 and so it tries to get all the structures thinking that means "no id", committed r41431 which is good for doc.t.o and my limited test data, but please watch out for other regressions (jb)
** Sounds like no one's got a more scary structure than that, and trunkdoc now appears to be working ok, so crossing it off ''(jb)''
* --I've just noticed (Xavi) that jquery.s5 might be broken under some circumstances in 9x (it's broken for sure in a site of mine, while it was working nicely in 8x for the same site before upgrade). Example: ...-- Fixed. 
* --profile mobile--
** didn't set mobile perspective to 1 (in a brand new tiki install; it used to do it in tiki7 at least). Thus, switch to mobile doesn't work after the profile is applied. Workaround: set mobile perspective manually to 1 after the profile is applied. r40679 in local 9x. http://profiles.tiki.org/Mobile
** Fixed by changing the mobile perspective - was a timing issue ''(jb)''
* --when registering as a new user, Tiki no longer shows the relative strength of passwords--
** Lost after removal of xajax in 7.x - restored in __r41590__ - also restored ajax validation for registration using jquery.validation if feature_jquery_validation is enabled ''(jb)''
* --the __textarea__ in Look & Feel admin panel on Customizing tab for Custom CSS puts the __super-annoying ~lt~x~gt~__  in CSS url() so it breaks all images used as background etc. !--
** fixed in __r41591__ ''(jb)''
!!- Cleanup
* --Rename [http://tikiwiki.svn.sourceforge.net/viewvc/tikiwiki?view=revision&revision=39020|Lazy Tabs] to something more descriptive (Robert)-- Done, now called "Plugin PageTabs"
* profiles server would need to indicate version so we know what encoding is (Marc and Chealer)
** --Profiles server version 8 with client version 9-- tested by Chealer
** --Profiles server version 9 with client version 6, 7 or 8-- tested by Chealer
* --A few missing files for http://demo.tiki.org/trunk/tiki-edit_invoice.php-- r40352 added with no functionality
* --Double check that ((Report)) works-- r40351, it works


!! Following major changes in images directory
* It will be even more important than usual to clear the Tiki cache after an upgrade
** Check if the last step of tiki-install clears the cache
** Add php doc/devtools/clearcache.php
*** default param is all, and other params would be nice to have

!! Documentation
Documentation for the end user of the changes and improvements included with this new release:
http://doc.tiki.org/Tiki9

!! To discuss
* If Zend_Lucene still has issues, possibly revert to MySQL Full-text search as the default preference.
* --((doc:PluginConvene)) should probably have 3 status, and not just 2 as of February 2012. The third status is for unconfirmed dates added after the user had already visited and selected his/her preferences. -- Done by RobertPlummer
* How to solve the issue with broken images (and broken sites in some cases where those images where in custom toolbar icons) that are no longer in pics/icons but in img/icons
+ What about some mysql command to replace the old path with the new path? Something like:
+ {CODE(colors="sql", wrap="1")}
update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');
{CODE} 
+ Some users reported to have used those icons in content stored in the following mysql tables:
** tiki_comments, field "data" (from forum posts)
** tiki_content_templates, field "content" (BLOB)
** tiki_history, field "data" (BLOB)
** tiki_link_cache, field "data" (BLOB)
** tiki_pages, field "data"
** tiki_preferences, field "value" (for custom toolbar icons)
** tiki_quicktags, field "tagicon" 
{REMARKSBOX(type="comment" title="did not find this one" close="n")}gezza: I don't have tiki_quicktags table in my Tiki 8 and 9 installs{REMARKSBOX}
** tiki_rss_feeds, field "cache" (BLOB)
** tiki_tracker_fields, field "description" (used in static text item field)
** tiki_untranslated, field "source" (BLOB)
** tiki_user_modules, field "data" (BLOB)
+ Jonny B: would like to revamp the menu admin page before branch - should be able to do it over this weekend (24/25th March)
+ Is it thinkable to have something in .htaccess that will rewrite old URLs to the new ones? --MarcLaporte 
+ gezza: r40732 seems to be ok using .htaccess (will need to put it into release notes that you have to replace your existing .htaccess file). Also added some raw sql scripts below to query, fix and rollback the db content based on Xavi's comments. The fix part could be in the installer, but I am not sure if it should, I would not modify the site content automatically. Maybe would be better to run manually from a healthcheck page or similar
{CODE(colors="sql", wrap="1")}
QUERY:
SELECT * FROM tiki_comments WHERE data LIKE '%pics/%';
SELECT * FROM tiki_content_templates WHERE content LIKE '%pics/%';
SELECT * FROM tiki_history WHERE data LIKE '%pics/%';
SELECT * FROM tiki_link_cache WHERE data LIKE '%pics/%';
SELECT * FROM tiki_pages WHERE data LIKE '%pics/%';
SELECT * FROM tiki_preferences WHERE value LIKE '%pics/%';
SELECT * FROM tiki_rss_feeds WHERE cache LIKE '%pics/%';
SELECT * FROM tiki_tracker_fields WHERE description LIKE '%pics/%';
SELECT * FROM tiki_untranslated WHERE source LIKE '%pics/%';
SELECT * FROM tiki_user_modules WHERE data LIKE '%pics/%';

FIX:
UPDATE tiki_comments SET data = REPLACE(data, 'pics/' , 'img/');
UPDATE tiki_content_templates SET content = REPLACE(content, 'pics/' , 'img/');
UPDATE tiki_history SET data = REPLACE(data, 'pics/' , 'img/');
UPDATE tiki_link_cache SET data = REPLACE(data, 'pics/' , 'img/');
UPDATE tiki_pages SET data = REPLACE(data, 'pics/' , 'img/');
UPDATE tiki_preferences SET value = REPLACE(value, 'pics/' , 'img/');
UPDATE tiki_rss_feeds SET cache = REPLACE(cache, 'pics/' , 'img/');
UPDATE tiki_tracker_fields SET description = REPLACE(description, 'pics/' , 'img/');
UPDATE tiki_untranslated SET source = REPLACE(source, 'pics/' , 'img/');
UPDATE tiki_user_modules SET data = REPLACE(data, 'pics/' , 'img/');

ROLLBACK:
UPDATE tiki_comments SET data = REPLACE(data, 'img/' , 'pics/');
UPDATE tiki_content_templates SET content = REPLACE(content, 'img/' , 'pics/');
UPDATE tiki_history SET data = REPLACE(data, 'img/' , 'pics/');
UPDATE tiki_link_cache SET data = REPLACE(data, 'img/' , 'pics/');
UPDATE tiki_pages SET data = REPLACE(data, 'img/' , 'pics/');
UPDATE tiki_preferences SET value = REPLACE(value, 'img/' , 'pics/');
UPDATE tiki_rss_feeds SET cache = REPLACE(cache, 'img/' , 'pics/');
UPDATE tiki_tracker_fields SET description = REPLACE(description, 'img/' , 'pics/');
UPDATE tiki_untranslated SET source = REPLACE(source, 'img/' , 'pics/');
UPDATE tiki_user_modules SET data = REPLACE(data, 'img/' , 'pics/');
{CODE} 

!! Todo
* --Smarty 3.1-- Done
* improvements in ((doc:batch)) actions control in order to allow them to be run based on url's with a token, so that the linux cron can be set on external servers (Rodrigo, Xavi).
* improvements to daily reports (Rodrigo, Xavi)
* drag & drop editon of structures (Jonnyb, Xavi)
* --diminishing the number of clicks needed to add a file in a wiki page by means of a toolbar icon in textareas. (Jyhem, Xavi)-- Done r39880
* --optional use of [webeditor#ACE|ACE editor] (replacing codemirror) for smarty templates in wiki pages. Feature under the Experimental admin panel-- Abandoned for now after seeing the codemirror improvements in indentation and R support (Jyhem, Xavi)
* --new option for sending emails from tracker user selector only for actions made by other users (done r39897)--, plus have these in daily reports. (Jyhem and/or Rodrigo, Xavi)
* Simile Timeline improvements (Jonnyb)
* Improve user-friendliness of tracker filling/edition when end-users need to enter/edit multiple items (Jyhem)
* Codemirror fixes and improvements:
+ Issues needing fix:
** --In some (medium to long) pages, When you click somewhere with the mouse and type, your new characters get added somewhere else. Xavi (reproduced by him and his students using different browsers such as Chrome on Windows, and probably safari from his students' macs). Xavi couldn't reproduce with Chrome on GNU/Linux.-- fixed in r40654
+ Improvements needed:
** --Add support for Smarty syntax:-- done when branched to 9.x
++ --http://codemirror.net/mode/smarty/index.html--
** Add support for Self indenting (with smarty syntax also):
*** Smarty is not supported because of too much flexibility, most editors don't even support smarty indent {CODE()}{if}//open
{else}//remain open, don't open another set to indent
{/if}//close

//function calls are killers too, they don't open or close, they just are
{smartyfunction}
{CODE}
*** With the update to codemirror, we gain r highlighting, and indent and a few other languages too.
++ http://codemirror.net/demo/formatting.html
+ If codemirror was buggy for too long, we could re-consider the option to add [ACE#ACE|ACE] as an alternative editor for future tiki versions (10, 11...)

!! Waiting for confirmation
* --Ugrade to [http://code.google.com/p/swfobject/wiki/whats_new|SWFObject 2.2]-- [http://tikiwiki.svn.sourceforge.net/viewvc/tikiwiki?view=revision&revision=39546|Done]
* --MySQL: switch from MyISAM to InnoDB, now that we won't need MySQL search index-- Done as experimental in ((Tiki8))
* Better organization of controls on wiki page. 
** Common controls/icons such as print, edit, are divided between wikitopline and page-bar. The print link is only available as an icon, while most others are only available as text links. This makes the page's user controls a messy mix, impossible to style cleanly and consistently. Also, the page-bar text links each need a unique CSS selector class so graphic icons can be assigned if desired (change from class="button" to class="button edit", etc.). And there is an arbitrary separation of, for example, "comments" and "print" links. There is no way to arrange these aligned and styled consistently.

!!Possible Issues
#Wiki pages with long revision histories may not show history pagination navigation on default new install.  May need to enable pagination under configuration preferences (tiki-admin.php, Configuration search: pagination).  
+ http://demo.tiki.org/9x/tiki-index.php?page=TestingPagination
+ Click on History at bottom.  Change "Enable pagination x  per page" to some number less than the number or revisions.  You should see navigation links/buttons. 
#__THIS MAY BE A BLOCKER for users who need trackers:__ On some installations, cannot view tracker items, tiki-view_tracker.php.  nkoth thinks it may be a PHP memory_limit issue; fails on 64MB tiki demo server; works fine with 512M :^).  Appears to log user out, but not really.  Jonny thinks it might be a rogue space problem.  Petjal thinks it might be related to RFC absolute path issue ("cookie confusion"?).
+ http://demo.tiki.org/9x/tiki-view_tracker.php?trackerId=3
#White screen of death after Insert New Item.  Item inserts fine; don't refresh browser, click browser Back button (Alt+LeftArrow) instead.
#Tracker auto_increment not enabled by default.  Enable Auto-Increment (found in trackers).  
+ Funny, was trying to paste this link here:
++ http://demo.tiki.org/9x/tiki-admin.php?page=trackers&cookietab=3&highlight=trackerfield_autoincrement
+ But that link throws this error:
++ Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 122880 bytes) in /www/htdocs/w00ec615/9x/templates_c/en18b660cf6951a7bde07357befc24a4e5....file.tiki.tpl.php on line 92
#Google Chrome, with some extensions, may cause user to redirect to your Server Root directory after login.  Works fine on Firefox, or Chrome in Incognito mode, or with "chrome --disable-extensions".   See RFC 2616 in 
+ http://tikiwiki.svn.sourceforge.net/viewvc/tikiwiki/trunk/tiki-login.php?annotate=39915&pathrev=40093 
#Deleting a tracker item throws Sea Surfing (CSRF) detected. Operation blocked.  Workaround:  disable CSRF protection under Security. 
+ http://demo.tiki.org/9x/tiki-view_tracker.php?trackerId=1
# tracker numeric field: separator is buggy (reported also weeks ago by some user on irc also)
** bug1: Decimal separator set to "c" (comma). However, if you write  "1,2" for instance, it's rejected (on both ff and chrome). Xavi.
** bug2: Decimal separator set to "c" (comma).  If you write  "1.2" for instance with FF, it works and it's saved as 1 point 2. However, if you write  "1.2"  on chrome, the js validation shows up and prevents you from saving. Once you write "1,2" in chrome, then it's saved as "12,0". Xavi
** also, documentation needs to be updated with whatever params are expected in Tiki:
++ http://doc.tiki.org/Numeric+Tracker+Field


-=Pages linking to Tiki9=-
{BACKLINKS()}{BACKLINKS}

-=Alias=-
* (alias(release process 9))