Title: PHPmyAdmin BD Tables Last modified: October 4, 2023 --- # PHPmyAdmin BD Tables * Resolved [ibiza69](https://wordpress.org/support/users/ibiza69/) * (@ibiza69) * [2 years, 8 months ago](https://wordpress.org/support/topic/phpmyadmin-bd-tables/) * Today we went to PHPMyAdmin, for deleting all theme tables and options, AND we saw that your plugin has created hundreds of tables at (DB: “options”). they are all like these one: * 5094918sp_wp_carousel_page_id42643 * Why does this happen?, I mean, there are pages and pages, about 500 results from your plugin. Is this normal? Is there any way for not having all them, as is seems like too much, as we only have like 20 images at only 1 slider? * Thank you once more for your time and support 🙂 Viewing 8 replies - 1 through 8 (of 8 total) * Plugin Support [Pulak Ahmed](https://wordpress.org/support/users/pulak00/) * (@pulak00) * [2 years, 8 months ago](https://wordpress.org/support/topic/phpmyadmin-bd-tables/#post-17109389) * Hi [@ibiza69](https://wordpress.org/support/users/ibiza69/), * Sorry for the delayed response due to the weekly holidays. * Usually, the plugin creates such a table when a shortcode is used on a page. As you have created only one shortcode, we can tell you used it only once on your site. So this is really unusual if that creates 500+ tables in the database. We would appreciate it if you could share a little bit more information about the tables. Kindly, share a screenshot of the tables and the contents inside of them. So that we could check and identify which data are stored in those tables. * Your understanding and cooperation would be highly apprecaited. * Have a great day! * Thread Starter [ibiza69](https://wordpress.org/support/users/ibiza69/) * (@ibiza69) * [2 years, 8 months ago](https://wordpress.org/support/topic/phpmyadmin-bd-tables/#post-17109511) * Hi [@pulak00](https://wordpress.org/support/users/pulak00/), thanks for answering. * Here are just a pair of screenshot, for not including all of them here, as are too many: * > [View post on imgur.com](https://imgur.com/pXAajub) * > [View post on imgur.com](https://imgur.com/o7e3l4z) * And those tables contain this type of information inside: * option_id: 4804322 * option_name: sp_wp_carousel_page_id147 * option_value: a:1:{i:0;i:33088;} * autoload: yes * Hopefully this information helps 😉 * Thread Starter [ibiza69](https://wordpress.org/support/users/ibiza69/) * (@ibiza69) * [2 years, 8 months ago](https://wordpress.org/support/topic/phpmyadmin-bd-tables/#post-17109772) * Sorry [@pulak00](https://wordpress.org/support/users/pulak00/), I forgot to say that this happens in all our websites that have the plugin installed (we have 5 websites with your plugin) and same thing is happening in all of them. Thank you. * Thread Starter [ibiza69](https://wordpress.org/support/users/ibiza69/) * (@ibiza69) * [2 years, 7 months ago](https://wordpress.org/support/topic/phpmyadmin-bd-tables/#post-17141706) * Hi [@pulak00](https://wordpress.org/support/users/pulak00/), we didn´t receive any news from your side. Did you have time to check all this table entries (+ 500), to see if there is a way to fix it? Thank you once more. * Plugin Support [Pulak Ahmed](https://wordpress.org/support/users/pulak00/) * (@pulak00) * [2 years, 7 months ago](https://wordpress.org/support/topic/phpmyadmin-bd-tables/#post-17142529) * Hi [@ibiza69](https://wordpress.org/support/users/ibiza69/), * Sorry for the delayed response. First of all, thank you for sharing the screenshots. Based on the screenshots provided, it seems that the shortcode was utilized across all pages to generate the database table. I understand that manually inserting the shortcode on over 500 pages would be impractical. However, did you happen to use the shortcode in any commonly shared sections of the website such as the footer, sidebar, or header? If so, this could be the reason behind the table creation. When the shortcode is utilized in a common area, it gets initialized on every page, post, product, etc., thus resulting in the creation of all the tables. * We would appreciate it if you could share the page link where you used the shortcode. So that we could check and inspect. * Your understanding and cooperation would be highly appreciated. * Have a great day! * Thread Starter [ibiza69](https://wordpress.org/support/users/ibiza69/) * (@ibiza69) * [2 years, 7 months ago](https://wordpress.org/support/topic/phpmyadmin-bd-tables/#post-17142657) * Hi [@pulak00](https://wordpress.org/support/users/pulak00/), sure here is one of our sites trabajaribiza.com, hopefully it helps, the slider is after header slider. Thank you once more for your time and attention. * Plugin Support [Pulak Ahmed](https://wordpress.org/support/users/pulak00/) * (@pulak00) * [2 years, 7 months ago](https://wordpress.org/support/topic/phpmyadmin-bd-tables/#post-17159906) * Hi [@ibiza69](https://wordpress.org/support/users/ibiza69/), * Thank you for sharing the page link. We have investigated the website and we can see that the carousel is loaded in the header section. Now let me explain why all the tables were created. For each shortcode implementation on a page, the plugin creates some dynamic CSS and stores the data in a table with the page ID. Since you have loaded the carousel on the header of the site, the carousel initializes on every page, post, product, custom post type, etc. For each new page ID, a table and dynamic CSS are created. If you remove the carousel from the header section and move it to the body, then the issue will be resolved. If you use the shortcode in the content area of a page, only one table will be generated with that page ID. * Hope this will clear the confusion. * Have a great day! * Thread Starter [ibiza69](https://wordpress.org/support/users/ibiza69/) * (@ibiza69) * [2 years, 7 months ago](https://wordpress.org/support/topic/phpmyadmin-bd-tables/#post-17160284) * Hi [@pulak00](https://wordpress.org/support/users/pulak00/), thanks for the information. Have a nice day 😉 Viewing 8 replies - 1 through 8 (of 8 total) The topic ‘PHPmyAdmin BD Tables’ is closed to new replies. * ![](https://ps.w.org/wp-carousel-free/assets/icon-256x256.png?rev=3506878) * [Carousel, Slider, Photo Gallery with Lightbox, Video Slider, by WP Carousel](https://wordpress.org/plugins/wp-carousel-free/) * [Frequently Asked Questions](https://wordpress.org/plugins/wp-carousel-free/#faq) * [Support Threads](https://wordpress.org/support/plugin/wp-carousel-free/) * [Active Topics](https://wordpress.org/support/plugin/wp-carousel-free/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/wp-carousel-free/unresolved/) * [Reviews](https://wordpress.org/support/plugin/wp-carousel-free/reviews/) * 8 replies * 2 participants * Last reply from: [ibiza69](https://wordpress.org/support/users/ibiza69/) * Last activity: [2 years, 7 months ago](https://wordpress.org/support/topic/phpmyadmin-bd-tables/#post-17160284) * Status: resolved