Loading...
 
Skip to main content

file galleries broken (db error) for some registered users on upgraded 1.10 site

  • Tracker item actions
Trackers
Items
Status
Closed
Subject
file galleries broken (db error) for some registered users on upgraded 1.10 site
Version
2.x
Category
  • Error
Feature
File Gallery (elFinder or standard UI)
Resolution status
Fixed or Solved
Submitted by
Xavier de Pedro
Lastmod by
Xavi (as xavidp - admin)
Rating
(0)
Description

Since some weeks (maybe a couple of months?) file galleries return db error when users logs in tiki. (Using updated 1.10)

Example:
http://uniwiki.ourproject.org/tiki-file_galleries.phpQuestion

When logging in as user sylvie (or Xavier.dePedro, for instance), I get

Copy to clipboard
An error occured in a database query!
Context:
File	tiki-file_galleries.php
Url	tiki-file_galleries.php
Query:
select * from (select u.* , f.`friend` from `users_users` u left join `tiki_friends` as f on (u.`login` = f.`friend` and f.`user`=?) order by `login` asc) as tab
Values:
0	sylvie
Message:
Error Message	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 'select u.* , f.`friend` from `users_users` u left join `tiki_


If you try as anonymous, or as newly created plain registered users (try with user/pass: prova/prova ), everything is shown fine.

FYI: friendship is toggled off as feature.

Importance
8
Priority
40
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
1326
Created
Wednesday 22 August, 2007 15:23:59 UTC
by Unknown
LastModif
Thursday 10 September, 2009 11:06:32 UTC


Show PHP error messages