Tickets :: [#13642] SQL syntax error when trying to add a Notepad from device

6.0.0-alpha14

6/24/25

Summary	SQL syntax error when trying to add a Notepad from device
Queue	Synchronization
Queue Version	Git master
Type	Bug
State	Resolved
Priority	1. Low
Owners	mrubinsk (at) horde (dot) org
Requester	software-horde (at) interfasys (dot) ch
Created	10/21/2014 (3899 days ago)
Due
Updated	10/21/2014 (3899 days ago)
Assigned	10/21/2014 (3899 days ago)
Resolved	10/21/2014 (3899 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch	No

10/21/2014 11:31:53 AM	software-horde (at) interfasys (dot) ch	Comment #9	Reply to this comment
And I just realisedthat the fix was made in Core, not Activesync... So it's all good.

10/21/2014 11:28:16 AM	software-horde (at) interfasys (dot) ch	Comment #8	Reply to this comment
Applying the patch manually solves the problem. Thank you!

10/21/2014 11:17:51 AM	software-horde (at) interfasys (dot) ch	Comment #7	Reply to this comment
The fix should be included in horde_activesync-2.19.4 I've installed the package Package Version State Horde_ActiveSync 2.19.4 stable File has not been updated Oct 13 14:24 /usr/local/php54/lib/php/Horde/Core/ActiveSync/Connector.php Is it a problem with the pear packaging?

10/21/2014 04:33:30 AM	Michael Rubinsky	Comment #6 State ⇒ Resolved	Reply to this comment
Resolving. Everything related to Horde, and not the client, has been fixed.

10/21/2014 04:30:12 AM	Git Commit	Comment #5	Reply to this comment
Changes have been made in Git (FRAMEWORK_5_2): commit b5c169f061b8da297e94fb31506e0dbb38820013 Author: Michael J Rubinsky <mrubinsk@horde.org> Date: Tue Oct 21 00:23:28 2014 -0400 Fix scope. Another fix for ~~Bug: 13642~~ nag/lib/Api.php \| 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) http://github.com/horde/horde/commit/b5c169f061b8da297e94fb31506e0dbb38820013

10/21/2014 04:25:37 AM	Michael Rubinsky	Assigned to Michael Rubinsky

10/21/2014 04:25:26 AM	Michael Rubinsky	Comment #4 State ⇒ Feedback	Reply to this comment
On the BlackBerry, a Tasks folder will have been created. Could be a bug with the OS, but others don't seem to be having this issue. Can't reproduce. Creating a Task folder on BB 10.3.1 (Simulator) creates a task folder. Creating a Notes folder creates a Notes folder. In the Horde logs, I see a SQL syntax error. Fixed, along with some other issues that was preventing the task list from being added.

10/21/2014 04:24:02 AM	Git Commit	Comment #3	Reply to this comment
Changes have been made in Git (master): commit 4ace7aaa8cb909c327d545ff3ccd7c8bfaadd928 Author: Michael J Rubinsky <mrubinsk@horde.org> Date: Tue Oct 21 00:23:28 2014 -0400 Fix scope. Another fix for ~~Bug: 13642~~ nag/lib/Api.php \| 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) http://github.com/horde/horde/commit/4ace7aaa8cb909c327d545ff3ccd7c8bfaadd928

10/21/2014 04:23:56 AM	Git Commit	Comment #2	Reply to this comment
Changes have been made in Git (master): commit 9ed0777a69fd862cf920250fddbd406a310021cb Author: Michael J Rubinsky <mrubinsk@horde.org> Date: Tue Oct 21 00:20:17 2014 -0400 Fix parameter list for adding a new tasklist from EAS. ~~Bug: 13642~~ .../Core/lib/Horde/Core/ActiveSync/Connector.php \| 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) http://github.com/horde/horde/commit/9ed0777a69fd862cf920250fddbd406a310021cb

