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

--- Comment #7 from Thomas Dukleth <[email protected]> ---
I successfully changed variables and added some additional conditions to avoid
NULL values as necessary from the original form of the Postgres to MySQL
conversion script,
http://www.winterrodeln.org/trac/browser/servermediawiki/trunk/pgsqltomysql/pgsqltomysql.py
.  I also added the Postgres schema for the wiki which is "mediawiki", the same
as the database name in the case of the Koha Wiki, and not the "public" schema.

I should now be reporting that it takes X minutes to run a script to convert
the wiki database on my test system, however, there is an error similar to what
was found to be SQL statement quotation or comma separation problem addressed
at
https://stackoverflow.com/questions/41475309/psycopg-error-column-does-not-exist
and
https://stackoverflow.com/questions/41804213/psycopg2-programmingerror-column-your-name-does-not-exist
.

I am printing the generated SQL statements to try to trace the problem.  I may
try using the generated SQL statements directly with suggested quotation to
avoid problems where the SQL statements as stored in a variable elude what may
be needed quotation.

-- 
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/

Reply via email to