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 ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| ||||
| ||||
| 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:
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. |
| Sponsored Links | ||
| ||
|
#2
| |||
| |||
| 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
| |||
| |||
| 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 |
| Sponsored Links | ||
| ||
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| 1054 - Unknown column 'a.authors_id' in 'on clause' | fuzzyphil | osCMax v2 Customization/Mods | 27 | 10-23-2008 12:09 AM |
| Error: 1054 - Unknown column | islander | osCMax v2 Installation issues | 1 | 02-27-2006 12:31 PM |
| 1054 - Unknown column 'p.vendors_product_price' | RoyceK | osCMax v2 Installation issues | 1 | 02-12-2006 09:22 PM |
| 1054 - Unknown column when restock product | DigitalPimp | osCMax v2 Customization/Mods | 3 | 07-25-2005 03:57 PM |
| 1054 - Unknown column - Help, please ! | Anonymous | osCommerce 2.2 Modification Help | 2 | 11-27-2002 12:48 PM |