allura quickstart demo - problem with mysql during instalation - Forum | JoomShaper
Solved General

allura quickstart demo - problem with mysql during instalation

Asked by lucie sulerka 2 years ago Last activity 2 years ago

Every time I try to install the demo. I'm having trouble completing the installation. There is always a problem in the database with: 'wms_d244_belug1.vnhdk_easystore_categories' doesn't exist

Your AI tell me: It seems that you are facing an issue while installing the Allura Quickstart J4 v1.0.1. To resolve this issue, please follow the steps below:

Go to the location: installation/sql/mysql and replace the custom.sql file with the attached file.
Unzip the file and then replace it: custom.sql.zip
Compare your PHP setting with Technical Requirements.
Upgrade used PHP version (to PHP 7.4 or PHP 8.0), and increasing the maximum execution time for PHP to 600 or 800 (better).

I tried according to the instructions, but an empty joomla was uploaded. No any demo data. I absolutely do not like this. I do not know what do with it.

Accepted answer

Marked as the solution

18 more replies

Oldest first Newest first Most helpful
lucie sulerka Asked this
2 years ago

Every time there is a problem in the database with uploading tables from easystore part. And cannot complete the installation.

lucie sulerka Asked this
2 years ago

with setting MYSQL (PDO) writed message:
42000, 1071, Specified key was too long; max key length is 767 bytes
42S02, 1146, Table 'wms_d244_belug1.xebt1_easystore_categories' doesn't exist
42S02, 1146, Table 'wms_d244_belug1.xebt1_easystore_coupons' doesn't exist
42S02, 1146, Table 'wms_d244_belug1.xebt1_easystore_product_skus' doesn't exist

and again it won't let me go to the next step of the installation.

I saw that in the database that almost all the tables have been uploaded. So I exported the database and backup. And delete database from server. After i try replace it: custom.sql.zip in /installation/sql/mysql and installed empty joomla.

After in configuration file change database prefix and import backup database. Now demo working with error. I think exactly those tables are missing: 42000, 1071, Specified key was too long; max key length is 767 bytes
42S02, 1146, Table 'wms_d244_belug1.xebt1_easystore_categories' doesn't exist
42S02, 1146, Table 'wms_d244_belug1.xebt1_easystore_coupons' doesn't exist
42S02, 1146, Table 'wms_d244_belug1.xebt1_easystore_product_skus' doesn't exist

This is the only way I finally got the demo to work for me :(

Can someone help me upload the rest of the tables or send me mysql database backup from demo?

Very thanx . 'm already unhappy with it. time is running

Toufiq Senior Staff
2 years ago

Hi there,

I appreciate you reaching out. I sincerely apologize for this oversight. Will you please provide me the Joomla administrator access to check the issue? I will check & get back to you soon. 

-Thanks

lucie sulerka Asked this
2 years ago

I do not have access because there's probably a problem somewhere and the password doesn't work.

it was not installed in the classic way, which did not work

lucie sulerka Asked this
2 years ago

42000, 1071, Specified key was too long; max key length is 767 bytes
42S02, 1146, Table 'wms_d244_belug2.du7mw_easystore_categories' doesn't exist
42S02, 1146, Table 'wms_d244_belug2.du7mw_easystore_product_skus' doesn't exist

Toufiq Senior Staff
2 years ago

Can you provide me cpanel/hosting server access to install the quickstart package?

lucie sulerka Asked this
2 years ago

yes! very thanx!! after 10 min i send you in hide message

lucie sulerka Asked this
2 years ago

now i send in hide

Toufiq Senior Staff
2 years ago

Is it possible to provide me hosting server access?

Toufiq Senior Staff
2 years ago

Are you there? I am wating for your response. Thanks

lucie sulerka Asked this
2 years ago

ftp ?

lucie sulerka Asked this
2 years ago

you think problem is with version of MariaDB on webhosting ?

Toufiq Senior Staff
2 years ago

Without checking i can't make sure anything. Is it possible to share cpanel access? domain.com/cpanel?

lucie sulerka Asked this
2 years ago

ok

lucie sulerka Asked this
2 years ago

now

lucie sulerka Asked this
2 years ago


try install on other hosting with mysql version - (10.4.31-MariaDB-log)
newer version and same problem :( I've been struggling for 14 days, time is money, this is a massacre

lucie sulerka Asked this
2 years ago

I have verified that the database version plays a role there. Now have good version: 10.4.31-MariaDB-log.

Now no see error mesage like this: 42000, 1071, Specified key was too long; max key length is 767

But even then everything doesn't install. The first message is that there is an installation error.
I press the install button twice and tell me:

somehow not all tables are uploaded to the database.

do you have another version to install?

I will give you access to another hosting with good version maria db.

Log in to reply.