Re: [Phpgroupware-users] sitemgr...

[Chris Weiss]

The error was a PostgreSQL one, so I'm sure they were properly escaped, but they
should't be there in teh first place.  I wasn't aware that even MySql suported
using double quotes in sql.

Brian Johnson (address@hidden) wrote*:
>
>A little brief, but Chris is right - check that your nested quotes within (and
>around) the SQL statement don't cancel themselves out
>
>ie use " ' ' " not " " " "
>
>
>
>Chris Weiss (address@hidden) wrote*:
>>
>>" should be ' in sql statements
>>
>>
>>John Burton (address@hidden) wrote*:
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>Hi Patrick,
>>>
>>>I tried your and it appeared to correct that particular problem. There was
>>>one instance in  class.Pages_SO.inc.php and two in
class.Categories_db_SO.inc.php.
>>> Now I get the error:
>>>
>>>
>>> --    Database error: Invalid
>>>SQL: SELECT value FROM phpgw_sitemgr_preferences WHERE name="catsupdated"
>>> PostgreSQL Error: 1 (ERROR:  Attribute 'catsupdated' not found )
>>>
>>>File: /var/www/html/FIRST/sitemgr/inc/class.sitePreference_SO.inc.php
>>>Line: 33Session halted.
>>>
>>>thoughts?
>>>
>>>John