- Posts: 14
COMMUNITY FORUM
Error 1064: database error in K2 table
- Roger
-
Topic Author
- Offline
- New Member
Less
More
8 years 8 months ago #156896
by Roger
Error 1064: database error in K2 table was created by Roger
Hello
I'm suddenly facing problems with the database tables of k2. I'm running Joomla 3.6 with K2 2.7.1. Reinstalled K2 2.7 and also 2.6.9 and then back to 2.7.1. Unfortunately without any luck. No other software installations, created a new k2 article. Worked fine at the beginning, now I get the error below.
Any ideas?
Thank you
I'm suddenly facing problems with the database tables of k2. I'm running Joomla 3.6 with K2 2.7.1. Reinstalled K2 2.7 and also 2.6.9 and then back to 2.7.1. Unfortunately without any luck. No other software installations, created a new k2 article. Worked fine at the beginning, now I get the error below.
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 <= '2016-08-09 18:46:59' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2016-08-09 18:46:59' ) AND i.catid IN (11,22)Any ideas?
Thank you
Please Log in or Create an account to join the conversation.
- Roger
-
- Offline
- New Member
Less
More
- Posts: 14
8 years 8 months ago #156934
by Roger
Replied by Roger on topic Error 1064: database error in K2 table
Same again, this error broke my productive page again. Any thoughts?
Please Log in or Create an account to join the conversation.
- Roger
-
- Offline
- New Member
Less
More
- Posts: 14
8 years 8 months ago #156937
by Roger
Replied by Roger on topic Error 1064: database error in K2 table
In the mean time I found out that the problem is connected to the JA News Featured module from the T3 templates from Joomlart.
Please Log in or Create an account to join the conversation.
- Krikor Boghossian
-
- Offline
- Platinum Member
Less
More
- Posts: 15920
8 years 8 months ago #157006
by Krikor Boghossian
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Replied by Krikor Boghossian on topic Error 1064: database error in K2 table
Thank you for reporting the culprit Roger.
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Please Log in or Create an account to join the conversation.
- Yuriy Boev
-
- Offline
- New Member
Less
More
- Posts: 10
8 years 5 months ago #158959
by Yuriy Boev
Replied by Yuriy Boev on topic Error 1064: database error in K2 table
Hello,
I have found the problem in mod_janews_featured/helpers/adapter/k2.php
This line was wrong $aid = $user->get(‘aid’);
The correct one is $aid = $user->get(‘aid’) ? $user->get(‘aid’) : 1;
I'm not sure however why the correct user ID is not set.
I have found the problem in mod_janews_featured/helpers/adapter/k2.php
This line was wrong $aid = $user->get(‘aid’);
The correct one is $aid = $user->get(‘aid’) ? $user->get(‘aid’) : 1;
I'm not sure however why the correct user ID is not set.
Please Log in or Create an account to join the conversation.
- Krikor Boghossian
-
- Offline
- Platinum Member
Less
More
- Posts: 15920
8 years 5 months ago #158988
by Krikor Boghossian
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Replied by Krikor Boghossian on topic Error 1064: database error in K2 table
Have you reported it to JoomlArt?
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Please Log in or Create an account to join the conversation.
- Roger
-
- Offline
- New Member
Less
More
- Posts: 14
8 years 5 months ago #158998
by Roger
Replied by Roger on topic Error 1064: database error in K2 table
Hello
Did not have the time to try it yet. But I will report it to Joomlart, so that they can fix it.
Thanks
Roger
Did not have the time to try it yet. But I will report it to Joomlart, so that they can fix it.
Thanks
Roger
Please Log in or Create an account to join the conversation.
- Krikor Boghossian
-
- Offline
- Platinum Member
Less
More
- Posts: 15920
8 years 5 months ago #159002
by Krikor Boghossian
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Replied by Krikor Boghossian on topic Error 1064: database error in K2 table
If they are aware of it, they can provide a fix.
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Please Log in or Create an account to join the conversation.
- Roger
-
- Offline
- New Member
Less
More
- Posts: 14
8 years 5 months ago #159049
by Roger
Replied by Roger on topic Error 1064: database error in K2 table
Please Log in or Create an account to join the conversation.
- Krikor Boghossian
-
- Offline
- Platinum Member
Less
More
- Posts: 15920
8 years 5 months ago #159061
by Krikor Boghossian
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Replied by Krikor Boghossian on topic Error 1064: database error in K2 table
Thank you Roger :)
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Please Log in or Create an account to join the conversation.