site it goes to a blank white page with error message

Discussion in 'WordPress' started by 2point2, Jan 20, 2011.

0
  1. #1
    I downloaded the popular contest plugin but when trying to activate the following error message displayed fatal error. Incorrect table name '' on line: 255. So I found the below solution in a wordpress support forum. But after trying this solution now every time I try to click on anything within my site it goes to a blank white page with the following statment at the top:Table 'ak_popularity_options' already exists on line: 255.
    So now my site is down until I can fix some how. Please help

    Below is the solution I tried:

    Edit the plugin file. Find the SQL statements that create the two tables. It's around line 255. You can do a case sensitive search for the string: "CREATE TABLE" to find the statements as well.
    Change the first line of each of the two SQL statements from:
    CREATE TABLE $wpdb->ak_popularity_options (
    to:
    CREATE TABLE ak_popularity_options (
    and, a few lines down, from:
    CREATE TABLE $wpdb->ak_popularity (
    to:
    CREATE TABLE ak_popularity (
    Save the file and try again to install. If you get another error saying that a table already exists, as I did, re-edit the plugin file and restore those lines, that is, put the $wpdb-> part back into the SQL statements and try again. It worked for me, I hope you have the same luck.
     
    2point2, Jan 20, 2011 IP
  2. bablu

    bablu Peon

    Messages:
    277
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    delete the plugin that you installed and then try again.
     
    bablu, Jan 20, 2011 IP
  3. bablu

    bablu Peon

    Messages:
    277
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    if you face same problem again, PM me.
     
    bablu, Jan 20, 2011 IP
  4. 2point2

    2point2 Peon

    Messages:
    88
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    I cannot delete the plugin since anything I click on goes to that white screen.
     
    2point2, Jan 20, 2011 IP
  5. Yuuko008

    Yuuko008 Member

    Messages:
    682
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    33
    #5
    Use filezilla to access your site via ftp. Then delete the plugin fomr there. Or you can login to your cpanel>File Manager.
     
    Yuuko008, Jan 20, 2011 IP
  6. 2point2

    2point2 Peon

    Messages:
    88
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Do you know where that is located in the cpanel/file manager?
     
    2point2, Jan 20, 2011 IP
  7. 2point2

    2point2 Peon

    Messages:
    88
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    It worked....thank you.
     
    2point2, Jan 20, 2011 IP
  8. Yuuko008

    Yuuko008 Member

    Messages:
    682
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    33
    #8
    No problem 2point2. I'm glad I helped :)
     
    Yuuko008, Jan 20, 2011 IP
  9. bablu

    bablu Peon

    Messages:
    277
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #9
    Yuuko008 guide you and i think now you know how to delete plugin etc.
     
    bablu, Jan 20, 2011 IP
  10. joshuthomas

    joshuthomas Well-Known Member

    Messages:
    595
    Likes Received:
    9
    Best Answers:
    1
    Trophy Points:
    140
    #10
    Hello 2point2,

    Please do not panic, the situation is simple to handle. And do not delete or try reinstall at this point.
    Try to login to your website FTP cpanel and rename the "plugins" folder, i am almost sure that you will get your login page back and you can take it forward.

    warm regards
    Josh
     
    joshuthomas, Jan 20, 2011 IP