[Koha-bugs] [Bug 23073] wiki.koha-community.org needs updating to a later version

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23073

--- Comment #9 from Thomas Dukleth <td-koha-bugs at agogme.com> ---
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.