Error

[yippykiyey]

I'm not sure if I am posting this in the correct place and If I'm not than I am sorry. I have this error..Any help would be awesome, thanks in advance!

Warning: mysqli_query(): (42000/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. in /var/www/html/uohl/public_html/includes/class_core.php on line 1394

[squidsk]

Your mysql settings have limited the number the rows being returned to 8126. You'll need to change or get your host to change your mysql settings and then restart mysql.

[yippykiyey]

How would I do this on my own?

--------------- Added 1445961876 at 1445961876 ---------------

Server guys said I would have to do it on my own sadly, so Now I would need to know how to do it haha. We're using PHPMYADMIN if that helps anyone explaining how to change the settings.

[Lynne]

You need access to the my.cnf file in order to change mysql settings.

Google shows several results on that error. A couple are here:
http://stackoverflow.com/questions/22637733/mysql-error-code-1118-row-size-too-large-8126-changing-some-columns-to-te
http://stackoverflow.com/questions/15585602/change-limit-for-mysql-row-size-too-large

[RichieBoy67]

I may be mistaken but I believe it is the innodb_log_file_size or something like that. Increase that and restart your database server and you should be ok.

[ForceHSS]

function &execute_query($buffered = true, &$link)
{
$this->connection_recent =& $link;
$this->querycount++;

if ($queryresult = mysqli_query($link, $this->sql, ($buffered ? MYSQLI_STORE_RESULT : MYSQLI_USE_RESULT)))
{
// unset $sql to lower memory .. this isn't an error, so it's not needed
$this->sql = '';

return $queryresult;
}
else
{
$this->halt();

// unset $sql to lower memory .. error will have already been thrown
$this->sql = '';
}
}


line 1394 above I added extra of the code

if ($queryresult = mysqli_query($link, $this->sql, ($buffered ? MYSQLI_STORE_RESULT : MYSQLI_USE_RESULT)))

[RichieBoy67]

function &execute_query($buffered = true, &$link)
{
$this->connection_recent =& $link;
$this->querycount++;

if ($queryresult = mysqli_query($link, $this->sql, ($buffered ? MYSQLI_STORE_RESULT : MYSQLI_USE_RESULT)))
{
// unset $sql to lower memory .. this isn't an error, so it's not needed
$this->sql = '';

return $queryresult;
}
else
{
$this->halt();

// unset $sql to lower memory .. error will have already been thrown
$this->sql = '';
}
}
line 1394 above I added extra of the code

if ($queryresult = mysqli_query($link, $this->sql, ($buffered ? MYSQLI_STORE_RESULT : MYSQLI_USE_RESULT)))
Pretty slick my friend. Has that been tested? If he doesn't have access to my.cnf than this would be vital.

[ForceHSS]

When I said I added extra of the code I meant I posted what is in the file from the default one I am too busy to recode anything today

[RichieBoy67]

When I said I added extra of the code I meant I posted what is in the file from the default one I am too busy to recode anything todayAh I see. I thought it was a fix. :)