1054 Unknown column 'type_title' in 'field list' when installing

-- HikaShop version -- : 4.1
-- Joomla version -- : 3.9
-- PHP version -- : 7.1

Hi,

I'm trying to install hikashop and getting:

1054 Unknown column 'type_title' in 'field list'

I have tried to "check database" and everything reports ok


OK Table "hikashop_address" checked

OK Table "hikashop_badge" checked

OK Table "hikashop_banner" checked

OK Table "hikashop_cart" checked

OK Table "hikashop_cart_product" checked

OK Table "hikashop_category" checked

OK Table "hikashop_characteristic" checked

OK Table "hikashop_click" checked

OK Table "hikashop_config" checked

OK Table "hikashop_currency" checked

OK Table "hikashop_discount" checked

OK Table "hikashop_download" checked

OK Table "hikashop_entry" checked

OK Table "hikashop_field" checked

OK Table "hikashop_file" checked

OK Table "hikashop_filter" checked

OK Table "hikashop_geolocation" checked

OK Table "hikashop_history" checked

OK Table "hikashop_limit" checked

OK Table "hikashop_massaction" checked

OK Table "hikashop_order" checked

OK Table "hikashop_orderstatus" checked

OK Table "hikashop_order_product" checked

OK Table "hikashop_payment" checked

OK Table "hikashop_price" checked

OK Table "hikashop_product" checked

OK Table "hikashop_product_category" checked

OK Table "hikashop_product_related" checked

OK Table "hikashop_plugin" checked

OK Table "hikashop_shipping" checked

OK Table "hikashop_shipping_price" checked

OK Table "hikashop_tax" checked

OK Table "hikashop_taxation" checked

OK Table "hikashop_user" checked

OK Table "hikashop_variant" checked

OK Table "hikashop_vote" checked

OK Table "hikashop_vote_user" checked

OK Table "hikashop_waitlist" checked

OK Table "hikashop_widget" checked

OK Table "hikashop_zone" checked

OK Table "hikashop_zone_link" checked

OK Table "hikashop_warehouse" checked

OK Product categories checked

OK Variants orphan links cleaned

OK Joomla users synchronized

OK User email addresses synchronized


Please advise.

Hi,

There is no such column in HikaShop. There is a column with the same name in the Joomla tags system. But I don't see why it would create an error during the installation of HikaShop.
Please do this modification to get the MySQL query of that error message:
www.hikashop.com/support/forum/product-c...eld-list.html#304882
And please try again after activating the "error reporting" and "debug mode" settings of the Joomla configuration.
You should get more information on the error screen which will help us better understand the situation.

Hi,

Please see attached image with the details requested.

Thank you!

Hi,

It seems that you're missing the type_title column in the content_types table of Joomla. That's a standard column of Joomla for its tag system.
Go to the menu Manage->Extensions->Database and click on the "fix" button. It should hopefully fix that.

Hi,

Go to the menu Manage->Extensions->Database and click on the "fix" button. It should hopefully fix that.

Unfortunately that didn't work.

The way I fixed it was to copy the table structure from another working site.

Many thanks.