Gantry 5 and Hydrogen template problem

-- url of the page with the problem -- : carterrabbitclothing.com/newdesign
-- HikaShop version -- : 2.6.0
-- Joomla version -- : 3.4.8
-- PHP version -- : 5.4.43
-- Browser(s) name and version -- : various
-- Error-message(debug-mod must be tuned on) -- : jos-Warning: exception 'RuntimeException' with message 'Unknown column 'header' in 'field list' SQL=SELECT `new_url`,`header`,`published` FROM `ahdtu_redirect_links` WHERE `old_url` = ' carterrabbitclothing.com/newdesign/shop/.../171-girls-bib-dress ' LIMIT 0, 1' in /home/ACCTNAME/public_html/libraries/joomla/database/driver/mysqli.php:610 Stack trace: #0 /home/ACCTNAME/public_html/libraries/joomla/database/driver.php(1279): JDatabaseDriverMysqli->execute() #1 /home/ACCTNAME/public_html/plugins/system/redirect/redirect.php(86): JDatabaseDriver->loadObject() #2 [internal function]: PlgSystemRedirect::handleError(Object(JException)) #3 /home/ACCTNAME/public_html/libraries/legacy/error/error.php(760): call_user_func(Array, Object(JException)) #4 [internal function]: JError::handleCallback(Object(JException), Array) #5 /home/ACCTNAME/public_html/libraries/legacy/error/error.php(218): call_user_func_array(Array, Array) #6 /home/ACCTNAME/public_html/libraries/legacy/error/error.php(179): JError::throwError(Object(JException)) #7 /home/ACCTNAME/public_html/libraries/legacy/error/error.php(254): JError::raise(1, 404, 'Article not fou...', NULL, true) #8 /home/ACCTNAME/public_html/components/com_content/models/article.php(163): JError::raiseError(404, 'Article not fou...') #9 /home/ACCTNAME/public_html/libraries/legacy/view/legacy.php(401): ContentModelArticle->getItem() #10 /home/ACCTNAME/public_html/components/com_content/views/article/view.html.php(42): JViewLegacy->get('Item') #11 /home/ACCTNAME/public_html/libraries/joomla/cache/controller/view.php(96): ContentViewArticle->display() #12 /home/ACCTNAME/public_html/libraries/legacy/controller/legacy.php(686): JCacheControllerView->get(Object(ContentViewArticle), 'display') #13 /home/ACCTNAME/public_html/components/com_content/controller.php(104): JControllerLegacy->display(true, Array) #14 /home/ACCTNAME/public_html/libraries/legacy/controller/legacy.php(728): ContentController->display() #15 /home/ACCTNAME/public_html/components/com_content/content.php(38): JControllerLegacy->execute(NULL) #16 /home/ACCTNAME/public_html/libraries/cms/component/helper.php(392): require_once('/home/ACCTNAME/...') #17 /home/ACCTNAME/public_html/libraries/cms/component/helper.php(372): JComponentHelper::executeComponent('/home/ACCTNAME/...') #18 /home/ACCTNAME/public_html/libraries/cms/application/site.php(191): JComponentHelper::renderComponent('com_content') #19 /home/ACCTNAME/public_html/libraries/cms/application/site.php(230): JApplicationSite->dispatch() #20 /home/ACCTNAME/public_html/libraries/cms/application/cms.php(252): JApplicationSite->doExecute() #21 /home/ACCTNAME/public_html/index.php(45): JApplicationCms->execute() #22 {main}

I am doing a redesign on a website so I duplicated it to a '/newdesign/' folder and setup a new database name. Everything works fine except HikaShop product links. I have changed all of the 'redirect' links to include the '/newdesign/' in the URL links. Same error message. So I disabled the 'redirect' plug-in. Same error message. I re-enabled the 'redirect' plug-in but removed all records in the '#_redirect_links' table. Same error message.

I applied the following via SQL:

ALTER TABLE `ahdtu__redirect_links` ADD header smallint(3) NOT NULL DEFAULT 301;
ALTER TABLE `ahdtu__redirect_links` MODIFY new_url varchar(255);

Database table structure is up to date.

    Other Information

    Database schema version (in #__schemas): 3.4.0-2015-02-26.
    Update version (in #__extensions): 3.4.8.
    Database driver: mysqli.
    80 database changes were checked successfully.
    144 database changes did not alter table structure and were skipped.

Error: 1054 - Unknown column 'header' in 'field list' SQL=SELECT `new_url`,`header`,`published` FROM `ahdtu_redirect_links` WHERE `old_url` = 'https://carterrabbitclothing.com/newdesign/shop' LIMIT 0, 1

Jerome,

Well the issue appears on the 'shop' page when I click on the product to go to the details for that product. Am I missing something here?

Not sure if it helps but I have just installed hikashop on my test server with the Hydrogen Gantry 5 template and it all appears to be working OK!

Jerome,

You are probably correct.

This was a site that I duplicated, with a different database name, in a sub-folder for development purposes as the same time that the client changed their primary domain name. With so many entries in the database referring to the old domain name, it will probably be best to just create a new website and manually setup the content including the shopping cart.

Thanks.

I've just had a very similar issue with the Error: 1054 being issued when I tried to empty the cart.

Not sure if Luke has mijosef installed but when I disabled that the problem disappeared.

Nope. I didn't have mijosef installed. Rebuilt the site and it works fine.