Forums / All Other Contributions/Addons / 1054 Unknown column 'sort' in 'order clause' in ... products_with_attributes_stock

1054 Unknown column 'sort' in 'order clause' in ... products_with_attributes_stock

Started by countingsheep on 4 Feb 2012, 3:51 AM · Views: 1,039

Results 1 to 1 of 1
4 Feb 2012, 3:51 AM
#1
countingsheep avatar

countingsheep

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