Custom Fields; can not change nor delete

[hdraye]

Hi
If I change anything in a custom field, proprties are lost, and I can not delete old ones, nor create new ones.
I checked using phpmyadmin, I get a "No index defined!" message, is that normal?

I dropped the table and then recrated it, still the same.

please help

[esm]

and you are using which version of INDEXU...??? hopefully, v5.4 since all others are not supported.


.

[Bruceper]

If you change the properties of a custom field where? If you change a field from text to an image then I'm sure all data would be removed since it is no longer applicable.

After you change the custom field you can't create a new custom field?

I am totally confused by your post. Indexes dont matter.

Also, when you create a custom field data is inserted into three tables in the database, not just one. By dumping one table you are still leaving those fields in the other tables which is probably what is causing your issue.

You SHOULD have removed the fields from within the admin panel. That's why it's there.

When you create a custom field there are rows created in the following tables

idx_custom_field
idx_link
idx_link_temp

[hdraye]

yes I am using 5.4
and yes I am truing to remove from admin panel/links/coudtom fields
the field was a select type, I wanted to add more option, when saved, the properties are lost, and when try to chanhe or delete, no luck.

[Bruceper]

I dropped the table and then recrated it

But the field still exists as I said above, once you messed with the database via phpmyadmin you messed up IndexU. You need to delete the fields in the tables I mentioned above or you will continue to have issues.

[hdraye]

I restored the database, and can not drop fields.
nevermind, I was restoring the wrong database, now it works

Thanx