-
Bug
-
Resolution: Fixed
-
Minor
-
2.0.3
-
None
-
Scientific Linux 5.6 & RHEL 5.6, arch: x64_64, php (5.3.6 backport by rpms.famillecollet.com), postgresql84 (8.4.7)
-
PostgreSQL
-
MOODLE_20_STABLE
-
MOODLE_21_STABLE
It says there is a syntax error. It possibly be due to PostgreSQL as DBMS, since a collegue from another school has sent me their dump which was done with Moodle 2.0.2 with MySQL. We have OS with german locale settings.
(Transcript: ERROR: Invalid Input syntax for the number "2011033003.03")
Debug info: FEHLER: ungültige Eingabesyntax für ganze Zahl: »2011033003.03«
INSERT INTO mdl_admin_preset (userid,name,comments,site,author,moodleversion,moodlerelease,timecreated) VALUES($1,$2,$3,$4,$5,$6,$7,$8) RETURNING id
[array (
'userid' => '2',
'name' => 'myExport',
'comments' => '<p>NoCommentsHere</p>',
'site' => 'https://devmoodle.koeniz-lerbermatt.ch',
'author' => 'IT Services',
'moodleversion' => '2011033003.03',
'moodlerelease' => '2.0.3+ (Build: 20110525)',
'timecreated' => 1306933186,
)]
Stack trace:
- line 394 of /lib/dml/moodle_database.php: dml_write_exception thrown
- line 232 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end()
- line 781 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
- line 833 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->insert_record_raw()
- line 73 of /blocks/admin_presets/lib/admin_presets_export.class.php: call to pgsql_native_moodle_database->insert_record()
- line 54 of /blocks/admin_presets/index.php: call to admin_presets_export->execute()