Results 1 to 3 of 3

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

This is a discussion on 1054 - Unknown column 'a.authors_id' in 'on clause' within the osCmax v2 Customization/Mods forums, part of the osCmax v2.0 Forums category; When I enabled the articles, authors, cross sells, I get the following error: 1054 - Unknown column 'a.authors_id' in 'on ...

      
  1. #1
    New Member dragonkeeper1973's Avatar
    Join Date
    Jan 2007
    Posts
    14
    Rep Power
    0


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

    When I enabled the articles, authors, cross sells, I get the following error:

    1054 - Unknown column 'a.authors_id' in 'on clause'
    select count(*) as total 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]

    Is there any way to fix this problem?

    Server info:
    Linux
    Apache Version
    1.3.37 (Unix)
    PHP version 5.1.6
    MySQL client version: 4.1.21
    MySQL details as provided by host:
    • Server version: 5.0.27-standard-log
    • Protocol version: 10
    • Server: Localhost via UNIX socket

    The page that the error happens on is when I click the all articles and on the article it's self. I also had created article topic categories under the admin section.

    Thanks for any info.

    Dallas
    Last edited by dragonkeeper1973; 01-31-2007 at 01:55 AM.

  2. #2
    New Member
    Join Date
    Oct 2004
    Posts
    21
    Rep Power
    0


    Default Re: 1054 - Unknown column 'a.authors_id' in 'on clause'

    I don't know the answer, but maybe can give you a lead. This looks like it might be a MySQL version 5 issue with joins. See this thread for more information and some good links to other info:

    I know you show MySQL 4.x in your post, but make sure you verify in your account (or contact your host) which version you are using. Many hosts have been upgrading to MySQL 5 recently.
    Keilup

    www.eboxofstuff.com
    \"Home of the Flex-e-Wizard FlipAlbum/FlipPublisher Add-on\"

  3. #3
    New Member
    Join Date
    Dec 2006
    Posts
    7
    Rep Power
    0


    Default Re: 1054 - Unknown column 'a.authors_id' in 'on clause'

    I found this fix that worked for me - I think php 5 is the problem, but this solved it:

    Article Manager v1.0 - osCommerce Community Support Forums

Similar Threads

  1. 1054 - Unknown column 'a.authors_id' in 'on clause'
    By fuzzyphil in forum osCmax v2 Customization/Mods
    Replies: 29
    Last Post: 01-08-2009, 05:05 PM
  2. Error: 1054 - Unknown column
    By islander in forum osCmax v2 Installation issues
    Replies: 1
    Last Post: 02-27-2006, 12:31 PM
  3. 1054 - Unknown column 'p.vendors_product_price'
    By RoyceK in forum osCmax v2 Installation issues
    Replies: 1
    Last Post: 02-12-2006, 09:22 PM
  4. 1054 - Unknown column when restock product
    By DigitalPimp in forum osCmax v2 Customization/Mods
    Replies: 3
    Last Post: 07-25-2005, 03:57 PM
  5. 1054 - Unknown column - Help, please !
    By Anonymous in forum osCommerce 2.2 Modification Help
    Replies: 2
    Last Post: 11-27-2002, 12:48 PM

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
  •