1064 when choosing anything for Easyblog

News Show Pro GK5 - flexible, responsive and easily extendable free Joomla module support forum.
Rate this topic: Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.
GK User
Mon Jun 02, 2014 10:47 am
Error
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 = 1702 OR content.id = 1807 OR content.id = 1628 OR content.id = 1' at line 27 SQL=EXPLAIN SELECT content.id AS id, content.permalink AS alias, content.title AS title, content.intro AS text, content.created AS date, content.publish_up AS date_publish, content.hits AS hits, content.frontpage AS frontpage, content.category_id AS cid, categories.title AS catname, categories.alias AS cat_alias, users.email AS author_email, users.name AS author_username, content.created_by AS author_id, content.image AS image FROM x6rga_easyblog_post AS content LEFT JOIN x6rga_easyblog_category AS categories ON categories.id = content.category_id LEFT JOIN x6rga_users AS users ON users.id = content.created_by WHERE 1=1 content.id = 1702 OR content.id = 1807 OR content.id = 1628 OR content.id = 1797 OR content.id = 1665 OR content.id = 1799 OR content.id = 1806 OR content.id = 1754 OR content.id = 1723 ORDER BY RAND()
User avatar
Fresh Boarder

GK User
Mon Jun 02, 2014 10:58 am
And if I choose a Category instead of ALL

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 = 1807 ORDER BY RAND()' at line 27 SQL=EXPLAIN SELECT content.id AS id, content.permalink AS alias, content.title AS title, content.intro AS text, content.created AS date, content.publish_up AS date_publish, content.hits AS hits, content.frontpage AS frontpage, content.category_id AS cid, categories.title AS catname, categories.alias AS cat_alias, users.email AS author_email, users.name AS author_username, content.created_by AS author_id, content.image AS image FROM x6rga_easyblog_post AS content LEFT JOIN x6rga_easyblog_category AS categories ON categories.id = content.category_id LEFT JOIN x6rga_users AS users ON users.id = content.created_by WHERE 1=1 content.id = 1807 ORDER BY RAND()
User avatar
Fresh Boarder

GK User
Mon Jun 02, 2014 11:06 am
This is what breaks the Query

content.id = 1807

What the hell is is looking for an blog post with id 1807 when its set to pull all or pull all from a Category?
User avatar
Fresh Boarder

GK User
Mon Jun 02, 2014 11:13 am
select * from x6rga_easyblog_post where id=1807

This works and pulls down an article, so the bug is actually the

WHERE 1=1

This messes up the next WHERE which is valid , what IS THIS from?
User avatar
Fresh Boarder

GK User
Mon Jun 02, 2014 11:21 am
I have fixed this by REMOVING line 294 in the model.php 1=1

no idea why this useless sql where is added which just crashes this module.
User avatar
Fresh Boarder

teitbite
Thu Jun 05, 2014 8:37 am
Hi

Thanks for reporting this. I'll let programmers know.
User avatar
Moderator


cron