Code:
[Warning] InnoDB: Cannot add field `phone2` in table `engine`.`addresses` because after adding it, the row size is 8457 which is greater than maximum allowed size
(8126) for a record on index leaf page.
[Warning] InnoDB: Cannot add field `phone2` in table `engine`.`addresses` because after adding it, the row size is 8457 which is greater than maximum allowed size
(8126) for a record on index leaf page.
Ne znam o cemu se radi:
tabela:
Code:
MariaDB [engine]> desc addresses;
+--------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+-------+
| first_name | varchar(255) | YES | | NULL | |
| last_name | varchar(255) | YES | | NULL | |
| company_name | varchar(255) | YES | | NULL | |
| address | varchar(255) | YES | | NULL | |
| city | varchar(255) | YES | | NULL | |
| county | varchar(255) | YES | | NULL | |
| state | varchar(255) | YES | | NULL | |
| zip | varchar(255) | YES | | NULL | |
| phone1 | varchar(255) | YES | | NULL | |
| phone2 | varchar(255) | YES | | NULL | |
| email | varchar(255) | NO | PRI | NULL | |
| web | varchar(255) | YES | | NULL | |
+--------------+--------------+------+-----+---------+-------+
MariaDB [engine]> desc addresses;
+--------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+-------+
| first_name | varchar(255) | YES | | NULL | |
| last_name | varchar(255) | YES | | NULL | |
| company_name | varchar(255) | YES | | NULL | |
| address | varchar(255) | YES | | NULL | |
| city | varchar(255) | YES | | NULL | |
| county | varchar(255) | YES | | NULL | |
| state | varchar(255) | YES | | NULL | |
| zip | varchar(255) | YES | | NULL | |
| phone1 | varchar(255) | YES | | NULL | |
| phone2 | varchar(255) | YES | | NULL | |
| email | varchar(255) | NO | PRI | NULL | |
| web | varchar(255) | YES | | NULL | |
+--------------+--------------+------+-----+---------+-------+
Da li je to vece nego sto moze da smesti pa se desava nesto sto ne valja? Inace tabela izgleda ok, nema nikakvih problema da
primetim.