https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23073
--- Comment #9 from Thomas Dukleth <[email protected]> --- Database migration is working without any Python or MySQL errors in my current current revisions to Philipp Spitzer's Postgres to MySQL conversion script, http://www.winterrodeln.org/trac/browser/servermediawiki/trunk/pgsqltomysql/pgsqltomysql.py . There are still some 'data truncated' warnings for some columns which I working through to correct for issues such as whether default values should be NULL, '', or 0. The "psycopg2.ProgrammingError: column Host does not exist" error for non-existent column Host when retrieving database values from Python was not related to any lack of quotation for SQL statements in the original script from Philipp Spitzer. Lack of quotation may be a concern especially for string values in the input data which I have endeavoured to correct to the extent permitted by the data structure required by the Python module MySQLdb. However, if the data values could be trusted, avoiding string quotation had avoided some "data truncated" warnings. Lack of database constraint which I subsequently added, had led to the SQL statement for collecting column names for each wiki database table as reported in information_schema.COLUMNS mistakenly collecting columns from some MySQL system user table when collecting column names for the wiki user table. Evidently at the time the script was originally written, a MySQL system user table was not an issue or the database constraint in the MySQLdb connection was sufficient. -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
