Category: Release20

Logged in user without edit permission can not use sandbox.

Despite comments, tiki-editpage.tpl, checks for edit permissions and displays 'Permission denied ...' See test around line 71 in tiki-editpage.php.

Further, the 'Preview' button is not displayed. See first line of wiki_edit_actions.tpl.

After saving the "Edit CSS" changes, the *.css file is empty!!

At doc.tw.o (upgraded to 1.10svn April 12th), I went to admin categories.
Selected "Editorial Board Meeting" (already existed), to add pages to it.
At the filter box I set "Editorial Board Meeting" and a mysql error is returned:


{BOX()}
~pp~
~np~
An error occured in a database query!

Context:
File tiki-admin_categories.php
Url tiki-admin_categories.php?find_objects=Editorial+Board+Meeting&parentId=10&search_objects=Filter&sort_mode=name_asc&offset=0&find=
Query:
SELECT tab.*, tfgp.`name` as `parentName` FROM (SELECT 1 as `isgal`, tfg.`galleryId` as `id`, tfg.`parentId`, tfg.`name`, tfg.`description`, 0 as `size`, tfg.`created`, tfg.`name` as `filename`, tfg.`type`, tfg.`user` as `creator`, '' as `author`, tfg.`hits`, tfg.`votes`, tfg.`points`, '' as `path`, '' as `reference_url`, '' as `is_reference`, '' as `hash`, tfg.`name` as `search_data`, tfg.`lastmodif` as `lastmodif`, '' as `last_user`, '' as `lockedby`, '' as `comment`, 0 as `archiveId`, tfg.`visible`, tfg.`public`, tfg.`galleryId` as `fileId`, tfg.`parentId` as `galleryId`, 0 as `filesize`, tfg.`type` as `filetype`, tfg.`user`, '' as `lastModifUser`, count(distinct tfc.`fileId`) as `files` FROM `tiki_file_galleries` as tfg LEFT JOIN `tiki_files` tfc ON (tfg.`galleryId` = tfc.`galleryId`) GROUP BY tfg.`galleryId`) as tab LEFT OUTER JOIN `tiki_file_galleries` tfgp ON (tab.`parentId` = tfgp.`galleryId`) WHERE (upper(`name`) LIKE upper(?) OR upper(`description`) LIKE upper(?) OR upper(`filename`) LIKE upper(?)) ORDER BY `isgal` desc, tab.`name` desc
Values:
0 %Editorial Board Meeting%
1 %Editorial Board Meeting%
2 %Editorial Board Meeting%
Message:
Column 'name' in where clause is ambiguous
Built query was probably:
SELECT tab.*, tfgp.`name` as `parentName` FROM (SELECT 1 as `isgal`, tfg.`galleryId` as `id`, tfg.`parentId`, tfg.`name`, tfg.`description`, 0 as `size`, tfg.`created`, tfg.`name` as `filename`, tfg.`type`, tfg.`user` as `creator`, '' as `author`, tfg.`hits`, tfg.`votes`, tfg.`points`, '' as `path`, '' as `reference_url`, '' as `is_reference`, '' as `hash`, tfg.`name` as `search_data`, tfg.`lastmodif` as `lastmodif`, '' as `last_user`, '' as `lockedby`, '' as `comment`, 0 as `archiveId`, tfg.`visible`, tfg.`public`, tfg.`galleryId` as `fileId`, tfg.`parentId` as `galleryId`, 0 as `filesize`, tfg.`type` as `filetype`, tfg.`user`, '' as `lastModifUser`, count(distinct tfc.`fileId`) as `files` FROM `tiki_file_galleries` as tfg LEFT JOIN `tiki_files` tfc ON (tfg.`galleryId` = tfc.`galleryId`) GROUP BY tfg.`galleryId`) as tab LEFT OUTER JOIN `tiki_file_galleries` tfgp ON (tab.`parentId` = tfgp.`galleryId`) WHERE (upper(`name`) LIKE upper('%Editorial Board Meeting%') OR upper(`description`) LIKE upper('%Editorial Board Meeting%') OR upper(`filename`) LIKE upper('%Editorial Board Meeting%')) ORDER BY `isgal` desc, tab.`name` desc
~/np~
~pp~
{BOX}

