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


Last change: 15.12.2016 14:52
 
15.12.2016 22:43
#6
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 19640
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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 19640
Quote
Aw: Error - Problem with order lines after update.

Now I understand more.

send me example import csv

 
16.12.2016 15:50
#9
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 19640
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


Last change: 16.12.2016 20:00
 
17.12.2016 11:58
#11
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 19640
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.)


Last change: 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


Last change: 17.12.2016 17:44
 
17.12.2016 21:18
#13
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 19640
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.


Last change: 17.12.2016 22:26
 
17.12.2016 22:43
#15
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 19640
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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 19640
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. 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.