• Resolved mustafasabir12

    (@mustafasabir12)


    Hi,

    I have been using tablepress without issues on many of my sites. But on one of my servers, when I try to import csv or xlxs/manual csv input, the browser upload completes and then it give me this error in the admin panel “sorry you are not allowed to access this page”. But if I create a table and then enter data using the admin panel UI, the table successfully creates without any issue. One more strange thing is that if I now try to export this table into csv, it does not generate a csv but a sort of a random <filename>.ait file. which has some random string in it (please note my website uses ait theme). what do you think is the issue as I have tried the following without luck:
    1) checked all folder and file permissions which are correct
    2) reset the htaccess
    3) I am using administrator with full capabilities, so no permission issue

    One possibility that I can think of is maybe the plugin’s hooks are getting overriden/clashing with some of the theme one’s. You are the developer so you can help me better with this I guess.

    WP version: 5.0.3
    plugin version: 1.9.2

    Please help me on this as I am desperate to make it work.

    Thanks & Regards,
    Mustafa

Viewing 11 replies - 1 through 11 (of 11 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    This indicates that another plugin is interfering (by not checking properly if it is the intended recipient of a request). Can you therefore please try again after temporarily deactivating all other plugins and after switching to a WordPress default theme like Twenty Sixteen? That way, we can find what’s causing this.

    Regards,
    Tobias

    Thread Starter mustafasabir12

    (@mustafasabir12)

    Thanks for the reply, will update you by trying this out.

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks! Please let me know what you find!

    Best wishes,
    Tobias

    Thread Starter mustafasabir12

    (@mustafasabir12)

    Hi Tobias,

    I have tried disabling all plugins and resetting theme. Although plugin disable did not work for me, switching to default twentyeighteen theme had better results. The export now works and gives me a proper csv file, but the import now shows a blank white screen and nothing imports. Any ideas for this? will try to debug and check for errors. Also can you suggest me what theme code/hook could be interfering with the tablepress plugin import so that I can fix that in the theme. As I have to use that theme since my website is already built and running on it.

    Thanks and Regards,
    Mustafa

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    this is a bug in your AIT theme then. They are not checking the proper request parameters somewhere. Unfortunately, I don’t know their code well enough.

    For the import problem: Can you please also set the WP_DEBUG constant to true in your site’s wp-config.php file (see https://codex.www.ads-software.com/Editing_wp-config.php#Debug) After that, we should see error messages and not just a blank screen.

    Regards,
    Tobias

    Thread Starter mustafasabir12

    (@mustafasabir12)

    Even with debug true it gives me a blank screen on csv upload. The url it gets white page on is <website-url>/wp-admin/admin-post.php

    Any ideas?

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    hmm, that’s strange then. I don’t really know what could be causing this then. Maybe the server software (like the firewall or mod_security) is intercepting and blocking the request. Can you (or your webhost company) maybe check the server error log file?

    Regards,
    Tobias

    Thread Starter mustafasabir12

    (@mustafasabir12)

    Hi Tobias,

    Thanks for your support. I have resolved the issue. So the theme conflict was due to one file backup related code written in one of the theme files. So whenever the upload csv was running in tablepress it was firing that part of code in the theme. After commenting that block out Tablepress started working with my Directory Theme (by AIT). But the import issue with blank screen was still there. I also managed to resolve that by reverting to older version of tablepress plugin. I switched from version 1.9.2 back to 1.7 and import also started working. I guess some compatibility issue between wordpress 5.0.3 and tablepress 1.9.2 version. Anyways thanks for your support again.

    Cheers ??
    Mustafa

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    NO! Please don’t do that! Reverting back to an old version of TablePress is not a good solution, at all! You are running into stability and security problems with that!
    Please always use the latest version of the plugin! Let’s then try to find the cause for the problem!

    I don’t think that this is a general incompatibility though, otherwise I would have received many more reports about this. There is something else on the server or site that is interfering.

    Regards,
    Tobias

    Thread Starter mustafasabir12

    (@mustafasabir12)

    Hi,

    Ok, In that case I will try to compare code differences between v1.7 and v1.9.2 for import and see what has changed. But till then will have to stick to the version running.

    Regards,
    Mustafa

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    ok, try that, but most likely nothing really changed. Here’s the complete changes between 1.7 and 1.9.2: https://github.com/TobiasBg/TablePress/compare/1.7…1.9.2#files_bucket

    We should try to find out from the server error log file on the server why it shows a blank screen.

    Regards,
    Tobias

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Permission Error when importing csv in TablePress’ is closed to new replies.