Koozali.org: home of the SME Server

Obsolete Releases => SME 7.x Contribs => Topic started by: EdelingF on April 07, 2008, 08:14:47 AM

Title: Database error
Post by: EdelingF on April 07, 2008, 08:14:47 AM

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?

Title: Re: Database error
Post by: HomePlayer on April 07, 2008, 09:13:07 AM

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

Title: Re: Database error
Post by: EdelingF on April 07, 2008, 12:58:34 PM

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