[webgod]

Originally Posted by john.friel

Post 616 describes the necessary changes to the field in the database, but what would the correct SQL command be to do it manually from within vbadmin?

I'm a MS SQL programmer and have not looked up the MySQL equivalent.

John

I have direct access to the server and a GUI interface, so it was as a easy as point and click for me.

but being a developer myself, the correct SQL query is:
ALTER TABLE userfield MODIFY COLUMN Field55 Decimal(5,3);

Reference:
http://dev.mysql.com/doc/refman/5.0/en/alter-table.html

Field55 may be different in your installation, so make sure it refers to the data column for the 1/4 ET and/or 1/8 ET

Back up your table/DB before attempting any schema alterations, I take absolutely no responsibility for the code above, and have not tested or verified it's compatibility on any system.


.