hi

we have been using linkssql 1.11 on mysql 3.21.33. everything worked fine.

then we upgraded mysql to latest stable 3.22.xx.
and from then on the linkssql did not work.

please try it yourself when adding a new url at:
http://www.netreal.de/cgi-bin/add.cgi (simply type in something to test).

what i get is as an error and i am asked to review my entries:

Title (Invalid format)
URL (Invalid format)
Hits (Invalid format)
isNew (Invalid format)
isChanged (Invalid format)
isPopular (Invalid format)
Rating (Invalid format)
Votes (Invalid format)
ReceiveMail (Invalid format)
Status (Invalid format)
Mode (Invalid format)

my def file is the same as the database table syntax

please help
maik

Hi maik,

Hmmm...I would go to the Links editor and take a look at the Validation column. This usually requires retweaking when re-syncing your .def files In the Validation column you probably will have all 1's, in particular, for the fields that are coming up as invalid. Change them to 0's and your problem should go away.

thank you, that was the solution.
although i do not understand why this changed after upgrading the mysql server. i mean nor the database (content), nor the links sql configuration have changed during this process.

thank you anyway.
maik

No prob glad to help
I'm not sure myself, why...but what happened usually occurs when the editor is used to re-sync the def files with the database tables.