submit problem

[revolver]

i just discovered a bug of mine in the submit process that i must have introduced while building some custom mods a while back and not caught until now. I am getting a mysql error message in step 3 of the submit process (the review page) whenever i submit tags with an apostrophe ('). It took a long time for this error to come up because i just tried submitting tags with apostrophes for the first time. The error message looks like this if i try to submit the tag s' :

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's', from_unixtime(1163986345))' at line 1

The error isn't fatal. The rest of the page displays properly and everything including the tags with apostrophes are posted correctly when i submit the story.

I know the problem isn't in submit.php because i reverted back to the default version and still get the error. I aslo get the error regardless of which template i am using.

I am not using version control but have made notes on all of my mods and tried to retrace my steps with no luck. Can anyone guess at which file i may have messed up?

Any tips greatly appreciated.

[AshDigg]

Sounds like /libs/link.php. Function store_basic() which gets called by function store() which "stores" the link information in the database.

[revolver]

thanks AshDigg ... but i had only altered a single line in link.php and when i tried uploading the original version i still got the error.

Any other ideas?