Iratzar Carrasson Bores Iratzar Carrasson Bores - 6 months ago 22
MySQL Question

#1036 - Table is read only in phpMyAdmin

i'm using a database host with phpMyAdmin. This host isn't mine.

I execute this code in the phpMyAdmin of this host:

INSERT INTO `fronton`(`id`, `Name`, `number`, `cover`, `ligth`, `type`, `height`, `widht`, `lenght`, `latitude`, `longitude`, `status`, `time`, `price`) VALUES (NULL , 'Barrikako Frontoia', '9', '1', '2', '0', NULL , NULL , NULL , '0,3454232', '0,32243243', '0', '0', '0')


And this error appear:


1036 - Table 'fronton' is read only




I have been searching a lot about it but i haven't found nothing. Someone know what i can do about this?

Updated:

Now i am using a host service called Hostinger and i have the same problem.

Thank you so much!

Answer

i found the solution to the problem. Instead of use this code:

ENGINE=MRG_MyISAM DEFAULT CHARSET=utf8mb4;

i have to use:

ENGINE=innoDB DEFAULT CHARSET=utf8;

it was a engine error.