WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Fileupload Url doesn't show up in setting (25 posts)

  1. Daniel
    Member
    Posted 2 years ago #

    Hello,
    Having problems with only 1 of my many wordpress multisite subsites. I'm using a plugin called Sermon Browser and it works great on all other subsites except 1 of them. When I try to upload a file using it, it tells me that "Upload is disabled". I cross referenced the problematic site's settings with another site where the plugin is working and the only difference I can see is that Fileupload Url is missing and on the site where it is working it shows up.

    I was going to post this question under plugins but I don't think it has anything to do with the plugin.

    Any Ideas?

  2. Daniel
    Member
    Posted 2 years ago #

    No one seems to be responding on that forum. But I really don't think it has anything to do with the plugin because it works on all my other multisites (and its the same plugin files). When comparing the settings of a working site everything looks identical until you get down to the "Fileupload Url" on the site where the plugin works it shows "Fileupload Url" and on the site where it doesn't work it shows "Initial Db Version". Any Ideas?

  3. Two thoughts.

    Run a repair of your database first.

    If the 'Fileupload URL' setting is totally missing, you can add it in via the database (but search the page first, they're not in order).

  4. Daniel
    Member
    Posted 2 years ago #

    I ran a repair on the database like you suggested and got this message back on a few of the tables:

    "The storage engine for the table doesn't support r..."

    this error message only occurred on the site that I am having problems with.

    Error showed in:

    wp_7_commentmeta
    wp_7_comments
    wp_7_links
    wp_7_options
    wp_7_postmeta
    wp_7_posts
    wp_7_terms

    ...and many others

    Any ideas?

  5. "The storage engine for the table doesn't support r..."

    Well... That'd be it.

    Is that MySQL server set to default to InnoDB tables? (Ask your host if you're not sure)

  6. Daniel
    Member
    Posted 2 years ago #

    I will check with the host today on that. But, isn't strange that this is only happening on one of the multisites all the others in that database seem to be working great?

  7. Yes, it's very strange. I'd wonder if some of your tables got flipped over.

  8. Daniel
    Member
    Posted 2 years ago #

    I contacted the host and by default it is set to InnoDB I tried to run ALTER TABLE wp_7_comments ENGINE=INNODB and I got this error:

    "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE wp_7_comments ENGINE=INNODB ALTER TABLE ' at line 2"

    I also looked at the exported version of the database and noticed that all of these tables already have the "ENGINE = Innodb" assigned after the table is created. So i'm wondering if this is the problem at all..

    Any Ideas?

  9. I'd be grabbing my host, and asking for help why I can't repair those tables.

  10. Daniel
    Member
    Posted 2 years ago #

    Alright I contacted my host and they said that becuase those table are set to INNODB, the repair function isn't supported. I converted the INNODB tables to MyISAM using:

    ALTER TABLE wp_7_comments ENGINE = MYISAM;

    and all seemed to go well. I ran a successful repair on all of those tables but the initial problem still exists. (Upload is disabled. Please contact your systems administrator.)

    Any Ideas? You've been a great help so far btw!

  11. You're logged in as Super Admin, right?

  12. Daniel
    Member
    Posted 2 years ago #

    yeap

  13. Does it work without that plugin?

  14. Daniel
    Member
    Posted 2 years ago #

    I can upload media just fine but I can't upload any audio using that plugin. I disabled the plugin and in the site's settings i'm still missing the the file upload field and in it's place it has the field of "Inital db Version 19470"

  15. Don't get worried about the 'different' field, they're not actually in order. That it's MISSING entirely is the point ;)

    The problem is I don't know the plugin, and the devs really are who should be saying what the RIGHT field is.

    Was the plugin activated network wide or per site?

  16. Daniel
    Member
    Posted 2 years ago #

    Network wide. I am having other issues with this site as well when using the wp orbit slider plugin. It breaks the slider when I add links to the images. Again this is another plugin that works fine on all sites except for this site. This is what leads me to believe there is a bigger problem here that doesn't relate to any of the plugins.

  17. We can test that.

    Make a new site and see if the same issues crop up.

  18. Daniel
    Member
    Posted 2 years ago #

    I've made a few sites since this site and none of them have experienced this issue.

  19. I stick with my 'Something in THOSE tables is screwey.'

    Make a replacement site and delete that one.

  20. Daniel
    Member
    Posted 2 years ago #

    Do you have any links to any resources that might be able to walk me through the best way to do that?

  21. To make a replacement site?

    Make a new site in your network. If the 'bad' site is named foobar, use a name with the same character length (foobaz, but not bingbaz). Set up the 'replacement' site and get it working. Then RENAME the bad site to something else (go in to Network Admin -> Sites -> Edit Site, make sure you check 'Update siteurl and home as well' ). Then rename the NEW site to the BAD site's name.

    Done.

  22. Daniel
    Member
    Posted 2 years ago #

    Great, so far so good... What do you think the best way is to transfer all pages, posts, menus, images from the old "Bad" site to the new one?

  23. Export. http://codex.wordpress.org/Tools_Export_Screen

    That'll get all posts, pages and images.

    Menus ... not so much.

  24. Daniel
    Member
    Posted 2 years ago #

    Thanks, that seemed to be the best option. I Had to re-add all the widgets from the old site but for the most part the change over went smoothly. Now everything is working correctly. Thanks again for all your help with this!

Topic Closed

This topic has been closed to new replies.

About this Topic