Joomla Templates Club 406,261 posts

[palos Friend palosJoin date: January 2013Posts: 369Downloads:37Uploads:8 Thanks: 125 Thanked: 27 times in 7 posts]

#1000933

Some of the site’s editors noticed 1064 error last year and now I could reproduce it finally.
Not just reproduce but the site is gone and appears the error only.
It is in Chrome.

The strange thing is that it shows the site perfectly in a new incognito page.
Firefox also has no this problem.
???
I have never met this issue with JA templates or even with any Joomla site… or even at 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 ‘AND i.trash = 0 AND c.published = 1 AND c.access <= AND c.trash = 0 AND ( i.pu’ at line 3 SQL=SELECT count(i.id) FROM #__k2_items as i LEFT JOIN #__k2_categories c ON c.id = i.catid WHERE i.published = 1 AND i.access <= AND i.trash = 0 AND c.published = 1 AND c.access <= AND c.trash = 0 AND ( i.publish_up = ‘0000-00-00 00:00:00’ OR i.publish_up <= ‘2017-01-09 11:56:05’ ) AND ( i.publish_down = ‘0000-00-00 00:00:00’ OR i.publish_down >= ‘2017-01-09 11:56:05’ ) AND i.catid IN (64,100,121,101)

[Pankaj Sharma Moderator Pankaj SharmaJoin date: February 2015Posts: 24589Downloads:144Uploads:202 Thanks: 127 Thanked: 4196 times in 4019 posts]

#1000941

Hi
The error indicating from the K2 database table. For better understanding could u submit your site detail using private reply. So that I can take a look on it.

[palos Friend palosJoin date: January 2013Posts: 369Downloads:37Uploads:8 Thanks: 125 Thanked: 27 times in 7 posts]

#1000962

This reply has been marked as private.

[Pankaj Sharma Moderator Pankaj SharmaJoin date: February 2015Posts: 24589Downloads:144Uploads:202 Thanks: 127 Thanked: 4196 times in 4019 posts]

#1000967

This reply has been marked as private.

[palos Friend palosJoin date: January 2013Posts: 369Downloads:37Uploads:8 Thanks: 125 Thanked: 27 times in 7 posts]

#1000970

This reply has been marked as private.

[Pankaj Sharma Moderator Pankaj SharmaJoin date: February 2015Posts: 24589Downloads:144Uploads:202 Thanks: 127 Thanked: 4196 times in 4019 posts]

#1001087

Hi
I checked your site and it looks fine, i suggest you when u got this issue just let me know here, Also check the error page with default Joomla template. Becuase its from K2 extension.
And you can write issue to k2 forum so you will get a better solution about this extension issue.

[palos Friend palosJoin date: January 2013Posts: 369Downloads:37Uploads:8 Thanks: 125 Thanked: 27 times in 7 posts]

#1074019

It seems that we have the issue right now!

[Pankaj Sharma Moderator Pankaj SharmaJoin date: February 2015Posts: 24589Downloads:144Uploads:202 Thanks: 127 Thanked: 4196 times in 4019 posts]

#1074155

This reply has been marked as private.

[palos Friend palosJoin date: January 2013Posts: 369Downloads:37Uploads:8 Thanks: 125 Thanked: 27 times in 7 posts]

#1074221

Hi Pankaj,
It has no error with beez3!

[palos Friend palosJoin date: January 2013Posts: 369Downloads:37Uploads:8 Thanks: 125 Thanked: 27 times in 7 posts]

#1074222

I am just trying to disable modules by modules on Home page…
And facing with an other issue that some of them resistant for clicking [save&close] button.
:O

[Pankaj Sharma Moderator Pankaj SharmaJoin date: February 2015Posts: 24589Downloads:144Uploads:202 Thanks: 127 Thanked: 4196 times in 4019 posts]

#1074225

Hi
Please share a temp superuser and FTP details of site in Private reply and how i will replicate this error on your site.
I will check it directly on your site.

Regards

[palos Friend palosJoin date: January 2013Posts: 369Downloads:37Uploads:8 Thanks: 125 Thanked: 27 times in 7 posts]

#1074230

Well, I have GOT IT! No Browser cache. No K2. Nor any theoretical 3rd party extension.

It is the: JA News Featured module at top-home1
Please help me to get rid this annoying issue what exists since months… year(s)!

[palos Friend palosJoin date: January 2013Posts: 369Downloads:37Uploads:8 Thanks: 125 Thanked: 27 times in 7 posts]

#1074233

This reply has been marked as private.

[palos Friend palosJoin date: January 2013Posts: 369Downloads:37Uploads:8 Thanks: 125 Thanked: 27 times in 7 posts]

#1074236

This reply has been marked as private.

[Pankaj Sharma Moderator Pankaj SharmaJoin date: February 2015Posts: 24589Downloads:144Uploads:202 Thanks: 127 Thanked: 4196 times in 4019 posts]

#1074433

Hi @palos
I noticed the issue is already fixed on your site from this fix.

Regards

[Author]

Posts