Nothing was added to that category. I had to add them selecting them from the multiple select box showing all pages in doc.tw.o (at least nowadays all pages are listed :-) - thanks to the coders who improved that )

Error message with search function in category.
PHP (4.3.10-18) ERROR (E_USER_WARNING):
File: tikidblib.php
Line: 181
Type: mysql error: Column 'name' in where clause is ambiguous in query:

SELECT DISTINCT c.*, o.* FROM `tiki_category_objects` c, `tiki_categorized_objects` co, `tiki_objects` o LEFT JOIN `users_objectpermissions` u ON u.`objectId`=MD5(CONCAT(o.`type`,LOWER(o.`itemId`))) AND u.`objectType`=o.`type` WHERE c.`catObjectId`=o.`objectId` AND o.`objectId`=co.`catObjectId` AND c.`categId`=? AND (`name` LIKE ? OR `description` LIKE ?) AND (( u.`objectId` IS NULL AND (o.`type` IN ('',?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) OR o.`type` like ?) OR (((o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`perm

At this site: http://www.moviments.net/ilp/
We had a file gallery called "Actes d'Assemblees i reunions" (without the surrounding double quotation marks)
http://moviments.net/ilp/tiki-list_file_gallery.php?galleryId=3

There was a child file gallery called: "Assemblea 080907" (without quotation marks)
http://moviments.net/ilp/tiki-list_file_gallery.php?galleryId=9

When I tried to upload a file (xls, "estat comptes.xls"), the server restarted in the middle of the upload and Firefox showed a "connection reset while loading page", etc.
I couldn't load other pages of this site or others on the same server for some seconds, but later on, server came up again.
So I could load other pages of the same tiki site. Then I tried again doing the same, and same behavior after attempting to upload that file: server restarted, etc.
After reloding file gallery, no file was uploaded, etc.

Then I went to the parent file gallery, and deleted at least the single quotation mark from the name, leaving that name as: "Assemblees i reunions"
Then the file could be uploaded with no problems at all on the child file gallery "Assemblea 080907"

This is the file, in case you want to reproduce with the same file, just in case:
http://moviments.net/ilp/tiki-download_file.php?fileId=20

The first problem (maybe local) is that the ad checkboxes on tiki-admin.php?page=ads tend to not stay checked. Please confirm if this is true for other users.

The bigger problem (on two servers): when I switch the logo from left to right on the Look & Feel admin page, the ad checkboxes on tiki-admin.php?page=ads get emptied. Maybe any update on Look & Feel resets the ad activate and publish checkboxes to empty; I didn't check.

Also, on the ads and banners admin page, only the bottom "Apply" button works, for me.

Site header banner ad configuration worked before it was split off as a separate page, afaik. Maybe a bug was introduced by the move to its own page.

After adding the following to wiki pages it stops them rendering.


{CODE(caption=>~np~ bash ~/np~)}

LOCATION=smb://server/directory/
IFS=$'\n'
for SONGS in $(find -type f |grep .mp3 | awk 'sub("./","") {print $0}';find -type f |grep .wmv | awk 'sub("./","") {print $0}'; find -type f |grep .ogg | awk 'sub("./","") {print $0}')
do
echo $LOCATION$SONGS
done
{CODE}

Some of the preinstalled themes seem to be incomplete:
I have the word "loading..." in the top left corner of each page.

Check: http://list.vic-fontaine.com/
(test user/pw if needed: smarty)

I found this forum topic:
http://tikiwiki.org/tiki-view_forum_thread.php?forumId=6&comments_parentId=32558&highlight=loading

However, in this case, preinstalled themes are affected.
For example:
bluegreen.css: error
boreal.css: works fine
brtiki.css: error
codex.css: works fine
etc...

Tring to create a structure results in the error:
An error occured in a database query!

Context:
File tiki-admin_structures.php
Url tiki-admin_structures.php
Query:
insert into `tiki_structures`(`parent_id`,`page_id`,`page_alias`,`pos`) values(?,?,?,?)
Values:
0 0
1 2
2 Test Structure
3 1
Message:
Field 'structure_id' doesn't have a default value
Built query was probably:
insert into `tiki_structures`(`parent_id`,`page_id`,`page_alias`,`pos`) values('0','2','Test Structure','1')

If the process is repeated the error thrown is different: 1 page not added (Exists)

Found with clean installs of 2.0RC4 on Windows Server 2003 x32 and also server 2008 x64. PHP 5.2.6 (x32); MySQL 5.0.51b (x32 and x64); Apache 2.2.9 (x32)

This tracker item could not be found

In certain instances when editing a page through the text editor (or creating a new blog post), with the wysiwyg-available available (though hidden) the smilies field is not displayed.

The problem is probably due to the fact that the variable $wysiwyg contains an 'n' if the editor is hidden while in some instances the value is NULL. This is probably because if the wysiwyg feature in admin-features is disabled then the $wysiwyg value is NULL, but if it is enabled but hidden the value is 'n'.

There is a conditional in templates/tiki-editpage.tpl that does not take this into account.

(The problem may be present in other versions as well)

{syntax type="tiki" editor="plain"}
mod-last_modif_pages should not list the sandbox page.
Users could confuse it for real content.

Themes using the old preference format do not work/show in 1.10. While we want people to upgrade themes to 1.10, legacy mode should be enabled.

Please check this out on other Windows servers, but on my Windows XP WAMP setup, theme information isn't working right. The switch-theme module shows no style being used. Trying to select a theme in the module has no effect. Theme selection works normally with userslib.php CVS version 1.247.2.23, but as of version 1.247.2.24, it's broken. (Comparing the files shows the lines involved. To work with themes I have to be careful about updating userslib.php.)

{syntax type="tiki" editor="plain"}
Although there are permissions such as tiki_p_create_galleries there is no tiki_p_edit_image_galleries.

So a group with tiki_p_create_galleries permissions can add a new image gallery but cant edit the description after they have added it. Which is a problem if they made a mistake.

Trying to start using Images Gallery on a fresh 1.10 install on a Ubuntu 7.10 Server/Apach2/PHP5 platform. All image files are JPG.

__GD__
GD ("2.0 or higher" per phpinfo) was installed with the platform and Tikiwiki seemed to recognie it, but functionality is not right.

If I upload an image from a URL, I get a thumb sized as predicted. However, if I upload a local file I get a 100% sized thumb.

If I choose to "rebulid thumbnails" all thumbs are made 100% sized.

__Imagemagick__
I installed it (2.0.0-alpha per phpinfo) and it's PHP module using apt-get and restarted the whole system for good measure.

Uploading an image from URL or local file is the same. I get what appears to be a white, 2x10 pixel thumbnail and image.

If I choose to "rebuild thumbnails" there is no apparent change. If I only switch back to GD and choose to "rebuild thumbnails" I get perfect looking, though 100% sized thumbs again.

'Shared' contacts don't shared the field names. If userA creates an entry with a 'custom' field of 'Company' as 'The Smith Company', we see this in the db:


||contactId|fieldId|value|hidden
1 | 7 |The Smith Company|0||


The problem is that other users do not 'inherit' that custom field: so other users seeing that record will see no description of the field name. Indeed, if another user chooses 'Company' from the list of fields to add, it will get a new fieldId:

||contactId | fieldId | value | hidden
1 | 7 | The Smith Company | 0
2 | 23 | Smith Industries | 0 ||

It should, especially for the predefined (semi-custom fields, like 'Company' and 'Street Address', defined in lib/webmail/contactlib.php) 'share' these values with others instead of creating new fieldId's.

tiki-admin_layout.php is totally broken for me in a 2.4 (using eatlon, btw)

http://www.ub.edu/optics/tiki/tiki-admin_layout.php
returns:
{CODE()}
An error occured in a database query!

Context:
File tiki-admin_layout.php
Url tiki-admin_layout.php
Query:
select `name`, `value` from `tiki_preferences` where
Values:
Message:
Algo est� equivocado en su sintax cerca '' en la linea 1
Built query was probably:
select `name`, `value` from `tiki_preferences` where
{CODE}

As preference syntax in tiki-admin.php?page=general, I have 2.0 - ...

{THUMB(id=39)}{THUMB}

It takes over 30 seconds to save an article using tiki-article.php. No one else can access the server while this is stalled.

To verify and determine why. Probably some bad db locking.

When you try and sort according to one of the columns in tiki-listpages.php, the search params, such as category, are forgotten.

This is very irritating. This is caused by the new smarty self_link function not taking into account enough params. Perhaps this can be improved by some kind of better way of handling this.

Or more practically, perhaps these links that cause the table to be sorted should be optional?

It would be nice if TikiSheet had the ability to clone an already existing spreadsheet. A possibility would be to have a clone button next to the import/export buttons.

Possible functionality of the clone button:
- Create a new table with an new sheetId that has exactly the same contents of the original
- Title of copy could be Copy of 'InsertOrigName'
- If aforementioned Title exists new title could be Copy of InsertOrigName(#) as long as the title containing specific # also does not exist.
- All setting, excluding sheetId, of orig table copied to cloned table

when performing a search only the first page of results is available, the pagination links at the bottom of the page do not navigate to the subsiquent pages.

Once saved, style changes (such as setting the font size or centering text) results in pages displaying like these:

My test starts here. Not much of yle="font-size: larger">interest going on though!
AND
yle="text-align: center">Home Page Test

Clicking to insert an image: dialog is displayed buyt clicking on the Browse server button results in the error "Error creating folder "" (Can't create directory)". Manually entering an image in source view mode (<img src="blah-blah">) and saving results in: img src=/home/lib/fckeditor/editor/blah-blah height=30 width=28 (surrounded by curely brackets)

Both related to parsing the html from the WSYWIG editor?

Clicking "Insert/Edit an internal wiki link" shows the "Insert Internal Link" popup but no content is displayed. The dialog briefly shows a cancel button and then the "wait squares" but nothing more.

Found with clean installs of 2.0RC4 on Windows Server 2003 x32 and also server 2008 x64. PHP 5.2.6 (x32); MySQL 5.0.51b (x32 and x64); Apache 2.2.9 (x32)

(sorry if these aren't sufficiently related and should be in separate bug reports)

Hello,

sorry for my bad English, but I´m from Germany and I´ve got my last lesson at school - nearly 20 years ago...

So I hope that you will understand me, here my problem :

I use Tiki 2.0 RC4 with the "andreas08"-Theme. It works quite good, but this bug (maybe ?) happens when I try to edit and save the Theme-CSS via the Admin-Menu :

Some command lines will be added with a "x" (included by tag-brackets) and the instruction given by this command will be ignored - cause it´s "rubbish" than.
( I can´t show you an example, i tried it, but here the "X" in the brackets not appears after saving this thread. )

This strange "effect" also happens by editing or formatting an text by the wysiwyg-editor, so that the text appears with some "rubbish" code-tiles instead of the formatted styles. (Text-Color, Size, Justify, etc.)

I´m not sure - is it a bug, or is this a failure caused by myself ?

Thanks for any answers or comments an greeting form Germany.

Hofnarr