Archived topic
Database tables filled with weird data & CSS styles
3 replies · Started by _blank on November 2, 2018
My site is relatively new, only has 3 posts and 26 pages but my database size is giant! 2 tables in particular are enormous. See below. I wonder if this is related to the Header elements I created. The data seems to come from there.
wp_posts - has 1486 rows in the database including weird data like:
<h2>
About Us
</h2>
<p>Making Waves Web Des...wp_postmeta - has over 3000 rows in the database including weird data like:
<div class="home-hero-text home-header flfl-animation fl-fade-in fl-animated">
Update: I ran WP-Optimize and it took care of some of the records but the weird data ones are still there.
What about the data is weird? Looks like regular metadata/post data to me.
Things like fl-animated make me think you're seeing Beaver Builder row data.
I apologize for late response. Been down some rabbit holes.
Maybe this is normal, just weird to me.
I downloaded a csv of the wp_postmeta table as an example.Sorry formatting sucks. It seems weird because there are
meta_id post_id meta_key meta_value
31 15 _wp_attached_file 2018/09/pubandgrill.jpg
32 15 _wp_attachment_metadata a:5:{s:5:"width";i:1920;s:6:"height";i:1223;s:4:"file";s:23:"2018/09/pubandgrill.jpg";s:5:"sizes";a:4:{s:9:"thumbnail";a:4:{s:4:"file";s:23:"pubandgrill-150x150.jpg";s:5:"width";i:150;s:6:"height";i:150;s:9:"mime-type";s:10:"image/jpeg";}s:6:"medium";a:4:{s:4:"file";s:23:"pubandgrill-300x191.jpg";s:5:"width";i:300;s:6:"height";i:191;s:9:"mime-type";s:10:"image/jpeg";}s:12:"medium_large";a:4:{s:4:"file";s:23:"pubandgrill-768x489.jpg";s:5:"width";i:768;s:6:"height";i:489;s:9:"mime-type";s:10:"image/jpeg";}s:5:"large";a:4:{s:4:"file";s:24:"pubandgrill-1024x652.jpg";s:5:"width";i:1024;s:6:"height";i:652;s:9:"mime-type";s:10:"image/jpeg";}}s:10:"image_meta";a:12:{s:8:"aperture";s:1:"0";s:6:"credit";s:0:"";s:6:"camera";s:0:"";s:7:"caption";s:0:"";s:17:"created_timestamp";s:1:"0";s:9:"copyright";s:0:"";s:12:"focal_length";s:1:"0";s:3:"iso";s:1:"0";s:13:"shutter_speed";s:1:"0";s:5:"title";s:0:"";s:11:"orientation";s:1:"0";s:8:"keywords";a:0:{}}}
33 15 _wp_attachment_image_alt background of pub
47 17 _edit_last 1
48 17 _edit_lock 1542130736:1
49 19 _edit_last 1
50 19 _edit_lock 1542121467:1
51 21 _edit_last 1
52 21 _edit_lock 1542141255:1
95 37 _edit_last 1
96 37 _generate_element_type layout
97 37 _generate_sidebar_layout no-sidebar
99 37 _generate_content_area full-width
100 37 _generate_element_display_conditions a:5:{i:0;a:2:{s:4:"rule";s:9:"post:page";s:6:"object";s:0:"";}i:1;a:2:{s:4:"rule";s:9:"post:page";s:6:"object";s:1:"0";}i:2;a:2:{s:4:"rule";s:22:"post:taxonomy:category";s:6:"object";s:4:"1955";}i:3;a:2:{s:4:"rule";s:18:"general:front_page";s:6:"object";s:1:"0";}i:4;a:2:{s:4:"rule";s:9:"post:page";s:6:"object";s:0:"";}}
101 37 _edit_lock 1542034587:1
131 58 _wp_attached_file 2018/09/food-beer.jpg
132 58 _wp_attachment_metadata a:5:{s:5:"width";i:1920;s:6:"height";i:1280;s:4:"file";s:21:"2018/09/food-beer.jpg";s:5:"sizes";a:4:{s:9:"thumbnail";a:4:{s:4:"file";s:21:"food-beer-150x150.jpg";s:5:"width";i:150;s:6:"height";i:150;s:9:"mime-type";s:10:"image/jpeg";}s:6:"medium";a:4:{s:4:"file";s:21:"food-beer-300x200.jpg";s:5:"width";i:300;s:6:"height";i:200;s:9:"mime-type";s:10:"image/jpeg";}s:12:"medium_large";a:4:{s:4:"file";s:21:"food-beer-768x512.jpg";s:5:"width";i:768;s:6:"height";i:512;s:9:"mime-type";s:10:"image/jpeg";}s:5:"large";a:4:{s:4:"file";s:22:"food-beer-1024x683.jpg";s:5:"width";i:1024;s:6:"height";i:683;s:9:"mime-type";s:10:"image/jpeg";}}s:10:"image_meta";a:12:{s:8:"aperture";s:1:"0";s:6:"credit";s:0:"";s:6:"camera";s:0:"";s:7:"caption";s:0:"";s:17:"created_timestamp";s:1:"0";s:9:"copyright";s:23:"© by Nikolay Trubnikov";s:12:"focal_length";s:1:"0";s:3:"iso";s:1:"0";s:13:"shutter_speed";s:1:"0";s:5:"title";s:0:"";s:11:"orientation";s:1:"0";s:8:"keywords";a:0:{}}}
133 58 _wp_attachment_image_alt bar food and beer mug
278 139 _wp_attached_file 2018/09/making-waves-logo-white-3.svg
279 139 _wp_attachment_image_alt LOGO
305 152 _edit_last 1
306 152 _edit_lock 1542130581:1
307 154 _menu_item_type post_type
308 154 _menu_item_menu_item_parent 0
309 154 _menu_item_object_id 152
310 154 _menu_item_object page
311 154 _menu_item_target
312 154 _menu_item_classes a:1:{i:0;s:0:"";}
313 154 _menu_item_xfn
314 154 _menu_item_url
334 157 _menu_item_type post_type
335 157 _menu_item_menu_item_parent 0
336 157 _menu_item_object_id 21
337 157 _menu_item_object page
338 157 _menu_item_target
339 157 _menu_item_classes a:1:{i:0;s:0:"";}
340 157 _menu_item_xfn
341 157 _menu_item_url
343 158 _menu_item_type post_type
344 158 _menu_item_menu_item_parent 0
345 158 _menu_item_object_id 19
346 158 _menu_item_object page
347 158 _menu_item_target
348 158 _menu_item_classes a:1:{i:0;s:0:"";}
349 158 _menu_item_xfn
350 158 _menu_item_url
352 159 _menu_item_type post_type
353 159 _menu_item_menu_item_parent 0
354 159 _menu_item_object_id 17
355 159 _menu_item_object page
356 159 _menu_item_target
357 159 _menu_item_classes a:1:{i:0;s:0:"";}
358 159 _menu_item_xfn
I'm not seeing anything out of the ordinary there.
Is there something specific you're suspicious of?
