Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • brentwilliams2 Friend
    #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
    #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
    #509755

    All fixed – thanks!

Viewing 3 posts - 1 through 3 (of 3 total)

This topic contains 3 replies, has 2 voices, and was last updated by  brentwilliams2 10 years, 8 months ago.

We moved to new unified forum. Please post all new support queries in our New Forum