10/21/2014 12:18:04 AM	software-horde (at) interfasys (dot) ch	Comment #1 State ⇒ Unconfirmed Patch ⇒ No Milestone ⇒ Queue ⇒ Synchronization Summary ⇒ SQL syntax error when trying to add a Notepad from device Type ⇒ Bug Priority ⇒ 1. Low	Reply to this comment
There are 2 problems, one of which may not be Horde's fault. On a BlackBerry 10 device with OS 10.3.1, create a Notes folder On the BlackBerry, a Tasks folder will have been created. Could be a bug with the OS, but others don't seem to be having this issue. In the Horde logs, I see a SQL syntax error. INFO: [89553] Horde_Core_ActiveSync_Driver::authenticate() attempt for user@domain.tld INFO: [89553] FOLDERCREATE request received for user user@domain.tld INFO: [89553] Device entry exists for BBALPHA, updating userAgent and version. INFO: [89553] Request being handled for device: BBALPHA, Supporting protocol version: 14.1, Using Horde_ActiveSync v2.19.3 INFO: [89553] GET VARIABLES: Array INFO: [BBALPHA] Handling FOLDER[CREATE\|DELETE\|CHANGE] command. DEBUG: [89553] I <FolderHierarchy:FolderCreate> DEBUG: [89553] I <FolderHierarchy:SyncKey> DEBUG: [89553] I {542e671b-21bc-4bd6-aeef-1c47904cae96}6 DEBUG: [89553] I </FolderHierarchy:SyncKey> DEBUG: [89553] I <FolderHierarchy:ParentId> DEBUG: [89553] I Tffcae2bd DEBUG: [89553] I </FolderHierarchy:ParentId> DEBUG: [89553] I <FolderHierarchy:DisplayName> DEBUG: [89553] I Secrets DEBUG: [89553] I </FolderHierarchy:DisplayName> DEBUG: [89553] I <FolderHierarchy:Type> DEBUG: [89553] I 15 DEBUG: [89553] I </FolderHierarchy:Type> DEBUG: [89553] I </FolderHierarchy:FolderCreate> INFO: [89553] Loading state for synckey {542e671b-21bc-4bd6-aeef-1c47904cae96}6 INFO: [89553] Loading FOLDERSYNC state containing 15 folders. INFO: [89553] Horde_ActiveSync_Connector_Importer::importFolderChange(, Secrets, Tffcae2bd, 15) INFO: [89553] Horde_Core_ActiveSync_Driver::changeFolder(, Secrets, Tasks:Qq5-SA5HpXiDvZoid7XCew2, , 15) ERR: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' 0)' at line 1 2014-10-21T00:56:09+02:00 ERR: HORDE [nag] SQL QUERY FAILED: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' 0)' at line 1 INSERT INTO nag_sharesng (share_name, share_parents, share_owner, attribute_name, attribute_color, attribute_desc, share_flags) VALUES ('1eR105zPiy3PBuYwAiVc4w1', NULL, 'user@domain.tld', 'Secrets', '', , 0) [pid 89553 on line 204 of "/usr/local/php54/lib/php/Horde/Db/Adapter/Pdo/Base.php"] 2014-10-21T00:56:09+02:00 ERR: HORDE Returning HTTP 500 while handling FolderCreate command. [pid 89553 on line 159 of "/var/www/html/webmail/rpc.php"] 2014-10-21T00:56:09+02:00 ERR: HORDE Error in communicating with ActiveSync server: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' 0)' at line 1 [pid 89553 on line 162 of "/usr/local/php54/lib/php/Horde/Rpc/ActiveSync.php"] 2014-10-21T00:56:09+02:00 ERR: HORDE #0 /var/www/html/webmail/nag/lib/Api.php(157): Nag::addTasklist(Array) #1 [internal function]: Nag_Api->addTasklist('Secrets', Array) #2 /usr/local/php54/lib/php/Horde/Registry.php(1136): call_user_func_array(Array, Array) #3 /usr/local/php54/lib/php/Horde/Registry.php(1093): Horde_Registry->callByPackage('nag', 'addTasklist', Array) #4 /usr/local/php54/lib/php/Horde/Registry/Caller.php(41): Horde_Registry->call('tasks/addTaskli...', Array) #5 /usr/local/php54/lib/php/Horde/Core/ActiveSync/Connector.php(1200): Horde_Registry_Caller->__call('addTasklist', Array) #6 /usr/local/php54/lib/php/Horde/Core/ActiveSync/Connector.php(1200): Horde_Registry_Caller->addTasklist('Secrets', Array) #7 /usr/local/php54/lib/php/Horde/Core/ActiveSync/Driver.php(703): Horde_Core_ActiveSync_Connector->createFolder('Tasks', 'Secrets') #8 /usr/local/php54/lib/php/Horde/ActiveSync/Connector/Importer.php(353): Horde_Core_ActiveSync_Driver->changeFolder(false, 'Secrets', 'Tasks:Qq5-SA5Hp...', false, '15') #9 /usr/local/php54/lib/php/Horde/ActiveSync/Request/FolderCreate.php(151): Horde_ActiveSync_Connector_Importer->importFolderChange(false, 'Secrets', 'Tffcae2bd', '15') ~~#10~~ /usr/local/php54/lib/php/Horde/ActiveSync/Request/Base.php(253): Horde_ActiveSync_Request_FolderCreate->_handle() ~~#11~~ /usr/local/php54/lib/php/Horde/ActiveSync.php(880): Horde_ActiveSync_Request_Base->handle() ~~#12~~ /usr/local/php54/lib/php/Horde/Rpc/ActiveSync.php(143): Horde_ActiveSync->handleRequest('FolderCreate', 'BBALPHA') #13 /var/www/html/webmail/rpc.php(159): Horde_Rpc_ActiveSync->getResponse(NULL) ~~#14~~ {main} [pid 89553 on line 162 of "/usr/local/php54/lib/php/Horde/Rpc/ActiveSync.php"] 2014-10-21T00:56:09+02:00 ERR: HORDE Buffer contents: [pid 89553 on line 162 of "/usr/local/php54/lib/php/Horde/Rpc/ActiveSync.php"]