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
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?