Support/TikiTrunkTestingNotes: Difference between revisions

category -> Support Archive
No edit summary
(category -> Support Archive)
 
(18 intermediate revisions by one other user not shown)
Line 1: Line 1:
! Coordination page for http://tiki-trunk.mozilla.com/ testers.
= Coordination page for tiki-trunk.mozilla.com testers.=


!! Background
== Background ==
tiki-trunk.mozilla.com contains real SUMO data from November 2009, on a environment similar (same?) to the real thing. The code will soon be updated daily from Tiki trunk
http://tiki-trunk.mozilla.com/ contains real SUMO data from November 2009, on a environment similar (same?) to the real thing. The code is updated 4 time per day from [http://tikiwiki.svn.sourceforge.net/viewvc/tikiwiki/trunk/ Tiki trunk]


== Notes ==


2009-12-28  
=== 2010-01-06 ===
* http://tiki-trunk.mozilla.com/ is now testable
*Cron job update should be OK now
** Very soon, automatic svn upgrades will be sorted (and we'll have revision number if bottom bar)
*But still no way to login and stay logged in reliably (but better)
*Found a bug trying to set memcached. Sent to LPH.
**Perhaps we should use .htaccess for bots instead of Tiki closing the site?
*would be nice to have [https://bugzilla.mozilla.org/show_bug.cgi?id=537513 real theme]
** Needs to figure out svn externals (or equivalent)
 
=== 2009-12-28 ===
* http://tiki-trunk.mozilla.com/ is now somewhat testable
** [https://bugzilla.mozilla.org/show_bug.cgi?id=525427 Very soon, automatic svn upgrades will be sorted (and we'll have revision number if bottom bar) (Last update from SVN (trunk -future Tiki 5.x-): Sunday 27 of December, 2009 00:43:11 UTC - REV 24050)]
** However, http://tiki-trunk.mozilla.com/tiki-admin.php "reports Database Version Problem"
** However, http://tiki-trunk.mozilla.com/tiki-admin.php "reports Database Version Problem"
*I get logged out every once in a while. Perhaps the load balancers?
*I get logged out every once in a while. Perhaps the load balancers?
*We need a way to change base URL so we don't get sent to subdirectories because of rewrite rules. (ex.: http://tiki-trunk.mozilla.com/en-US/kb/tiki-admin.php)
**Perhaps {literal}<base href="http://tiki-trunk.mozilla.com/" />{/literal} in [http://tiki-trunk.mozilla.com/tiki-admin.php?page=look Admin -> Look & Feel -> General Layout Options -> Custom HTML <head> Content]
*** Would need to reduce security here because base becomes ba<x>se
*There is cache weirdness. I changed top to "This is the SUMO-Tiki5 testing site." and David is getting the old "We will be performing maintenance tonight at 8pm PDT. During this time the site is expected to be down for approximately an hour"
**tenser: "if you file a bug under the same component/product as the one to get the tiki-trunk server up, IT will look at it"
*Is http/https configured properly?
*What are the settings to [https://tiki-trunk.mozilla.com/tiki-admin.php?page=performance tell Tiki for memcached]?
** We don't need this just yet, but need to make sure it's not causing some issues because it's not filled in.


 
== Some things to think about/discuss ==
 
Some things to think about
 
*plugins need to be re-created (keyboard, etc)
*plugins need to be re-created (keyboard, etc)
*Need to know last date of update
** This should be done in [http://profiles.tikiwiki.org profiles] for easy redeployment
** If site is updated via doc/devtools/svnup.sh, the version number will appear in the footer. ex.: "Last update from SVN(4.0): Monday 07 December, 2009 19:53:19 UTC - REV 23720"
*All potentially unsafe plugins become "Plugin execution pending approval" (Need to visit a page for the plugins to appears on http://tiki-trunk.mozilla.com/tiki-plugins.php)
***Editing a page gives the following error. LPH says it should be fixed in trunk. How do I know?
** Here is an example: http://tiki-trunk.mozilla.com/Contributor+Home+Page
System error.
** This is a known upgrade annoyance, brought by much better security in Tiki3
 
** So we would need a bot to visit all page and create the, (or do manually)
The following error message was returned:
 
The used SELECT statements have a different number of columns
 
The query was:
select tuw.*, tup1.`value` as language, tup2.`value` as mailCharset from `tiki_user_watches` tuw left join `tiki_user_preferences` tup1 on (tup1.`user`=tuw.`user` and tup1.`prefName`='language') left join `tiki_user_preferences` tup2 on (tup2.`user`=tuw.`user` and tup2.`prefName`='mailCharset') where `event`=? and `object`=? UNION DISTINCT select tgw.`watchId`, uu.`login`, tgw.`event`, tgw.`object`, tgw.`title`, tgw.`type`, tgw.`url`, uu.`email`, tup1.`value` as language, tup2.`value` as mailCharset from `tiki_group_watches` tgw inner join `users_usergroups` ug on tgw.`group` = ug.`groupName` inner join `users_users` uu on ug.`userId` = uu.`userId` and uu.`email` is not null and uu.`email` <> '' left join `tiki_user_preferences` tup1 on (tup1.`user`=uu.`login` and tup1.`prefName`='language') left join `tiki_user_preferences` tup2 on (tup2.`user`=uu.`login` and tup2.`prefName`='mailCharset') where `event`=? and `object`=?
 
Values:
 
  1. wiki_page_changed
  2. *TestMarcLaporte
  3. wiki_page_changed
  4. *TestMarcLaporte


The built query was likely:
[[Category:Support Archive]]
select tuw.*, tup1.`value` as language, tup2.`value` as mailCharset from `tiki_user_watches` tuw left join `tiki_user_preferences` tup1 on (tup1.`user`=tuw.`user` and tup1.`prefName`='language') left join `tiki_user_preferences` tup2 on (tup2.`user`=tuw.`user` and tup2.`prefName`='mailCharset') where `event`='wiki_page_changed' and `object`='*TestMarcLaporte' UNION DISTINCT select tgw.`watchId`, uu.`login`, tgw.`event`, tgw.`object`, tgw.`title`, tgw.`type`, tgw.`url`, uu.`email`, tup1.`value` as language, tup2.`value` as mailCharset from `tiki_group_watches` tgw inner join `users_usergroups` ug on tgw.`group` = ug.`groupName` inner join `users_users` uu on ug.`userId` = uu.`userId` and uu.`email` is not null and uu.`email` <> '' left join `tiki_user_preferences` tup1 on (tup1.`user`=uu.`login` and tup1.`prefName`='language') left join `tiki_user_preferences` tup2 on (tup2.`user`=uu.`login` and tup2.`prefName`='mailCharset') where `event`='wiki_page_changed' and `object`='*TestMarcLaporte'
900

edits