vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)

- - Error (https://vborg.vbsupport.ru/showthread.php?t=320615)

yippykiyey

10-27-2015 01:52 PM

Error

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

10-27-2015 02:10 PM

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

10-27-2015 02:14 PM

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

10-27-2015 05:50 PM

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

10-28-2015 12:06 PM

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

10-28-2015 04:52 PM

Code:

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

Code:

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

RichieBoy67

10-28-2015 04:56 PM

Quote:

Originally Posted by ForceHSS (Post 2557765)

Code:

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

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

10-28-2015 05:29 PM

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

10-28-2015 06:21 PM

Quote:

Originally Posted by ForceHSS (Post 2557773)

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. :)

All times are GMT. The time now is 06:56 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01234 seconds Memory Usage 1,732KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (9)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: