Keyword

Database issue.

  • Kieron Novak
  • Kieron Novak's Avatar Topic Author
  • Offline
  • New Member
More
7 years 1 month ago #161344 by Kieron Novak
Database issue. was created by Kieron Novak
Suddenly i am facing with this issue. When i am trying to save a new article i see the below msg and nothing is getting save.

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 '' at line 6 SQL=UPDATE jos_k2_items SET video_caption = '', video_credits = '', extra_fields = '[]', extra_fields_search = '' , published = '1' WHERE id =

This is on joomla 1.5.22

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

  • Mohamed Abdelaziz
  • Mohamed Abdelaziz's Avatar
  • Offline
  • Platinum Member
  • Joomla Developer
More
7 years 1 month ago #161349 by Mohamed Abdelaziz
Replied by Mohamed Abdelaziz on topic Database issue.
Hi,

First of all, it is highly recommended to upgrade to the latest Joomla 3 version.
Then, which K2 version have this issue?
Do you have any K2 plugins installed?
Do you find any javascript issues/errors?

Multiple Extra Fields Groups for K2
AutoMeta for K2
Chained Fields for K2
More K2 Extensions In My Extensions Store

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

  • Kieron Novak
  • Kieron Novak's Avatar Topic Author
  • Offline
  • New Member
More
7 years 1 month ago - 7 years 1 month ago #161357 by Kieron Novak
Replied by Kieron Novak on topic Database issue.
The k2 is 2.5.5. for now i will stick with joomla 1.5 and when i find time i will upgrade it. I can't find any other problems and the front works just fine. The back-end as well. The only issue i find is when i am trying to save articles. Yes i have k2 plugins install but it is just to show the articles in the front. It was working fine few days ago.

I disabled the plugins but the same issue exist.
Last edit: 7 years 1 month ago by Kieron Novak.

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

  • Mohamed Abdelaziz
  • Mohamed Abdelaziz's Avatar
  • Offline
  • Platinum Member
  • Joomla Developer
More
7 years 1 month ago #161358 by Mohamed Abdelaziz
Replied by Mohamed Abdelaziz on topic Database issue.
Well, maybe it is helpful to enable debugging and set error reporting to maximum or development to find out in which file the problem happened.
Make sure to disable debugging and set error reporting to its previous value after testing.

Multiple Extra Fields Groups for K2
AutoMeta for K2
Chained Fields for K2
More K2 Extensions In My Extensions Store

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

  • Kieron Novak
  • Kieron Novak's Avatar Topic Author
  • Offline
  • New Member
More
7 years 1 month ago #161363 by Kieron Novak
Replied by Kieron Novak on topic Database issue.
Hello. This is the error:

jDatabaseMySQL::query: 1064 - 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 ')}' at line 1 SQL=DELETE FROM jos_k2_tags_xref WHERE itemID={intval()}

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

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
7 years 1 month ago #161377 by Krikor Boghossian
Replied by Krikor Boghossian on topic Database issue.
2.5.5 and Joomla! 1.5.22 are not supported.
I would urge you to backup and update to Joomla! 1.5.26 and K2 2.7.1.

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

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

  • Kieron Novak
  • Kieron Novak's Avatar Topic Author
  • Offline
  • New Member
More
7 years 1 month ago - 7 years 1 month ago #161385 by Kieron Novak
Replied by Kieron Novak on topic Database issue.
I did the update to joomla 1.5.26 and to k2 2.6 but i dont want to try 2.7.1 cause there are issues. I already did that update and the back end was messed up and didn't fix the error. So can you help me? The website was working fine the one day ad the other had this issue. By the way this is happening only to k2 component. From joomla article component i can save articles
Last edit: 7 years 1 month ago by Kieron Novak.

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

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
7 years 1 month ago #161394 by Krikor Boghossian
Replied by Krikor Boghossian on topic Database issue.
You can try repairing your db's tables.
Where you always using MariaDB?

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

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

  • Kieron Novak
  • Kieron Novak's Avatar Topic Author
  • Offline
  • New Member
More
7 years 1 month ago #161400 by Kieron Novak
Replied by Kieron Novak on topic Database issue.
Yes this is the same db server

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

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
7 years 1 month ago #161410 by Krikor Boghossian
Replied by Krikor Boghossian on topic Database issue.
Did you try repairing the tables?

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

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


Powered by Kunena Forum