Blank Page, how to fix in database?

  • Resolved madkad

    (@madkad)


    15 years ago

    Hi

    OK I updated my wordpress, but I did a mistake and forgot to turn of the plugins and now I get a blank index page on the main site and I get this msg on the admin =

    You do not have sufficient permissions to access this page.

    I have searched around and it looks like its because I didn’t de-activate my plugins, so how do I do this from the database?

    I tried an old way but the sql didn’t work, can any one please help with this problem?

Viewing 15 replies - 1 through 15 (of 20 total)

  • Rename the plugins folder to something else. If it’s a plugin problem it should vanish once you rename the folder… (deleting it is an option to, if you’re wondering)..

    Alternatively, flush the active_plugins field from the options table.

    If you’ve not done so already, now is a good time to back up your DB, just incase..

    Thread Starter madkad

    (@madkad)

    Thanks for the reply

    I deleted all the plugins and nothing changed.

    how do I do the flush thing?

    do you have a sql for it?

    Thread Starter madkad

    (@madkad)

    I went to the database

    I found the table that you said to flush

    then under that I clicked the flush table link and it just said Sql error then “#1227 – Access denied; you need the RELOAD privilege for this operation “

    I just don’t know, these things drive me nuts

    Thread Starter madkad

    (@madkad)

    lol dont think thats the problem any way, ok this is what I did

    using this site
    https://perishablepress.com/press/2008/02/18/quickly-disable-or-enable-all-wordpress-plugins-via-the-database/

    I ran

    SELECT * FROM wp_options WHERE option_name = 'active_plugins';

    then I removed the info from the section, i have saved this in a file.

    i got nothing so i ran:

    UPDATE wp_options SET option_value = '' WHERE option_name = 'active_plugins';

    and i still get the error msg I said about in first post?

    Thread Starter madkad

    (@madkad)

    I forgot to say that I had to do a password reset also as it wouldn’t log in, so I typed in the one sent to my email but it didn’t work, I wonder if it could be that?

    Sorry when i said flush, i simply meant empty or delete that field…

    Access denied; you need the RELOAD privilege for this operation

    Sounds like the DB user that was setup for the database does not have all the privileges it needs.

    When you create a DB, you also (usually) need to create a MySQL user account that can perform operations on that database, it may be that the account wasn’t given all permissions, or at least all those required.

    If active_plugins doesn’t exist, then it’s probably clear that the issue is not a plugin one, but something else.

    Bear in mind, when performing the SQL query mentioned, prior to doing so you will need to choose/select the WordPress database in phpmyadmin (assuming that’s what you’re using), else you’d need to include which database to select from in the query (easier if you just click the relevant DB before clicking and performing the SQL query).

    Thread Starter madkad

    (@madkad)

    I will have a look into all that now,

    I meant to also say that the main page is also blank on the website also

    here: xbox-360-console.co.uk

    Grab a fresh copy of WordPress and reupload the wp-includes and wp-admin folders over the top of your existing ones… and see if that helps. (SEE BELOW FIRST)

    The login page works ok..

    What about renaming/moving the current theme, have you tried that?

    Thread Starter madkad

    (@madkad)

    OK I will try a upload

    I just remember the theme is set to a non default, is there a way to set to default in the database if needed?

    Thread Starter madkad

    (@madkad)

    Thanks for still helping me by the way

    apart from the theme in the database I have tried all the other things

    re-upload
    old themes have fully gone

    but still all the same problems

    Thread Starter madkad

    (@madkad)

    what about, if i did a full new install, the database the lot

    then after if all is working on that domain, I just replace the database with my old one?

    could that work?

    if it didnt would we no its a database fault?

    Thread Starter madkad

    (@madkad)

    So

    I did what i said above, and what I did was drop the old tables in the database (backed up first) and I counted 10 tables but now I have installed a new database and its working, I looked in the database and I see there are 11 tables, so it must have not updated the database on the upgrade correctly.

    So what is new in the database, if I was to place my old database back, can I do it so it keeps what’s new from the upgrade?

    Thread Starter madkad

    (@madkad)

    lol doh scrap that I just looked though the text and all the tables are the same, I must have missed counted last time, I am going to swop the database over and see what happens

    Wow, seems like you’re making good progress on your own… ??

    Let me know how it goes..

    Thread Starter madkad

    (@madkad)

    ??

    Not good, it all worked before I re-installed my database and then when I installed it it went back to how it was

    blank website
    not liking my password, so I renew it and then I get that msg page again

    So its an error in my database, but how the heck am I going to find what the error is?

    does that mean I have lots all my content?

Viewing 15 replies - 1 through 15 (of 20 total)
  • The topic ‘Blank Page, how to fix in database?’ is closed to new replies.