osCmax v2.5 User Manual
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Mysql 5 + Article Manager - NOT Compatible in RC2

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 ...

      
  1. #1
    Active Member red_fraggle's Avatar
    Join Date
    Feb 2004
    Location
    wilmington, NC
    Posts
    343
    Rep Power
    9


    Unhappy Mysql 5 + Article Manager - NOT Compatible in RC2

    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]
    In reading some articles here, i have found that this is fixed in the following patch: osCMax-2.0RC2-update051112

    However, there is no link to download this patch that i canf ind. Can someone link this patch for me please.

    sincerely,
    Last edited by red_fraggle; 03-06-2008 at 01:08 PM. Reason: added patch link request

  2. #2
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,907
    Rep Power
    568


    Default Re: Mysql 5 + Article Manager - NOT Compatible

    The patch is in this thread:
    osCMax 2.0RC2 Security Patch/Update 051112
    Michael Sasek
    osCMax Developer


    osCmax Installation Service
    - Have our professionals install osCmax on your server - same day service!
    osCmax 2.5 User Manual - the must have beginners guide to osCmax v2.5

    Stay Up To Date with everything osCMax:
    Free osCmax Newsletters - Security notices, New Releases, osCMax News
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  3. #3
    Active Member red_fraggle's Avatar
    Join Date
    Feb 2004
    Location
    wilmington, NC
    Posts
    343
    Rep Power
    9


    Default Re: Mysql 5 + Article Manager - NOT Compatible in RC2

    thanks michael

  4. #4
    Active Member red_fraggle's Avatar
    Join Date
    Feb 2004
    Location
    wilmington, NC
    Posts
    343
    Rep Power
    9


    Unhappy Re: Mysql 5 + Article Manager - NOT Compatible in RC2

    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
    However, the articles and reviews module still displays the following sql error on the homepage where the info box should be:


    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]
    
    Also, i have made sure that an author exists by creating one with the authors tool in the admin for this add-on, and i have even disabled ALL articles (using red button beside each article). The error still displays. Keep in mind no changes were made to this store, other than an upgrade of the server from Mysql4 to Mysql5.

    sincerely,
    Last edited by red_fraggle; 03-07-2008 at 04:42 AM.

  5. #5
    osCMax Testing Team
    Join Date
    Sep 2004
    Posts
    362
    Rep Power
    10


    Default Re: Mysql 5 + Article Manager - NOT Compatible in RC2


  6. #6
    osCMax Testing Team
    Join Date
    Sep 2004
    Posts
    362
    Rep Power
    10


    Default Re: Mysql 5 + Article Manager - NOT Compatible in RC2

    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.
    Attached Files Attached Files

  7. #7
    New Member
    Join Date
    Feb 2007
    Location
    Edinurgh
    Posts
    20
    Rep Power
    0


    Default Re: Mysql 5 + Article Manager - NOT Compatible in RC2

    Hi

    I have a similar problem with a V old OSC site I inherited

    The following query (on advanced search) works on MySQL3.23 and 4.xx but fails on V5 with 1054 - Unknown column 'p.products_id' in 'on clause'

    Code:
    select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id), products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c left join tax_rates tr on p.products_tax_class_id = tr.tax_class_id left join zones_to_geo_zones gz on tr.tax_zone_id = gz.geo_zone_id and (gz.zone_country_id is null or gz.zone_country_id = '0' or gz.zone_country_id = '222') and (gz.zone_id is null or gz.zone_id = '0' or gz.zone_id = '182') where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and (IF(s.status, s.specials_new_products_price, p.products_price) * if(gz.geo_zone_id is null, 1, 1 + (tr.tax_rate / 100) ) >= 45) and (IF(s.status, s.specials_new_products_price, p.products_price) * if(gz.geo_zone_id is null, 1, 1 + (tr.tax_rate / 100) ) <= 55)
    anybody know the mySQL5 equivalent to the above query?

  8. #8
    jpf
    jpf is offline
    osCMax Testing Team
    jpf's Avatar
    Join Date
    Sep 2003
    Location
    Manitoba, Canada
    Posts
    2,699
    Rep Power
    22


    Default Re: Mysql 5 + Article Manager - NOT Compatible in RC2

    Yes - It is not compatible.... with MySQL 5!

    You need MySQL v3.x or v4.x and php 4.x

    If you want Version 5 compatible - then use RC4-SVN version
    JPF - osCMax Fourm Moderator - To contact, post on the forum or click here
    Try out our osCMax at: Live Catalog Demo
    Limited access Admin: Live Admin Demo
    Feel free to add products they way you want and then purchase them -=+=- Sorry nothing will be billed or shipped!

  9. #9
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,907
    Rep Power
    568


    Default Re: Mysql 5 + Article Manager - NOT Compatible in RC2

    This should work on mysql5:

    Code:
    select count(distinct p.products_id) as total from ((((products p) left join manufacturers m using(manufacturers_id), products_description pd) left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c) left join tax_rates tr on p.products_tax_class_id = tr.tax_class_id) left join zones_to_geo_zones gz on tr.tax_zone_id = gz.geo_zone_id and (gz.zone_country_id is null or gz.zone_country_id = '0' or gz.zone_country_id = '222') and (gz.zone_id is null or gz.zone_id = '0' or gz.zone_id = '182') where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and (IF(s.status, s.specials_new_products_price, p.products_price) * if(gz.geo_zone_id is null, 1, 1 + (tr.tax_rate / 100) ) >= 45) and (IF(s.status, s.specials_new_products_price, p.products_price) * if(gz.geo_zone_id is null, 1, 1 + (tr.tax_rate / 100) ) <= 55)
    Michael Sasek
    osCMax Developer


    osCmax Installation Service
    - Have our professionals install osCmax on your server - same day service!
    osCmax 2.5 User Manual - the must have beginners guide to osCmax v2.5

    Stay Up To Date with everything osCMax:
    Free osCmax Newsletters - Security notices, New Releases, osCMax News
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  10. #10
    New Member
    Join Date
    Feb 2007
    Location
    Edinurgh
    Posts
    20
    Rep Power
    0


    Default Re: Mysql 5 + Article Manager - NOT Compatible in RC2

    Excellent. Not tried it yet but was along the same lines as what I was trying. Seemed to get into parenthesis madness somewhere along the way.

    Thanx a lot

Page 1 of 2 12 LastLast

Similar Threads

  1. Article Manager v1.0
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 10-30-2007, 08:00 PM
  2. Reviews in Article Info (Article Manager)
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 10-25-2007, 07:26 AM
  3. Reviews in Article Info (Article Manager)
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 05-10-2007, 02:00 PM
  4. Mysql error in article manager
    By clauska in forum osCmax v2 Customization/Mods
    Replies: 0
    Last Post: 06-27-2006, 01:11 AM
  5. Compatible with PHP 4.33 and mysql 3.23
    By the_error_king in forum osCmax v2 Installation issues
    Replies: 6
    Last Post: 06-15-2005, 07:19 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
  •