SA-MP Forums Archive
mysql error. - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: mysql error. (/showthread.php?tid=600395)


mysql error. - CSCripMa - 07.02.2016

Hi,

Code:
(error #1118) Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
I was reading that i need to remake my table structure, changing innodb_file_format to barracuda row format dynamic, but that didn't help i still sometimes get this error. Maybe possible to make higher value of this limit > 8126? because i save a lot of text, last kill player names, last 20 send messages and so on and i unable to minimise it, and with time i create more and more collums and in future this will be bigger problem.

Re: mysql error. - Vince - 07.02.2016

Make more tables, more rows and less columns. If you have message1 through message20 then evidently you will hit that limit. Anything that has a number behind it must be split into different tables where the number essentially becomes the id, i.e.:

Messages
iduserIdmessage
17message 1
27message 2
37message 3
.........
197message 19
207message 20


Re: mysql error. - CSCripMa - 07.02.2016

What is limit of columns?

Re: mysql error. - mirou123 - 07.02.2016

Quote:
Originally Posted by CSCripMa
View Post
What is limit of columns?
4096.
Read this for more information.