1054 Unknown column 'p.language'
By Ben Wilson on Wednesday, 09 September 2015
Posted in Installation Issues
Likes 0
Views 867
Votes 0
Updated from 5.0.20 to 5.0.25 and now have this error when trying to create a new post:

1054 Unknown column 'p.language' in 'field list' SQL=select a.`post_id`, a.`key`, p.`language`, p.`title` from `vne5t_easyblog_associations` as a inner join `vne5t_easyblog_associations` as b on a.`key` = b.`key` inner join `vne5t_easyblog_post` as p on a.`post_id` = p.`id` where b.`post_id` = '125'
Hey Ben,

After investigate again, it seems like missing one of the columns again, I manually run this in your database, it work fine now.
ALTER TABLE `vne5t_easyblog_post` ADD `image` text;
Arlex Wong
·
Wednesday, 09 September 2015 23:34
·
0 Likes
·
0 Votes
·
0 Comments
·
Can you provide us with your Joomla backend, FTP and PHPMYADMIN access so we can take a look of this missing columns error issue?
Arlex Wong
·
Wednesday, 09 September 2015 13:32
·
0 Likes
·
0 Votes
·
0 Comments
·
Info attached. Thanks!
Ben Wilson
·
Wednesday, 09 September 2015 15:29
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Ben,

After manually add this `language` column in this table `#__easyblog_post`, it work fine now. 
ALTER TABLE `vne5t_easyblog_post` Add`language` char(7) NOT NULL;
Arlex Wong
·
Wednesday, 09 September 2015 16:02
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi,
The error is gone however there's still an issue with the extension. I'm unable to create new posts still. I hit create new, add a title and text, then hit save and publish. It appears to work but the new post doesn't exist anywhere that I can see.
Ben Wilson
·
Wednesday, 09 September 2015 22:40
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks Arlex. Looks good now.
Ben Wilson
·
Thursday, 10 September 2015 00:26
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks for updating Ben, glad that your issues are resolved now
Mark
·
Thursday, 10 September 2015 03:55
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post