osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 

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

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; run that one by me again? I just downloaded it again and the same zip file with the same size ...



Find us on Facebook
Go Back   osCommerce and osCMax shopping cart software forums > osCMax v2.0 Forums > osCMax v2 Customization/Mods

Connect with Facebook Register FAQDonate Members List Calendar Mark Forums Read


Closed Thread

 

LinkBack Thread Tools
  #21  
Old 04-11-2008, 06:22 PM
New Member
 
Join Date: Apr 2008
Posts: 19
Thanks: 4
Thanked 0 Times in 0 Posts
Rep Power: 0
felisanator is on a distinguished road
Default Re: 1054 - Unknown column 'a.authors_id' in 'on clause'

run that one by me again? I just downloaded it again and the same zip file with the same size and date (only one file articles.tpl.php 8/9/07) ...with no changes to the server after upload.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #22  
Old 04-11-2008, 06:24 PM
michael_s's Avatar
osCMax Developer


 
Join Date: Jul 2002
Location: Phoenix, AZ
Posts: 15,736
Thanks: 139
Thanked 609 Times in 521 Posts
Rep Power: 10
michael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond repute
Default Re: 1054 - Unknown column 'a.authors_id' in 'on clause'

Sorry about that, I have several installs of osCMax (6) and I zipped the wrong file twice...

I fixed it. The new zip contains the fixed file dated 4-11-08 It is 2 posts up in my previous post.
__________________
Michael Sasek
osCMax Developer

*** Do not PM me requesting paid help. The only paid work I do is for AABox Web Hosting customers ***

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 User Manual - osCMax Templates - Advanced Template Tutorial

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
The Following User Says Thank You to michael_s For This Useful Post:
felisanator (04-11-2008)
  #23  
Old 04-11-2008, 06:31 PM
New Member
 
Join Date: Apr 2008
Posts: 19
Thanks: 4
Thanked 0 Times in 0 Posts
Rep Power: 0
felisanator is on a distinguished road
Default Re: 1054 - Unknown column 'a.authors_id' in 'on clause'

Thanks for that! The store isn't broken anymore. but when I assign the articles to the top category (as I don't want to categorize any of the articles at this time).
It says that there are no articles
Quote:
All Articles
Current Articles There are currently no articles listed.
So...I found that I can disable the link to "all articles" That way the articles still show under the "articles" heading.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #24  
Old 04-11-2008, 07:18 PM
michael_s's Avatar
osCMax Developer


 
Join Date: Jul 2002
Location: Phoenix, AZ
Posts: 15,736
Thanks: 139
Thanked 609 Times in 521 Posts
Rep Power: 10
michael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond repute
Default Re: 1054 - Unknown column 'a.authors_id' in 'on clause'

Yes, that is a limitation of the mod. Articles must be put in a category.
__________________
Michael Sasek
osCMax Developer

*** Do not PM me requesting paid help. The only paid work I do is for AABox Web Hosting customers ***

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 User Manual - osCMax Templates - Advanced Template Tutorial

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #25  
Old 04-12-2008, 12:23 AM
MindTwist's Avatar
Active Member
 
Join Date: Jun 2007
Location: Barcelona, Spain
Posts: 405
Thanks: 17
Thanked 37 Times in 35 Posts
Rep Power: 5
MindTwist has a spectacular aura aboutMindTwist has a spectacular aura aboutMindTwist has a spectacular aura about
Default Re: 1054 - Unknown column 'a.authors_id' in 'on clause'

heh I am almost afraid to touch anything over here now since my articles are working ok...
__________________
MindTwist of Twisted Reality, Twisted Tienda and Securame
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #26  
Old 10-19-2008, 07:40 PM
New Member
 
Join Date: Oct 2008
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
Microtekblue is on a distinguished road
Lightbulb Re: 1054 - Unknown column 'a.authors_id' in 'on clause'

Hello,

I had the exact problem and I downloaded your patch, and that fixed everything wonderfully,

EXCEPT for when I click the New Articles link I get the 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' and a.articles_date_added > SUBDATE(now( ), INTERVAL '30' DAY)

[TEP STOP]

New Articles



Please advise a fix to that part.

I think another code fix is needed for the articles_new.tpl.php

All help is greatly appreciated.

Thank you.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #27  
Old 10-22-2008, 03:56 PM
New Member
 
Join Date: Oct 2008
Location: Florida
Posts: 21
Thanks: 4
Thanked 0 Times in 0 Posts
Rep Power: 0
cikez is on a distinguished road
Default Re: 1054 - Unknown column 'a.authors_id' in 'on clause'

I am also having the same problem after the fix above. Everything seems to work fine except for articles_new.php.

Quote:
Originally Posted by Microtekblue View Post
Hello,

