This is a discussion on Mysql error in article manager 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 count(*) as total from articles a, articles_to_topics a2t left join topics_description ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| |||
| |||
| 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 = '4' and td.language_id = '4' I think that it is a mysql5 problem, but I can not correct it, badly need help. |
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Problems with Article Manager | jbanda | osCMax v2 Features Discussion | 0 | 07-18-2006 12:28 PM |
| Article Manager | pglock | osCMax v2 Features Discussion | 2 | 03-26-2006 12:10 PM |
| Article Manager with MS2-MAX | oakhill | osCMax v1.7 General Mods Discussion | 1 | 03-30-2005 04:25 AM |
| converting article manager to MS2-MAX | Anonymous | osCMax v1.7 General Mods Discussion | 5 | 11-25-2004 02:48 PM |
| MS2-Max & article manager | Anonymous | osCMax v1.7 Discussion | 0 | 03-23-2004 01:57 PM |