I have tried playing around with common_functions.php:

    case "postgres":
        return "\"".$id."\"";
        break;

But if I remove the quotes I just get blank screens. I have also tried strtolower() for the $id variable but it still all ends up upper case and produces the same error.

That's about as far as my limited knowledge of PHP goes at the moment...

Tried it with MySQL v5.1 - it works ok so the problem is probably limited to PostgreSQL.

As a workaround remove the line

if (!isset($ADODB_QUOTE_FIELDNAMES)){$ADODB_QUOTE_FIELDNAMES=true;}

from common.php

You can place $ADODB_QUOTE_FIELDNAMES=false; in config.php.

But i think here there are a problem of uppercase.
define('ADODB_ASSOC_CASE', 2); have to be good ...
And the array send to GetInsertSQL are in lowercase ...

PinkPenguin,
can you try with
$ADODB_QUOTE_FIELDNAMES=false;
and with
define('ADODB_ASSOC_CASE', 0);

please ?

I put the following lines in config.php at the end of the file:

$ADODB_QUOTE_FIELDNAMES=false;
define('ADODB_ASSOC_CASE', 0);

That worked. I created a survey, did a few updates and inserted a question group and question just to be sure.

[edit]It also works with only $ADODB_QUOTE_FIELDNAMES=false; in the config.php file but it does not work with only define('ADODB_ASSOC_CASE', 0); - this latter maybe a question of where you put (just not in config.php).[/edit]

I suspect common.php is probably a better place for them but I'll leave that to you.

Many thanks.

OK, i install postgres and see what we can do.

Hello,

I don't know how to resolve,

I install LS with postgre 8.4

If i put
$ADODB_QUOTE_FIELDNAMES=false;; then i can create and activate a survey, but again i have the 05367 bug ..

With 05367 method:

ERREUR: erreur de syntaxe sur ou près de « # » LINE 1: ...te, lastpage, startlanguage, token, 72275X1X7SQ001#0, 72275X... ^:SELECT id, submitdate, lastpage, startlanguage, token, 72275X1X7SQ001#0, 72275X1X7SQ001#1, 72275X2X11#0, 72275X2X11#1, 72275X2X12#0, 72275X2X12#1, 72275X2X13#0, 72275X2X13#1, 72275X2X14#0, 72275X2X14#1 FROM lime_old_survey_72275_20110812130046

Somthing i don't understand : i read:
http://phplens.com/adodb/reference.constants.adodb_assoc_case.html
The 2 = use native-case field names.
The array are in lower-case, i don't understand why it was in upper-case for the function ...

Search for an idea ...

Workaround:
$ADODB_QUOTE_FIELDNAMES=false;
in config.php

It is probably not a good idea to use the # (hash) character in field names as in some SQL enfironments this causes teh rest of the statement to be treated as a comment. It was probably the reason you had to quote the field names in the first place.

Can the # (hash) be substituted for the _ (underscore) ?
This would be less ambiguous in the context. If this is so then $ADODB_QUOTE_FIELDNAMES=false; would probably work fine even for 05367.

I know PinkPenguin ...

But there are some other part to verify.

Renaming fields is really a PITA. Lots of places would have to be changed. Maybe for a later version.

I guess the only way is to fix ADODB to use the right casing when calling getInsertSQL.

... I had a nasty feeling that the field name fix would be a problem ...;-)

So, if I have understood correctly, it's a hunt for wherever the field names get capitalized... probably in ADODB.

Is there a good way of tracing PHP while its executing ?

Remove getInsertSQL,

Put an pure sql string and an Execute on importoldresponse

Test the patch in postgre AND mysql, see what it done.

( and remove the $ADODB_QUOTE_FIELDNAMES=true; )

PS: jquery problem too with # in fieldname ;)
:)

Fixed in 10704

Use of own function in importoldresponses.php .
Maybe put a global function in common_function.php is a good idea to insert and update a table with array of keys=>values