SQL error saving a Contact
- Status
- Closed
- Subject
- SQL error saving a Contact
- Version
- 12.x
- Category
- Error
- Feature
- Contact (address book)
- Resolution status
- New
- Submitted by
- Telesight
- Volunteered to solve
- Jean-Marc Libs
- Lastmod by
- Jean-Marc Libs
- Rating
- Description
As a registered user I try to create a contact, I click on the save button and then I get the following page with this error (By the way the contact is saved):
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 'AS x FROM `tiki_webmail_contacts_ext` AS x LEFT JOIN `tiki_webmail_contacts_fiel' at line 1
The query was:
DELETE `tiki_webmail_contacts_ext`.* AS x FROM `tiki_webmail_contacts_ext` AS x LEFT JOIN `tiki_webmail_contacts_fields` AS f ON x.`fieldId`=f.`fieldId`WHERE x.`contactId`=? AND f.`flagsPublic`='n' AND f.`user`=?Values:
1. 2
2. John DoeThe built query was likely:
DELETE `tiki_webmail_contacts_ext`.* AS x FROM `tiki_webmail_contacts_ext` AS x LEFT JOIN `tiki_webmail_contacts_fields` AS f ON x.`fieldId`=f.`fieldId`WHERE x.`contactId`='2' AND f.`flagsPublic`='n' AND f.`user`='John Doe'
The extra fields like "City" and so on, are not saved.
Logged in as a admin I do not get this fault (not on my own installation nor on the show.tikiwiki.org)
I have seen this error in version 11 too, but did not pay attention to it because it was my first use of Tiki.- Solution
The SQL error made the whole site get in error mode when a normal user adds a contact.
SQL query obviously wrong and easy to fix.Funny thing is, no error in Tiki 9.x, yet the query is the same there.
Committed revision 49381. Thank you for the report
- Importance
- 10 high
- Easy to solve?
- 9
- Priority
- 90
- 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
- 5097
- Created
- Tuesday 14 January, 2014 13:03:39 GMT-0000
by Telesight - LastModif
- Tuesday 14 January, 2014 20:40:25 GMT-0000
Attachments
| filename | created | hits | comment | version | filetype | ||
|---|---|---|---|---|---|---|---|
| No attachments for this item | |||||||
;){kind=link}
;){kind=link}
- Trackers, Tracker list inline editing; When Tracker list inline editing is enable you can't print the tracker list fields values (all field are blank)
- Trackers, Modal create item; Saving a an item from a modal on Tiki25 display a leave page warning
- Trackers: Need to be able sort as numerical instead of text
- Tiki community HomePage show a "Data too long" error
- Threaded comment listing sort order
;){kind=link}
;){kind=link}