Keyword

SQL syntax Error with K2

  • Tolulope Oyebola
  • Tolulope Oyebola's Avatar Topic Author
  • Offline
  • New Member
More
11 years 10 months ago #105547 by Tolulope Oyebola
SQL syntax Error with K2 was created by Tolulope Oyebola
Hello,

I'm trying to update my site so i created from scratch afresh. I exported my old database to the new one i'm using for the new site installation.

All other components work well except for K2 Blog. it keeps giving me SQL syntax errors. eg:
"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 '20,26,137,34,35,130' at line 1 SQL=SELECT ordering AS value, title AS text FROM husrm_k2_items WHERE catid=16,20,26,137,34,35,130"

Any help o resolve this please as it doesnt allow k2 to work well on the new site.

Regards

Tolu

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

More
11 years 10 months ago #105548 by Lefteris
Replied by Lefteris on topic Re: SQL syntax Error with K2
Hi. Ensure that the table prefix is the correct one ( check this under Joomla! configuration).

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

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

  • Tolulope Oyebola
  • Tolulope Oyebola's Avatar Topic Author
  • Offline
  • New Member
More
11 years 10 months ago #105549 by Tolulope Oyebola
Replied by Tolulope Oyebola on topic Re: SQL syntax Error with K2
Hello,

Table prefix is very correct sir.

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

More
11 years 10 months ago #105550 by Lefteris
Replied by Lefteris on topic Re: SQL syntax Error with K2
The query is not coming from K2 ( it's not present at K2 2.6.1). Probably other extensions are causing this. Search for K2 related extensions and try to disable them.

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