JA Job Board Component 8,554 posts

[brentwilliams2 Friend brentwilliams2Join date: January 2013Posts: 231Downloads:0Uploads:23 Thanks: 4 Thanked: 33 times in 1 posts]

#191518

When logging in as an employer and visiting the job list layout, I am now getting this error after upgrading to 1.0.5.

500 – JDatabaseMySQL::query: 1054 – Unknown column ‘a.complete’ in ‘where clause’ SQL=SELECT a.id AS transactionid, a.completed, b.id as subscriptionid, b.duration, b.units, a.created_date, a.processed_date, a.user_id FROM jos_ja_transactions a INNER JOIN jos_ja_subscriptions b ON a.product_id = b.id WHERE a.user_id = 4074 AND a.product_type = ‘S’ AND a.complete = 1 AND ( ISNULL(a.reason) OR a.reason <> ‘Reverse’ ) ORDER BY a.id DESC LIMIT 1

[Luna Garden Moderator Luna GardenJoin date: July 2011Posts: 2617Downloads:80Uploads:96 Thanks: 78 Thanked: 453 times in 425 posts]

#509636

Hello Brentwilliams2,

Please go to file :
<blockquote>modulesmod_jajobboard_menuhelper.php</blockquote>
and
<blockquote>componentscom_jajobboardmodelsjaemployers.php</blockquote>
Find for:

AND a.complete = 1
change to:

AND a.completed = 1

[brentwilliams2 Friend brentwilliams2Join date: January 2013Posts: 231Downloads:0Uploads:23 Thanks: 4 Thanked: 33 times in 1 posts]

#509755

All fixed – thanks!

[Author]

Posts