1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Oscommerce Articles Manager Error

Discussion in 'PHP' started by ChocciChops, Apr 24, 2006.

0
  1. #1
    I have just installed artcle manager version 1.2 for oscommerce but just get the following errors -

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

    select a.articles_id, a.articles_date_added, a.articles_date_available, a.authors_id, ad.articles_name, ad.articles_description, ad.articles_url, au.authors_name from articles a, articles_description ad left join authors au on a.authors_id = au.authors_id where a.articles_status = '1' and a.articles_id = '1' and ad.articles_id = a.articles_id and ad.language_id = '1'

    [TEP STOP]

    I've had a read about and it seems its something to do with mysql v5 but im not positive.

    Anyone have any ideas how to solve this?

    thanks for your help all.
     
    ChocciChops, Apr 24, 2006 IP