Gossamer Forum
Home : Products : Gossamer Links : Pre Sales :

MYSQL shows other values than links

Quote Reply
MYSQL shows other values than links
Have a strange problem with my mysql-database.
PhpMyAdmin shows my links-table with completly different values than links. OK, in just this moment i tried it with a recreate of defs and now everything is ok. I will write on, maybe it helps someone other.

BTW: Do someone now which is the difference between OPTIMIZE TABLE LINKS and using the xyzchk-tool from command-line? (I dont must flash the table or stop mysql, but what else?)

Quote Reply
Re: MYSQL shows other values than links In reply to
If the .DEF file doesn't match your Links table (or any .def file doesn't match the corresponding table) then the data displayed using the .def file (as in the Admin area) will be all mixed up.

That's why it's a good idea to only add or delete fields through the Admin functions, since the .def table update is taken care of you automatically. If you do any modification of the table structure in another program, you have to resync the .def files.

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