Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
sadams101 Posted June 20, 2018 Posted June 20, 2018 After updating to 4.3.3 on 6/12, the size of my database when I do a mysql dump went from 3.1 gigs, to 9.0 gigs. What is going on with this update? There is no way my database could grow that fast unless there is a serious issue with this update. How can I get my database back to its correct size?
sadams101 Posted June 20, 2018 Author Posted June 20, 2018 PS - it looks like 6.7 gigs is in the ibf_core_log table. I have 2 questions: 1) Is it safe for me to empty this table? 2) Why am I getting so many uncaught_exception errors like this, and how can I fix this?: SELECT field_ FROM `ibf_core_pfields_content` AS `core_pfields_content` WHERE member_id=28795 IPS\Db\Exception: Unknown column 'field_' in 'field list' (1054) #0 /home/mysite/public_html/system/Db/Select.php(378): IPS\_Db->preparedQuery('/*IPS\\plugins\\d...', Array, true) #1 /home/mysite/public_html/system/Db/Select.php(440): IPS\Db\_Select->runQuery() #2 /home/mysite/public_html/system/Db/Select.php(361): IPS\Db\_Select->rewind() #3 /home/mysite/public_html/plugins/dp43aboutmeinpages/widgets/dp43aboutMeInPages.php(116): IPS\Db\_Select->first() #4 /home/mysite/public_html/system/Widget/Widget.php(797): IPS\plugins\dp43aboutmeinpages\widgets\_dp43aboutMeInPages->render() #5 /home/mysite/public_html/system/Theme/Theme.php(824) : eval()'d code(16692): IPS\_Widget->__toString() #6 /home/mysite/public_html/system/Theme/SandboxedTemplate.php(58): IPS\Theme\class_core_front_global->widgetContainer('header', 'horizontal') #7 /home/mysite/public_html/system/Theme/Theme.php(824) : eval()'d code(6342): IPS\Theme\_SandboxedTemplate->__call('widgetContainer', Array) #8 /home/mysite/public_html/system/Theme/SandboxedTemplate.php(58): IPS\Theme\class_core_front_global->globalTemplate('ba861e78c6653fb...', '\n\n<section id='...', Array) #9 /home/mysite/public_html/system/Output/Output.php(645): IPS\Theme\_SandboxedTemplate->__call('globalTemplate', Array) #10 /home/mysite/public_html/init.php(458) : eval()'d code(26): IPS\_Output->error('Something went ...', 'EX1054', 500, NULL, Array, 'SELECT field_ F...', NULL) #11 /home/mysite/public_html/init.php(573): IPS\cms_hook_Output->error('generic_error', 'EX1054', 500, NULL, Array, 'SELECT field_ F...', NULL) #12 /home/mysite/public_html/system/Widget/Widget.php(806): IPS\IPS::exceptionHandler(Object(IPS\Db\Exception)) #13 /home/mysite/public_html/system/Theme/Theme.php(824) : eval()'d code(16692): IPS\_Widget->__toString() #14 /home/mysite/public_html/system/Theme/SandboxedTemplate.php(58): IPS\Theme\class_core_front_global->widgetContainer('header', 'horizontal') #15 /home/mysite/public_html/system/Theme/Theme.php(824) : eval()'d code(6342): IPS\Theme\_SandboxedTemplate->__call('widgetContainer', Array) #16 /home/mysite/public_html/system/Theme/SandboxedTemplate.php(58): IPS\Theme\class_core_front_global->globalTemplate('ba861e78c6653fb...', '\n\n<section id='...', Array) #17 /home/mysite/public_html/system/Output/Output.php(645): IPS\Theme\_SandboxedTemplate->__call('globalTemplate', Array) #18 /home/mysite/public_html/init.php(458) : eval()'d code(26): IPS\_Output->error('Something went ...', 'EX1054', 500, NULL, Array, 'SELECT field_ F...', NULL) #19 /home/mysite/public_html/init.php(573): IPS\cms_hook_Output->error('generic_error', 'EX1054', 500, NULL, Array, 'SELECT field_ F...', NULL) #20 /home/mysite/public_html/system/Widget/Widget.php(806): IPS\IPS::exceptionHandler(Object(IPS\Db\Exception)) #21 /home/mysite/public_html/system/Theme/Theme.php(824) : eval()'d code(16692): IPS\_Widget->__toString() #22 /home/mysite/public_html/system/Theme/SandboxedTemplate.php(58): IPS\Theme\class_core_front_global->widgetContainer('header', 'horizontal') #23 /home/mysite/public_html/system/Theme/Theme.php(824) : eval()'d code(6342): IPS\Theme\_SandboxedTemplate->__call('widgetContainer', Array) #24 /home/mysite/public_html/system/Theme/SandboxedTemplate.php(58): IPS\Theme\class_core_front_global->globalTemplate('ba861e78c6653fb...', '\n\n<section id='...', Array) #25 /home/mysite/public_html/system/Output/Output.php(645): IPS\Theme\_SandboxedTemplate->__call('globalTemplate', Array) #26 /home/mysite/public_html/init.php(458) : eval()'d code(26): IPS\_Output->error('Something went ...', 'EX1054', 500, NULL, Array, 'SELECT field_ F...', NULL)
sadams101 Posted June 20, 2018 Author Posted June 20, 2018 I was able to delete my log, and found out this is an issue with a widget. I'll contact the person who made this widget.
Tom S. Posted June 20, 2018 Posted June 20, 2018 Why did you post 3374 lines from a log here ? It's only about 8 lines repeating over and over.
Aiwa Posted June 20, 2018 Posted June 20, 2018 dp43aboutmeinpages You'll want to check with @DawPi his plugin is in the stack. And you can set the logs to prune after a couple days.. Keep that table from getting out of control.
sadams101 Posted June 20, 2018 Author Posted June 20, 2018 Well, just so you know, I ran the plugin for ~5 minutes, and it filled my logs with 3 gigs in only 5 minutes!
DawPi Posted June 20, 2018 Posted June 20, 2018 That's weird. Last plugin version sent to you today morning fix this?
sadams101 Posted June 20, 2018 Author Posted June 20, 2018 I'll test it...this was all posted before I realized that the plugin test I did is what was filling my logs.
sadams101 Posted June 20, 2018 Author Posted June 20, 2018 I just wanted to say that DawPi got the custom plugin going without errors--the plugin is for Pages and pulls in the Author's "About Me" picture and content into their article pages.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.