Hi all
I just updated my server and get the above error well in full i get
When trying to view order infomation.1054 Unknown column 'U' in 'where clause'
in:
[ SELECT zone_id FROM zen_zones_to_geo_zones WHERE geo_zone_id = 10 AND zone_country_id = U ORDER BY zone_id ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
I first assumed this was a mysql5 issue but
im not on mysql 5Server Host: router (192.167.0.1) Database Host: localhost (127.0.0.1)
Server OS: Linux 2.6.9-67.0.1.ELsmp Database: MySQL 4.1.20
Server Date: 01/13/2008 15:10:14 Database Date: 01/13/2008 15:10:13
Server Up Time: 15:10:14 up 1 day, 9:45, 0 users, load average: 0.15, 0.06, 0.05
PHP Version: 4.3.9 (Zend: 1.3.0)
HTTP Server: Apache
But this did start happeneing after the server upgrade so unless its coincidental im assuming its to do with the upgrade I do know the old version of mysql was 4.1.20-2 and php was 4.3.9-3.22.5
It appears to only affect certain orders in admin and i cant see it affecting anywhere else but orders in admin.
But im at a loss, and suggestions
James
*edit
Zen version 1.3.0.2
Results 1 to 8 of 8
-
13 Jan 2008, 04:23 PM #1
New Zenner
- Join Date
- Jul 2006
- Posts
- 55
- Plugin Contributions
- 0
Ceon Protx module vs 1054 Unknown column 'U' in 'where clause'
-
16 Jan 2008, 01:01 AM #2
New Zenner
- Join Date
- Jul 2006
- Posts
- 55
- Plugin Contributions
- 0
Re: 1054 Unknown column 'U' in 'where clause'
I have been looking at all avenues and cant see how the recent upgrade of mysql (as above) would affect only admin and orders/super orders. I could do with any assistance at all at the moment, anyone got any ideas?
James
-
16 Jan 2008, 05:23 AM #3
Totally Zenned
- Join Date
- Oct 2006
- Posts
- 5,477
- Plugin Contributions
- 11
Re: 1054 Unknown column 'U' in 'where clause'
I have just upgraded to 1.3.8 as well and do not see this issue (using super order as well). You probably missed something or overwrote something during the upgrade)
I no longer provide installation support on forum for all my modules. However, if there are real bugs with the modules please feel free to contact me
-
16 Jan 2008, 06:54 AM #4
Sensei
- Join Date
- Jan 2004
- Posts
- 66,373
- Blog Entries
- 7
- Plugin Contributions
- 274
Re: 1054 Unknown column 'U' in 'where clause'
I recall seeing someone else post a similar "U" problem, and if I recall correctly, it was after installing the uk_template addon or something akin to it. Or maybe it was a UK-related payment module?
Maybe you should check which addons you have installed and active..
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.
-
17 Jan 2008, 06:16 PM #5
New Zenner
- Join Date
- Jul 2006
- Posts
- 55
- Plugin Contributions
- 0
Re: 1054 Unknown column 'U' in 'where clause'
not using the uk template, but the version is 1.3.0.2 not 1.3.8 yet
I chenged nothing in the zen cart but did a server upgrade as above, so mysql and php was updated. Im looking to see if i can roll back to the old ones, but as its still 4.x not 5.x i cant see its mysql related directly. Obviously something is borked but i dont know what
James
-
18 Jan 2008, 12:04 AM #6
New Zenner
- Join Date
- Jul 2006
- Posts
- 55
- Plugin Contributions
- 0
Re: 1054 Unknown column 'U' in 'where clause'
Also its only credit card payments other payments work fine. I have recently updated the ceon protx module also could they be related?
-
18 Jan 2008, 05:46 AM #7
Sensei
- Join Date
- Jan 2004
- Posts
- 66,373
- Blog Entries
- 7
- Plugin Contributions
- 274
Re: 1054 Unknown column 'U' in 'where clause'
Yes, it does appear to be related:
Originally Posted by jameswilson
http://www.zen-cart.com/forum/showthread.php?p=484169.
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 Jan 2008, 03:20 PM #8
New Zenner
- Join Date
- Jul 2006
- Posts
- 55
- Plugin Contributions
- 0
Re: 1054 Unknown column 'U' in 'where clause'
oh yeah
Superb. Wonderful thanks again, i need to donate to the project again thankyou matey!
James
Similar Threads
-
1054 Unknown column 'zen_order_id' in 'where clause'
By jchrinko in forum General QuestionsReplies: 1Last Post: 24 Apr 2010, 04:57 AM -
1054 Unknown column 'zen_order_id' in 'where clause'
By mtrantas in forum Built-in Shipping and Payment ModulesReplies: 21Last Post: 19 Apr 2009, 02:18 PM -
1054 Unknown column 'COWOA_account' in 'where clause'
By lemonaid in forum All Other Contributions/AddonsReplies: 7Last Post: 7 Jan 2009, 08:08 AM -
1054 Unknown column 'order_id' in 'where clause' using nochex payment module
By PGlad in forum Built-in Shipping and Payment ModulesReplies: 2Last Post: 26 Mar 2008, 08:39 AM -
1054 Unknown column 'products_id' in 'where clause'
By Darkwander in forum All Other Contributions/AddonsReplies: 1Last Post: 15 Jun 2006, 10:59 PM
Bookmarks