COMMUNITY FORUM

Database issue.

Start
Prev
1
Next
End

Kieron Novak
Topic Author
Offline
New Member

8 years 2 weeks 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
Offline
Platinum Member
Joomla Developer

8 years 2 weeks 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
Topic Author
Offline
New Member

8 years 2 weeks ago - 8 years 2 weeks 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: 8 years 2 weeks ago by Kieron Novak.

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

Mohamed Abdelaziz
Offline
Platinum Member
Joomla Developer

8 years 2 weeks 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
Topic Author
Offline
New Member

8 years 2 weeks 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
Offline
Platinum Member

8 years 2 weeks 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
Topic Author
Offline
New Member

8 years 2 weeks ago - 8 years 2 weeks 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: 8 years 2 weeks ago by Kieron Novak.

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

Krikor Boghossian
Offline
Platinum Member

8 years 2 weeks 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
Topic Author
Offline
New Member

8 years 2 weeks 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
Offline
Platinum Member

8 years 2 weeks 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.

Kieron Novak
Topic Author
Offline
New Member

8 years 1 week ago #161421 by Kieron Novak

Replied by Kieron Novak on topic Database issue.

I tried to repair tables from joomla and from adminphp. I tried to reinstall k2 over the old one but nothing.i saved the database and the files and after the update i put all the old ones back.

Note that i did everything i could think.

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

Krikor Boghossian
Offline
Platinum Member

8 years 1 week ago #161433 by Krikor Boghossian

Replied by Krikor Boghossian on topic Database issue.

Can you remember any operations you performed?

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
Topic Author
Offline
New Member

8 years 1 week ago #161441 by Kieron Novak

Replied by Kieron Novak on topic Database issue.

Nothing. The one day was ok and the other wasn't. The previous day i added an article and the other day when i couldn't receiving that specific error

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

Krikor Boghossian
Offline
Platinum Member

8 years 1 week ago #161487 by Krikor Boghossian

Replied by Krikor Boghossian on topic Database issue.

Any changes in PHP version/ server setup?

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
Topic Author
Offline
New Member

8 years 4 days ago #161543 by Kieron Novak

Replied by Kieron Novak on topic Database issue.

Nothing. I asked my hosting and they said they didn't changed anything

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

Krikor Boghossian
Offline
Platinum Member

8 years 4 days ago #161564 by Krikor Boghossian

Replied by Krikor Boghossian on topic Database issue.

Try the following,

Disable all extensions one by one to see which if this is caused by a 3rd party extension.

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

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

Start
Prev
1
Next
End