PHPmyAdmin BD Tables

Hi @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!

Hi @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

View post on imgur.com

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 ??

Sorry @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.

Hi @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.

Hi @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!

Hi @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.

Hi @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!

Hi @pulak00, thanks for the information. Have a nice day ??