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
orderlines.jpg
Website Url: streeetshop.dk
15.12.2016 13:36
|
|
jacobsen
Name: john
15.02.2011
Posts: 410
|
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 orderlines.jpg
Website Url: streeetshop.dk
|
15.12.2016 13:41
|
|
admin
(Support Team) Name: Admin
05.08.2010
Posts: 25929
|
|
15.12.2016 14:26
|
|
jacobsen
Name: john
15.02.2011
Posts: 410
|
|
15.12.2016 14:35
|
|
admin
(Support Team) Name: Admin
05.08.2010
Posts: 25929
|
|
15.12.2016 14:48
|
|
jacobsen
Name: john
15.02.2011
Posts: 410
|
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
Last change: 15.12.2016 14:52
|
15.12.2016 22:43
|
|
admin
(Support Team) Name: Admin
05.08.2010
Posts: 25929
|
|
16.12.2016 09:30
|
|
jacobsen
Name: john
15.02.2011
Posts: 410
|
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
|
|
admin
(Support Team) Name: Admin
05.08.2010
Posts: 25929
|
|
16.12.2016 15:50
|
|
admin
(Support Team) Name: Admin
05.08.2010
Posts: 25929
|
|
16.12.2016 19:51
|
|
jacobsen
Name: john
15.02.2011
Posts: 410
|
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 Kind regards Jacobsen
Last change: 16.12.2016 20:00
|
17.12.2016 11:58
|
|
admin
(Support Team) Name: Admin
05.08.2010
Posts: 25929
|
|
17.12.2016 17:34
|
|
jacobsen
Name: john
15.02.2011
Posts: 410
|
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
Last change: 17.12.2016 17:44
|
17.12.2016 21:18
|
|
admin
(Support Team) Name: Admin
05.08.2010
Posts: 25929
|
|
17.12.2016 22:14
|
|
jacobsen
Name: john
15.02.2011
Posts: 410
|
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
Last change: 17.12.2016 22:26
|
17.12.2016 22:43
|
|
admin
(Support Team) Name: Admin
05.08.2010
Posts: 25929
|
|
18.12.2016 08:22
|
|
jacobsen
Name: john
15.02.2011
Posts: 410
|
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
|
|
admin
(Support Team) Name: Admin
05.08.2010
Posts: 25929
|
|
04.01.2017 11:46
|
|
jacobsen
Name: john
15.02.2011
Posts: 410
|
|