| Description | If you have a array dual scale question,
activate the survey,
have some answer,
deactivate survey
reactivate survey
try to reimport old answer.
You have a SQL error with some 62737X76X1124ACC#0 inside (with mysql)
Unknown column 'id' in 'field list':SELECT id, submitdate, lastpage, startlanguage, token, 62737X76X1124SPD#0, 62737X76X1124SPD#1, 62737X76X1124DSN#0, 62737X76X1124DSN#1, 62737X76X1124ACC#0, 62737X76X1124ACC#1 FROM lime_old_survey_62737_20110729015006 |
|---|
| Additional Information | For the select, we can use :
-- $queryOldValues = "SELECT ".implode(", ",$aValidFields)." FROM {$oldtable} ";
++ $queryOldValues = "SELECT ".implode(", ",array_map("db_quote_id",$aValidFields))." FROM {$oldtable} ";
But after we use GetInsertSQL, and have the error:
INSERT INTO lime_survey_62737 ( SUBMITDATE, LASTPAGE, STARTLANGUAGE, TOKEN, 62737X76X1124SPD#0, 62737X76X1124SPD#1, 62737X76X1124DSN#0, 62737X76X1124DSN#1, 62737X76X1124ACC#0, 62737X76X1124ACC#1 ) VALUES ( '2011-07-29 01:49:58', 2, 'en', null, '5', '1', '3', '1', '5', '1' )
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 '' at line 1
( AdoDB error ????? )
I trye with a little quick and dirty fix:
foreach ($row as $key => $value) {
$quoterow[db_quote_id($key)]=$value;
}
But after we can't use GetInsertSQL:
Error:
Query was empty
I thgink we can fix it quick and dirty with an INSERT ... "manual" request ( can do it ))without adodb but maybe there are another possibility and we loose adodb speed ?
Thanks |
|---|
