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

  • Posts: 363
  • Thank you received: 7
  • Hikashop Business
5 years 5 months ago #307197

-- 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.

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13375
  • MODERATOR
5 years 5 months ago #307199

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.

Please Log in or Create an account to join the conversation.

  • Posts: 363
  • Thank you received: 7
  • Hikashop Business
5 years 5 months ago #307210

Hi,

Please see attached image with the details requested.

Thank you!

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13375
  • MODERATOR
5 years 5 months ago #307224

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.

Please Log in or Create an account to join the conversation.

  • Posts: 363
  • Thank you received: 7
  • Hikashop Business
5 years 5 months ago #307285

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.

Please Log in or Create an account to join the conversation.

Time to create page: 0.066 seconds
Powered by Kunena Forum