[Skip to main content](#vessel-content) # 1054 Unknown Column file\_pos ## - **[hdwebpros](/forum/user/6863-hdwebpros "View hdwebpros's Profile")** - [![hdwebpros's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6863-hdwebpros "View hdwebpros's Profile") Topic Author - [ Offline](/forum/user/6863-hdwebpros) Less More - Posts: 14 - Thank you received: 0 - - 12 years 3 months ago [\#165204](#165204) by [hdwebpros](/forum/user/6863-hdwebpros "View hdwebpros's Profile") *[1054 Unknown Column file\_pos](/forum/3-bug-report/869921-1054-unknown-column-file-pos#165204 "-- url of the page with the problem -- : www.peteshardwoodfloors.com/Shop-for-Pro...Online/checkout.html -- HikaShop version -- : 2.3.2 -- Joomla version -- : 3.3.1 -- PHP version -- : 5.4.30 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : 1054 - Unknown column 'file_pos' in 'order clause' SQL=SELECT b.*,a.* FROM jml_hikashop_file AS a LEFT JOIN jml_hikashop_download AS b ON b.order_id=45 AND a.file_id = b.file_id WHERE a.file_ref_id IN (1) AND a.file_type='file' ORDER BY file_ref_id ASC, file_ordering, file_pos ASC Whenever you try and order anything from the site since upgrading Hikashop, I get this error. That column shouldn't even exist in the DB so I have no idea why it is there. I can email any credential you want, just get me an address. I don't know how to fix this though, please help")* was created by *[hdwebpros](/forum/user/6863-hdwebpros "View hdwebpros's Profile")* -- url of the page with the problem -- : [ www.peteshardwoodfloors.com/Shop-for-Pro...Online/checkout.html](http://www.peteshardwoodfloors.com/Shop-for-Products-Online/checkout.html) -- HikaShop version -- : 2.3.2 -- Joomla version -- : 3.3.1 -- PHP version -- : 5.4.30 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : 1054 - Unknown column 'file_pos' in 'order clause' SQL=SELECT b.*,a.* FROM jml_hikashop_file AS a LEFT JOIN jml_hikashop_download AS b ON b.order_id=45 AND a.file_id = b.file_id WHERE a.file_ref_id IN (1) AND a.file_type='file' ORDER BY file_ref_id ASC, file_ordering, file_pos ASC Whenever you try and order anything from the site since upgrading Hikashop, I get this error. That column shouldn't even exist in the DB so I have no idea why it is there. I can email any credential you want, just get me an address. I don't know how to fix this though, please help Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84Njk5MjEtMTA1NC11bmtub3duLWNvbHVtbi1maWxlLXBvcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 12 years 3 months ago [\#165208](#165208) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[1054 Unknown Column file\_pos](/forum/3-bug-report/869921-1054-unknown-column-file-pos#165208 "-- url of the page with the problem -- : www.peteshardwoodfloors.com/Shop-for-Pro...Online/checkout.html -- HikaShop version -- : 2.3.2 -- Joomla version -- : 3.3.1 -- PHP version -- : 5.4.30 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : 1054 - Unknown column 'file_pos' in 'order clause' SQL=SELECT b.*,a.* FROM jml_hikashop_file AS a LEFT JOIN jml_hikashop_download AS b ON b.order_id=45 AND a.file_id = b.file_id WHERE a.file_ref_id IN (1) AND a.file_type='file' ORDER BY file_ref_id ASC, file_ordering, file_pos ASC Whenever you try and order anything from the site since upgrading Hikashop, I get this error. That column shouldn't even exist in the DB so I have no idea why it is there. I can email any credential you want, just get me an address. I don't know how to fix this though, please help")* Hello, 1. Can you download the last Hikashop version through our website, manually install it (extension manager), and test it again ? 2. Also, checking that documentation will probably help you : [ www.hikashop.com/support/support/documen...lity-issues.html#SQL](http://www.hikashop.com/support/support/documentation/61-hikashop-compatibility-issues.html#SQL) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84Njk5MjEtMTA1NC11bmtub3duLWNvbHVtbi1maWxlLXBvcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[hdwebpros](/forum/user/6863-hdwebpros "View hdwebpros's Profile")** - [![hdwebpros's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6863-hdwebpros "View hdwebpros's Profile") Topic Author - [ Offline](/forum/user/6863-hdwebpros) Less More - Posts: 14 - Thank you received: 0 - - 12 years 3 months ago [\#165331](#165331) by [hdwebpros](/forum/user/6863-hdwebpros "View hdwebpros's Profile") Replied by *[hdwebpros](/forum/user/6863-hdwebpros "View hdwebpros's Profile")* on topic *[1054 Unknown Column file\_pos](/forum/3-bug-report/869921-1054-unknown-column-file-pos#165331 "-- url of the page with the problem -- : www.peteshardwoodfloors.com/Shop-for-Pro...Online/checkout.html -- HikaShop version -- : 2.3.2 -- Joomla version -- : 3.3.1 -- PHP version -- : 5.4.30 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : 1054 - Unknown column 'file_pos' in 'order clause' SQL=SELECT b.*,a.* FROM jml_hikashop_file AS a LEFT JOIN jml_hikashop_download AS b ON b.order_id=45 AND a.file_id = b.file_id WHERE a.file_ref_id IN (1) AND a.file_type='file' ORDER BY file_ref_id ASC, file_ordering, file_pos ASC Whenever you try and order anything from the site since upgrading Hikashop, I get this error. That column shouldn't even exist in the DB so I have no idea why it is there. I can email any credential you want, just get me an address. I don't know how to fix this though, please help")* That is what I did. I tried the latest version. I also read that doc, and it doesn't help. Look at the error 1054 - Unknown column 'file_pos' To truly test, I did a fresh install on a blank site. There is no column named that that is supposed to be there. How can I fix? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84Njk5MjEtMTA1NC11bmtub3duLWNvbHVtbi1maWxlLXBvcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 12 years 3 months ago [\#165339](#165339) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[1054 Unknown Column file\_pos](/forum/3-bug-report/869921-1054-unknown-column-file-pos#165339 "-- url of the page with the problem -- : www.peteshardwoodfloors.com/Shop-for-Pro...Online/checkout.html -- HikaShop version -- : 2.3.2 -- Joomla version -- : 3.3.1 -- PHP version -- : 5.4.30 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : 1054 - Unknown column 'file_pos' in 'order clause' SQL=SELECT b.*,a.* FROM jml_hikashop_file AS a LEFT JOIN jml_hikashop_download AS b ON b.order_id=45 AND a.file_id = b.file_id WHERE a.file_ref_id IN (1) AND a.file_type='file' ORDER BY file_ref_id ASC, file_ordering, file_pos ASC Whenever you try and order anything from the site since upgrading Hikashop, I get this error. That column shouldn't even exist in the DB so I have no idea why it is there. I can email any credential you want, just get me an address. I don't know how to fix this though, please help")* Hi, Please edit the file "administrator/components/com_hikashop/classes/order.php" and replace Code: $query = 'SELECT b.*,a.* FROM '.hikashop_table('file').' AS a LEFT JOIN '.hikashop_table('download').' AS b ON b.order_id='.$order->order_id.' AND a.file_id = b.file_id WHERE '.implode(' AND ',$filters).' ORDER BY file_ref_id ASC, file_ordering, file_pos ASC'; By Code: $query = 'SELECT b.*,a.* FROM '.hikashop_table('file').' AS a LEFT JOIN '.hikashop_table('download').' AS b ON b.order_id='.$order->order_id.' AND a.file_id = b.file_id WHERE '.implode(' AND ',$filters).' ORDER BY a.file_ref_id ASC, a.file_ordering ASC, b.file_pos ASC'; And please check that your table "hikashop_download" right contain a column named "file_pos". HikaShop 2.3.2 now contain a new feature called "database check", the button is available in the HikaShop configuration toolbar. This feature can help you to create the missing columns in the tables (if you had problems during an HikaShop update). Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84Njk5MjEtMTA1NC11bmtub3duLWNvbHVtbi1maWxlLXBvcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[hdwebpros](/forum/user/6863-hdwebpros "View hdwebpros's Profile")** - [![hdwebpros's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6863-hdwebpros "View hdwebpros's Profile") Topic Author - [ Offline](/forum/user/6863-hdwebpros) Less More - Posts: 14 - Thank you received: 0 - - 12 years 3 months ago [\#165450](#165450) by [hdwebpros](/forum/user/6863-hdwebpros "View hdwebpros's Profile") Replied by *[hdwebpros](/forum/user/6863-hdwebpros "View hdwebpros's Profile")* on topic *[1054 Unknown Column file\_pos](/forum/3-bug-report/869921-1054-unknown-column-file-pos#165450 "-- url of the page with the problem -- : www.peteshardwoodfloors.com/Shop-for-Pro...Online/checkout.html -- HikaShop version -- : 2.3.2 -- Joomla version -- : 3.3.1 -- PHP version -- : 5.4.30 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : 1054 - Unknown column 'file_pos' in 'order clause' SQL=SELECT b.*,a.* FROM jml_hikashop_file AS a LEFT JOIN jml_hikashop_download AS b ON b.order_id=45 AND a.file_id = b.file_id WHERE a.file_ref_id IN (1) AND a.file_type='file' ORDER BY file_ref_id ASC, file_ordering, file_pos ASC Whenever you try and order anything from the site since upgrading Hikashop, I get this error. That column shouldn't even exist in the DB so I have no idea why it is there. I can email any credential you want, just get me an address. I don't know how to fix this though, please help")* Thank you. That did the trick Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84Njk5MjEtMTA1NC11bmtub3duLWNvbHVtbi1maWxlLXBvcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.245 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)