Error in M2

[Tom27]

Error: Invalid Index found(Idx:0 Name..

Got this error in M2 shortly after all items on server randomly dissapeared.
Any ideas?

This happened last time the server was live and one of the reasons I had to close it down.

 

[Kaori]

Error: Invalid Index found(Idx:0 Name..

Got this error in M2 shortly after all items on server randomly dissapeared.
Any ideas?

This happened last time the server was live and one of the reasons I had to close it down.

restore original db, does it work?

 

[Tom27]

Ive just done a full server wipe including ID's.

Im just hoping to hell it dont appear again

 

[Bon]

sounds like uve messed up the item index from 0 ? lol

 

[paul.obrien]

you will have treied to make a new item using the same index as another item.
ive done this a few time on the live server lol.Its not the end of the world.
Simply use sql and do a query.find the 2 id numbers that are the same and change one of the to a unique id number in numerical order then reboot the server.

 

[Tom27]

Cheers ill look into that now,
All my database is completely messed up anyway so its real confusing.

Numbers go like
1-600 1100-1300 601-1000 1400-1500

Completely messed up. I might just go right the way down the list and rename them all so there in the correct order, will this mess anything up if i do so?

 

[akacary2]

Why not just make another TBL_STDITEMS but put a 2 on the end, make sure all the values are the same and copy the data over so that its in order?
Then just delete the original and rename the TBL_STDITEMS2 to TBL_STDITEMS

 

[Tom27]

I got lost at:

"Why not just make another TBL_STDITEMS but put a 2 on the end, make sure"

xD

 

[Bon]

what database type you using? SQL?

just index it so it displays it all in order 1-1600 or w/e..

 

[Spoon666]

Cheers ill look into that now,
All my database is completely messed up anyway so its real confusing.

Numbers go like
1-600 1100-1300 601-1000 1400-1500

Completely messed up. I might just go right the way down the list and rename them all so there in the correct order, will this mess anything up if i do so?

Export the DB to .mdb to use in Access or .txt and cut and paste it back into order then import it back to SQL

 

[Tom27]

Cheers guys but Boothy's fixed it for me
Changed something in design table and put some weird key thing on it. Cheers anyways

 

[Killmaster]

Lol... it actually means you cannot start from Index 0 like 1.9 used to.
Changing or deleted that item with the Index of 0 would have fixed it.

 

[boothy]

it was because he had a full row with <NULL> in every column, deleted that and it worked lol