[Skip to main content](#vessel-content) # 2.2 On install i got this error ## - **[emmdee](/forum/user/4217-emmdee "View emmdee's Profile")** - [![emmdee's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/bike_skid.png)](/forum/user/4217-emmdee "View emmdee's Profile") Topic Author - [ Offline](/forum/user/4217-emmdee) Less More - Posts: 50 - Thank you received: 2 - - 13 years 4 months ago [\#111577](#111577) by [emmdee](/forum/user/4217-emmdee "View emmdee's Profile") *[2.2 On install i got this error](/forum/3-bug-report/84378-2-2-on-install-i-got-this-error#111577 "Just installed 2.2 On install i got this error An error has occurred. SQL=ALTER TABLE `tco3_hikashop_payment` ADD `payment_ordering` int(10) unsigned NOT NULL DEFAULT '0', ADD `payment_vendor_id` int(10) unsigned NOT NULL DEFAULT '0', ADD `payment_published` tinyint(4) NOT NULL DEFAULT '1'; But its wrong cause the table has been altered... Database table structure is up to date. Then when I click on a product in the product listing I get an error of cant find this page and error of SQL=SELECT * FROM xxxx_hikashop_massaction WHERE massaction_published=1 && massaction_triggers!='' So i go back to phpmyadmin and see that xxxx_hikashop_massaction has not been created. So i create it manually and now product shows up ok. So i go to checkout and see Total $23.20 Postage $0.00 Final total $31.10 the postage is 7.90 and the final total is correct. Any ideas?? Rgds emmdee")* was created by *[emmdee](/forum/user/4217-emmdee "View emmdee's Profile")* Just installed 2.2 On install i got this error An error has occurred. SQL=ALTER TABLE `tco3_hikashop_payment` ADD `payment_ordering` int(10) unsigned NOT NULL DEFAULT '0', ADD `payment_vendor_id` int(10) unsigned NOT NULL DEFAULT '0', ADD `payment_published` tinyint(4) NOT NULL DEFAULT '1'; But its wrong cause the table has been altered... Database table structure is up to date. Then when I click on a product in the product listing I get an error of cant find this page and error of SQL=SELECT * FROM xxxx_hikashop_massaction WHERE massaction_published=1 && massaction_triggers!='' So i go back to phpmyadmin and see that xxxx_hikashop_massaction has not been created. So i create it manually and now product shows up ok. So i go to checkout and see Total $23.20 Postage $0.00 Final total $31.10 the postage is 7.90 and the final total is correct. Any ideas?? Rgds emmdee Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NDM3OC0yLTItb24taW5zdGFsbC1pLWdvdC10aGlzLWVycm9yP3RtcGw9bWFya2Rvd24=) 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 - - - 13 years 4 months ago [\#111583](#111583) 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 *[2.2 On install i got this error](/forum/3-bug-report/84378-2-2-on-install-i-got-this-error#111583 "Just installed 2.2 On install i got this error An error has occurred. SQL=ALTER TABLE `tco3_hikashop_payment` ADD `payment_ordering` int(10) unsigned NOT NULL DEFAULT '0', ADD `payment_vendor_id` int(10) unsigned NOT NULL DEFAULT '0', ADD `payment_published` tinyint(4) NOT NULL DEFAULT '1'; But its wrong cause the table has been altered... Database table structure is up to date. Then when I click on a product in the product listing I get an error of cant find this page and error of SQL=SELECT * FROM xxxx_hikashop_massaction WHERE massaction_published=1 && massaction_triggers!='' So i go back to phpmyadmin and see that xxxx_hikashop_massaction has not been created. So i create it manually and now product shows up ok. So i go to checkout and see Total $23.20 Postage $0.00 Final total $31.10 the postage is 7.90 and the final total is correct. Any ideas?? Rgds emmdee")* Hi, Can you send me a link to your product listing for testing purpose ? also, can you try to re-install the last version of Hikashop ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NDM3OC0yLTItb24taW5zdGFsbC1pLWdvdC10aGlzLWVycm9yP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[emmdee](/forum/user/4217-emmdee "View emmdee's Profile")** - [![emmdee's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/bike_skid.png)](/forum/user/4217-emmdee "View emmdee's Profile") Topic Author - [ Offline](/forum/user/4217-emmdee) Less More - Posts: 50 - Thank you received: 2 - - 13 years 4 months ago [\#111586](#111586) by [emmdee](/forum/user/4217-emmdee "View emmdee's Profile") Replied by *[emmdee](/forum/user/4217-emmdee "View emmdee's Profile")* on topic *[2.2 On install i got this error](/forum/3-bug-report/84378-2-2-on-install-i-got-this-error#111586 "Just installed 2.2 On install i got this error An error has occurred. SQL=ALTER TABLE `tco3_hikashop_payment` ADD `payment_ordering` int(10) unsigned NOT NULL DEFAULT '0', ADD `payment_vendor_id` int(10) unsigned NOT NULL DEFAULT '0', ADD `payment_published` tinyint(4) NOT NULL DEFAULT '1'; But its wrong cause the table has been altered... Database table structure is up to date. Then when I click on a product in the product listing I get an error of cant find this page and error of SQL=SELECT * FROM xxxx_hikashop_massaction WHERE massaction_published=1 && massaction_triggers!='' So i go back to phpmyadmin and see that xxxx_hikashop_massaction has not been created. So i create it manually and now product shows up ok. So i go to checkout and see Total $23.20 Postage $0.00 Final total $31.10 the postage is 7.90 and the final total is correct. Any ideas?? Rgds emmdee")* Sorry mate its local only. I have reinstalled 2.2 All seems good except checkout ... Total $23.20 Postage $0.00 Final total $31.10 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NDM3OC0yLTItb24taW5zdGFsbC1pLWdvdC10aGlzLWVycm9yP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")** - [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile") - [ Offline](/forum/user/1824-eliot) Less More - Posts: 2334 - Thank you received: 403 - - 13 years 4 months ago [\#111594](#111594) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[2.2 On install i got this error](/forum/3-bug-report/84378-2-2-on-install-i-got-this-error#111594 "Just installed 2.2 On install i got this error An error has occurred. SQL=ALTER TABLE `tco3_hikashop_payment` ADD `payment_ordering` int(10) unsigned NOT NULL DEFAULT '0', ADD `payment_vendor_id` int(10) unsigned NOT NULL DEFAULT '0', ADD `payment_published` tinyint(4) NOT NULL DEFAULT '1'; But its wrong cause the table has been altered... Database table structure is up to date. Then when I click on a product in the product listing I get an error of cant find this page and error of SQL=SELECT * FROM xxxx_hikashop_massaction WHERE massaction_published=1 && massaction_triggers!='' So i go back to phpmyadmin and see that xxxx_hikashop_massaction has not been created. So i create it manually and now product shows up ok. So i go to checkout and see Total $23.20 Postage $0.00 Final total $31.10 the postage is 7.90 and the final total is correct. Any ideas?? Rgds emmdee")* Great news for the SQL errors. However, it's going to be hard for us to help you if you we can't access your website. You can still check if you don't have a tax rate or something similar causing the issue. It may be normal depending of your configuration. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NDM3OC0yLTItb24taW5zdGFsbC1pLWdvdC10aGlzLWVycm9yP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[emmdee](/forum/user/4217-emmdee "View emmdee's Profile")** - [![emmdee's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/bike_skid.png)](/forum/user/4217-emmdee "View emmdee's Profile") Topic Author - [ Offline](/forum/user/4217-emmdee) Less More - Posts: 50 - Thank you received: 2 - - 13 years 4 months ago [\#111603](#111603) by [emmdee](/forum/user/4217-emmdee "View emmdee's Profile") Replied by *[emmdee](/forum/user/4217-emmdee "View emmdee's Profile")* on topic *[2.2 On install i got this error](/forum/3-bug-report/84378-2-2-on-install-i-got-this-error#111603 "Just installed 2.2 On install i got this error An error has occurred. SQL=ALTER TABLE `tco3_hikashop_payment` ADD `payment_ordering` int(10) unsigned NOT NULL DEFAULT '0', ADD `payment_vendor_id` int(10) unsigned NOT NULL DEFAULT '0', ADD `payment_published` tinyint(4) NOT NULL DEFAULT '1'; But its wrong cause the table has been altered... Database table structure is up to date. Then when I click on a product in the product listing I get an error of cant find this page and error of SQL=SELECT * FROM xxxx_hikashop_massaction WHERE massaction_published=1 && massaction_triggers!='' So i go back to phpmyadmin and see that xxxx_hikashop_massaction has not been created. So i create it manually and now product shows up ok. So i go to checkout and see Total $23.20 Postage $0.00 Final total $31.10 the postage is 7.90 and the final total is correct. Any ideas?? Rgds emmdee")* All i can give is a screen shot [ ![2_2_cart_hika_screenshot.png](/forum/attachment/10875) ](/forum/attachment/10875 "...screenshot.png") - [ ![2_2_cart_hika_screenshot.png](/forum/attachment/10875) ](/forum/attachment/10875 "...screenshot.png") [ ](/forum/attachment/10875?download=1 "...screenshot.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NDM3OC0yLTItb24taW5zdGFsbC1pLWdvdC10aGlzLWVycm9yP3RtcGw9bWFya2Rvd24=) 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) - 13 years 4 months ago [\#111614](#111614) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[2.2 On install i got this error](/forum/3-bug-report/84378-2-2-on-install-i-got-this-error#111614 "Just installed 2.2 On install i got this error An error has occurred. SQL=ALTER TABLE `tco3_hikashop_payment` ADD `payment_ordering` int(10) unsigned NOT NULL DEFAULT '0', ADD `payment_vendor_id` int(10) unsigned NOT NULL DEFAULT '0', ADD `payment_published` tinyint(4) NOT NULL DEFAULT '1'; But its wrong cause the table has been altered... Database table structure is up to date. Then when I click on a product in the product listing I get an error of cant find this page and error of SQL=SELECT * FROM xxxx_hikashop_massaction WHERE massaction_published=1 && massaction_triggers!='' So i go back to phpmyadmin and see that xxxx_hikashop_massaction has not been created. So i create it manually and now product shows up ok. So i go to checkout and see Total $23.20 Postage $0.00 Final total $31.10 the postage is 7.90 and the final total is correct. Any ideas?? Rgds emmdee")* Hi, Do you have a "checkout | cart" view override ? Which shipping plugin do you use ? Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. The following user(s) said Thank You: [emmdee](/forum/user/4217-emmdee "View emmdee's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NDM3OC0yLTItb24taW5zdGFsbC1pLWdvdC10aGlzLWVycm9yP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[emmdee](/forum/user/4217-emmdee "View emmdee's Profile")** - [![emmdee's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/bike_skid.png)](/forum/user/4217-emmdee "View emmdee's Profile") Topic Author - [ Offline](/forum/user/4217-emmdee) Less More - Posts: 50 - Thank you received: 2 - - 13 years 4 months ago [\#111698](#111698) by [emmdee](/forum/user/4217-emmdee "View emmdee's Profile") Replied by *[emmdee](/forum/user/4217-emmdee "View emmdee's Profile")* on topic *[2.2 On install i got this error](/forum/3-bug-report/84378-2-2-on-install-i-got-this-error#111698 "Just installed 2.2 On install i got this error An error has occurred. SQL=ALTER TABLE `tco3_hikashop_payment` ADD `payment_ordering` int(10) unsigned NOT NULL DEFAULT '0', ADD `payment_vendor_id` int(10) unsigned NOT NULL DEFAULT '0', ADD `payment_published` tinyint(4) NOT NULL DEFAULT '1'; But its wrong cause the table has been altered... Database table structure is up to date. Then when I click on a product in the product listing I get an error of cant find this page and error of SQL=SELECT * FROM xxxx_hikashop_massaction WHERE massaction_published=1 && massaction_triggers!='' So i go back to phpmyadmin and see that xxxx_hikashop_massaction has not been created. So i create it manually and now product shows up ok. So i go to checkout and see Total $23.20 Postage $0.00 Final total $31.10 the postage is 7.90 and the final total is correct. Any ideas?? Rgds emmdee")* Thanks Jerome The problem was my cart override. Sloppy on my behalf cause that override is version 1.5.4 All is good now. This is the first time I've ever had problems with upgrading your fantastic cart. The thing that really threw me was the massaction table not being created to start with. All of the sql is correct in update package, so its not a bug... who knows... as usual it was probably human errror. Many thanks emmdee Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NDM3OC0yLTItb24taW5zdGFsbC1pLWdvdC10aGlzLWVycm9yP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")** - [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile") - [ Offline](/forum/user/1824-eliot) Less More - Posts: 2334 - Thank you received: 403 - - 13 years 4 months ago [\#111717](#111717) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[2.2 On install i got this error](/forum/3-bug-report/84378-2-2-on-install-i-got-this-error#111717 "Just installed 2.2 On install i got this error An error has occurred. SQL=ALTER TABLE `tco3_hikashop_payment` ADD `payment_ordering` int(10) unsigned NOT NULL DEFAULT '0', ADD `payment_vendor_id` int(10) unsigned NOT NULL DEFAULT '0', ADD `payment_published` tinyint(4) NOT NULL DEFAULT '1'; But its wrong cause the table has been altered... Database table structure is up to date. Then when I click on a product in the product listing I get an error of cant find this page and error of SQL=SELECT * FROM xxxx_hikashop_massaction WHERE massaction_published=1 && massaction_triggers!='' So i go back to phpmyadmin and see that xxxx_hikashop_massaction has not been created. So i create it manually and now product shows up ok. So i go to checkout and see Total $23.20 Postage $0.00 Final total $31.10 the postage is 7.90 and the final total is correct. Any ideas?? Rgds emmdee")* Glad to see you found a solution ![:)](/media/kunena/emoticons/3.png ":)"). About the SQL errors we didn't get any feedback about it but we will stay alert on this point. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NDM3OC0yLTItb24taW5zdGFsbC1pLWdvdC10aGlzLWVycm9yP3RtcGw9bWFya2Rvd24=) 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.137 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)