SOLVED - Update Issues

[trains58554]

just change the table name to oc5_t_item_description

Jay

[sundance]

Tried again, got this:

[trains58554]

so the database looks like it is up correct is it just the one item or a bunch showing that error?

Jay

[sundance]

About half of them. So I am guessing that it is not letting me copy because some of them are still ok?

[sundance]

I delete each duplicate entry (from the old database) and try again, but each time a new duplicate shows up - each one that is a already good item. I guess it won't copy over the ones that are already good. Any way to do a overwrite kind of copy?

[trains58554]

I am thinking that they are not copying because some are ok and it wants to input them again.

I have an idea copy the old table to a new table just give it a new name that way you still have a backup.

Then go though the item_description table and write down which ids you have there then either in you item_description table or the other backup delete these rows then try copying the table into the item_description table.

Jay

[sundance]

It wants me to create a new table first. How do I do this?

[sundance]

What is I just deleted all of them in the current and copied all the old over?

[trains58554]

click on the item_description table and click operations and there is an option like this "Move table to (database.table): " add a 1 at the end of the table name.

click on the item_description_old and under "Table options" where it says rename table just remove the _old from the end and click go.

that way you still have you item_descriptions table.

Jay

[sundance]

Ok, man that sucked. I renamed it like you suggested and made the old the current one. I had to do some copying because of a couple of them I had deleted (needed to carry them over from the first current table). That phpmyadmin is crazy stuff. Thank you for your help. I wish I had some $$ I could pay you. Thank you again.

[trains58554]

What a way to learn phpmyadmin? I am glad I was able to help you get it working again.

Jay