Forums

John
John
Offline
Resolved
0 votes
Hi all,

Recently we encountered the problem that we are unable to add new users to a site made with Joomla with the following error message:
Save failed with the following error: 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 ' 3)' at line 3 SQL=INSERT INTO `#__user_usergroup_map` (`user_id`,`group_id`) VALUES (, 3)

ClearOS version 7.3, Joomla version 3.6.5, PHP version 5.4.16
We where able to fix this by manually editing the PHPMyAdmin table "<prefix>_users" and changing the id entry from 0 to the currently highest number + 1.

Manually patching the "<prefix>_contact_details" table is required as well, when creating a contact (highest number + 1).
But ... when we attempt to add/edit a Joomla contact, we encounter a similar issuewith the following error message:
Save failed with the following error: Duplicate entry '0' for key 'PRIMARY' SQL=INSERT INTO `#__ucm_history` (`ucm_item_id`,`ucm_type_id`,`version_note`,`save_date`,`editor_user_id`,`character_count`,`sha1_hash`,`version_data`) VALUES ('30','3','','2017-04-18 12:10:42','475','1796','0a77a4e1d9bf7a121d06526a55049454314f7a3c','{\"id\":30,\"name\":\"Daniel W.\",\"alias\":\"daniel-w\",\"con_position\":\"Programmeur \\/ Designer\",\"address\":\"Koningin Wilhelminalaan 6\",\"suburb\":\"Utrecht\",\"state\":\"\",\"country\":\"\",\"postcode\":\"3734 AC\",\"telephone\":\"030 - 760 2 760\",\"fax\":\"\",\"misc\":\"\",\"image\":\"\",\"email_to\":\"danielw@ict-stadsbrug.nl\",\"default_con\":0,\"published\":\"1\",\"checked_out\":\"475\",\"checked_out_time\":\"2017-04-18 12:10:29\",\"ordering\":\"20\",\"params\":\"{\\\"show_contact_category\\\":\\\"\\\",\\\"show_contact_list\\\":\\\"\\\",\\\"presentation_style\\\":\\\"\\\",\\\"show_tags\\\":\\\"\\\",\\\"show_name\\\":\\\"\\\",\\\"show_position\\\":\\\"\\\",\\\"show_email\\\":\\\"\\\",\\\"show_street_address\\\":\\\"\\\",\\\"show_suburb\\\":\\\"\\\",\\\"show_state\\\":\\\"\\\",\\\"show_postcode\\\":\\\"\\\",\\\"show_country\\\":\\\"\\\",\\\"show_telephone\\\":\\\"\\\",\\\"show_mobile\\\":\\\"\\\",\\\"show_fax\\\":\\\"\\\",\\\"show_webpage\\\":\\\"\\\",\\\"show_misc\\\":\\\"\\\",\\\"show_image\\\":\\\"\\\",\\\"allow_vcard\\\":\\\"\\\",\\\"show_articles\\\":\\\"\\\",\\\"articles_display_num\\\":\\\"\\\",\\\"show_profile\\\":\\\"\\\",\\\"show_links\\\":\\\"\\\",\\\"linka_name\\\":\\\"\\\",\\\"linka\\\":false,\\\"linkb_name\\\":\\\"\\\",\\\"linkb\\\":false,\\\"linkc_name\\\":\\\"\\\",\\\"linkc\\\":false,\\\"linkd_name\\\":\\\"\\\",\\\"linkd\\\":false,\\\"linke_name\\\":\\\"\\\",\\\"linke\\\":false,\\\"contact_layout\\\":\\\"\\\",\\\"show_email_form\\\":\\\"\\\",\\\"show_email_copy\\\":\\\"\\\",\\\"banned_email\\\":\\\"\\\",\\\"banned_subject\\\":\\\"\\\",\\\"banned_text\\\":\\\"\\\",\\\"validate_session\\\":\\\"\\\",\\\"custom_reply\\\":\\\"\\\",\\\"redirect\\\":\\\"\\\"}\",\"user_id\":\"486\",\"catid\":\"4\",\"access\":\"1\",\"mobile\":\"\",\"webpage\":\"http:\\/\\/ict-stadsbrug.nl\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2017-04-18 11:29:21\",\"created_by\":\"475\",\"created_by_alias\":\"\",\"modified\":\"2017-04-18 12:10:42\",\"modified_by\":\"475\",\"metakey\":\"\",\"metadesc\":\"\",\"metadata\":\"{\\\"robots\\\":\\\"\\\",\\\"rights\\\":\\\"\\\"}\",\"featured\":\"0\",\"xreference\":\"\",\"publish_up\":\"0000-00-00 00:00:00\",\"publish_down\":\"0000-00-00 00:00:00\",\"version\":4,\"hits\":\"0\"}')

AFAIK it is not table <prefix>_ucm_history.
Please assist,

John
Tuesday, April 18 2017, 12:54 PM
Share this post:
Responses (0)
  • There are no replies here yet.
Your Reply