geirosset: In cases like this, you have to be very exact with you information because we can’t guess if you are omitting things for convenience or if they are truly missing, thus wrong, in your system.
What does your your wp-config actually state as the prefix parameter? Because if $table_prefix truly is “syd_” instead of “syd_wp_” then the table names would be “syd_user_roles”, not “syd_wp_user_roles” etc.
Once you CORRECTLY match up your table prefixes with the wp-config settings, then the NEXT step is to bring this in line with the information in your wp_usermeta table and in your wp_options (or whatever the correct table names are in your system).
THOSE two tables have records that normally would start with “wp_” (the default table prefix) – so those rows would have to be changed to match whatever correct value to match your ACTUAL table names AND your $table_prefix.
PS: Also, you didn’t explain when this started breaking? What is that you changed/installed etc. that caused your site to fail for the first time? Why not undo it?
-
This reply was modified 7 years, 9 months ago by Andy Schmidt.