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
Bookmarks