Problem creating a new product

[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

[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

[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....

[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]

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

[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]

How can You have index 7855 Then ?
Jörgen

[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

[Jörgen]

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

Jörgen

[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

[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