Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

#1 08-14-2020 09:16:41

sdn
Member
From: UK
Registered: 05-29-2007
Posts: 882

CSV Database Import Error

Hi

I have not imported any tables for a while but needed to update ecom_shipzonerate table.

I keep getting the same error message "You did not complete all of the required fields before submitting this form. Fields missing data are highlighted below in red."

Exporting the table (96KB) and importing the same unchanged file give the same error so it is not the contents of the file but the server.

Do you have any idea what might be causing the problem?

Presumably some security setting. Munin antivirus recently replaced ClamAV. Other server details are

cPanel Version    88.0 (build 13)
Apache Version    2.4.46
PHP Version    7.2.33
MySQL Version    5.7.31
Architecture    x86_64
Operating System    linux
Path to Perl    /usr/bin/perl
Perl Version    5.16.3
Kernel Version    3.10.0-1127.13.1.el7.x86_64


Simon

Offline

 

#2 08-17-2020 12:35:10

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: CSV Database Import Error

I'd first be looking at PHP - specifically php.ini for any settings which limit POST size, number of fields in POST requests, file upload limits, etc.  A recent PHP change or upgrade could have changed or added config values which are very restrictive.


Nick Hendler

Offline

 

#3 08-17-2020 12:47:11

sdn
Member
From: UK
Registered: 05-29-2007
Posts: 882

Re: CSV Database Import Error

Thanks. Could not remember where to look...

PHP72 set itself to "file_uploads = disabled". All working now.


Simon

Offline

 

#4 08-18-2020 09:12:15

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: CSV Database Import Error

Awesome.  Thanks for posting the solution back.


Nick Hendler

Offline

 

Board footer