Universal Import images error

22.01.2016 18:41
#1
Pierre Corell
Joomshopping forum user no avatar
Name: Pierre
05.06.2014
Posts: 4
Quote
Universal Import images error

Hello,

a client bought the plugin and there is an error with the image upload. All other fields are imported as they should.

So we reduced the csv file for testing:
ean; image
001; img001.png

The image is not processed - not as file or url. In the database there´s just an entry (on both relevant tables) with "img_", the automated prefix I may.
The image at the server itself does not change or removed or is processed in anyway.

Error: "FAILED" (red) at type=url
no Error "SUCCESS" at type=file
no further infos were found at the logs (- are some available anywhere?)

allow_url_fopen is set on, I tested on 2 serverconfigurations also.

What could be the prob or where could I find detailled logs or do you have another idea what could cause this error?

Thanks in advance,
Pierre.

images enhanced: first one with url, second via name
Universal Import images error
jpraxis_2016_01_22_183550.jpg


Joomla: 3.4.8
JoomShopping: 4.10.5
PHP: 5.6
MySQL: 5.6
 
22.01.2016 20:59
#2
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16475
Quote
Aw: Universal Import images error

ean;image

try without space.

 
01.02.2016 22:54
#3
Pierre Corell
Joomshopping forum user no avatar
Name: Pierre
05.06.2014
Posts: 4
Quote
Aw: Universal Import images error

Hello,

of course we did, including separator, take off spaces of each column name etc. - so a lot at the end we tried.
I publish a debug now here from a image-via-name import (same as mentioned in last post with ean,image tryout), at the debug output I changed some none-to-publish-secrets to string 'HIDDEN' and some spaces at the SET-statement for better readibility. Please have a look - in the array 1 at the top the image is still referenced, at the import array itself just 'img_', at the database it is imported also - for me the missing image support seems like a bug or another problem. Please have an idea or point me to a real errorlog :-)

Thanks in advance,
Pierre.

PID 11522035 gespeichert
Lade PID 11522035 Bild (1/1) "HIDDEN/components/com_jshopping/files/img_products/"... ERFOLGREICH
TAble product stored: jshopProduct Object ( [_tbl:protected] => #__jshopping_products [_tbl_key:protected] => product_id [_tbl_keys:protected] => Array ( [0] => product_id ) [_db:protected] => JDatabaseDriverMysqli Object ( [name] => mysqli [nameQuote:protected] => ` [nullDate:protected] => 0000-00-00 00:00:00 [_database:JDatabaseDriver:private] => HIDDEN[connection:protected] => mysqli Object ( [affected_rows] => 0 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: HIDDEN $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 0 [host_info] => localhost via TCP/IP [info] => Rows matched: 1 Changed: 0 Warnings: 0 [insert_id] => 0 [server_info] => 5.6.24 [server_version] => 50624 [stat] => Uptime: 442 Threads: 1 Questions: 257 Slow queries: 0 Opens: 96 Flush tables: 1 Open tables: 89 Queries per second avg: 0.581 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 9 [warning_count] => 0 ) [count:protected] => 34 [cursor:protected] => 1 [debug:protected] => [limit:protected] => 0 [log:protected] => Array ( ) [timings:protected] => Array ( ) [callStacks:protected] => Array ( ) [offset:protected] => 0 [options:protected] => Array ( [driver] => mysqli [host] => localhost [user] => HIDDEN [password] => HIDDEN [database] => HIDDEN [prefix] => HIDDEN [select] => 1 [port] => 3306 [socket] => ) [sql:protected] => UPDATE `#__jshopping_products` SET `parent_id`='0', `product_ean`='000001', `product_quantity`='0.00', `unlimited`='0', `product_availability`='', `product_date_added`='2016-01-22 18:04:26', `date_modify`='0000-00-00 00:00:00', `product_publish`='1', `product_tax_id`='0', `currency_id`='1', `product_template`='default', `product_url`='', `product_old_price`='0.0000', `product_buy_price`='0.0000', `product_price`='0.000000', `min_price`='0.000000', `different_prices`='0', `product_weight`='0.0000', `image`='img_', `product_manufacturer_id`='0', `product_is_add_price`='0', `add_price_unit_id`='0', `average_rating`='0.00', `reviews_count`='0', `delivery_times_id`='0', `hits`='0', `weight_volume_units`='0.0000', `basic_price_unit_id`='0', `label_id`='0', `vendor_id`='0', `access`='1', `name_de-DE`='', `alias_de-DE`='', `short_description_de-DE`='', `description_de-DE`='', `meta_title_de-DE`='', `meta_description_de-DE`='', `meta_keyword_de-DE`='', `name_en-GB`='', `alias_en-GB`='', `short_description_en-GB`='', `description_en-GB`='', `meta_title_en-GB`='', `meta_description_en-GB`='', `meta_keyword_en-GB`='', `extra_field_1`='', `extra_field_2`='' WHERE `product_id`='11522035' [tablePrefix:protected] => HIDDEN [utf:protected] => 1 [errorNum:protected] => 0 [errorMsg:protected] => [transactionDepth:protected] => 0 [disconnectHandlers:protected] => Array ( ) ) [_trackAssets:protected] => [_rules:protected] => [_locked:protected] => [_autoincrement:protected] => 1 [_observers:protected] => JObserverUpdater Object ( [observers:protected] => Array ( ) [doCallObservers:protected] => 1 ) [_columnAlias:protected] => Array ( ) [_jsonEncode:protected] => Array ( ) [_errors:protected] => Array ( ) [product_id] => 11522035 [parent_id] => 0 [product_ean] => 000001 [product_quantity] => 0.00 [unlimited] => 0 [product_availability] => [product_date_added] => 2016-01-22 18:04:26 [date_modify] => 0000-00-00 00:00:00 [product_publish] => 1 [product_tax_id] => 0 [currency_id] => 1 [product_template] => default [product_url] => [product_old_price] => 0.0000 [product_buy_price] => 0.0000 [product_price] => 0.000000 [min_price] => 0.000000 [different_prices] => 0 [product_weight] => 0.0000 [image] => img_ [product_manufacturer_id] => 0 [product_is_add_price] => 0 [add_price_unit_id] => 0 [average_rating] => 0.00 [reviews_count] => 0 [delivery_times_id] => 0 [hits] => 0 [weight_volume_units] => 0.0000 [basic_price_unit_id] => 0 [label_id] => 0 [vendor_id] => 0 [access] => 1 [name_de-DE] => [alias_de-DE] => [short_description_de-DE] => [description_de-DE] => [meta_title_de-DE] => [meta_description_de-DE] => [meta_keyword_de-DE] => [name_en-GB] => [alias_en-GB] => [short_description_en-GB] => [description_en-GB] => [meta_title_en-GB] => [meta_description_en-GB] => [meta_keyword_en-GB] => [extra_field_1] => [extra_field_2] => )



Letzte Änderung: 01.02.2016 23:01
 
02.02.2016 07:49
#4
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16475
Quote
Aw: Universal Import images error

url?
admin login?
ftp?
(privat)

file example.


Letzte Änderung: 02.02.2016 07:49
 
Copyrights MAXXmarketing GmbH. All Rights Reserved