#1247 PostgreSQL quoting problems?

v1.8RC
open
nobody
5
2012-12-08
2004-02-05
No

I get the following error after a clean install when trying
to access any tiki file:

Warning: error: ERROR: parser: parse error at or
near "`" at character 29 in query:
select `name` ,`value` from `tiki_preferences`
in /srv/www/htdocs/rhyme/tiki/lib/tikidblib.php on line
125
Values:
Array ( )
$result is false
$result is empty

It seems that the attribute quotes are not compatilble
with PostgreSQL, which expects "normal" single quotes,
not the backward variety.

Have I missedn something?

Discussion

  • Philip Warner

    Philip Warner - 2004-02-06

    Logged In: YES
    user_id=20293

    This is cause by the fact that $ADODB_Database is empty for
    some reason. In tracking this down, I also found several
    cases where it is compared to 'postgres7' and several where
    it is compared to 'pgsql72', but they do not seem to
    consistently check both.

    Fixing the above, and hardcoding 'pgsql72' results in tikiwiki
    working...

     
  • Philip Warner

    Philip Warner - 2004-02-06

    Logged In: YES
    user_id=20293

    Updating this item for category / group / subject line or other
    data. No real change to the item, just house-keeping.

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks