file galleries broken (db error) for some registered users on upgraded 1.10 site
- 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
- 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.phpWhen logging in as user sylvie (or Xavier.dePedro, for instance), I get
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 (Tiki 19+)
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Version: Create show2.tiki.org instanceAbout show2.tiki.orgTo help developers solve the bug, we kindly request that you demonstrate your bug on a show2.tiki.org instance. To start, simply select a version and click on "Create show2.tiki.org instance". Once the instance is ready (in a minute or two), as indicated in the status window below, you can then access that instance, login (the initial admin username/password is "admin") and configure the Tiki to demonstrate your bug. Priority will be given to bugs that have been demonstrated on show2.tiki.org.
- Ticket ID
- 1326
- Created
- Wednesday 22 August, 2007 15:23:59 GMT-0000
by Unknown - LastModif
- Thursday 10 September, 2009 11:06:32 GMT-0000
Attachments
| filename | created | hits | comment | version | filetype | ||
|---|---|---|---|---|---|---|---|
| No attachments for this item | |||||||
;){kind=link}
;){kind=link}
- fresh opening of tiki home page tiki-index (I removed a warning) is it OK
- Tracker with field type "Numeric" won't
- tiki 25.1 Database 'xxxx'. Unable to connect to database (when 25.0 will connect)
- Kanban plugin; the Swimlane field throw an error if using a category field type
- Kanban plugin: Error if the fields Description and Swimlane are empty
;){kind=link}
;){kind=link}