General Questions/New to Joomla! 3.x • Re: SQL syntax error when i save article with tags

Thank you for helping but the results are the same :

tags.php (from line 70 to 80)

$tags = array_unique($tags);



$query = $db->getQuery(true);

$query->insert($db->qn('#__contentitem_tag_map'));

$query->columns(

array(

$db->quoteName('type_alias'),

$db->quoteName('core_content_id'),

$db->quoteName('content_item_id'),

$db->quoteName('tag_id'),

$db->quoteName('tag_date'),

$db->quoteName('type_id')



In Backend after creating new article with tag :



Save failed with the following error: 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 '' at line 1 SQL=INSERT INTO `jos_contentitem_tag_map`



And the same error in tags manager :





Error



Save failed with the following error: exception 'UnexpectedValueException' with message 'TagsTableTag::_getNode(1, ) failed.' in /home/sa236595/public_html/libraries/joomla/table/nested.php:1542 Stack trace: #0 /home/sa236595/public_html/libraries/joomla/table/nested.php(783): JTableNested->_getNode('1') #1 /home/sa236595/public_html/administrator/components/com_tags/tables/tag.php(197): JTableNested->store(false) #2 /home/sa236595/public_html/administrator/components/com_tags/models/tag.php(343): TagsTableTag->store() #3 /home/sa236595/public_html/libraries/legacy/controller/form.php(736): TagsModelTag->save(Array) #4 /home/sa236595/public_html/libraries/legacy/controller/legacy.php(728): JControllerForm->save() #5 /home/sa236595/public_html/administrator/components/com_tags/tags.php(23): JControllerLegacy->execute('apply') #6 /home/sa236595/public_html/libraries/cms/component/helper.php(391): require_once('/home/sa236595/...') #7 /home/sa236595/public_html/libraries/cms/component/helper.php(371): JComponentHelper::executeComponent('/home/sa236595/...') #8 /home/sa236595/public_html/libraries/cms/application/administrator.php(98): JComponentHelper::renderComponent('com_tags') #9 /home/sa236595/public_html/libraries/cms/application/administrator.php(152): JApplicationAdministrator->dispatch() #10 /home/sa236595/public_html/libraries/cms/application/cms.php(252): JApplicationAdministrator->doExecute() #11 /home/sa236595/public_html/administrator/index.php(42): JApplicationCms->execute() #12 {main}

Statistics: Posted by polyzois12 — Sun Apr 19, 2015 5:04 am

---

via Joomla! http://ift.tt/1IXWbU4