Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 10-09-2013, 03:33 AM
Digital Jedi's Avatar
Digital Jedi Digital Jedi is offline
 
Join Date: Oct 2006
Location: PopCulturalReferenceLand
Posts: 5,171
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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");
                }

            } 
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 12:30 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03614 seconds
  • Memory Usage 2,233KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)showthread_list
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_threadedmode.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids_threaded
  • showthread_threaded_construct_link
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete