Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Product Import Error on Windows Server 2016 and 2012 r2 #21284

Closed
tekdorkz opened this issue Sep 6, 2018 · 2 comments
Closed

Product Import Error on Windows Server 2016 and 2012 r2 #21284

tekdorkz opened this issue Sep 6, 2018 · 2 comments
Labels
needs: author feedback The issue/PR needs a response from any of the parties involved in the issue.

Comments

@tekdorkz
Copy link

tekdorkz commented Sep 6, 2018

Describe the bug
I am experiencing an issue where I am unable to import .csv and .txt files to my sites even when woocommerce is the only plugin on a fresh site. I have talked with the WPMU dev team and they believe this issue is a possible limitation of woocommerce on windows servers. The only issue with assertion is that I have one site (tekdorkzservers.com which is a multisite running on windows 2016) which is able to import and export the files. I have only been able to test on windows 2012 r2 and 2016 servers.

To Reproduce
Steps to reproduce the behavior:
Importing on a windows server

Screenshots
If applicable, add screenshots to help explain your problem.
product import johncy s liquor store wordpress - google chrome 9_5_2018 7_33_19 pm
product import johncy s liquor store wordpress - google chrome 9_5_2018 7_33_56 pm
product import johncy s liquor store wordpress - google chrome 9_5_2018 7_34_04 pm

Expected behavior
After importing a file, which has been converted to UTF-8, this error will show up
"The file is empty or using a different encoding than UTF-8, please try again with a new file."

Isolating the problem (mark completed items with an [x]):

  • [x ] I have deactivated other plugins and confirmed this bug occurs when only WooCommerce plugin is active.
  • [ x] This bug happens with a default WordPress theme active, or Storefront.
  • [x ] I can reproduce this bug consistently using the steps above.

WordPress Environment

``` ` ### WordPress Environment ###

Home URL: https://www.johncysliquorstore.com
Site URL: https://www.johncysliquorstore.com
WC Version: 3.4.5
Log Directory Writable: ✔
WP Version: 4.9.8
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ✔
Language: en_US
External object cache: –

Server Environment

Server Info: Microsoft-IIS/8.5
PHP Version: 5.6.31 - We recommend using PHP version 7.2 or above for greater performance and security. How to update your PHP version
PHP Post Max Size: 500 MB
PHP Time Limit: 300
PHP Max Input Vars: 1000
cURL Version: 7.51.0
OpenSSL/1.0.2k

SUHOSIN Installed: –
MySQL Version: ❌ 5.1.73-community - We recommend a minimum MySQL version of 5.6. See: WordPress requirements
Max Upload Size: 100 MB
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✔
DOMDocument: ✔
GZip: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔

Database

WC Database Version: 3.4.5
WC Database Prefix: jls_
MaxMind GeoIP Database: ✔
Total Database Size: 16.20MB
Database Data Size: 12.69MB
Database Index Size: 3.51MB
jls_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB
jls_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB
jls_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB
jls_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.05MB
jls_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB
jls_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB
jls_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB
jls_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB
jls_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB
jls_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB
jls_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB
jls_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB
jls_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB
jls_woocommerce_log: Data: 0.02MB + Index: 0.02MB
jls_blogs: Data: 0.02MB + Index: 0.03MB
jls_blog_versions: Data: 0.02MB + Index: 0.02MB
jls_commentmeta: Data: 0.02MB + Index: 0.03MB
jls_comments: Data: 0.02MB + Index: 0.09MB
jls_cpk_wpcsv_export_queue: Data: 0.00MB + Index: 0.00MB
jls_cpk_wpcsv_log: Data: 0.00MB + Index: 0.00MB
jls_defender_lockout: Data: 0.02MB + Index: 0.00MB
jls_defender_lockout_log: Data: 0.02MB + Index: 0.00MB
jls_eab_bookings: Data: 0.02MB + Index: 0.08MB
jls_eab_booking_meta: Data: 0.02MB + Index: 0.03MB
jls_enewsletter_members: Data: 0.02MB + Index: 0.00MB
jls_enewsletter_meta: Data: 0.02MB + Index: 0.00MB
jls_frmt_form_entry: Data: 0.02MB + Index: 0.05MB
jls_frmt_form_entry_meta: Data: 0.02MB + Index: 0.05MB
jls_frmt_form_views: Data: 0.02MB + Index: 0.06MB
jls_hustle_modules: Data: 0.02MB + Index: 0.03MB
jls_hustle_modules_meta: Data: 0.02MB + Index: 0.03MB
jls_links: Data: 0.02MB + Index: 0.02MB
jls_options: Data: 5.03MB + Index: 0.05MB
jls_pmxi_files: Data: 0.02MB + Index: 0.00MB
jls_pmxi_history: Data: 0.02MB + Index: 0.00MB
jls_pmxi_images: Data: 0.02MB + Index: 0.00MB
jls_pmxi_imports: Data: 0.06MB + Index: 0.00MB
jls_pmxi_posts: Data: 0.02MB + Index: 0.03MB
jls_pmxi_templates: Data: 0.03MB + Index: 0.00MB
jls_postmeta: Data: 3.03MB + Index: 2.09MB
jls_posts: Data: 0.08MB + Index: 0.06MB
jls_registration_log: Data: 0.02MB + Index: 0.02MB
jls_signups: Data: 0.02MB + Index: 0.06MB
jls_site: Data: 0.02MB + Index: 0.02MB
jls_sitemeta: Data: 3.27MB + Index: 0.03MB
jls_smush_dir_images: Data: 0.02MB + Index: 0.03MB
jls_termmeta: Data: 0.05MB + Index: 0.03MB
jls_terms: Data: 0.05MB + Index: 0.03MB
jls_term_relationships: Data: 0.02MB + Index: 0.02MB
jls_term_taxonomy: Data: 0.06MB + Index: 0.03MB
jls_usermeta: Data: 0.05MB + Index: 0.03MB
jls_users: Data: 0.02MB + Index: 0.05MB
jls_wc_download_log: Data: 0.02MB + Index: 0.03MB
jls_wc_webhooks: Data: 0.02MB + Index: 0.02MB
smackuci_events: Data: 0.02MB + Index: 0.00MB
smackuci_history: Data: 0.02MB + Index: 0.00MB
wp_ultimate_csv_importer_log_values: Data: 0.06MB + Index: 0.00MB
wp_ultimate_csv_importer_manageshortcodes: Data: 0.02MB + Index: 0.00MB
wp_ultimate_csv_importer_shortcodes_statusrel: Data: 0.02MB + Index: 0.00MB

Post Type Counts

acf: 1
attachment: 35
elementor_library: 9
event: 3
incsub_event: 1
nav_menu_item: 12
page: 14
post: 3
revision: 53
shop_coupon: 1
shop_order: 7
wcccf: 2
wccpf: 1
wc_conditional_fee: 1
wdf_scan: 2
wdf_scan_item: 1

Security

Secure connection (HTTPS): ✔
Hide errors from visitors: ✔

Active Plugins (26)

Admin Menu Editor: by Janis Elsts – 1.8.4
Advanced Custom Fields: by Elliot Condon – 4.4.12
Custom Twitter Feeds: by Smash Balloon – 1.2.9
CustomPress: by WPMU DEV – 1.3.7
E-Newsletter: by WPMUDEV – 2.7.4.5
Elementor Pro: by Elementor.com – 2.1.3
Elementor: by Elementor.com – 2.2.1
Flexible Shipping: by WP Desk – 2.1.7
Hustle Pro: by WPMU DEV – 3.0.4.2
One Click SSL: by Tribulant Software – 1.4.1
Profile Builder - Custom Profile Menus Add-On: by Cozmoslabs
Cristophor Hurduban – 1.0.7

Profile Builder - WooCommerce Sync Add-on: by Cozmoslabs
Adrian Spiac – 1.5.3 – Not tested with the active version of WooCommerce

Profile Builder Pro: by Cozmoslabs – 2.8.9
Snapshot Pro: by WPMU DEV – 3.1.9.1
WooCommerce Conditional Product Fees for Checkout Pro: by Multidots – 1.2.9 – Not tested with the active version of WooCommerce
WooCommerce Stripe Gateway: by WooCommerce – 4.1.9
WooCommerce Remove All Products: by Gabriel Reguly – 1.0.6 – Not tested with the active version of WooCommerce
WP All Import - WooCommerce Add-On: by Soflyy – 1.3.9
WooCommerce: by Automattic – 3.4.5
WordPress Importer: by wordpressdotorg – 0.6.4
WP All Import: by Soflyy – 3.4.9
Defender Pro: by WPMU DEV – 2.0
WP Mail SMTP: by WPForms – 1.3.3
Smush Pro: by WPMU DEV – 2.8.1
SmartCrawl: by WPMU DEV – 2.2.2.1
WPMU DEV Dashboard: by WPMU DEV – 4.5.2

Settings

API Enabled: –
Force SSL: –
Currency: USD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: 1.4 oz (1-4-oz)
1.75 ltrs (1-75-ltrs)
1.75l (1-75l)
1000 (1000)
12 0z (12-0z)
12 oz (12-oz)
12 oz 6 pk (12-oz-6-pk)
12 pk (12-pk)
12 pk 12 oz (12-pk-12-oz)
12 pk cans (12-pk-cans)
12oz (12oz)
12pk (12pk)
15.5g (15-5g)
15pk can (15pk-can)
16 0z 6 pk (16-0z-6-pk)
16 oz (16-oz)
1750 (1750)
18 pk btls (18-pk-btls)
1pt (1pt)
200 (200)
22 0z (22-0z)
22 oz (22-oz)
22oz (22oz)
24 oz (24-oz)
24 pk (24-pk)
25 oz (25-oz)
3 pk (3-pk)
355ml (355ml)
375 (375)
375ml (375ml)
40 oz (40-oz)
4pk (4pk)
50 ml (50-ml)
500ml (500ml)
6 pack (6-pack)
6 pk (6-pk)
6pk (6pk)
750 (750)
750 ml (750-ml)
750ml (750ml)
8 oz (8-oz)
8.4fl oz (8-4fl-oz)
external (external)
grouped (grouped)
half bbl (half-bbl)
pint (pint)
simple (simple)
single (single)
variable (variable)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-1 (rated-1)
rated-2 (rated-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)

WC Pages

Shop base: ❌ Page not set
Cart: #9 - /cart/
Checkout: #10 - /checkout/
My account: #11 - /my-account/
Terms and conditions: ❌ Page not set

Theme

Name: Twenty Seventeen
Version: 1.7
Author URL: https://wordpress.org/
Child Theme: ❌ – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
WooCommerce Support: ✔

Templates

Overrides: –

</details>
@peterfabian
Copy link
Contributor

Hi,

can you please provide a minimal file that causes this problem so that we can try to replicate it ourselves?

Thanks.

@peterfabian peterfabian added the needs: author feedback The issue/PR needs a response from any of the parties involved in the issue. label Sep 6, 2018
@rodrigoprimo
Copy link
Contributor

Closing due to lack of feedback.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
needs: author feedback The issue/PR needs a response from any of the parties involved in the issue.
Projects
None yet
Development

No branches or pull requests

3 participants