JDatabaseMySQL::query: 1054 - Unknown column 'create'
By Jan on Monday, 10 February 2014
Posted in General Issues
Replies 3
Likes 0
Views 0.9K
Votes 0
Hi,
we came across database error during testing on email page .../administrator/index.php?option=com_easysocial&view=mailer

JDatabaseMySQL::query: 1054 - Unknown column 'create' in 'order clause' SQL=SELECT * FROM `xxx_social_mailer` ORDER BY `create` asc LIMIT 0, 20

Any ideas please?
Thank you
Regards
Hello Jan,

It looks like there's a typo there. Edit the file /administrator/components/com_easysocial/themes/default/mailer/default.php and at line 61 locate the codes below:



<?php echo $this->html( 'grid.sort' , 'create' , JText::_( 'COM_EASYSOCIAL_TABLE_COLUMN_CREATED' ) , $ordering , $direction ); ?>


Replace it with,



<?php echo $this->html( 'grid.sort' , 'created' , JText::_( 'COM_EASYSOCIAL_TABLE_COLUMN_CREATED' ) , $ordering , $direction ); ?>


After replacing the file, logout and login again to clear the session.
Mark
·
Monday, 10 February 2014 22:11
·
0 Likes
·
0 Votes
·
0 Comments
·
What an annoying 'd'
Thanks a lot! It helped.
Jan
·
Monday, 10 February 2014 22:40
·
0 Likes
·
0 Votes
·
0 Comments
·
You are most welcome
Mark
·
Monday, 10 February 2014 22:50
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post