Error - Problem with order lines after update.

15.12.2016 13:36
#1
jacobsen
Joomshopping forum user no avatar
Name: john
15.02.2011
Posts: 355
Quote
Error - Problem with order lines after update.

Hi

Can anybody help me.
when raising a new order in admin area.
The ID number jumps.

See attached images.

Images from SQL
Images from admin Product list

Kind regards
Error - Problem with order lines after update.
orderlines.jpg


Website Url: streeetshop.dk
 
15.12.2016 13:41
#2
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 18293
Quote
Aw: Error - Problem with order lines after update.

??
order number or??

 
15.12.2016 14:26
#3
jacobsen
Joomshopping forum user no avatar
Name: john
15.02.2011
Posts: 355
Quote
Aw: Error - Problem with order lines after update.

If you see images, it ID numbers.
It easy to spot.

kind regards
Jacobsen

 
15.12.2016 14:35
#4
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 18293
Quote
Aw: Error - Problem with order lines after update.

No error after update in my test site.
For order development use Kontakt.

 
15.12.2016 14:48
#5
jacobsen
Joomshopping forum user no avatar
Name: john
15.02.2011
Posts: 355
Quote
Aw: Error - Problem with order lines after update.

I Don't understand you.

I use a standard JoomShopping, every time I raise a new product JommShopping skip a lot of lines.
If you look closer on image from database you can see that Joomshopping is skipping a lot of ID order lines.
It probably because that i'm using attributes. - ?

I have change from PHP 7.0 to PHP 7.1 and update Joomshopping.

I can see it started 2015-10-17

Kind regards
Jacobsen


Letzte Änderung: 15.12.2016 14:52
 
15.12.2016 22:43
#6
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 18293
Quote
Aw: Error - Problem with order lines after update.

try disable plugins.

 
16.12.2016 09:30
#7
jacobsen
Joomshopping forum user no avatar
Name: john
15.02.2011
Posts: 355
Quote
Aw: Error - Problem with order lines after update.

I can see what you mean. There is no error in Product list - new order.

After testing.
I see that the error occur when I'm importing attributes using - Import Attributes to Product 1.4.1

Import Attribute to product
charset: (iso-8859-1)
Field (Dependent/Yes):
product_id;price;amount_in_stock;product_code;weight;buy_price;weight_volume_units;old_price;Color;Size;ext_image;date_available

The import is creating empty product_id line in database tabel jshopping_products

I Don't know if it here I have to raise the question or you would like me to address this issues to the Forum for Commercial extensions


Kind regards
Jacobsen

 
16.12.2016 10:55
#8
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 18293
Quote
Aw: Error - Problem with order lines after update.

Now I understand more.

send me example import csv

 
16.12.2016 15:50
#9
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 18293
Quote
Aw: Error - Problem with order lines after update.

All right.
Data dependent attributes are recorded in the table product.

 
16.12.2016 19:51
#10
jacobsen
Joomshopping forum user no avatar
Name: john
15.02.2011
Posts: 355
Quote
Aw: Error - Problem with order lines after update.

Hi

The import doesn't load the images (the images link is working) and it still mess with the ID, when I import the CSV file.
If there is only 1 atribute the numbers is following +1 but if there is a lot of attributes the ID no. is jumping. with the count of the attributes +1

Kind regards
Jacobsen
Aw: Error - Problem with order lines after update.
Aw: Error - Problem with order lines after update.
Aw: Error - Problem with order lines after update.

Kind regards
Jacobsen


Letzte Änderung: 16.12.2016 20:00
 
17.12.2016 11:58
#11
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 18293
Quote
Aw: Error - Problem with order lines after update.

I do not understand you.
Error?

id - not error. (Data dependent attributes are recorded in the table product.)


Letzte Änderung: 17.12.2016 12:00
 
17.12.2016 17:34
#12
jacobsen
Joomshopping forum user no avatar
Name: john
15.02.2011
Posts: 355
Quote
Aw: Error - Problem with order lines after update.

Sorry then is not a problem?

I actually thought that is was save in _jshopping_products_attr
Then you have change the code around 2015-10-17 to also use the _jshopping_products to store attributes in???
Before that time it wasn't a problem. `???

But The import doesn't load the images (the images link is working)there is no page coming up that run thru the images as I did before.

Kind regards
Jacobsen


Letzte Änderung: 17.12.2016 17:44
 
17.12.2016 21:18
#13
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 18293
Quote
Aw: Error - Problem with order lines after update.

???

Do not set 'ext_image' field.

 
17.12.2016 22:14
#14
jacobsen
Joomshopping forum user no avatar
Name: john
15.02.2011
Posts: 355
Quote
Aw: Error - Problem with order lines after update.

??????

I need to upload the images! Still think there is a major bug in Import Attributes to Product 1.4.1
why started to mix product with attributes? Why used a hole product record in (_jshopping_products) to control the attribute when you have made a table for the same???

Looking at the information on the record in (database _jshopping_products) it doesn't make any sense to use a hole record, here i what there is in the record that not default.

Eg.
product_id int(11) 7748
parent_id int(11) 7743

Furthermore please look at the images I have uploaded and also look at the following 2 images.
As you can see there wasn't any Error before.
You did´t used a hole record in the database _jshopping_products.pr. attributes in the past

there is no jump between ID no. in (database _jshopping_products) so why NOW ???


Kind regards
Jacobsen
Aw: Error - Problem with order lines after update.
Aw: Error - Problem with order lines after update.


Letzte Änderung: 17.12.2016 22:26
 
17.12.2016 22:43
#15
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 18293
Quote
Aw: Error - Problem with order lines after update.

try create atribute and set image.
see database.

not bug.

 
18.12.2016 08:22
#16
jacobsen
Joomshopping forum user no avatar
Name: john
15.02.2011
Posts: 355
Quote
Aw: Error - Problem with order lines after update.

You are right.


BUT....................... When I run Import Attributes to Product 1.4.1
Hell breaks loose.

It somehow creating empty records in (database _jshopping_products).

Please see the images I have send.

I can input 10 new product and when I update them hell breaks loose - still have problem with importing the images.

Kind regards
Jacobsen

 
18.12.2016 11:46
#17
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 18293
Quote
Aw: Error - Problem with order lines after update.

1. Import not works with separator ,
Need set (;)
2. problem in name file 915-AF:SLV.jpg (symbol :)

 
04.01.2017 11:46
#18
jacobsen
Joomshopping forum user no avatar
Name: john
15.02.2011
Posts: 355
Quote
Aw: Error - Problem with order lines after update.

Happy New Year

I see what you mean, is it possible next time the Import Attributes to Product need an update to make sure the the separator is a ;
So it won't download the file if it not ; separate.

Thank you for the help.

Kind regards
Jacobsen

 
Copyrights MAXXmarketing GmbH. All Rights Reserved