Zen Follower
- Join Date:
- Sep 2006
- Posts:
- 154
- Plugin Contributions:
- 0
1054 Unknown column 'sort' in 'order clause' in ... products_with_attributes_stock
Can anyone please tell me what I need to do for the following:
1054 Unknown column 'sort' in 'order clause'
in:
[select * from zen_products_with_attributes_stock where products_id="107" order by sort ASC;]
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.
This is showing when we click on admin>catalog>products with attributes stock
Server OS: Linux 2.6.9-100.ELsmp Database: MySQL 5.0.92-community
Server Date: 02/03/2012 22:48:12 Database Date: 02/03/2012 22:48:12
Server Up Time: 22:48:12 up 195 days, 15:54, 0 users, load average: 0.88, 0.70, 0.73 HTTP Server: Apache
PHP Version: 5.2.11 (Zend: 2.2.0) PHP Memory Limit: 256M PHP Safe Mode: Off
PHP File Uploads: On Max Size: 128M POST Max Size: 128M
Database Data Size: 2,095 kB Database Index Size: 849 kB
Zen Cart 1.3.9h
Database Patch Level: 1.3.9h
v1.3.9h [2011-11-20 22:01:01] (Version Update 1.3.8->1.3.9h)
v1.3.8 [2008-08-16 10:59:26] (Fresh Installation)
PHP Version 5.2.11