#1036 - Table is read only in phpMyAdmin

Question

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

I executed 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 anything. Does anyone 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!

duplicate of [table-is-read-only](http://stackoverflow.com/questions/9575914/table-is-read-only) — amdixon, Aug 23 '15 at 00:53
This question is not duplicate, because this link speaks about a server of MySQL and about the path /var/db/mysql and his privileges. But in my case, i can't access to that folder or apply some privilege with GRANT. What i can do? — Iratzar Carrasson Bores, Aug 23 '15 at 08:22

score 3 · Answer 1 · answered Apr 27 '19 at 03:43

3

If you are using windows server than you comment line innodb_force_recovery = 1 to #innodb_force_recovery = 1 in my.ini

It works for me.

answered Apr 27 '19 at 03:43

vpgodara

329
2
2

I forgot that I added this line. :D Thank you. – OzgurG May 19 '20 at 11:44

score 2 · Accepted Answer · answered Aug 25 '15 at 21:15

2

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.

answered Aug 25 '15 at 21:15

Iratzar Carrasson Bores

57
1
2
10

#1036 - Table is read only in phpMyAdmin

1036 - Table 'fronton' is read only

2 Answers2

Linked