|
|
| Line 17: |
Line 17: |
| *plugins need to be re-created (keyboard, etc) | | *plugins need to be re-created (keyboard, etc) |
| *Need to know last date of update | | *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" | | ** 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?
| |
| 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'
| |
! 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
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"