Hi All,

Ive added new fields to the database, and a couple of these are defined as Yes|No. They show OK when i add them, but when I Re-Sync it defaults back to a blank box!!

Also if I change "Not Null" To "YES" and try it this way It also reverts back to "NO"

Any Ideas?

Ive also just noticed my "INDEX WEIGHTS" reverting back to '0'


Regards

MDJ1
http://www.isee-multimedia.co.uk

Hi All,

I think im getting confussed!!!

I only re-sync if i change the order of the fields as this reverts all to the program defaults, If i actually change the info in the fields its updated automatically, Is this correct!!

Regards

MDJ1
http://www.isee-multimedia.co.uk

If you add fields in your .def files, you need to re-adujust the weights and theh click on the Changes button...do not hit the Re-sync button as it will default back to your original values identified through the setup process.

Regards,

Eliot Lee

So i have to change the .def files manually then and then re-upload it and change the weights?



Regards

MDJ1
http://www.isee-multimedia.co.uk

No...you do the following (if you want to use the setup.cgi to re-create your tables and .def files)....

1) EXPORT all data from your tables using individual EXPORT functions via editor.cgi or MySQLMan or use the MySQLdump command via telnet or the SQL Monitor via either of the above mentioned applications.

2) DROP the tables.

3) Then execute setup.cgi to re-create your tables and .def files.

4) IMPORT your data into the appropriate tables...

Although I do the following when adding new fields:

1) Add the fields in the table.
2) Add the field MANUALLY in the respective .def file.
3) Re-weight the fields via editor.cgi.
4) Re-index the tables.

Regards,

Eliot Lee

The only caution in _manually_ entering the fields in the .def file is that you need to make sure you get the _ORDER_ of the fields correct.

If you re-weight the files anyway, you might as well resync, then reweight the files and re-index, and everything will be updated properly.

The new MySQLMan appears to let you insert fields in tables in positions other than at the end.

(NOTE: This is not meant for you, Eliot, but to the legions of others who read these posts <G>)

http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/