News:

Support the VirtueMart project and become a member

Main Menu

Problem creating a new product

Started by m.davide82, October 14, 2021, 14:16:28 PM

Previous topic - Next topic

Jörgen

You have more product related tables custom fields, prices etc. Have You checked these?

What is the highest index in Your product table ?


Jörgen
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

m.davide82

Hi,

did some tests and the situation is very strage.

I imported a new test product via ROCSVI and when I click on new, the product creation is always from the latest product inserted.

I'm very worried...


Thanks.
Davide

Jörgen

The sql table has an index that is autoincremented ? what is the autoincrement value ? Is it one to low ?

Jörgen
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

GJC Web Design

See how declaring ALL info would have helped you and stopped us wasting our time?

no where did u mention that you are importing products via a 3rd party ext. 
It is fairly obvious then that the import is not correct....
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

m.davide82

Hi GJC,

I told you everything, I wrote the situation.
But this morning I had to have a solution to create some products and I decided to do this creation with the importer, nothing else.

@Jorgen
Yes, from 4 to 10240.

Thanks.
Davide

Jörgen

#20
You can not create a new product with Id 7855 IF you have more than 10000 occupied indexes. You overwrite old products. Why has this happened? I Guess a wrongly applied products import or some Broken and not completed products update. Check your phpmyadmin and set a correct next autoincrement index. I already told You in my previous post to check the autoincrement indexes, have You done that ?

Good luck

Jörgen
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

m.davide82

Hi Jorgen,

I know!  :)

No, I NEVER did an import before lastday... so I don't know how this problem was created.
In mysql, the next autoincrement works.

Thanks.
Davide

Jörgen

#22
How can You have index 7855 Then ?
Jörgen
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

m.davide82

Hi Jorgen,

this is a beautiful question...
I'm sorry, but I don't know....

Probably an update of Virtuemart?


Thanks.
Davide

GJC Web Design

VM updates do not alter any table entries
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

Jörgen

If Your autoincrement points to one past the last of your table. I am out of guesses.

Jörgen
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

m.davide82

Hi,

In attachment you find the table structure...
Thanks,
Davide

Jörgen

This tells us nothing about the issue.

You have to check under Operations for this table. There you will see and can also set the actual Autoincrement value.

Jörgen @ Kreativ Fotografi
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

m.davide82

Hi,

the last ID is 10216 in the products table, so in the operation is 10217.
In attachment the screenshot.

Thanks.
Davide

Jörgen

OK, when Do you get product id 7855 ?

Where does this come from ?

Was it perhaps the last product You edited before you med a new product ?

Can this be some autofill that comes from Your web browser ? Browser cache issue perhaps ?

Jörgen @ Kreativ Fotografi
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.