I had the exact problem and I downloaded your patch, and that fixed everything wonderfully,

EXCEPT for when I click the New Articles link I get the 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' and a.articles_date_added > SUBDATE(now( ), INTERVAL '30' DAY)

[TEP STOP]

New Articles



Please advise a fix to that part.

I think another code fix is needed for the articles_new.tpl.php

All help is greatly appreciated.

Thank you.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #28  
Old 10-22-2008, 11:09 PM
michael_s's Avatar
osCMax Developer


 
Join Date: Jul 2002
Location: Phoenix, AZ
Posts: 15,736
Thanks: 139
Thanked 609 Times in 521 Posts
Rep Power: 10
michael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond repute
Default Re: 1054 - Unknown column 'a.authors_id' in 'on clause'

To fix the new articles issue, edit articles_new.tpl.php in the fallback/content directory and change line 17 from this :

PHP Code:
  $articles_new_query_raw "select a.articles_id, a.articles_date_added, ad.articles_name, ad.articles_head_desc_tag, au.authors_id, au.authors_name, td.topics_id, td.topics_name from " TABLE_ARTICLES " a, " TABLE_ARTICLES_TO_TOPICS " a2t left join " TABLE_TOPICS_DESCRIPTION " td on a2t.topics_id = td.topics_id left join " TABLE_AUTHORS " au on a.authors_id = au.authors_id, " TABLE_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 = '" . (int)$languages_id "' and td.language_id = '" . (int)$languages_id "' and a.articles_date_added > SUBDATE(now( ), INTERVAL '" NEW_ARTICLES_DAYS_DISPLAY "' DAY) order by a.articles_date_added desc, ad.articles_name"
to this:
PHP Code:
  $articles_new_query_raw "select a.articles_id, a.articles_date_added, ad.articles_name, ad.articles_head_desc_tag, au.authors_id, au.authors_name, td.topics_id, td.topics_name from ((" TABLE_ARTICLES " a, " TABLE_ARTICLES_TO_TOPICS " a2t) left join " TABLE_TOPICS_DESCRIPTION " td on a2t.topics_id = td.topics_id) left join " TABLE_AUTHORS " au on a.authors_id = au.authors_id, " TABLE_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 = '" . (int)$languages_id "' and td.language_id = '" . (int)$languages_id "' and a.articles_date_added > SUBDATE(now( ), INTERVAL '" NEW_ARTICLES_DAYS_DISPLAY "' DAY) order by a.articles_date_added desc, ad.articles_name"
__________________
Michael Sasek
osCMax Developer

*** Do not PM me requesting paid help. The only paid work I do is for AABox Web Hosting customers ***

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 User Manual - osCMax Templates - Advanced Template Tutorial

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #29  
Old 01-08-2009, 11:15 AM
Lurker
 
Join Date: Nov 2008
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
TylerD is on a distinguished road
Default Re: 1054 - Unknown column 'a.authors_id' in 'on clause'

Hello,

i'm new here. I'm also experiencing the same problem. Except that you can see it on whatever page you're on. I' ve also downloaded your articles file. Thing is that it doesn't change anything. Btw i'm not using the fallback template. Can anybody help me any further?..
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #30  
Old 01-08-2009, 04:05 PM
michael_s's Avatar
osCMax Developer


 
Join Date: Jul 2002
Location: Phoenix, AZ
Posts: 15,736
Thanks: 139
Thanked 609 Times in 521 Posts
Rep Power: 10
michael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond repute
Default Re: 1054 - Unknown column 'a.authors_id' in 'on clause'

Did you also do the above code edit?

It doesn't matter if you are not using the fallback template. All templates use the fallback/content templates unless there is one present in the active content directory. If your template has its own content files, make sure you replace yours with the new ones...
__________________
Michael Sasek
osCMax Developer

*** Do not PM me requesting paid help. The only paid work I do is for AABox Web Hosting customers ***

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 User Manual - osCMax Templates - Advanced Template Tutorial

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
Error: 1054 - Unknown column islander osCMax v2 Installation issues 1 02-27-2006 11:31 AM
1054 - Unknown column 'p.vendors_product_price' RoyceK osCMax v2 Installation issues 1 02-12-2006 08:22 PM
1054 - Unknown column when restock product DigitalPimp osCMax v2 Customization/Mods 3 07-25-2005 02:57 PM
1054 - Unknown column 'popt.products_options_type Anonymous osCMax v1.7 Discussion 5 03-08-2004 01:47 AM
1054 - Unknown column - Help, please ! Anonymous osCommerce 2.2 Modification Help 2 11-27-2002 11:48 AM


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


Powered by vBulletin®
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO
Copyright 2009 osCMax
Inactive Reminders By Icora Web Design