vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Limits Set on Tables to Delete? (https://vborg.vbsupport.ru/showthread.php?t=303146)

Digital Jedi 10-09-2013 03:33 AM
Limits Set on Tables to Delete?
 
When using this query, I've run into the issue of when the number of rows in the table get somewhere around 200, nothing happens. Nothing is deleted, nor can be. As long as the number of rows (in this case, definitions) is around 30-50, I don't seem to have a problem deleting anything. But with the larger table, I can't even delete one item successfully. Is there some kind of limit in my server settings that would cause this?

PHP Code:
$delete     = "";

            if (!empty($oldorder))
            {
                $update        = array();

                foreach($oldorder as $key => $value)
                {

                    if ($deleted["$key"])
                    {
                        $delete .= ($delete ? "," : "") . $key;
                    }
                    else
                    {

                        if ($value != $order["$key"])
                        {
                            $update["$key"]['displayorder'] = $order["$key"];
                        }
                        if ($oldstatus["$key"] != $status["$key"])
                        {
                            $update["$key"]['status'] = $status["$key"];
                        }
                        if ($oldcontainer["$key"] != $container["$key"])
                        {
                            $update["$key"]['container'] = $container["$key"];
                        }
                        if ($oldextract["$key"] != $extract["$key"])
                        {
                            $update["$key"]['extraction'] = $extract["$key"];
                        }

                    }
                }
            }

            if ($delete)
            {
                $db->query_write("DELETE FROM " . TABLE_PREFIX . "automediaembed WHERE id in ($delete)");
            }

            if (sizeof($update))
            {

                foreach($update as $id => $columns)
                {
                    $columninfo = "";

                    foreach ($columns as $column => $value)
                    {
                        $columninfo .= ($columninfo ? ", " : " SET ") . " $column = '$value'";
                    }

                    $db->query_write("UPDATE " . TABLE_PREFIX . "automediaembed $columninfo WHERE id=$id");
                }

            } 

Digital Jedi 10-10-2013 03:47 PM
Looking around, I see that people are having problems with deleting a large number of rows using PHP, but that's when the records are in the thousands/millions. You would think when you're only deleting one row out of a few hundred, it wouldn't be a problem.

nerbert 10-10-2013 04:14 PM
Somewhere (and I couldn't begin to guess where now) I saw a hard coded limit to a query like that. I guess it's a security feature that prevents a hacker from doing too much too quickly.

Digital Jedi 10-12-2013 02:32 AM
That seems odd, considering the number of deleted rows is sometimes 1, and still doesn't work. Then gain, it does look like that's what is happening. At least on my server. I haven't got any feedback that anyone else is experiencing this problem.


All times are GMT. The time now is 01:06 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01047 seconds
  • Memory Usage 1,742KB
  • 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
  • (1)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)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