osCmax v2.5 User Manual
Results 1 to 2 of 2

articles section problem (the 1054..)

This is a discussion on articles section problem (the 1054..) within the osCmax v2 Customization/Mods forums, part of the osCmax v2.0 Forums category; 1054 - Unknown column 'a.authors_id' in 'on clause' select a.articles_id from articles a, articles_to_topics a2t left join topics_description td on ...

      
  1. #1
    osCMax Testing Team
    Join Date
    Jun 2004
    Posts
    258
    Rep Power
    0


    Default articles section problem (the 1054..)

    1054 - Unknown column 'a.authors_id' in 'on clause'

    select a.articles_id from articles a, articles_to_topics a2t left join topics_description td on a2t.topics_id = td.topics_id left join authors au on a.authors_id = au.authors_id, articles_description ad where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a.articles_id = ad.articles_id and ad.language_id = '1' and td.language_id = '1'

    [TEP STOP]

    I've been reading up on the old threads and the fix for this, but I guess the site I'm using it has a different oscmax template and some of the codes aren't code that is supposed to be fixed, so I'm kind of stuck on how to fix the articles manager problem right now.

  2. #2
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,907
    Rep Power
    568


    Default Re: articles section problem (the 1054..)

    You can compare your custom template files to the working fallback template files and add in the correct mysql queries.
    Michael Sasek
    osCMax Developer


    osCmax Installation Service
    - Have our professionals install osCmax on your server - same day service!
    osCmax 2.5 User Manual - the must have beginners guide to osCmax v2.5

    Stay Up To Date with everything osCMax:
    Free osCmax Newsletters - Security notices, New Releases, osCMax News
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

Similar Threads

  1. Unable to add products to articles with Cross-Sell Articles
    By jdistad in forum osCmax v2 Installation issues
    Replies: 5
    Last Post: 04-18-2011, 11:21 AM
  2. problem after installing in admin/catalog section
    By MrE03 in forum osCmax v2 Installation issues
    Replies: 0
    Last Post: 06-19-2008, 02:50 AM
  3. What would it take to get Ultimate SEO urls to work on the articles section?
    By aaanativearts in forum osCmax v2 Customization/Mods
    Replies: 1
    Last Post: 05-26-2007, 08:50 PM
  4. Articles Problem - Unknown column 'a.authors_id' in 'on clause'
    By dononeil in forum osCmax v2 Installation issues
    Replies: 3
    Last Post: 04-19-2007, 11:03 PM
  5. Problem (error 1054)
    By Yari_Gio in forum osCmax v1.7 Discussion
    Replies: 0
    Last Post: 10-26-2004, 01:54 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •