[Skip to main content](#vessel-content) # Upgrade creates database issues ## - **[Keith49](/forum/user/31200-keith49 "View Keith49's Profile")** - [![Keith49's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31200-keith49 "View Keith49's Profile") Topic Author - [ Offline](/forum/user/31200-keith49) Less More - Posts: 2 - Thank you received: 0 - - 12 years 8 months ago [\#144200](#144200) by [Keith49](/forum/user/31200-keith49 "View Keith49's Profile") *[Upgrade creates database issues](/forum/25-install-update/865915-upgrade-creates-database-issues#144200 "-- url of the page with the problem -- : mywebsite.com/mypage -- HikaShop version -- : 2.3 -- Joomla version -- : 3.1.6 -- PHP version -- : 5.3.28 -- Browser(s) name and version -- : XXXXX x.x.x -- Error-message(debug-mod must be tuned on) -- : Error_message When trying to upgrade to Hikashop essential: enter shop, click on a product and it redirects to site Home Page. rather than to the product page. In Admin, Hikashop>products>product folder, select a product and it shows an SQL database error. Have done a backup restore to reinstate the database and free version of Hikashop. Have spent several hours trying to track down information on this but don't seem to be able to find any reference to this issue. Thanks.")* was created by *[Keith49](/forum/user/31200-keith49 "View Keith49's Profile")* -- url of the page with the problem -- : [ mywebsite.com/mypage](http://mywebsite.com/mypage) -- HikaShop version -- : 2.3 -- Joomla version -- : 3.1.6 -- PHP version -- : 5.3.28 -- Browser(s) name and version -- : XXXXX x.x.x -- Error-message(debug-mod must be tuned on) -- : Error_message When trying to upgrade to Hikashop essential: enter shop, click on a product and it redirects to site Home Page. rather than to the product page. In Admin, Hikashop>products>product folder, select a product and it shows an SQL database error. Have done a backup restore to reinstate the database and free version of Hikashop. Have spent several hours trying to track down information on this but don't seem to be able to find any reference to this issue. Thanks. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2NTkxNS11cGdyYWRlLWNyZWF0ZXMtZGF0YWJhc2UtaXNzdWVzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Online](/forum/user/63-nicolas) Less More - Posts: 86292 - Thank you received: 14271 - - 12 years 8 months ago [\#144207](#144207) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Upgrade creates database issues](/forum/25-install-update/865915-upgrade-creates-database-issues#144207 "-- url of the page with the problem -- : mywebsite.com/mypage -- HikaShop version -- : 2.3 -- Joomla version -- : 3.1.6 -- PHP version -- : 5.3.28 -- Browser(s) name and version -- : XXXXX x.x.x -- Error-message(debug-mod must be tuned on) -- : Error_message When trying to upgrade to Hikashop essential: enter shop, click on a product and it redirects to site Home Page. rather than to the product page. In Admin, Hikashop>products>product folder, select a product and it shows an SQL database error. Have done a backup restore to reinstate the database and free version of Hikashop. Have spent several hours trying to track down information on this but don't seem to be able to find any reference to this issue. Thanks.")* This is referenced here in the documentation: [ www.hikashop.com/support/support/documen...lity-issues.html#SQL](http://www.hikashop.com/support/support/documentation/61-hikashop-compatibility-issues.html#SQL) The following user(s) said Thank You: [Keith49](/forum/user/31200-keith49 "View Keith49's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2NTkxNS11cGdyYWRlLWNyZWF0ZXMtZGF0YWJhc2UtaXNzdWVzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Keith49](/forum/user/31200-keith49 "View Keith49's Profile")** - [![Keith49's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31200-keith49 "View Keith49's Profile") Topic Author - [ Offline](/forum/user/31200-keith49) Less More - Posts: 2 - Thank you received: 0 - - 12 years 8 months ago [\#144322](#144322) by [Keith49](/forum/user/31200-keith49 "View Keith49's Profile") Replied by *[Keith49](/forum/user/31200-keith49 "View Keith49's Profile")* on topic *[Upgrade creates database issues](/forum/25-install-update/865915-upgrade-creates-database-issues#144322 "-- url of the page with the problem -- : mywebsite.com/mypage -- HikaShop version -- : 2.3 -- Joomla version -- : 3.1.6 -- PHP version -- : 5.3.28 -- Browser(s) name and version -- : XXXXX x.x.x -- Error-message(debug-mod must be tuned on) -- : Error_message When trying to upgrade to Hikashop essential: enter shop, click on a product and it redirects to site Home Page. rather than to the product page. In Admin, Hikashop>products>product folder, select a product and it shows an SQL database error. Have done a backup restore to reinstate the database and free version of Hikashop. Have spent several hours trying to track down information on this but don't seem to be able to find any reference to this issue. Thanks.")* Further to this above problem - I have access to the write function of the database, so this is not an issue. Have again tried to upgrade and again, it breaks... Here is the error message displayed against products after upgrade: An error has occurred. 0 SQL=SELECT b.*,c.* FROM gf_hikashop_category AS a LEFT JOIN gf_hikashop_taxation AS b ON a.category_namekey=b.category_namekey LEFT JOIN gf_hikashop_tax AS c ON b.tax_namekey=c.tax_namekey WHERE a.category_id = 11 AND b.taxation_published=1 AND ( taxation_type = '' OR taxation_type = 'company_without_vat_number' ) AND b.taxation_date_start <= 1392610655 AND (b.taxation_date_end = 0 OR b.taxation_date_end > 1392610655) Any suggestions... Cheers, Keith Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2NTkxNS11cGdyYWRlLWNyZWF0ZXMtZGF0YWJhc2UtaXNzdWVzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Online](/forum/user/63-nicolas) Less More - Posts: 86292 - Thank you received: 14271 - - 12 years 8 months ago [\#144438](#144438) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Upgrade creates database issues](/forum/25-install-update/865915-upgrade-creates-database-issues#144438 "-- url of the page with the problem -- : mywebsite.com/mypage -- HikaShop version -- : 2.3 -- Joomla version -- : 3.1.6 -- PHP version -- : 5.3.28 -- Browser(s) name and version -- : XXXXX x.x.x -- Error-message(debug-mod must be tuned on) -- : Error_message When trying to upgrade to Hikashop essential: enter shop, click on a product and it redirects to site Home Page. rather than to the product page. In Admin, Hikashop>products>product folder, select a product and it shows an SQL database error. Have done a backup restore to reinstate the database and free version of Hikashop. Have spent several hours trying to track down information on this but don't seem to be able to find any reference to this issue. Thanks.")* It's not the write, it's the "ALTER" capabilities which have to be activated for the user group. Also, if you already did the update, running again the update won't run the ALTER queries again as the system will consider itself already up to date. Alternatively, you can also follow the documentation link I gave and run the ALERT queries yourself via phpmyadmin and that will fix the problem. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2NTkxNS11cGdyYWRlLWNyZWF0ZXMtZGF0YWJhc2UtaXNzdWVzP3RtcGw9bWFya2Rvd24=) 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.100 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)