MRatWork Forum by Mustafa Ramadhan

Sawo Project - Kloxo-MR Discussions => Kloxo-MR Technical Helps => Topic started by: nikobellicgamerin on 2019-10-31, 13:27:53

Title: keep getting SQLSTATE[42000] innodb error whicle i wanna install a website .
Post by: nikobellicgamerin on 2019-10-31, 13:27:53

SQLSTATE[42000]: Syntax error or access violation: 1286 Unknown storage engine 'innodb' (SQL: create table `migrations` (`id` int unsigned not null auto_increment primary key, `migration` varchar(191) not null, `batch` int not null) default character set utf8mb4 collate utf8mb4_unicode_ci engine = innodb)

how to fix this

Title: Re: keep getting SQLSTATE[42000] innodb error whicle i wanna install a website .
Post by: MRatWork on 2019-10-31, 14:38:37

Change 'skip-innodb' to '#skip-innodb' in '/etc/my.cnf.d/server.cnf' and then run 'sh /script/restart-mysql'.

Title: Re: keep getting SQLSTATE[42000] innodb error whicle i wanna install a website .
Post by: nikobellicgamerin on 2019-10-31, 14:50:03

i have done but still same issue

SQLSTATE[42000]: Syntax error or access violation: 1286 Unknown storage engine 'innodb' (SQL: create table `migrations` (`id` int unsigned not null auto_increment primary key, `migration` varchar(191) not null, `batch` int not null) default character set utf8mb4 collate utf8mb4_unicode_ci engine = innodb)

Title: Re: keep getting SQLSTATE[42000] innodb error whicle i wanna install a website .
Post by: MRatWork on 2019-11-01, 03:06:48

Give me ssh and panel access.

Title: Re: keep getting SQLSTATE[42000] innodb error whicle i wanna install a website .
Post by: nikobellicgamerin on 2019-11-01, 04:57:24

i dont have access to ssh

Title: Re: keep getting SQLSTATE[42000] innodb error whicle i wanna install a website .
Post by: nikobellicgamerin on 2019-11-01, 06:14:14

help me

Title: Re: keep getting SQLSTATE[42000] innodb error whicle i wanna install a website .
Post by: MRatWork on 2019-11-01, 06:27:33

Go 'admin > servers > localhost > file manager' and then find out '/etc/my.cnf.d/server.cnf' file. For this file, change 'skip-innodb' to '#skip-innodb'.

After that, go to 'admin > command center' and then run 'sh /script/restart-mysql'.

Title: Re: keep getting SQLSTATE[42000] innodb error whicle i wanna install a website .
Post by: nikobellicgamerin on 2019-11-01, 09:04:00

this i have already done nothing happen

Title: Re: keep getting SQLSTATE[42000] innodb error whicle i wanna install a website .
Post by: nikobellicgamerin on 2019-11-01, 09:11:23

thankyou now its working :D