[Koha-bugs] [Bug 11390] DBIx::Class schema deployment script

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11390 David Cook changed: What|Removed |Added Resolution|--- |WISHLIST

[Koha-bugs] [Bug 11390] DBIx::Class schema deployment script

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11390 Tom Misilo changed: What|Removed |Added CC|

[Koha-bugs] [Bug 11390] DBIx::Class schema deployment script

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11390 --- Comment #15 from David Cook --- Created attachment 42504 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=42504=edit Latest work -- You are receiving this mail because: You are watching

[Koha-bugs] [Bug 11390] DBIx::Class schema deployment script

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11390 --- Comment #14 from David Cook --- Created attachment 42503 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=42503=edit Wind this back... these are experiments for using DBIC schema control

[Koha-bugs] [Bug 11390] DBIx::Class schema deployment script

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11390 --- Comment #13 from David Cook --- If you want to reproduce the issues I was having exactly, I suggest checking out commit 85c25c619f8684f99c80fe6cf6a5c4885e903b5a (Bug 9165: (Followup) Tidied code

[Koha-bugs] [Bug 11390] DBIx::Class schema deployment script

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11390 Olli-Antti Kivilahti changed: What|Removed |Added CC|

[Koha-bugs] [Bug 11390] DBIx::Class schema deployment script

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11390 --- Comment #9 from David Cook dc...@prosentient.com.au --- (In reply to David Cook from comment #8) 10) DBIC wasn't able to create tables DBD::mysql::db do failed: Can't create table 'kohadev38.items_search_fields' (errno: 150)

[Koha-bugs] [Bug 11390] DBIx::Class schema deployment script

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11390 David Cook dc...@prosentient.com.au changed: What|Removed |Added See Also|

[Koha-bugs] [Bug 11390] DBIx::Class schema deployment script

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11390 David Cook dc...@prosentient.com.au changed: What|Removed |Added See Also|

[Koha-bugs] [Bug 11390] DBIx::Class schema deployment script

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11390 --- Comment #10 from David Cook dc...@prosentient.com.au --- I've summarized all the problems I've encountered on the wiki: http://wiki.koha-community.org/wiki/DB_schema_bugs#Koha_DBIx::Class_Problems I'll probably still post to

[Koha-bugs] [Bug 11390] DBIx::Class schema deployment script

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11390 --- Comment #11 from David Cook dc...@prosentient.com.au --- Updated the wiki a lot... http://wiki.koha-community.org/wiki/DB_schema_bugs#Koha_DBIx::Class_Problems Found some solutions, but I think we need to stop using

[Koha-bugs] [Bug 11390] DBIx::Class schema deployment script

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11390 --- Comment #8 from David Cook dc...@prosentient.com.au --- So I finally am running some diffs between clean installs from the web installer and the dbic deploy. There are a lot of differences... ( DBRev 3.17.00.055 a couple tweaks

[Koha-bugs] [Bug 11390] DBIx::Class schema deployment script

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11390 M. de Rooy m.de.r...@rijksmuseum.nl changed: What|Removed |Added See Also|

[Koha-bugs] [Bug 11390] DBIx::Class schema deployment script

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11390 --- Comment #6 from David Cook dc...@prosentient.com.au --- Muahaha. I've solved the timestamp issue. I ran the following SQL: SELECT * FROM information_schema.`COLUMNS` where TABLE_SCHEMA = 'kohadev' and DATA_TYPE = 'timestamp'; I

[Koha-bugs] [Bug 11390] DBIx::Class schema deployment script

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11390 --- Comment #7 from David Cook dc...@prosentient.com.au --- So I've solved the issue of the timestamp, the varchar being turned into text... I think I know why the DROP INDEXES are in there... but I'm not sure how to fix that except

[Koha-bugs] [Bug 11390] DBIx::Class schema deployment script

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11390 David Cook dc...@prosentient.com.au changed: What|Removed |Added CC|

[Koha-bugs] [Bug 11390] DBIx::Class schema deployment script

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11390 --- Comment #3 from David Cook dc...@prosentient.com.au --- I did think about this... deploying a DBIC schema to a database and doing a MySQL dump to get the structure of the deployed database. Probably also do a MySQL dump of a

[Koha-bugs] [Bug 11390] DBIx::Class schema deployment script

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11390 --- Comment #4 from David Cook dc...@prosentient.com.au --- (In reply to David Cook from comment #3) I did think about this... deploying a DBIC schema to a database and doing a MySQL dump to get the structure of the deployed

[Koha-bugs] [Bug 11390] DBIx::Class schema deployment script

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11390 --- Comment #5 from David Cook dc...@prosentient.com.au --- I've solved the ALTER TABLE marc_subfield_structure CHANGE COLUMN seealso seealso text NULL; issue. It turns out that you need to pass your MySQL version manually through

[Koha-bugs] [Bug 11390] DBIx::Class schema deployment script

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11390 M. de Rooy m.de.r...@rijksmuseum.nl changed: What|Removed |Added CC|

[Koha-bugs] [Bug 11390] DBIx::Class schema deployment script

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11390 Magnus Enger mag...@enger.priv.no changed: What|Removed |Added CC|

[Koha-bugs] [Bug 11390] DBIx::Class schema deployment script

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11390 --- Comment #1 from Galen Charlton gmcha...@gmail.com --- WIP can be found on the following Git branch: http://git.librarypolice.com/?p=koha-galen.git;a=shortlog;h=refs/heads/pg/bug11390_db_deploy_script -- You are receiving this