Hello RB,

Is it possible for you to provide us with the back end and FTP access to your site to check on this issue? By the way, where are you hitting this particular error?

Hello Mark,

The error occurs when I click in Blog Entries in backend.

Best Regards,
Ricardo

Hello,

Can you please set the user stackideas with super administrator privilege? I need to install a database manager on your Joomla site to run some sql query test.

Hi Mark,

try now.

Ricardo

Hello Ricardo,

Hm, there's something really weird with the database structure. Is it possible for you to also provide me with the phpmyadmin acccess? I can't run the query through the SQL manager

Hi Mark,

try now phpmyadmin access.

Ricardo

Hello,

Hm, something is not right with the database because when I tried to run the same query, I seem to be hitting this,

#126 - Incorrect key file for table '/tmp/#sql_4da_0.MYI'; try to repair it

Can you check with your hosting provider and see if they can fix this?

Hello Mark,

I solved the problem by increasing the size of tmp folder.

I have 92000 posts and query

"SELECT DISTINCT a.*, tp.`team_id`, t.`title` as `teamname`, g.`group_id` as `external_group_id`, e.`uid` as `external_event_id` FROM `rv_easyblog_post` AS a LEFT JOIN rv_easyblog_team_post AS tp ON a.`id`=tp.`post_id` LEFT JOIN rv_easyblog_team AS t ON tp.`team_id`=t.`id` LEFT JOIN rv_easyblog_external_groups AS g ON a.`id` = g.`post_id` LEFT JOIN rv_easyblog_external AS e ON a.`id` = e.`post_id` LEFT JOIN rv_easyblog_featured AS f ON a.`id` = f.`content_id` AND f.`type`="post" WHERE a.`published` IN ('1','0','2') AND `ispending` = '0' ORDER BY a.id DESC, ordering LIMIT 0, 20"

is heavy

I could also not access the posts through http://url/easyblog/latest


Ricardo Borges

Hello Mark,

The query can be optimized in a new version?

"SELECT DISTINCT a.*, tp.`team_id`, t.`title` as `teamname`, g.`group_id` as `external_group_id`, e.`uid` as `external_event_id` FROM `rv_easyblog_post` AS a LEFT JOIN rv_easyblog_team_post AS tp ON a.`id`=tp.`post_id` LEFT JOIN rv_easyblog_team AS t ON tp.`team_id`=t.`id` LEFT JOIN rv_easyblog_external_groups AS g ON a.`id` = g.`post_id` LEFT JOIN rv_easyblog_external AS e ON a.`id` = e.`post_id` LEFT JOIN rv_easyblog_featured AS f ON a.`id` = f.`content_id` AND f.`type`="post" WHERE a.`published` IN ('1','0','2') AND `ispending` = '0' ORDER BY a.id DESC, ordering LIMIT 0, 20"

Hello,

Hm, can I know what errors or logs are you getting there?