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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25856
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] => )



Last change: 01.02.2016 23:01
 
02.02.2016 07:49
#4
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25856
Quote
Aw: Universal Import images error

url?
admin login?
ftp?
(privat)

file example.


Last change: 02.02.2016 07:49
 


Copyrights MAXXmarketing GmbH. Alle Rechte vorbehalten
Durch die Nutzung dieser Website stimme ich zu, dass Cookies zur optimalen Gestaltung der Website sowie zur Analyse der Nutzung der Website verwendet werden. Weiterführende Informationen finden Sie hier. OK, einverstanden.