Architecture / Installation

Posted by patn 12 May 2014 16:53 GMT-0000 posts: 13

I am new to Tiki and setting up a new site. I have 4 users and 1 tracker. I want registered logged in users to be able to see their trackers ( and other trackers ) and be able to edit only their own.

When logged, the following MyTiki => MyInfo (tiki-user_information.php)
results in the following error page
System error.

The following error message was returned:

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 'ORDER BY `position` asc' at line 1
The query was:
SELECT * FROM `tiki_tracker_fields` WHERE 1=1 AND (`trackerId` = ? OR `trackerId` IS NULL) AND ORDER BY `position` asc
Values:
0
The built query was likely:
SELECT * FROM `tiki_tracker_fields` WHERE 1=1 AND (`trackerId` = '0' OR `trackerId` IS NULL) AND ORDER BY `position` asc

I am sure this is a permissions issue but that could just be my naivety.

Any thoughts on how to fix this?

thanks

- pat