csv upload do not work

  • Hello,

    I’ve tried to upload csv file, as explained, with , and not ; but all the uploads returns no data, no records, emply.
    I’ve tried to download the csv created by the extension and upload but with same problem: no records are uploaded.
    Is it possible to show a csv correct strutue? Or file demo to download?

    I’ve tried with these (and others):
    “sdsref”,”field1″,”field2″,””
    “1”,””,”2″,””
    “3”,””,”3″,””

    No sucess

    Regards
    Peter

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

  • Hi,

    I’m having the same problem. Bug maybe?

    Thx.
    Paul.

    Update, MySQL issue
    WordPress database error The used command is not allowed with this MySQL version for query LOAD DATA LOCAL INFILE

    # mysql -V
    mysql Ver 14.14 Distrib 5.5.53

    • This reply was modified 8 years, 3 months ago by arete7.
    • This reply was modified 8 years, 3 months ago by arete7.

    Hi,

    MySQL needs extra config, see https://dev.mysql.com/doc/refman/5.5/en/load-data-local.html

    Typically you may need to edit your my.cnf file and add

    [client]
    loose-local-infile=1

    Please read docs before just enabling this as it does have security implications.

    Thx
    Paul.

    Hi,

    Ok, after much looking reading and trying, I’ve resorted to changing LOAD DATA LOCAL INFILE to LOAD DATA INFILE and adding secure-file-priv = “” to my.cnf and GRANT FILE ON *.* TO ‘your_db_user’@’localhost’;.

    As there is much controversy about php 5.5 upwards having some issues(bug possibly) that breaks LOAD DATA LOCAL INFILE(see https://stackoverflow.com/questions/13016797/load-data-local-infile-fails-from-php-to-mysql-on-amazon-rds to test this).

    After making the about 3 changes, the upload was successful.

    HOTH.

    Paul.

    Hi Paul,

    Where is the my.cnf file located?

    Steve

    Hi all, this plugin works beautifully. But i always fail to upload csv. there is this notification

    Warning: mysqli_query(): Filename cannot be empty in /home/xxx/public_html/wp-includes/wp-db.php on line 1877

    xxx is my username on cpanel

    anything to resolve?
    thank you ??

    nounours77

    (@nounours77)

    Having the same problem with MySQL 5.6.33 – MySQL Community Server (GPL).

    I’m on shared hosting, and think I do not have access to my.cnf. Is there a possibility to modify this behaviour in PhpAdmin? How?

    • This reply was modified 8 years ago by nounours77.
Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘csv upload do not work’ is closed to new replies.