S
S
Sandro_s2018-05-05 00:13:47
MySQL
Sandro_s, 2018-05-05 00:13:47

Error in the database with strings - how to fix it?

The same error occurs when adding entries to the guestbook ("Error adding entry!") and when trying to register. The code is almost the same.
Create database
CREATE TABLE `mysite-local`.`guestbook` ( `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT , `name` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL , `comment` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL , PRIMARY KEY (`id`)) ENGINE = MyISAM CHARSET=utf8 COLLATE utf8_general_ci;
In phpMyAdmin - "MySQL returned an empty result (i.e. zero rows). (Query took 0.0005 seconds)"
Open Server
in MySQL Manager - "key index 'index 1" does not contain any column"
5aecccf6d523c901698319.jpeg

Answer the question

In order to leave comments, you need to log in

1 answer(s)
I
ivankomolin, 2018-05-17
@ivankomolin

Insert in the table (which creation code you resulted) cannot produce such error. Since there is no index "Index 1" in it.
Look at the indexes set on the table you are inserting into.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question