1064 error on my home page help please

Please help anyone

My site needs to go live in one day and now im getting this error that i dont know how to fix it

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 7 SQL=SELECT c.id AS id, c.video AS video FROM ibc_k2_items AS c WHERE c.id IN ()
It appears the page you were looking for doesn't exist. Sorry about that.

Please help and thank you in advance.

Hi

This error appears when NSP module is trying to display a none existing article. Please check source of each NSP module and see if it's not configured to wrong sources.

Hi

This error appears when NSP module is trying to display a none existing article. Please check source of each NSP module and see if it's not configured to wrong sources.

I'm having a related problem. When I click any item in the NSPgk4 module on my Home page, I get the following 1064 error:

Code: Select all

1064
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 'content.id = 12 OR content.id = 13 OR content.id = 14 OR content.id = 16 OR ' at line 27 SQL=SELECT categories.title AS cat, content.id AS ID, content.access AS access, categories.title AS cat, users.email AS author_email, users.name AS author, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count, categories.id AS CID FROM nxug2_content AS content LEFT JOIN nxug2_categories AS categories ON categories.id = content.catid LEFT JOIN nxug2_content_frontpage AS frontpage ON content.id = frontpage.content_id LEFT JOIN nxug2_users AS users ON users.id = content.created_by LEFT JOIN nxug2_content_rating AS content_rating ON content_rating.content_id = content.id WHERE 1=1 content.id = 12 OR content.id = 13 OR content.id = 14 OR content.id = 16 OR content.id = 17 OR content.id = 18AND ( content.id = 12 OR content.id = 13 OR content.id = 14 OR content.id = 16 OR content.id = 17 OR content.id = 18) AND categories.published = 1 ORDER BY content.created ASC

It happens with both NSPgk4 and 5. I have verified that the data source is for K2 categories which definitely have items published to them.

The site is Joomla 3.3.6, and I'm running K2 2.6.9, which I recently upgraded. I have PHP 5.3.28 and MySQL 5.0.96.
Do you think this is a MySQL version issue? I noted that in K2 2.6.8 they changed the MyISAM storage engine indices to InnoDB.

Any help is appreciated.

Railer

Hi

Sorry for replying know. Yes I found the problem and got it fixed.

Thanks

Hi

@railer it's not database version related. It's only a wrong source settings. Please disable all NSP modules than start publishing them back. The first published after the error shows again will need to have source settings checked.

Hi

@railer it's not database version related. It's only a wrong source settings. Please disable all NSP modules than start publishing them back. The first published after the error shows again will need to have source settings checked.

Thanks Teitbite,

Whew! That was a relief. I had a copy of a Latest News NSPgk4 which had Joomla Categories selected as the data source, but there were no articles published to it. I had no idea that all GK modules affect one another.

I unpublished it and everything works again.

Thanks so much!

Hey guys I'm struggling with this error 1064. Here's what I did. I went to Module manager>NSP GK5> Data Source>Source of Articles>K2 Categories. But nothing happens even if I change the sources of articles or when I unpublish the module. Please please help my site was supposed to have been live on 22nd January.

Hey guys I'm struggling with this error 1064. Here's what I did. I went to Module manager>NSP GK5> Data Source>Source of Articles>K2 Categories. But nothing happens even if I change the sources of articles or when I unpublish the module. Please please help my site was supposed to have been live on 22nd January.

Hi UmzoboAdmin — If you're sure that all of your K2 categories selected as a "Data Source" in NPSgk5 has items assigned to them, then I'd do what Teitbite suggested.
Which is to unpublish all of your GK modules and then publish them one at a time, checking each time to see if the error has gone away. Then you know which module is causing the problem and can address it directly — checking its data source. It worked for me. Good luck!

Thank you thank you thank you thank you thank you Railer! My client was starting to put me under a panic situation

Thank you thank you thank you thank you thank you Railer! My client was starting to put me under a panic situation

Well, it sounds you got it resolved. Awesome! But don't thank me, I just restated what Teitbite said, so the thanks ought to go to him.
Cheers,
Railer