[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 #8 from Thomas Dukleth <td-koha-bugs at agogme.com> ---
>From printing variables, I seem to have confirmed that the problem with the
Postgres to MySQL conversion script is failure to use proper quotation of the
data and/or SQL statement as a whole,
http://www.winterrodeln.org/trac/browser/servermediawiki/trunk/pgsqltomysql/pgsqltomysql.py
.  It had been evident at glance that quoting had been originally considered
for column names.  Nothing seems to be magically quoting the data so the
originator of the script presumably had some well trusted content.

Consequently, I seem to need to escape any quotes within the column data; quote
the data from each column; possibly avoid quoting numeric values to avoid a
data type problem; and possibly quote the entire SQL statement.

-- 
You are receiving this mail because:
You are watching all bug changes.