Support/TikiTrunkTestingNotes
! Coordination page for http://tiki-trunk.mozilla.com/ testers.
!! 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
2009-12-28
- http://tiki-trunk.mozilla.com/ is now testable
- Very soon, automatic svn upgrades will be sorted (and we'll have revision number if bottom bar)
- 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?
Some things to think about
- plugins need to be re-created (keyboard, etc)
- Need to know last date of update
- 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"
- Editing a page gives the following error. LPH says it should be fixed in trunk. How do I know?
- 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"
System error.
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: 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'