SQL insert error

  • Posts: 332
  • Thank you received: 6
9 years 6 months ago #230930

-- url of the page with the problem -- : carterrabbitclothing.com/hikashop-menu-f...ing/category/12-bags
-- HikaShop version -- : 2.6.1
-- Joomla version -- : 3.4.8
-- PHP version -- : 5.5
-- Browser(s) name and version -- : various
-- Error-message(debug-mod must be tuned on) -- : 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 XXXXX_contentitem_tag_map

I have a site that when I entered a product, I get this error message trying to add tags. The XXXXX_contentitem_tag_map table was completely empty but I went ahead and did a repair / optimize on the table. I tried again and got the same message. In both cases, the product record was saved in the XXXXX_hikashop_product table but nothing displays in the administrator side nor on the front public display for the product category. So I deleted both records from the product table and re-entered without any tags. The product was entered proper and does display now.

Please Log in or Create an account to join the conversation.

  • Posts: 84307
  • Thank you received: 13701
  • MODERATOR
9 years 6 months ago #230932

Hi,

That query is not in HikaShop. That table is actually a table of Joomla. I suppose that it's something related to the tags system of Joomla but I've never seen the issue.
So you don't have it anymore ?

Please Log in or Create an account to join the conversation.

  • Posts: 332
  • Thank you received: 6
9 years 6 months ago #231002

Nicholas,

It is still creating the error message. If I put anything in the 'tags' field, I get the error. If I leave the 'tags' field empty, it works as it should. Just to let you know, it does create the product record but it doesn't appear anywhere either in the frontend or the backend. It's like it never got indexed or linked.

Here is the example of what I tried to add when I got the error message.

Last edit: 9 years 6 months ago by LukeDouglas.

Please Log in or Create an account to join the conversation.

  • Posts: 84307
  • Thank you received: 13701
  • MODERATOR
9 years 6 months ago #231027

Hi,

The fact that you don't see the product anywhere is normal as the product is not yet associated to categories when the Joomla tags are processed. And that MySQL error stop the processing of the page.

So is it only when you create a product ? Or also if you update a product ?


I've done a test on my end with the latest version of Joomla and HikaShop, but it's working fine.

Please Log in or Create an account to join the conversation.

  • Posts: 332
  • Thank you received: 6
9 years 6 months ago #231071

Nicholas,

I used AdminTools to do a repair/optimize on the tables, used ACL Manager to check linkage (all green) and edited an existing product item to add tags. I got the same error message. Repaired/Optimized again, check ACL and tried to create a new product. Same error message. Something is really screwed up. I can live without tags but if this is messing up, what else could be going wrong with linkage. :(

Please Log in or Create an account to join the conversation.

  • Posts: 84307
  • Thank you received: 13701
  • MODERATOR
9 years 6 months ago #231144

Hi,

It seems to be a problem of the Joomla tags system:
forum.joomla.org/viewtopic.php?f=708&t=819609
However, I searched a bit more online but I couldn't fine any solution for that.

Please Log in or Create an account to join the conversation.

Time to create page: 0.062 seconds
Powered by Kunena Forum