prefix table and plugins

Short answer: Just a badly written plugin.

Longer answer: When a plugin calls the database in the right/correct/best practice way it uses Global $wpdb instead of just naming the database table, for example:

Wrong way

$sql = "SELECT * FROM wp_posts WHERE... "

Right way

$sql = "SELECT * FROM $wpdb->posts WHERE... "

this way it would work even if you change your tables prefix.

Related Posts:

  1. How do I show data from gravity forms in my template? [closed]
  2. Delete tables from database when deleting plugin
  3. How to delete all records from or empty a custom database table?
  4. WordPress sharding: which multi-DB plugin to use?
  5. How to make sense of the active_plugins option_value to enable and disable certain plugins from the database?
  6. Simple form that saves to database
  7. Using Vagrant for customizable WordPress Multi-sites [closed]
  8. Updating WordPress – the best approach (updating wp core, plugins and db)
  9. How do I check what plugins are enabled via the database?
  10. How to store ACF custom fields data in a custom table
  11. How can a Firebase user registration and login be integrated into a WordPress site?
  12. Bad Request (Invalid Hostname) on working server, database problem
  13. Plugin Not Working, But Only On GoDaddy Hosted site
  14. WordPress plugin DB upgrade
  15. How to update widget_text in the wp_options table
  16. how to show database content in wordpress post
  17. What is the easiest way to implement cascading database upgrade for my plugin?
  18. Ajax with jQuery UI dialog not working
  19. Remove obsolete plugins artifacts from database tables
  20. Is the wordpress user-model changed in wpmu?
  21. Default Plugin Settings Not Writing to Database
  22. Creating Tables on Network Activation
  23. What kind of data is that?
  24. Cannot login to ADMIN even after changing password in phpmyadmin
  25. Where to hook my plugin’s action
  26. Embed a Google Sheet as you view it in a separate tab?
  27. How to determine what is generating large amount of database queries?
  28. Building an email signup form. Where should the information be saved in the DB?
  29. Retrieving a Value from a wp-database
  30. Need help restoring my WordPress blog
  31. WP plugins for building a database?
  32. Is it possible to create Custom Post plug-in?
  33. Prevent duplicate records in plugin table
  34. Delete query not working in plugin
  35. How do I network enable a plugin for a multisite install via the database?
  36. Automatic switch to backup database on fail
  37. How can I change the meta_key for a particular piece of information?
  38. Create a table with wordpress plugin boilerplate
  39. WordPress and a secondary database?
  40. Why this function not working for install database on plugin activation
  41. plugin code is pulling information from database in one instance and not in other. What is wrong?
  42. Can I create a table on my DB without creating a plugin?
  43. WordPress : Explain Plugins & Theme string value in database
  44. Creating a CSV with PHP inside the plugin directory
  45. Plugins in WP_Options but not Active
  46. Gathering and logging data from a plugin: how to do it without race conditions?
  47. How to pass the API key to the client from the database? [closed]
  48. dbDelta not adding additional columns in plugin database update
  49. Updating options into the wp database performance
  50. Ajax save data to database on document ready, no data being saved
  51. How to edit a published post?
  52. Plugin has added weird data in wp_options, set to autoload
  53. How to create plugin/ page that reads from database
  54. Assign all Post in Wp to a specific Category
  55. External wpdb connections in different plugins on single page
  56. Storing The Data Collected by Ninja Forms into Another (custom) Database [closed]
  57. WordPress plugin: efficient way to store large data
  58. Is this plugin safe to run?
  59. Integrating Custom Database with WordPress
  60. Getting URL GET parameter with Code snippets and storing it in database?
  61. How to make a Product page without ordering and database
  62. Same Plugin tables between wordpress installations
  63. create pages automatically and dynamically in wordPress
  64. $wpdb->delete not working for me
  65. Performing CRUD operations on front end in wordpress
  66. How to add specific script to WordPress webpage that will working with user input and databases
  67. How to use WordPress header function and footer function and not load word press database
  68. How to securely controlling data without keeping it in postmeta?
  69. add_action(‘the_content’, ‘my_plugin_content’) is null
  70. WordPress database problem wp_posts, primary key
  71. How to allow URL with filename & extension in wordpress?
  72. Programmatically generate new pages for a site based on page template and content elements accessed via DB
  73. Remove special characters from filenames
  74. PHP message: WordPress database error Deadlock found when trying to get lock
  75. errno: 150 “Foreign key constraint is incorrectly formed” [closed]
  76. using wordpress login details for other website / application / forum?
  77. database – multiple wordpress installations using same database – can they share plugin settings?
  78. how to create database to use it in wordpress website?
  79. HyperDB failover Delay
  80. how can i get records from wp_postmeta table using particular meta_key in database?
  81. How to create a custom page for unrelated database?
  82. User content database [closed]
  83. Include plugin form in the home page
  84. Write mysql credentials in plugin
  85. Is saving multiple options or saving multiple items in one option better?
  86. Collaborate on wordpress local website, share files via dropbox?
  87. Pull Data from DB for Admin Page Display as Relates to Admin Page Class by BA Internet
  88. Posts are deleted everyday at night
  89. Display Plugin information on specific url
  90. How to find an option in the database?
  91. Is there a plugin that will override the “Error establishing a database connection” message? [closed]
  92. Get the url of attachments from the post?
  93. Create New Admin Menu Section – Like how custom post type works, in a way
  94. Shortcode returning specific content of a post
  95. get_option returning a different value from what’s saved
  96. How can I delete the options from DB when the plugin is deleted?
  97. register_activation_hook not working
  98. Text Wrapping in WPDataTables
  99. Does anyone recognize these table names?
  100. Edit a page/post DB data?