This is a discussion on Mysql 5 + Article Manager - NOT Compatible in RC2 within the osCMax v2 Installation issues forums, part of the osCMax v2.0 Forums category; Stock oscmax RC2 store. We have upgraded server to Mysql 5 from Mysql 4 and everything except the articles manager ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| ||||
| ||||
| Stock oscmax RC2 store. We have upgraded server to Mysql 5 from Mysql 4 and everything except the articles manager works. The following code is displayed on the home page in the location the articles/reviews info box used to be in. Does anyone have a fix for this? Error: Code: 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' and a.articles_date_added > SUBDATE(now( ), INTERVAL '365' DAY) [TEP STOP] However, there is no link to download this patch that i canf ind. Can someone link this patch for me please. sincerely,
__________________ Clifton Murphy CEO/CTO Hyperactive Inc. osCommerce hosting, OSCMAX hosting, osCommerce modification, and OSCMAX modification specialists! Last edited by red_fraggle; 03-06-2008 at 02:08 PM. Reason: added patch link request |
|
#2
| ||||
| ||||
| The patch is in this thread: osCMax 2.0RC2 Security Patch/Update 051112
__________________ Michael Sasek osCMax Developer osCMax Templates - Hundreds of premium quality templates. New designs every month! xShop for osCMax - Windows Based osCMax administration. Improved workflow, security, speed and convenience osCMax Hosting - From basic hosting to High Availability, Load Balanced arrays, the most experienced osCMax host. |
|
#3
| ||||
| ||||
| thanks michael |
|
#4
| ||||
| ||||
| I installed the patch per instrucitons by overwriting all files. I ran the sql query which completed with no errors Code: ALTER TABLE whos_online MODIFY COLUMN last_page_url VARCHAR( 255 ) NOT NULL ;# Affected rows: 1 ALTER TABLE customers MODIFY COLUMN customers_default_address_id INTEGER;# Affected rows: 629 ALTER TABLE customers_basket MODIFY COLUMN final_price DECIMAL( 15, 4 ) ;# Affected rows: 297 Code: 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' and a.articles_date_added > SUBDATE(now( ), INTERVAL '365' DAY) [TEP STOP] sincerely,
__________________ Clifton Murphy CEO/CTO Hyperactive Inc. osCommerce hosting, OSCMAX hosting, osCommerce modification, and OSCMAX modification specialists! Last edited by red_fraggle; 03-07-2008 at 05:42 AM. |
|
#5
| |||
| |||
| Did you look at this thread 1054 - Unknown column 'a.authors_id' in 'on clause' |
|
#6
| |||
| |||
| To make it easier for those having this problem I have made the changes that mindtwist found and I am uploading 2 stock oscmax files from your templates content. Articles.tpl and Articles_new.tpl This should fix the error asked about above. |
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Article Manager v1.0 | michael_s | New osCommerce Contributions | 0 | 10-30-2007 08:00 PM |
| Reviews in Article Info (Article Manager) | michael_s | New osCommerce Contributions | 0 | 10-25-2007 07:26 AM |
| Reviews in Article Info (Article Manager) | michael_s | New osCommerce Contributions | 0 | 05-10-2007 02:00 PM |
| Mysql error in article manager | clauska | osCMax v2 Customization/Mods | 0 | 06-27-2006 01:11 AM |
| Compatible with PHP 4.33 and mysql 3.23 | the_error_king | osCMax v2 Installation issues | 6 | 06-15-2005 07:19 PM |