Support/TikiTrunkTestingNotes: Difference between revisions
MarcLaporte (talk | contribs) (Created page with ' Some things to think about *plugins need to be re-created (keyboard, etc)') |
MarcLaporte (talk | contribs) No edit summary |
||
| Line 1: | Line 1: | ||
| Line 5: | Line 4: | ||
*plugins need to be re-created (keyboard, etc) | *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? | |||
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' | |||
Revision as of 19:51, 9 December 2009
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'