[Plugin: WP-Table Reloaded] Importing from CSV giving errors

  • rnrcomp

    (@rnrcomp)


    15 years, 2 months ago

    Installed your plugin tonight but when I try to do an import from a CSV to a new or existing table I get the following errors, any thoughts?

    Thanks
    Ed

    Warning: file_get_contents() [function.file-get-contents]: open_basedir restriction in effect. File(C:\Windows\Temp\php4109.tmp) is not within the allowed path(s): (\\webdata\webs$\Parss.org\) in \\WEBDATA\WEBS$\Parss.org\wp-content\plugins\wp-table-reloaded\classes\import.class.php on line 82

    Warning: file_get_contents(C:\Windows\Temp\php4109.tmp) [function.file-get-contents]: failed to open stream: Operation not permitted in \\WEBDATA\WEBS$\Parss.org\wp-content\plugins\wp-table-reloaded\classes\import.class.php on line 82

    Warning: unlink() [function.unlink]: open_basedir restriction in effect. File(C:\Windows\Temp\php4109.tmp) is not within the allowed path(s): (\\webdata\webs$\Parss.org\) in \\WEBDATA\WEBS$\Parss.org\wp-content\plugins\wp-table-reloaded\classes\import.class.php on line 271

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    15 years, 2 months ago

    Hi Ed,

    thanks for your post.

    Those error messages mean that your server is not configured correctly. PHP is not allowed to access files in the “temp” directory. The server tells PHP that temporary files (like those that were uploaded through a website) are stored in “C:\Windows\Temp”, however, it does not let PHP read those files.

    I suggest contacting your webhost to have them correct this.

    Regards,
    Tobias

    Thread Starter rnrcomp

    (@rnrcomp)

    15 years, 2 months ago

    Thanks Tobias

    I figured it was something along those lines just wanted to confirm.

    Ed

    Thread Starter rnrcomp

    (@rnrcomp)

    15 years, 2 months ago

    Hi Tobias

    My hosted asked if it is possible to change where the plug-in puts temp files? There reasoning is that to allow access to the c:\windows\temp directory is a security hole and being that we are in a server farm the c:\windows\temp will not always be the same server. Their idea was to have a temp folder within the WordPress folder that way it is always available.

    Any thoughts?

    Ed

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    15 years, 2 months ago

    Hi Ed,

    thanks for checking back with your host.

    This is however not a setting that I can influence in WP-Table Reloaded nor one that WordPress can influence.
    It is entirely a setting in the PHP configuration (namely in the php.ini file, see
    http://www.php.net/manual/en/ini.core.php#ini.upload-tmp-dir
    )
    Judging from your error message, I assume that exactly the described scenario in that link is happening on your server: There is no upload_tmp_dir defined, so PHP uses the system’s default (which on Windows is c:\windows\temp), but that is not accessible.
    Thus, the solution is for your webhost to define “upload_tmp_dir”, so that all necessary conditions from that link are met. So, if you/they want, you can set that directory to be within the WordPress folder.

    Best wishes,
    Tobias

    Thread Starter rnrcomp

    (@rnrcomp)

    15 years, 1 month ago

    Hi Tobias

    We got the previous PHP errors to go away now but now we get an error in a yellowish box that says “Table cannot be imported”. Any thoughts?

    I have my import file setup as a comma delimited but not sure if I am missing something else.

    Thanks
    Ed

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    15 years, 1 month ago

    Hi Ed,

    that can now have several reasons. While the actual process of uploading and reading the should now work, I assume that CSV file is somehow corrupted. To be sure of this, can you try again with a small test table (just a few cells, nothing fancy)?

    Also, if you want, please send your CSV to me (email address is in the main plugin file wp-table-reloaded.php) and I will take a look if I can maybe spot something that’s wrong.

    Regards,
    Tobias

    Thread Starter rnrcomp

    (@rnrcomp)

    15 years, 1 month ago

    Hi Tobias

    I can get it to work if I use the Manual Source option but not the CSV import. I even tried importing 6 or 7 records and tried using a TAB delimited file. I will send you the file in the morning.

    Thanks
    Ed

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    15 years, 1 month ago

    Hi Ed,

    thanks for investigating this. If the manual import works, but the CSV import through upload does not, this unfortunately means that there’s still something wrong with the server configuration, I’m afraid 🙁

    Another test, as it works similarly: Does the upload of images into your posts (the WordPress Media library) work?

    Regards,
    Tobias

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘[Plugin: WP-Table Reloaded] Importing from CSV giving errors’ is closed to new replies.