[ Branimir Maksimovic @ 03.10.2019. 03:47 ] @
Elem:
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.


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    |       |
+--------------+--------------+------+-----+---------+-------+

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.
[ bogdan.kecman @ 03.10.2019. 04:21 ] @
zaje%$#@%na greska :(

https://dev.mysql.com/doc/refman/5.7/en/innodb-restrictions.html

https://dev.mysql.com/doc/refm...s.html#sysvar_innodb_page_size

https://www.percona.com/blog/2...07/innodb-row-size-limitation/

Citat:

Upgrade to Barracuda format

This is probably the simplest approach, and as Barracuda only uses a 20 byte pointer for variable length types, this problem just goes away.

[ Branimir Maksimovic @ 03.10.2019. 04:49 ] @
Hvala, dump, pa import, je resio. Maria od neke verzije koristi Barracudu kao default.