Forums / Built-in Shipping and Payment Modules / 1054 Unknown column 'account_name' in 'field list'

1054 Unknown column 'account_name' in 'field list'

Locked

Views: 1,941

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
18 Aug 2006, 5:50 PM
#1
jford avatar

jford

Zen Follower

Join Date:
Mar 2006
Posts:
162
Plugin Contributions:
0

1054 Unknown column 'account_name' in 'field list'

this customer: https://www.jefoss.com/catalog gets this error anytime someone is trying to checkout. how do i fix this and what is the cause of it to prevent it in the future?

18 Aug 2006, 9:15 PM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: 1054 Unknown column 'account_name' in 'field list'

That error suggests something wrong with a database-query. It's usually caused by a mismatch in upgrading customized files, or a syntax error in custom code.

This is where I'd start:
http://www.zen-cart.com/wiki/index.php/Troubleshoot_-_Diagnosing_Obscure_Issues

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

18 Aug 2006, 10:15 PM
#3
jford avatar

jford

Zen Follower

Join Date:
Mar 2006
Posts:
162
Plugin Contributions:
0

Re: 1054 Unknown column 'account_name' in 'field list'

okay-i downloaded WinMerge and looked at all the files that were different. and every spot that was different from the original was where i inserted the Purchase Order mod. I'm really not sure how to fix this or what steps I need to take. This error occurs when I am trying to order from a CC and not the PO.

any suggestions?!

19 Aug 2006, 5:20 AM
#4
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: 1054 Unknown column 'account_name' in 'field list'

Did your purchase order mod have some SQL / database components to install that you missed doing?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

22 Aug 2006, 10:24 PM
#5
jford avatar

jford

Zen Follower

Join Date:
Mar 2006
Posts:
162
Plugin Contributions:
0

Re: 1054 Unknown column 'account_name' in 'field list'

gaaa..that was exactly it. thanks.i hate it when i forget to do simple stuff like that and then look like an idiot in the forum! thanks!