Help!! I Screwed up my WP

since i posted as a comment and most people miss the good tips that are in the comments, I’m posting again as an answer

The reason is because GD Star rating plugin creates custom capabilities and your query deleted all references of %rating% it deleted the wp_user_roles option which holds all capabilities roles.

the solution would be to re create that option in options table (usually wp_options) with the default value just like I answered here
.

Related Posts:

  1. Creating 20,000 Posts or Pages using a .csv file?
  2. How to properly insert data into custom table via plugin
  3. How does WordPress handle MySQL row lock errors?
  4. Searching users with WP_List_Table plugin
  5. Search and replace text across all posts
  6. Bad Request (Invalid Hostname) on working server, database problem
  7. $wpdb->get_results() does not fetch results with unicode ‘WHERE’ clause
  8. Changing BIGINT to INT
  9. Can I run multiple queries with $wpdb->prepare?
  10. How to remove duplicate Custom Fields?
  11. wordpress in nginx docker container connected to php:8-fpm container and mariadb container isn’t creating any tables on plugin activation
  12. greatest() function returns undefined property
  13. How to write one comment and publish on every post using database or plugin?
  14. How to get number of Affected rows from wordpress dbDelta() function
  15. How to determine what is generating large amount of database queries?
  16. Get post by ASC from custome field DATE picker
  17. MySql database help for a plugin
  18. How to remove Database Table in WordPress via Function file?
  19. mysqli_error() expects parameter 1 to be mysqli, null given in own db class
  20. Bulk edit existing shortcode within custom field
  21. Display data on Word Press site posts and pages from mysql table
  22. How to simultaneously access the same MySQL database in the main column and sidebar of WordPress?
  23. Help With MySQL to WPDB Query Conversion
  24. WpDataTables – View Image Directory
  25. get current date + 90 days and checking every day
  26. join 2 table orders wordpress plugin
  27. How do I run SQL queries on a WordPress web page? [closed]
  28. How can I perform high-level database merging for WordPress within continues delivery?
  29. 306 MB of wp_options occupied by WordPress SEO Plugin, is that normal? [closed]
  30. Plugin: register_deactivation_hook works perfectly well, while register_activation_hook suddenly stopped working
  31. Enabling WP_USE_EXT_MYSQL to support old plugin
  32. how to access all user dashboard on fronted page [closed]
  33. WordPress + JavaScipt + AJAX + MySQL: insert query for form
  34. WordPress Backend HA (Automatic failover)
  35. Automatic switch to backup database on fail
  36. SQL to order by CPT results by user->display_name w/only user->ID known
  37. Migrating to WordPress Recipe Plugin and Some SQL Issues
  38. Enabling plugin failed because MySQL user do not have CREATE permissions
  39. WordPress page and plugin list using sql query
  40. Multiple instance of data in plugin custom database table on plugin activation
  41. WP-DownloadManager – Query most download per week/month etc
  42. Better ads plugin has 500.000 entries in wp_postmeta
  43. Errors when trying to use a plugin to write to the database
  44. _prime_post_caches in wordpress
  45. after wordpress update to 3.5+ i get many errors in plugin wpdb::prepare()
  46. Cannot get wpdb data (Error in a simple fuction) [closed]
  47. Mass SQL WordPress Meta Key deletion
  48. Notice: Uninitialized string offset: 0 in social sharing mu-plugin
  49. Always get creating a new table with foreign key
  50. How to do database for download stats?
  51. How can I fetch data from another website to my wordpress website with mysql database
  52. Getting error “Warning: mysql_query(): Can’t connect to local MySQL server through socket ‘FILEPATH/cccatalog-plugin.php on line 1656”
  53. DB Query not working in Plugin
  54. External wpdb connections in different plugins on single page
  55. speed up pagination for huge database
  56. Way to send multiple values for column to MySQL?
  57. Comment Approve – Add custom function when comment is approved
  58. WordPress plugin: efficient way to store large data
  59. Can’t create tables with my plugin
  60. Integrating Custom Database with WordPress
  61. How to display results from a data table with an encrypted user id?
  62. Check against server time to display SQL entries – Radio Station DJ Rotator Plugin
  63. add_action for publish_post doesn’t work
  64. WordPress Cache delete on plugin uninstall
  65. need to find duplicated meta value in custom filed and view the posts that have the same value
  66. how can we migrate wordpress 5.9 website from aws ec2 to new installed wp 5.9 oci compute
  67. My CPU usage in A2 Hosting Shared Plan (Turbo Boost) is high due to mysql query!
  68. Getting current user data with MySQL statement
  69. How to get the custom field value using SQL query
  70. Memcaching recurring SQL Queries
  71. Need to know if my approach to designing a geneaology plug-in for wordpress makes sense
  72. What database state changes happen after a post is manually “updated” with no changes?
  73. Cant create table on plugin activation
  74. How to get database connection details without longing to cpanel in WordPress?
  75. WordPress UPDATE queries on MySQL database stuck
  76. Store GravityForm data in phpmyadmin (mysql)
  77. Moving a few select DB tables to a new WP instance
  78. dbDelta not CREATING TABLE
  79. WordPress database problem wp_posts, primary key
  80. How much PHP and MySQL or MariaDB knowledge should I know to start writing WordPress themes and plug-ins and whatever else a beginner can edit?
  81. Login issue in WordPress
  82. Delete user meta based on key value that is an array
  83. get/show Last ID
  84. Resetting AUTO_INCREMENT primary key
  85. Help with sorting and storing data on WordPress
  86. Linking Plugin Files to WP
  87. Using wp config to connect to a DB from a plugin
  88. how to search through plugin in wordpress cimy-user-extra-fields?
  89. Get all the related data from WordPress DB
  90. How to display blog posts only authored by the administrator
  91. Trying to insert a row from a Plugin
  92. 504/502 errors plauging our site
  93. how to show the data from a myqsl database in a post [closed]
  94. Post sorting and ordering function in WordPress Admin is broken and always shows post from oldest to newest
  95. How can I delete the options from DB when the plugin is deleted?
  96. PHP Creating a formula from mysql db values and db stored math operator
  97. Share or sync user table data with another user table
  98. Split Million WordPress Post’s Into Multiple Database Server
  99. Remove posts that start with similar words (like a delete duplicate posts plugin)
  100. WP_Query does not return the result even if the data is present in the database

Leave a Comment