Unable to update Joomla (from 3.9.8 to 3.9.10) and we receive an error 1064 error in syntax
Although late, I post the solution for future people because
JS Kart Quickstart and JS Marketplace Quickstart are still affected by this bug.
You have to check the tables
#__update_sites and
#__update_sites_extensions, in my case both were empty.
#__update_sites must have (or you have to create) these entries:
- 1, 'Joomla! Core', 'collection', '
https://update.joomla.org/core/list.xml', 1, 0
- 2, 'Accredited Joomla! Translations', 'collection', '
https://update.joomla.org/language/translationlist_3.xml', 1, 0
- 3, 'Joomla! Update Component Update Site', 'extension', '
https://update.joomla.org/core/extensions/com_joomlaupdate.xml', 1, 0
#__update_sites_extensions must have (or you have to create) these entries:
- 1, 700
- 2, 802
- 3, 28
After that you can rebuild the update sites from Extensions -> Manage -> Update Sites -> Rebuild and update your Joomla installation from Components -> Joomla! Update
Cheers.