By Marc on Tuesday, 06 September 2016
Posted in Technical Issues
Likes 0
Views 441
Votes 0
We get this issue when we try to run the Easysocial cron:

HTTP request sent, awaiting response... 500 Column count doesn't match value count at row 1 SQL=insert into `#__social_stream_history` select a.* from `#__social_stream` as a where a.`id` IN (147852,147853,147704,147854,147839) ON DUPLICATE KEY UPDATE id = a.`id`
2016-09-05 22:10:17 ERROR 500: Column count doesn't match value count at row 1 SQL=insert into `#__social_stream_history` select a.* from `#__social_stream` as a where a.`id` IN (147852,147853,147704,147854,147839) ON DUPLICATE KEY UPDATE id = a.`id`.

How do we fix/clear this error?
Hey Marc,

Thanks for reported, try run this following sql query from your database.

Note : Remember replace jos_ to your table prefix.
ALTER TABLE `jos_social_stream_history` modify `params` LONGTEXT, add column `datafix` tinyint(1) default 1;
·
Tuesday, 06 September 2016 09:59
·
0 Likes
·
0 Votes
·
0 Comments
·
Unfortunately running those mysql updates didn't make any difference....
·
Tuesday, 06 September 2016 14:50
·
0 Likes
·
0 Votes
·
0 Comments
·
hey Marc,

Can you update your Joomla backend and FTP access at http://stackideas.com/dashboard/site so we can better have a check?
·
Tuesday, 06 September 2016 15:09
·
0 Likes
·
0 Votes
·
0 Comments
·
The details have been updated.
·
Tuesday, 06 September 2016 19:11
·
0 Likes
·
0 Votes
·
0 Comments
·
It should work fine now, can you give it a check?

By the way, that was my mistake in my previous solution, I will edit it again.
·
Tuesday, 06 September 2016 23:27
·
0 Likes
·
0 Votes
·
0 Comments
·
Perfect. All sorted.
Thanks for the prompt response
·
Wednesday, 07 September 2016 00:10
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi there,

You are most welcome. Glad to hear that your issue has been resolved now.

As a gentle reminder, kindly start a new thread if you have any other issue in the future so it will be easier for us to manage your inquiry. I will lock and mark this thread as resolved.
·
Wednesday, 07 September 2016 00:11
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post