Layering Calendars

Doyle · Guest

Hi,

I have an evaluation copy of Thyme.

I have set up 4 groups.
I have set up 6 users. 3 of these users grant viewing access to 2 of the 4 groups.
When a user in one of the 2 groups logs in, I expected that user to be able to view the
3 calendars.

When this user clicks calendars, and types in a view name and description and clicks "Add" the user is redirected to the login page.

When I try this as administrator, I can create the view, but, when I go to add calendars to the view I get the following error displayed:
Error!: class.mysql.php :: query() :: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's preformance%')' at line 2

select * from thyme_Calendars
where type = 0 and (type = 0 and lower(title) like '%boo's preformance%')

Error!: class.mysql.php :: query() :: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's preformance%')' at line 2

select * from thyme_Calendars where
(type = 1 and owner = 1) or (type = 1 and owner = 0) and (type = 0 and lower(title) like '%boo's preformance%')

esoft_ian · Joined: 12 Sep 2005 Posts: 5275

Hi Doyle,

Both bugs. You may download the updates from:

http://www.extrosoft.com/products/thyme/updates/1.2/calendars.txt

rename to calendars.php, upload to modules/calendars/

http://www.extrosoft.com/products/thyme/updates/1.2/add_calendars.txt

rename to add_calendars.php, upload to modules/common_files/

Let me know if you have any trouble.

Note to readers: Both the trial and live downloads have been updated. There is no need to download these files and update Thyme if you've yet to download it at all.