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 [DATE]1445961876[/DATE] at [TIME]1445961876[/TIME] ---------------

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/2...-columns-to-te
http://stackoverflow.com/questions/1...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]

Originally Posted by 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)))

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]

Originally Posted by 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

Ah I see. I thought it was a fix.