osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 

Article Manager

This is a discussion on Article Manager within the osCMax v2 Features Discussion forums, part of the osCMax v2.0 Forums category; I'm attempting to setup a new store on a hosted server. The server is running PHP 4.0.6 (...


Go Back   osCommerce and osCMax shopping cart software forums > osCMax v2.0 Forums > osCMax v2 Features Discussion

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Closed Thread

 

LinkBack Thread Tools
  #1  
Old 03-24-2006, 03:05 AM
Lurker
 
Join Date: Mar 2006
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
pglock
Default Article Manager

I'm attempting to setup a new store on a hosted server. The server is running PHP 4.0.6 (yes, it's very old, I know), the database server is mysql 5.0.17-standard.

I started with a clean install of RC2 then uploaded the update file, then configured the store. I have imported products and customer data from a 'live' store currently running oscommerce MS2 (plus various contributions) after working out a 'migration' sql script which I run on a locally host mysql server.

I'm currently working on the article manager. I've added a test article, but when I click on the link (/articles.php) to it I get the following error:

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

select count(*) as total from articles a, articles_description ad left join authors au on a.authors_id = au.authors_id, articles_to_topics a2t left join topics_description td on a2t.topics_id = td.topics_id where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_status = '1' and a.articles_id = a2t.articles_id and ad.articles_id = a2t.articles_id and ad.language_id = '1' and td.language_id = '1' and a2t.topics_id = '1'
From a little googling of other forums, this seems to be associated with the join statement differences between mysql5 and previous versions. Any ideas what I need to update/change?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #2  
Old 03-25-2006, 10:30 PM
jpf's Avatar
jpf jpf is offline
Moderator

 
Join Date: Sep 2003
Posts: 1,521
Thanks: 1
Thanked 81 Times in 68 Posts
Rep Power: 10
jpf is just really nicejpf is just really nicejpf is just really nicejpf is just really nicejpf is just really nice
Default RE: Article Manager

Sound like a table is missing reload the table for Article Manager.
__________________
JPF - osCMax Fourm Moderator
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!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #3  
Old 03-26-2006, 12:10 PM
Lurker
 
Join Date: Mar 2006
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
pglock
Default RE: Article Manager

Tried reloading all tables from the stock osCMax.sql still got the same problem. Any other ideas?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Closed Thread



Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
Problems with Article Manager jbanda osCMax v2 Features Discussion 0 07-18-2006 12:28 PM
Mysql error in article manager clauska osCMax v2 Customization/Mods 0 06-27-2006 01:11 AM
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


All times are GMT -8. The time now is 10:24 PM.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO
Copyright 2008 osCMax