Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

Updating SQL

Quote Reply
Updating SQL
Seems i should sleep ...
1. I update my "index weight" for the links cols with the linksadmin. (yes, buttons ar clicked!)
2. i look at the links.def; OK
3. Start the setup.cgi and write tables; OK
4. ReStart MySQL
5. Watch again in the admin-tool;OK
6. Resync defs there

----> and all changes are lost?!?!?!?!?

What is wrong??
Quote Reply
Re: Updating SQL In reply to
I just posted TWO messages on this today!!

If you resync the .def files, they write out DEFAULT values. They simply read the mysql table, and write out the field names with the default values in links.

Once you edit them, DON'T RESYNC! If you do, you'll have to edit all your changes again.

If you do all your editing-- changes and deletions of fields in the Admin Editor, then you won't have to resync the tables.

I guess I need to add this in the FAQ ASAP.

Quote Reply
Re: Updating SQL In reply to
Ok. Get it.
Do you know where i could see the weight indixes and some other values with phpmyadmin?
Quote Reply
Re: Updating SQL In reply to
The weights are shown in the .def file.

The new layout of the program has the word indexes in the files. It's a JOIN of the the word_index and scores_index files.

Scores_Index has the link ID the score and the postion in the search order (used to help find phrases) The Word_Index has the word itself and the frequency.