Topic: Database error

[EdelingF]

On my SME 7.3 server I have GroupOffice installed. Every thing worked fine, but the last few days a get an error when I trie to upload files:

Code: [Select]

Database error: Invalid SQL: SELECT link_id FROM fs_links WHERE path='/opt/groupoffice/home/users/user@domain.nl/Projecten/Leiden/Communicatie/Beeldmateriaal/Luchtfoto's/2000/TVP_02-2000.pdf';
MySQL Error: 1064 (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/2000/TVP_02-2000.pdf'' at line 1)
Session halted.I haven't altered my SQL as far as I know it, doies anyone know what possible has happened?

[HomePlayer]

The -'- between o and s is your problem Luchtfoto's/2000/
 put a \ infront of the ' will solf it like this Luchtfoto\'s/2000/

[EdelingF]

Thanks! That did it, never realized it would be a problem to use '