fbpx

Astroid 2.4 Landed with Joomla 4 Compatibility Download Now

Welcome, Guest
Username: Password: Remember me

TOPIC: (SOLVED)database problem

database problem 7 months 1 week ago #20303

  • melix
  • melix's Avatar
  • Offline
  • New Member
  • Posts: 14
  • Karma: 0
Hi, i'm trying to install jd_yogahut_v1.0_Quickstart_j3.9.14 but I have problem with database:

Failed to add the foreign key constraint 'namedatabase/fk_#__acym_user_stat1' to system tables
Failed to add the foreign key constraint 'namedatabase/fk_#__acym_user_has_list1' to system tables
Failed to add the foreign key constraint 'namedatabase/fk_#__acym_user_has_field1' to system tables
Failed to add the foreign key constraint 'namedatabase/fk_#__acym_url_click_has_mail' to system tables
Failed to add the foreign key constraint 'namedatabase/fk#__acym__step1' to system tables
Failed to add the foreign key constraint 'namedatabase/fk_#__acym_queue1' to system tables
ecc ecc ecc ecc ecc ecc ecc ecc ecc ecc ecc ecc ecc ecc ecc

and also:
Table 'namedatabase.#__j2store_orderdiscounts' doesn't exist
Index column size too large. The maximum column size is 767 bytes.
The topic has been locked.

database problem 7 months 1 week ago #20308

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Posts: 4033
  • Thank you received: 592
  • Karma: 104
It looks like you may be running an older version of mysql/Maria DB that's causing this.

Can you provide the exact version you are using and we'll see if we can make a fix on our end.

Thanks,
Chetan
Thank You,
If you like our support and products, tweet us at joomdev and let the world know about it.
The topic has been locked.

database problem 7 months 1 week ago #20311

  • melix
  • melix's Avatar
  • Offline
  • New Member
  • Posts: 14
  • Karma: 0
thank you! the version mysql DB is 5.6.45
The topic has been locked.

database problem 7 months 1 week ago #20314

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Posts: 4033
  • Thank you received: 592
  • Karma: 104
I think you need to upgrade to Mysql 5.7 or Maria DB 10.2 or later.

Thanks,
Chetan
Thank You,
If you like our support and products, tweet us at joomdev and let the world know about it.
The topic has been locked.
The following user(s) said Thank You: melix

database problem 7 months 1 week ago #20340

  • melix
  • melix's Avatar
  • Offline
  • New Member
  • Posts: 14
  • Karma: 0
ok with mysql update work fine. Thank you for your time!
The topic has been locked.

database problem 7 months 1 week ago #20345

  • nishtha
  • nishtha's Avatar
  • Offline
  • Moderator
  • Posts: 1269
  • Thank you received: 123
  • Karma: 16
Hi,

Perfect Topic Closed then.

Thanks,
Nishtha
Thank You,
If you like our support and products, tweet us at joomdev and let the world know about it.

To know more about products check out the their documentation.
The topic has been locked.
Time to create page: 0.366 seconds