Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Zikula 3.0.4 fails to install on MYSQL 5.5 #4825

Closed
prbt2016 opened this issue Dec 21, 2021 · 4 comments
Closed

Zikula 3.0.4 fails to install on MYSQL 5.5 #4825

prbt2016 opened this issue Dec 21, 2021 · 4 comments
Labels
Milestone

Comments

@prbt2016
Copy link

prbt2016 commented Dec 21, 2021

Expected behaviour - What did you expect to happen?

Zikula 3.0.4 should be successfully installed on MYSQL 5.5

Current behavior - What happened instead?

I was in the process of manual installation of Zikula 3.0.4 downloaded from official website, on CentOS Linux release 7.6.1810 (Core) with PHP 7.2.34, MYSQL 5.5.62, 2.2.34. However I get Internal server error while doing the same.

After entering the database details and admin details, when I click on 'Begin Install' following error is thrown after enabling debug mode via .env file i.e setting APP_ENV=dev and
APP_DEBUG=1 on hitting the following URL i.e :

://{{DOMAIN.COM}}/zikula304/public/install/ajaxinstaller#installCard

Following is the error thrown via alert i.e :

Schema-Tool failed with Error 'An exception occurred while executing 'CREATE TABLE block_positions (pid INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, description VARCHAR(255) NOT NULL, INDEX name_idx (name), PRIMARY KEY(pid)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB':

SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes.' while executing DDL: CREATE TABLE block_positions (pid INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, description VARCHAR(255) NOT NULL, INDEX name_idx (name), PRIMARY KEY(pid)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB (500 Internal Server Error)

Possible solution

No response

Steps to reproduce

1. Hit the install URL
2. Enter database details
3. Enter admin details
4. Click 'Begin Installer'
Above error is thrown.

Context

No response

Zikula version

3.x-git

PHP version

7.2.x

@prbt2016 prbt2016 added the Bug label Dec 21, 2021
@Guite Guite modified the milestones: 3.0.5, 3.0.4 Dec 21, 2021
Guite added a commit that referenced this issue Dec 21, 2021
@Guite
Copy link
Member

Guite commented Dec 21, 2021

Hi @prbt2016,
thanks for reporting!

The issue is fixed in 0a6f61b - 3.0.4 is to be re-released asap.

@Guite Guite closed this as completed Dec 21, 2021
@prbt2016
Copy link
Author

Thanks @Guite for looking into the issue so quickly.
Kindly let me know when you re-release the 3.0.4 package.

@Guite
Copy link
Member

Guite commented Dec 21, 2021

@prbt2016 the new release is available

@prbt2016
Copy link
Author

Hello @Guite ,

Thanks a lot for the new release of 3.0.4. It's working fine now.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants