Loading...
 
Architecture / Installation

Architecture / Installation


tiki-user_information.php error

posts: 13 US

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

posts: 3620 United States

Very odd error.

Some additional information would be helpful:

  • What Tiki version are you using?
  • Is this new install or an upgrade?
  • Did you encounter any SQL errors during the installation (or upgrade)?
  • Has the My Info page ever worked correctly?


HTH,

- Rick | My Tiki Blog | My Tiki UserPage

Why be a dummy? Get smarty! TikiForSmarties.com
Tiki for Smarties, your source for the best (and only) Tiki books, guides, and tutorials.
posts: 13 US

>> What Tiki version are you using?
12.1
>>Is this new install or an upgrade?
new @ 12 upgraded to 12.1
>>Did you encounter any SQL errors during the installation (or upgrade)?
no. the database checks out.
>>Has the My Info page ever worked correctly?
good question - no clue - just tried it today.
i have been messing around with username requirements.

i'm wondering if i should delete the tracker, delete all the users and start over.


Upcoming Events

1)  Wed 23 Sep 2020 14:00 GMT-0000
September TRM

Why Register?

Register at tiki.org and you'll be able to use the account at any *.tiki.org site, thanks to the InterTiki feature. A valid email address is required to receive site notifications and occasional newsletters. You can opt out of these items at any time.