{"action":"closed","issue":{"url":"https://api.github.com/repos/joomla/joomla-cms/issues/22471","repository_url":"https://api.github.com/repos/joomla/joomla-cms","labels_url":"https://api.github.com/repos/joomla/joomla-cms/issues/22471/labels{/name}","comments_url":"https://api.github.com/repos/joomla/joomla-cms/issues/22471/comments","events_url":"https://api.github.com/repos/joomla/joomla-cms/issues/22471/events","html_url":"https://github.com/joomla/joomla-cms/issues/22471","id":366196308,"node_id":"MDU6SXNzdWUzNjYxOTYzMDg=","number":22471,"title":"[3.8] Smart Search Indexer - MariaDB, SQL Syntax Error","user":{"login":"n00bster","id":1003469,"node_id":"MDQ6VXNlcjEwMDM0Njk=","avatar_url":"https://avatars3.githubusercontent.com/u/1003469?v=4","gravatar_id":"","url":"https://api.github.com/users/n00bster","html_url":"https://github.com/n00bster","followers_url":"https://api.github.com/users/n00bster/followers","following_url":"https://api.github.com/users/n00bster/following{/other_user}","gists_url":"https://api.github.com/users/n00bster/gists{/gist_id}","starred_url":"https://api.github.com/users/n00bster/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/n00bster/subscriptions","organizations_url":"https://api.github.com/users/n00bster/orgs","repos_url":"https://api.github.com/users/n00bster/repos","events_url":"https://api.github.com/users/n00bster/events{/privacy}","received_events_url":"https://api.github.com/users/n00bster/received_events","type":"User","site_admin":false},"labels":[{"id":878880561,"node_id":"MDU6TGFiZWw4Nzg4ODA1NjE=","url":"https://api.github.com/repos/joomla/joomla-cms/labels/J3%20Issue","name":"J3 Issue","color":"bc8503","default":false},{"id":138443932,"node_id":"MDU6TGFiZWwxMzg0NDM5MzI=","url":"https://api.github.com/repos/joomla/joomla-cms/labels/No%20Code%20Attached%20Yet","name":"No Code Attached Yet","color":"ededed","default":false}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":12,"created_at":"2018-10-03T06:45:39Z","updated_at":"2018-10-05T07:10:39Z","closed_at":"2018-10-05T07:10:39Z","author_association":"NONE","body":"I noticed that the Smart Search Indexer are failing and does stop always around 90%.\r\nThe error came up on both sides when i run the indexer: on CLI or at joomla Backend\r\n\r\ni looked in this documentations and tested some things out but could not fix the problem on my own:\r\nhttps://docs.joomla.org/Smart_Search_configuration_options\r\nhttps://docs.joomla.org/Smart_Search_on_large_sites\r\n\r\nthere for it would be fine when some one could have a look in my problem.\r\nwhen i missed a info what it would good to know, please give me a hint.\r\nI'm not a developer or programmer, i hope it is not a problem to get help here.\r\n\r\n### Steps to reproduce the issue\r\n- run smart indexer from backend results in the issue.\r\n- also when i run the smart indexer in the CLI\r\ni used this command to test the smart search indexer from CLI:\r\n```\r\n/RunCloud/Packages/php72rc/bin/php -d memory_limit=256M webapps/mywebapp/cli/finder_indexer.php --purge\r\n```\r\nin the documentations i found a info to change the temporary memory size. i did so from 32M to:\r\n```\r\ntmp_table_size = 64M\r\nmax_heap_table_size = 64M \r\n```\r\nwithout positiv result - after i have restarted the MYSQL service the problem still exists.\r\n\r\nI changed also for testing purposes the \"batch size\" to \"5\", but that does also not help - same error came up.\r\n\r\ni also consulted with my server administration host (runcloud.io). they are saying that this error is not in there scope - answer from support:\r\n> It looks like an application level issue, we do not provide any application level support, you would have to upgrade it to the latest one or get in touch with the Joomla support team, they can help you with this.\r\n\r\n### Expected result\r\nthe smart indexer should run without error and finish the process.\r\n\r\n\r\n### Actual result\r\nthe process is stopping always in the last third of the process with this error message in the CLI\r\n```\r\n* Processed batch 92 in 5.166 seconds.\r\nYou have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'LIMIT 12' at line 1\r\n```\r\nor the error message from the backend:\r\n![2018-09-30_21-27-17](https://user-images.githubusercontent.com/1003469/46393990-d9e1d080-c6e7-11e8-8b8a-0f8e16277591.jpg)\r\n\r\n### System information (as much as possible)\r\nSERVER: cloudserver - Linux ubuntu 18 x64\r\nSERVER Administration: [runcloud.io](https://runcloud.io/)\r\nDatabase: 5.5.5-10.2.15-MariaDB-1:10.2.15+maria~bionic-log\r\nPHP: 7.2.8\r\nWebserver: Apache/2.4.34\r\nJoomla: 3.8.12\r\n\r\n#### Smart Search Indexer OPTIONS are set all on default\r\nIndexer Batch Size: 50\r\nMemory Table Limit: 30000\r\n\r\n### Additional comments\r\n"}}
{"actor":{"display_login":"infograf768"}}