From skushner@mplmain.mtpl.org Tue Mar 25 16:44:42 2014 From: Scott Kushner To: koha-devel@lists.koha-community.org Subject: [Koha-devel] Update database error on Koha install Date: Tue, 25 Mar 2014 15:38:07 +0000 Message-ID: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============9217388809529524100==" --===============9217388809529524100== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Hello all, Does anyone know how to get around this? It seems that I'm stuck in a loop wi= th the installer and cannot get out! Any help would be appreciated. Thanks, Scott Kushner Middletown Library Update report : * Status: 500 * Content-type: text/html * *

Software error:

* 
DBD::mysql::db do failed: Error on rename of './koha/patronima=
ge' to './koha/#sql2-6d9-4d4' (errno: 152) at /home/koha/kohaclone/installer/=
data/mysql/updatedatabase.pl line 7243.
*
*

* For help, please send mail to the webmaster (webmaster@mtplbywaterkoha), giving this error mess= age * and the time and date of the error. * *

Update errors : * [Tue Mar 25 03:06:12 2014] updatedatabase.pl: DBD::mysql::db do fai= led: Duplicate column name 'borrowernumber' at /home/koha/kohaclone/installer= /data/mysql/updatedatabase.pl line 7224. * [Tue Mar 25 03:06:12 2014] updatedatabase.pl: DBD::mysql::db do fai= led: Error on rename of './koha/patronimage' to './koha/#sql2-6d9-4d4' (errno= : 152) at /home/koha/kohaclone/installer/data/mysql/updatedatabase.pl line 72= 43. * [Tue Mar 25 03:06:12 2014] updatedatabase.pl: DBD::mysql::db do fai= led: Error on rename of './koha/patronimage' to './koha/#sql2-6d9-4d4' (errno= : 152) at /home/koha/kohaclone/installer/data/mysql/updatedatabase.pl line 72= 43. --===============9217388809529524100== Content-Type: text/html Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="attachment.html" MIME-Version: 1.0 PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVy bjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6dz0idXJuOnNjaGVt YXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6d29yZCIgeG1sbnM6bT0iaHR0cDovL3NjaGVtYXMubWlj cm9zb2Z0LmNvbS9vZmZpY2UvMjAwNC8xMi9vbW1sIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcv VFIvUkVDLWh0bWw0MCI+PGhlYWQ+PE1FVEEgSFRUUC1FUVVJVj0iQ29udGVudC1UeXBlIiBDT05U RU5UPSJ0ZXh0L2h0bWw7IGNoYXJzZXQ9dXMtYXNjaWkiPjxtZXRhIG5hbWU9R2VuZXJhdG9yIGNv bnRlbnQ9Ik1pY3Jvc29mdCBXb3JkIDE0IChmaWx0ZXJlZCBtZWRpdW0pIj48c3R5bGU+PCEtLQov KiBGb250IERlZmluaXRpb25zICovCkBmb250LWZhY2UKCXtmb250LWZhbWlseTpXaW5nZGluZ3M7 CglwYW5vc2UtMTo1IDAgMCAwIDAgMCAwIDAgMCAwO30KQGZvbnQtZmFjZQoJe2ZvbnQtZmFtaWx5 OldpbmdkaW5nczsKCXBhbm9zZS0xOjUgMCAwIDAgMCAwIDAgMCAwIDA7fQpAZm9udC1mYWNlCgl7 Zm9udC1mYW1pbHk6Q2FsaWJyaTsKCXBhbm9zZS0xOjIgMTUgNSAyIDIgMiA0IDMgMiA0O30KQGZv bnQtZmFjZQoJe2ZvbnQtZmFtaWx5Okdlb3JnaWE7CglwYW5vc2UtMToyIDQgNSAyIDUgNCA1IDIg MyAzO30KLyogU3R5bGUgRGVmaW5pdGlvbnMgKi8KcC5Nc29Ob3JtYWwsIGxpLk1zb05vcm1hbCwg ZGl2Lk1zb05vcm1hbAoJe21hcmdpbjowaW47CgltYXJnaW4tYm90dG9tOi4wMDAxcHQ7Cglmb250 LXNpemU6MTEuMHB0OwoJZm9udC1mYW1pbHk6IkNhbGlicmkiLCJzYW5zLXNlcmlmIjt9CmE6bGlu aywgc3Bhbi5Nc29IeXBlcmxpbmsKCXttc28tc3R5bGUtcHJpb3JpdHk6OTk7Cgljb2xvcjpibHVl OwoJdGV4dC1kZWNvcmF0aW9uOnVuZGVybGluZTt9CmE6dmlzaXRlZCwgc3Bhbi5Nc29IeXBlcmxp bmtGb2xsb3dlZAoJe21zby1zdHlsZS1wcmlvcml0eTo5OTsKCWNvbG9yOnB1cnBsZTsKCXRleHQt ZGVjb3JhdGlvbjp1bmRlcmxpbmU7fQpzcGFuLkVtYWlsU3R5bGUxNwoJe21zby1zdHlsZS10eXBl OnBlcnNvbmFsLWNvbXBvc2U7Cglmb250LWZhbWlseToiQ2FsaWJyaSIsInNhbnMtc2VyaWYiOwoJ Y29sb3I6d2luZG93dGV4dDt9Ci5Nc29DaHBEZWZhdWx0Cgl7bXNvLXN0eWxlLXR5cGU6ZXhwb3J0 LW9ubHk7Cglmb250LWZhbWlseToiQ2FsaWJyaSIsInNhbnMtc2VyaWYiO30KQHBhZ2UgV29yZFNl Y3Rpb24xCgl7c2l6ZTo4LjVpbiAxMS4waW47CgltYXJnaW46MS4waW4gMS4waW4gMS4waW4gMS4w aW47fQpkaXYuV29yZFNlY3Rpb24xCgl7cGFnZTpXb3JkU2VjdGlvbjE7fQovKiBMaXN0IERlZmlu aXRpb25zICovCkBsaXN0IGwwCgl7bXNvLWxpc3QtaWQ6NjYyNzgyNjI2OwoJbXNvLWxpc3QtdGVt cGxhdGUtaWRzOi0zNTU5NTg1MzQ7fQpAbGlzdCBsMDpsZXZlbDEKCXttc28tbGV2ZWwtbnVtYmVy LWZvcm1hdDpidWxsZXQ7Cgltc28tbGV2ZWwtdGV4dDpcRjBCNzsKCW1zby1sZXZlbC10YWItc3Rv cDouNWluOwoJbXNvLWxldmVsLW51bWJlci1wb3NpdGlvbjpsZWZ0OwoJdGV4dC1pbmRlbnQ6LS4y NWluOwoJbXNvLWFuc2ktZm9udC1zaXplOjEwLjBwdDsKCWZvbnQtZmFtaWx5OlN5bWJvbDt9CkBs aXN0IGwwOmxldmVsMgoJe21zby1sZXZlbC1udW1iZXItZm9ybWF0OmJ1bGxldDsKCW1zby1sZXZl bC10ZXh0Om87Cgltc28tbGV2ZWwtdGFiLXN0b3A6MS4waW47Cgltc28tbGV2ZWwtbnVtYmVyLXBv c2l0aW9uOmxlZnQ7Cgl0ZXh0LWluZGVudDotLjI1aW47Cgltc28tYW5zaS1mb250LXNpemU6MTAu MHB0OwoJZm9udC1mYW1pbHk6IkNvdXJpZXIgTmV3IjsKCW1zby1iaWRpLWZvbnQtZmFtaWx5OiJU aW1lcyBOZXcgUm9tYW4iO30KQGxpc3QgbDA6bGV2ZWwzCgl7bXNvLWxldmVsLW51bWJlci1mb3Jt YXQ6YnVsbGV0OwoJbXNvLWxldmVsLXRleHQ6XEYwQTc7Cgltc28tbGV2ZWwtdGFiLXN0b3A6MS41 aW47Cgltc28tbGV2ZWwtbnVtYmVyLXBvc2l0aW9uOmxlZnQ7Cgl0ZXh0LWluZGVudDotLjI1aW47 Cgltc28tYW5zaS1mb250LXNpemU6MTAuMHB0OwoJZm9udC1mYW1pbHk6V2luZ2RpbmdzO30KQGxp c3QgbDA6bGV2ZWw0Cgl7bXNvLWxldmVsLW51bWJlci1mb3JtYXQ6YnVsbGV0OwoJbXNvLWxldmVs LXRleHQ6XEYwQTc7Cgltc28tbGV2ZWwtdGFiLXN0b3A6Mi4waW47Cgltc28tbGV2ZWwtbnVtYmVy LXBvc2l0aW9uOmxlZnQ7Cgl0ZXh0LWluZGVudDotLjI1aW47Cgltc28tYW5zaS1mb250LXNpemU6 MTAuMHB0OwoJZm9udC1mYW1pbHk6V2luZ2RpbmdzO30KQGxpc3QgbDA6bGV2ZWw1Cgl7bXNvLWxl dmVsLW51bWJlci1mb3JtYXQ6YnVsbGV0OwoJbXNvLWxldmVsLXRleHQ6XEYwQTc7Cgltc28tbGV2 ZWwtdGFiLXN0b3A6Mi41aW47Cgltc28tbGV2ZWwtbnVtYmVyLXBvc2l0aW9uOmxlZnQ7Cgl0ZXh0 LWluZGVudDotLjI1aW47Cgltc28tYW5zaS1mb250LXNpemU6MTAuMHB0OwoJZm9udC1mYW1pbHk6 V2luZ2RpbmdzO30KQGxpc3QgbDA6bGV2ZWw2Cgl7bXNvLWxldmVsLW51bWJlci1mb3JtYXQ6YnVs bGV0OwoJbXNvLWxldmVsLXRleHQ6XEYwQTc7Cgltc28tbGV2ZWwtdGFiLXN0b3A6My4waW47Cglt c28tbGV2ZWwtbnVtYmVyLXBvc2l0aW9uOmxlZnQ7Cgl0ZXh0LWluZGVudDotLjI1aW47Cgltc28t YW5zaS1mb250LXNpemU6MTAuMHB0OwoJZm9udC1mYW1pbHk6V2luZ2RpbmdzO30KQGxpc3QgbDA6 bGV2ZWw3Cgl7bXNvLWxldmVsLW51bWJlci1mb3JtYXQ6YnVsbGV0OwoJbXNvLWxldmVsLXRleHQ6 XEYwQTc7Cgltc28tbGV2ZWwtdGFiLXN0b3A6My41aW47Cgltc28tbGV2ZWwtbnVtYmVyLXBvc2l0 aW9uOmxlZnQ7Cgl0ZXh0LWluZGVudDotLjI1aW47Cgltc28tYW5zaS1mb250LXNpemU6MTAuMHB0 OwoJZm9udC1mYW1pbHk6V2luZ2RpbmdzO30KQGxpc3QgbDA6bGV2ZWw4Cgl7bXNvLWxldmVsLW51 bWJlci1mb3JtYXQ6YnVsbGV0OwoJbXNvLWxldmVsLXRleHQ6XEYwQTc7Cgltc28tbGV2ZWwtdGFi LXN0b3A6NC4waW47Cgltc28tbGV2ZWwtbnVtYmVyLXBvc2l0aW9uOmxlZnQ7Cgl0ZXh0LWluZGVu dDotLjI1aW47Cgltc28tYW5zaS1mb250LXNpemU6MTAuMHB0OwoJZm9udC1mYW1pbHk6V2luZ2Rp bmdzO30KQGxpc3QgbDA6bGV2ZWw5Cgl7bXNvLWxldmVsLW51bWJlci1mb3JtYXQ6YnVsbGV0OwoJ bXNvLWxldmVsLXRleHQ6XEYwQTc7Cgltc28tbGV2ZWwtdGFiLXN0b3A6NC41aW47Cgltc28tbGV2 ZWwtbnVtYmVyLXBvc2l0aW9uOmxlZnQ7Cgl0ZXh0LWluZGVudDotLjI1aW47Cgltc28tYW5zaS1m b250LXNpemU6MTAuMHB0OwoJZm9udC1mYW1pbHk6V2luZ2RpbmdzO30KQGxpc3QgbDEKCXttc28t bGlzdC1pZDo5MDA1NTgwNTY7Cgltc28tbGlzdC10ZW1wbGF0ZS1pZHM6LTE2ODY0ODcwMDg7fQpA bGlzdCBsMTpsZXZlbDEKCXttc28tbGV2ZWwtbnVtYmVyLWZvcm1hdDpidWxsZXQ7Cgltc28tbGV2 ZWwtdGV4dDpcRjBCNzsKCW1zby1sZXZlbC10YWItc3RvcDouNWluOwoJbXNvLWxldmVsLW51bWJl ci1wb3NpdGlvbjpsZWZ0OwoJdGV4dC1pbmRlbnQ6LS4yNWluOwoJbXNvLWFuc2ktZm9udC1zaXpl OjEwLjBwdDsKCWZvbnQtZmFtaWx5OlN5bWJvbDt9CkBsaXN0IGwxOmxldmVsMgoJe21zby1sZXZl bC1udW1iZXItZm9ybWF0OmJ1bGxldDsKCW1zby1sZXZlbC10ZXh0Om87Cgltc28tbGV2ZWwtdGFi LXN0b3A6MS4waW47Cgltc28tbGV2ZWwtbnVtYmVyLXBvc2l0aW9uOmxlZnQ7Cgl0ZXh0LWluZGVu dDotLjI1aW47Cgltc28tYW5zaS1mb250LXNpemU6MTAuMHB0OwoJZm9udC1mYW1pbHk6IkNvdXJp ZXIgTmV3IjsKCW1zby1iaWRpLWZvbnQtZmFtaWx5OiJUaW1lcyBOZXcgUm9tYW4iO30KQGxpc3Qg bDE6bGV2ZWwzCgl7bXNvLWxldmVsLW51bWJlci1mb3JtYXQ6YnVsbGV0OwoJbXNvLWxldmVsLXRl eHQ6XEYwQTc7Cgltc28tbGV2ZWwtdGFiLXN0b3A6MS41aW47Cgltc28tbGV2ZWwtbnVtYmVyLXBv c2l0aW9uOmxlZnQ7Cgl0ZXh0LWluZGVudDotLjI1aW47Cgltc28tYW5zaS1mb250LXNpemU6MTAu MHB0OwoJZm9udC1mYW1pbHk6V2luZ2RpbmdzO30KQGxpc3QgbDE6bGV2ZWw0Cgl7bXNvLWxldmVs LW51bWJlci1mb3JtYXQ6YnVsbGV0OwoJbXNvLWxldmVsLXRleHQ6XEYwQTc7Cgltc28tbGV2ZWwt dGFiLXN0b3A6Mi4waW47Cgltc28tbGV2ZWwtbnVtYmVyLXBvc2l0aW9uOmxlZnQ7Cgl0ZXh0LWlu ZGVudDotLjI1aW47Cgltc28tYW5zaS1mb250LXNpemU6MTAuMHB0OwoJZm9udC1mYW1pbHk6V2lu Z2RpbmdzO30KQGxpc3QgbDE6bGV2ZWw1Cgl7bXNvLWxldmVsLW51bWJlci1mb3JtYXQ6YnVsbGV0 OwoJbXNvLWxldmVsLXRleHQ6XEYwQTc7Cgltc28tbGV2ZWwtdGFiLXN0b3A6Mi41aW47Cgltc28t bGV2ZWwtbnVtYmVyLXBvc2l0aW9uOmxlZnQ7Cgl0ZXh0LWluZGVudDotLjI1aW47Cgltc28tYW5z aS1mb250LXNpemU6MTAuMHB0OwoJZm9udC1mYW1pbHk6V2luZ2RpbmdzO30KQGxpc3QgbDE6bGV2 ZWw2Cgl7bXNvLWxldmVsLW51bWJlci1mb3JtYXQ6YnVsbGV0OwoJbXNvLWxldmVsLXRleHQ6XEYw QTc7Cgltc28tbGV2ZWwtdGFiLXN0b3A6My4waW47Cgltc28tbGV2ZWwtbnVtYmVyLXBvc2l0aW9u OmxlZnQ7Cgl0ZXh0LWluZGVudDotLjI1aW47Cgltc28tYW5zaS1mb250LXNpemU6MTAuMHB0OwoJ Zm9udC1mYW1pbHk6V2luZ2RpbmdzO30KQGxpc3QgbDE6bGV2ZWw3Cgl7bXNvLWxldmVsLW51bWJl ci1mb3JtYXQ6YnVsbGV0OwoJbXNvLWxldmVsLXRleHQ6XEYwQTc7Cgltc28tbGV2ZWwtdGFiLXN0 b3A6My41aW47Cgltc28tbGV2ZWwtbnVtYmVyLXBvc2l0aW9uOmxlZnQ7Cgl0ZXh0LWluZGVudDot LjI1aW47Cgltc28tYW5zaS1mb250LXNpemU6MTAuMHB0OwoJZm9udC1mYW1pbHk6V2luZ2Rpbmdz O30KQGxpc3QgbDE6bGV2ZWw4Cgl7bXNvLWxldmVsLW51bWJlci1mb3JtYXQ6YnVsbGV0OwoJbXNv LWxldmVsLXRleHQ6XEYwQTc7Cgltc28tbGV2ZWwtdGFiLXN0b3A6NC4waW47Cgltc28tbGV2ZWwt bnVtYmVyLXBvc2l0aW9uOmxlZnQ7Cgl0ZXh0LWluZGVudDotLjI1aW47Cgltc28tYW5zaS1mb250 LXNpemU6MTAuMHB0OwoJZm9udC1mYW1pbHk6V2luZ2RpbmdzO30KQGxpc3QgbDE6bGV2ZWw5Cgl7 bXNvLWxldmVsLW51bWJlci1mb3JtYXQ6YnVsbGV0OwoJbXNvLWxldmVsLXRleHQ6XEYwQTc7Cglt c28tbGV2ZWwtdGFiLXN0b3A6NC41aW47Cgltc28tbGV2ZWwtbnVtYmVyLXBvc2l0aW9uOmxlZnQ7 Cgl0ZXh0LWluZGVudDotLjI1aW47Cgltc28tYW5zaS1mb250LXNpemU6MTAuMHB0OwoJZm9udC1m YW1pbHk6V2luZ2RpbmdzO30Kb2wKCXttYXJnaW4tYm90dG9tOjBpbjt9CnVsCgl7bWFyZ2luLWJv dHRvbTowaW47fQotLT48L3N0eWxlPjwhLS1baWYgZ3RlIG1zbyA5XT48eG1sPgo8bzpzaGFwZWRl ZmF1bHRzIHY6ZXh0PSJlZGl0IiBzcGlkbWF4PSIxMDI2IiAvPgo8L3htbD48IVtlbmRpZl0tLT48 IS0tW2lmIGd0ZSBtc28gOV0+PHhtbD4KPG86c2hhcGVsYXlvdXQgdjpleHQ9ImVkaXQiPgo8bzpp ZG1hcCB2OmV4dD0iZWRpdCIgZGF0YT0iMSIgLz4KPC9vOnNoYXBlbGF5b3V0PjwveG1sPjwhW2Vu ZGlmXS0tPjwvaGVhZD48Ym9keSBsYW5nPUVOLVVTIGxpbms9Ymx1ZSB2bGluaz1wdXJwbGU+PGRp diBjbGFzcz1Xb3JkU2VjdGlvbjE+PHAgY2xhc3M9TXNvTm9ybWFsIHN0eWxlPSdtc28tbWFyZ2lu LXRvcC1hbHQ6YXV0bzttc28tbWFyZ2luLWJvdHRvbS1hbHQ6YXV0bztsaW5lLWhlaWdodDoxNDAl Jz48c3BhbiBsYW5nPUVOIHN0eWxlPSdmb250LXNpemU6MTIuMHB0O2xpbmUtaGVpZ2h0OjE0MCU7 Zm9udC1mYW1pbHk6Ikdlb3JnaWEiLCJzZXJpZiI7Y29sb3I6YmxhY2snPkhlbGxvIGFsbCwgPG86 cD48L286cD48L3NwYW4+PC9wPjxwIGNsYXNzPU1zb05vcm1hbCBzdHlsZT0nbXNvLW1hcmdpbi10 b3AtYWx0OmF1dG87bXNvLW1hcmdpbi1ib3R0b20tYWx0OmF1dG87bGluZS1oZWlnaHQ6MTQwJSc+ PHNwYW4gbGFuZz1FTiBzdHlsZT0nZm9udC1zaXplOjEyLjBwdDtsaW5lLWhlaWdodDoxNDAlO2Zv bnQtZmFtaWx5OiJHZW9yZ2lhIiwic2VyaWYiO2NvbG9yOmJsYWNrJz5Eb2VzIGFueW9uZSBrbm93 IGhvdyB0byBnZXQgYXJvdW5kIHRoaXM/IEl0IHNlZW1zIHRoYXQgSSYjODIxNzttIHN0dWNrIGlu IGEgbG9vcCB3aXRoIHRoZSBpbnN0YWxsZXIgYW5kIGNhbm5vdCBnZXQgb3V0ITxvOnA+PC9vOnA+ PC9zcGFuPjwvcD48cCBjbGFzcz1Nc29Ob3JtYWwgc3R5bGU9J21zby1tYXJnaW4tdG9wLWFsdDph dXRvO21zby1tYXJnaW4tYm90dG9tLWFsdDphdXRvO2xpbmUtaGVpZ2h0OjE0MCUnPjxzcGFuIGxh bmc9RU4gc3R5bGU9J2ZvbnQtc2l6ZToxMi4wcHQ7bGluZS1oZWlnaHQ6MTQwJTtmb250LWZhbWls eToiR2VvcmdpYSIsInNlcmlmIjtjb2xvcjpibGFjayc+QW55IGhlbHAgd291bGQgYmUgYXBwcmVj aWF0ZWQuIDxvOnA+PC9vOnA+PC9zcGFuPjwvcD48cCBjbGFzcz1Nc29Ob3JtYWwgc3R5bGU9J21z by1tYXJnaW4tdG9wLWFsdDphdXRvO21zby1tYXJnaW4tYm90dG9tLWFsdDphdXRvO2xpbmUtaGVp Z2h0OjE0MCUnPjxzcGFuIGxhbmc9RU4gc3R5bGU9J2ZvbnQtc2l6ZToxMi4wcHQ7bGluZS1oZWln aHQ6MTQwJTtmb250LWZhbWlseToiR2VvcmdpYSIsInNlcmlmIjtjb2xvcjpibGFjayc+VGhhbmtz LCA8bzpwPjwvbzpwPjwvc3Bhbj48L3A+PHAgY2xhc3M9TXNvTm9ybWFsIHN0eWxlPSdtc28tbWFy Z2luLXRvcC1hbHQ6YXV0bzttc28tbWFyZ2luLWJvdHRvbS1hbHQ6YXV0bztsaW5lLWhlaWdodDox NDAlJz48c3BhbiBsYW5nPUVOIHN0eWxlPSdmb250LXNpemU6MTIuMHB0O2xpbmUtaGVpZ2h0OjE0 MCU7Zm9udC1mYW1pbHk6Ikdlb3JnaWEiLCJzZXJpZiI7Y29sb3I6YmxhY2snPlNjb3R0IEt1c2hu ZXI8bzpwPjwvbzpwPjwvc3Bhbj48L3A+PHAgY2xhc3M9TXNvTm9ybWFsIHN0eWxlPSdtc28tbWFy Z2luLXRvcC1hbHQ6YXV0bzttc28tbWFyZ2luLWJvdHRvbS1hbHQ6YXV0bztsaW5lLWhlaWdodDox NDAlJz48c3BhbiBsYW5nPUVOIHN0eWxlPSdmb250LXNpemU6MTIuMHB0O2xpbmUtaGVpZ2h0OjE0 MCU7Zm9udC1mYW1pbHk6Ikdlb3JnaWEiLCJzZXJpZiI7Y29sb3I6YmxhY2snPk1pZGRsZXRvd24g TGlicmFyeTxvOnA+PC9vOnA+PC9zcGFuPjwvcD48cCBjbGFzcz1Nc29Ob3JtYWwgc3R5bGU9J21z by1tYXJnaW4tdG9wLWFsdDphdXRvO21zby1tYXJnaW4tYm90dG9tLWFsdDphdXRvO2xpbmUtaGVp Z2h0OjE0MCUnPjxzcGFuIGxhbmc9RU4gc3R5bGU9J2ZvbnQtc2l6ZToxMi4wcHQ7bGluZS1oZWln aHQ6MTQwJTtmb250LWZhbWlseToiR2VvcmdpYSIsInNlcmlmIjtjb2xvcjpibGFjayc+PG86cD4m bmJzcDs8L286cD48L3NwYW4+PC9wPjxwIGNsYXNzPU1zb05vcm1hbCBzdHlsZT0nbXNvLW1hcmdp bi10b3AtYWx0OmF1dG87bXNvLW1hcmdpbi1ib3R0b20tYWx0OmF1dG87bGluZS1oZWlnaHQ6MTQw JSc+PHNwYW4gbGFuZz1FTiBzdHlsZT0nZm9udC1zaXplOjEyLjBwdDtsaW5lLWhlaWdodDoxNDAl O2ZvbnQtZmFtaWx5OiJHZW9yZ2lhIiwic2VyaWYiO2NvbG9yOmJsYWNrJz5VcGRhdGUgcmVwb3J0 IDo8bzpwPjwvbzpwPjwvc3Bhbj48L3A+PHAgY2xhc3M9TXNvTm9ybWFsIHN0eWxlPSdtc28tbWFy Z2luLXRvcC1hbHQ6YXV0bzttc28tbWFyZ2luLWJvdHRvbS1hbHQ6YXV0bzttYXJnaW4tbGVmdDoz Ny4wcHQ7dGV4dC1pbmRlbnQ6LS4yNWluO2xpbmUtaGVpZ2h0OjE0MCU7bXNvLWxpc3Q6bDAgbGV2 ZWwxIGxmbzEnPjwhW2lmICFzdXBwb3J0TGlzdHNdPjxzcGFuIGxhbmc9RU4gc3R5bGU9J2ZvbnQt c2l6ZToxMC4wcHQ7bGluZS1oZWlnaHQ6MTQwJTtmb250LWZhbWlseTpTeW1ib2w7Y29sb3I6Ymxh Y2snPjxzcGFuIHN0eWxlPSdtc28tbGlzdDpJZ25vcmUnPiZtaWRkb3Q7PHNwYW4gc3R5bGU9J2Zv bnQ6Ny4wcHQgIlRpbWVzIE5ldyBSb21hbiInPiZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNw OyZuYnNwOyZuYnNwOyZuYnNwOyA8L3NwYW4+PC9zcGFuPjwvc3Bhbj48IVtlbmRpZl0+PHNwYW4g bGFuZz1FTiBzdHlsZT0nZm9udC1zaXplOjEyLjBwdDtsaW5lLWhlaWdodDoxNDAlO2ZvbnQtZmFt aWx5OiJHZW9yZ2lhIiwic2VyaWYiO2NvbG9yOmJsYWNrJz5TdGF0dXM6IDUwMDxvOnA+PC9vOnA+ PC9zcGFuPjwvcD48cCBjbGFzcz1Nc29Ob3JtYWwgc3R5bGU9J21zby1tYXJnaW4tdG9wLWFsdDph dXRvO21zby1tYXJnaW4tYm90dG9tLWFsdDphdXRvO21hcmdpbi1sZWZ0OjM3LjBwdDt0ZXh0LWlu ZGVudDotLjI1aW47bGluZS1oZWlnaHQ6MTQwJTttc28tbGlzdDpsMCBsZXZlbDEgbGZvMSc+PCFb aWYgIXN1cHBvcnRMaXN0c10+PHNwYW4gbGFuZz1FTiBzdHlsZT0nZm9udC1zaXplOjEwLjBwdDts aW5lLWhlaWdodDoxNDAlO2ZvbnQtZmFtaWx5OlN5bWJvbDtjb2xvcjpibGFjayc+PHNwYW4gc3R5 bGU9J21zby1saXN0Oklnbm9yZSc+Jm1pZGRvdDs8c3BhbiBzdHlsZT0nZm9udDo3LjBwdCAiVGlt ZXMgTmV3IFJvbWFuIic+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7 Jm5ic3A7IDwvc3Bhbj48L3NwYW4+PC9zcGFuPjwhW2VuZGlmXT48c3BhbiBsYW5nPUVOIHN0eWxl PSdmb250LXNpemU6MTIuMHB0O2xpbmUtaGVpZ2h0OjE0MCU7Zm9udC1mYW1pbHk6Ikdlb3JnaWEi LCJzZXJpZiI7Y29sb3I6YmxhY2snPkNvbnRlbnQtdHlwZTogdGV4dC9odG1sPG86cD48L286cD48 L3NwYW4+PC9wPjxwIGNsYXNzPU1zb05vcm1hbCBzdHlsZT0nbXNvLW1hcmdpbi10b3AtYWx0OmF1 dG87bXNvLW1hcmdpbi1ib3R0b20tYWx0OmF1dG87bWFyZ2luLWxlZnQ6MzcuMHB0O3RleHQtaW5k ZW50Oi0uMjVpbjtsaW5lLWhlaWdodDoxNDAlO21zby1saXN0OmwwIGxldmVsMSBsZm8xJz48IVtp ZiAhc3VwcG9ydExpc3RzXT48c3BhbiBsYW5nPUVOIHN0eWxlPSdmb250LXNpemU6MTAuMHB0O2xp bmUtaGVpZ2h0OjE0MCU7Zm9udC1mYW1pbHk6U3ltYm9sO2NvbG9yOmJsYWNrJz48c3BhbiBzdHls ZT0nbXNvLWxpc3Q6SWdub3JlJz4mbWlkZG90OzxzcGFuIHN0eWxlPSdmb250OjcuMHB0ICJUaW1l cyBOZXcgUm9tYW4iJz4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsm bmJzcDsgPC9zcGFuPjwvc3Bhbj48L3NwYW4+PCFbZW5kaWZdPjxzcGFuIGxhbmc9RU4gc3R5bGU9 J2ZvbnQtc2l6ZToxMi4wcHQ7bGluZS1oZWlnaHQ6MTQwJTtmb250LWZhbWlseToiR2VvcmdpYSIs InNlcmlmIjtjb2xvcjpibGFjayc+PG86cD4mbmJzcDs8L286cD48L3NwYW4+PC9wPjxwIGNsYXNz PU1zb05vcm1hbCBzdHlsZT0nbXNvLW1hcmdpbi10b3AtYWx0OmF1dG87bXNvLW1hcmdpbi1ib3R0 b20tYWx0OmF1dG87bWFyZ2luLWxlZnQ6MzcuMHB0O3RleHQtaW5kZW50Oi0uMjVpbjtsaW5lLWhl aWdodDoxNDAlO21zby1saXN0OmwwIGxldmVsMSBsZm8xJz48IVtpZiAhc3VwcG9ydExpc3RzXT48 c3BhbiBsYW5nPUVOIHN0eWxlPSdmb250LXNpemU6MTAuMHB0O2xpbmUtaGVpZ2h0OjE0MCU7Zm9u dC1mYW1pbHk6U3ltYm9sO2NvbG9yOmJsYWNrJz48c3BhbiBzdHlsZT0nbXNvLWxpc3Q6SWdub3Jl Jz4mbWlkZG90OzxzcGFuIHN0eWxlPSdmb250OjcuMHB0ICJUaW1lcyBOZXcgUm9tYW4iJz4mbmJz cDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgPC9zcGFuPjwvc3Bh bj48L3NwYW4+PCFbZW5kaWZdPjxzcGFuIGxhbmc9RU4gc3R5bGU9J2ZvbnQtc2l6ZToxMi4wcHQ7 bGluZS1oZWlnaHQ6MTQwJTtmb250LWZhbWlseToiR2VvcmdpYSIsInNlcmlmIjtjb2xvcjpibGFj ayc+Jmx0O2gxJmd0O1NvZnR3YXJlIGVycm9yOiZsdDsvaDEmZ3Q7PG86cD48L286cD48L3NwYW4+ PC9wPjxwIGNsYXNzPU1zb05vcm1hbCBzdHlsZT0nbXNvLW1hcmdpbi10b3AtYWx0OmF1dG87bXNv LW1hcmdpbi1ib3R0b20tYWx0OmF1dG87bWFyZ2luLWxlZnQ6MzcuMHB0O3RleHQtaW5kZW50Oi0u MjVpbjtsaW5lLWhlaWdodDoxNDAlO21zby1saXN0OmwwIGxldmVsMSBsZm8xJz48IVtpZiAhc3Vw cG9ydExpc3RzXT48c3BhbiBsYW5nPUVOIHN0eWxlPSdmb250LXNpemU6MTAuMHB0O2xpbmUtaGVp Z2h0OjE0MCU7Zm9udC1mYW1pbHk6U3ltYm9sO2NvbG9yOmJsYWNrJz48c3BhbiBzdHlsZT0nbXNv LWxpc3Q6SWdub3JlJz4mbWlkZG90OzxzcGFuIHN0eWxlPSdmb250OjcuMHB0ICJUaW1lcyBOZXcg Um9tYW4iJz4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsg PC9zcGFuPjwvc3Bhbj48L3NwYW4+PCFbZW5kaWZdPjxzcGFuIGxhbmc9RU4gc3R5bGU9J2ZvbnQt c2l6ZToxMi4wcHQ7bGluZS1oZWlnaHQ6MTQwJTtmb250LWZhbWlseToiR2VvcmdpYSIsInNlcmlm Ijtjb2xvcjpibGFjayc+Jmx0O3ByZSZndDtEQkQ6Om15c3FsOjpkYiBkbyBmYWlsZWQ6IEVycm9y IG9uIHJlbmFtZSBvZiAnLi9rb2hhL3BhdHJvbmltYWdlJyB0byAnLi9rb2hhLyNzcWwyLTZkOS00 ZDQnIChlcnJubzogMTUyKSBhdCAvaG9tZS9rb2hhL2tvaGFjbG9uZS9pbnN0YWxsZXIvZGF0YS9t eXNxbC91cGRhdGVkYXRhYmFzZS5wbCBsaW5lIDcyNDMuPG86cD48L286cD48L3NwYW4+PC9wPjxw IGNsYXNzPU1zb05vcm1hbCBzdHlsZT0nbXNvLW1hcmdpbi10b3AtYWx0OmF1dG87bXNvLW1hcmdp bi1ib3R0b20tYWx0OmF1dG87bWFyZ2luLWxlZnQ6MzcuMHB0O3RleHQtaW5kZW50Oi0uMjVpbjts aW5lLWhlaWdodDoxNDAlO21zby1saXN0OmwwIGxldmVsMSBsZm8xJz48IVtpZiAhc3VwcG9ydExp c3RzXT48c3BhbiBsYW5nPUVOIHN0eWxlPSdmb250LXNpemU6MTAuMHB0O2xpbmUtaGVpZ2h0OjE0 MCU7Zm9udC1mYW1pbHk6U3ltYm9sO2NvbG9yOmJsYWNrJz48c3BhbiBzdHlsZT0nbXNvLWxpc3Q6 SWdub3JlJz4mbWlkZG90OzxzcGFuIHN0eWxlPSdmb250OjcuMHB0ICJUaW1lcyBOZXcgUm9tYW4i Jz4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgPC9zcGFu Pjwvc3Bhbj48L3NwYW4+PCFbZW5kaWZdPjxzcGFuIGxhbmc9RU4gc3R5bGU9J2ZvbnQtc2l6ZTox Mi4wcHQ7bGluZS1oZWlnaHQ6MTQwJTtmb250LWZhbWlseToiR2VvcmdpYSIsInNlcmlmIjtjb2xv cjpibGFjayc+Jmx0Oy9wcmUmZ3Q7PG86cD48L286cD48L3NwYW4+PC9wPjxwIGNsYXNzPU1zb05v cm1hbCBzdHlsZT0nbXNvLW1hcmdpbi10b3AtYWx0OmF1dG87bXNvLW1hcmdpbi1ib3R0b20tYWx0 OmF1dG87bWFyZ2luLWxlZnQ6MzcuMHB0O3RleHQtaW5kZW50Oi0uMjVpbjtsaW5lLWhlaWdodDox NDAlO21zby1saXN0OmwwIGxldmVsMSBsZm8xJz48IVtpZiAhc3VwcG9ydExpc3RzXT48c3BhbiBs YW5nPUVOIHN0eWxlPSdmb250LXNpemU6MTAuMHB0O2xpbmUtaGVpZ2h0OjE0MCU7Zm9udC1mYW1p bHk6U3ltYm9sO2NvbG9yOmJsYWNrJz48c3BhbiBzdHlsZT0nbXNvLWxpc3Q6SWdub3JlJz4mbWlk ZG90OzxzcGFuIHN0eWxlPSdmb250OjcuMHB0ICJUaW1lcyBOZXcgUm9tYW4iJz4mbmJzcDsmbmJz cDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgPC9zcGFuPjwvc3Bhbj48L3Nw YW4+PCFbZW5kaWZdPjxzcGFuIGxhbmc9RU4gc3R5bGU9J2ZvbnQtc2l6ZToxMi4wcHQ7bGluZS1o ZWlnaHQ6MTQwJTtmb250LWZhbWlseToiR2VvcmdpYSIsInNlcmlmIjtjb2xvcjpibGFjayc+Jmx0 O3AmZ3Q7PG86cD48L286cD48L3NwYW4+PC9wPjxwIGNsYXNzPU1zb05vcm1hbCBzdHlsZT0nbXNv LW1hcmdpbi10b3AtYWx0OmF1dG87bXNvLW1hcmdpbi1ib3R0b20tYWx0OmF1dG87bWFyZ2luLWxl ZnQ6MzcuMHB0O3RleHQtaW5kZW50Oi0uMjVpbjtsaW5lLWhlaWdodDoxNDAlO21zby1saXN0Omww IGxldmVsMSBsZm8xJz48IVtpZiAhc3VwcG9ydExpc3RzXT48c3BhbiBsYW5nPUVOIHN0eWxlPSdm b250LXNpemU6MTAuMHB0O2xpbmUtaGVpZ2h0OjE0MCU7Zm9udC1mYW1pbHk6U3ltYm9sO2NvbG9y OmJsYWNrJz48c3BhbiBzdHlsZT0nbXNvLWxpc3Q6SWdub3JlJz4mbWlkZG90OzxzcGFuIHN0eWxl PSdmb250OjcuMHB0ICJUaW1lcyBOZXcgUm9tYW4iJz4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsm bmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgPC9zcGFuPjwvc3Bhbj48L3NwYW4+PCFbZW5kaWZdPjxz cGFuIGxhbmc9RU4gc3R5bGU9J2ZvbnQtc2l6ZToxMi4wcHQ7bGluZS1oZWlnaHQ6MTQwJTtmb250 LWZhbWlseToiR2VvcmdpYSIsInNlcmlmIjtjb2xvcjpibGFjayc+Rm9yIGhlbHAsIHBsZWFzZSBz ZW5kIG1haWwgdG8gdGhlIHdlYm1hc3RlciAoJmx0O2EgaHJlZj0mcXVvdDttYWlsdG86d2VibWFz dGVyQG10cGxieXdhdGVya29oYSZxdW90OyZndDt3ZWJtYXN0ZXJAbXRwbGJ5d2F0ZXJrb2hhJmx0 Oy9hJmd0OyksIGdpdmluZyB0aGlzIGVycm9yIG1lc3NhZ2UgPG86cD48L286cD48L3NwYW4+PC9w PjxwIGNsYXNzPU1zb05vcm1hbCBzdHlsZT0nbXNvLW1hcmdpbi10b3AtYWx0OmF1dG87bXNvLW1h cmdpbi1ib3R0b20tYWx0OmF1dG87bWFyZ2luLWxlZnQ6MzcuMHB0O3RleHQtaW5kZW50Oi0uMjVp bjtsaW5lLWhlaWdodDoxNDAlO21zby1saXN0OmwwIGxldmVsMSBsZm8xJz48IVtpZiAhc3VwcG9y dExpc3RzXT48c3BhbiBsYW5nPUVOIHN0eWxlPSdmb250LXNpemU6MTAuMHB0O2xpbmUtaGVpZ2h0 OjE0MCU7Zm9udC1mYW1pbHk6U3ltYm9sO2NvbG9yOmJsYWNrJz48c3BhbiBzdHlsZT0nbXNvLWxp c3Q6SWdub3JlJz4mbWlkZG90OzxzcGFuIHN0eWxlPSdmb250OjcuMHB0ICJUaW1lcyBOZXcgUm9t YW4iJz4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgPC9z cGFuPjwvc3Bhbj48L3NwYW4+PCFbZW5kaWZdPjxzcGFuIGxhbmc9RU4gc3R5bGU9J2ZvbnQtc2l6 ZToxMi4wcHQ7bGluZS1oZWlnaHQ6MTQwJTtmb250LWZhbWlseToiR2VvcmdpYSIsInNlcmlmIjtj b2xvcjpibGFjayc+YW5kIHRoZSB0aW1lIGFuZCBkYXRlIG9mIHRoZSBlcnJvci48bzpwPjwvbzpw Pjwvc3Bhbj48L3A+PHAgY2xhc3M9TXNvTm9ybWFsIHN0eWxlPSdtc28tbWFyZ2luLXRvcC1hbHQ6 YXV0bzttc28tbWFyZ2luLWJvdHRvbS1hbHQ6YXV0bzttYXJnaW4tbGVmdDozNy4wcHQ7dGV4dC1p bmRlbnQ6LS4yNWluO2xpbmUtaGVpZ2h0OjE0MCU7bXNvLWxpc3Q6bDAgbGV2ZWwxIGxmbzEnPjwh W2lmICFzdXBwb3J0TGlzdHNdPjxzcGFuIGxhbmc9RU4gc3R5bGU9J2ZvbnQtc2l6ZToxMC4wcHQ7 bGluZS1oZWlnaHQ6MTQwJTtmb250LWZhbWlseTpTeW1ib2w7Y29sb3I6YmxhY2snPjxzcGFuIHN0 eWxlPSdtc28tbGlzdDpJZ25vcmUnPiZtaWRkb3Q7PHNwYW4gc3R5bGU9J2ZvbnQ6Ny4wcHQgIlRp bWVzIE5ldyBSb21hbiInPiZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNw OyZuYnNwOyA8L3NwYW4+PC9zcGFuPjwvc3Bhbj48IVtlbmRpZl0+PHNwYW4gbGFuZz1FTiBzdHls ZT0nZm9udC1zaXplOjEyLjBwdDtsaW5lLWhlaWdodDoxNDAlO2ZvbnQtZmFtaWx5OiJHZW9yZ2lh Iiwic2VyaWYiO2NvbG9yOmJsYWNrJz48bzpwPiZuYnNwOzwvbzpwPjwvc3Bhbj48L3A+PHAgY2xh c3M9TXNvTm9ybWFsIHN0eWxlPSdtc28tbWFyZ2luLXRvcC1hbHQ6YXV0bzttc28tbWFyZ2luLWJv dHRvbS1hbHQ6YXV0bzttYXJnaW4tbGVmdDozNy4wcHQ7dGV4dC1pbmRlbnQ6LS4yNWluO2xpbmUt aGVpZ2h0OjE0MCU7bXNvLWxpc3Q6bDAgbGV2ZWwxIGxmbzEnPjwhW2lmICFzdXBwb3J0TGlzdHNd PjxzcGFuIGxhbmc9RU4gc3R5bGU9J2ZvbnQtc2l6ZToxMC4wcHQ7bGluZS1oZWlnaHQ6MTQwJTtm b250LWZhbWlseTpTeW1ib2w7Y29sb3I6YmxhY2snPjxzcGFuIHN0eWxlPSdtc28tbGlzdDpJZ25v cmUnPiZtaWRkb3Q7PHNwYW4gc3R5bGU9J2ZvbnQ6Ny4wcHQgIlRpbWVzIE5ldyBSb21hbiInPiZu YnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyA8L3NwYW4+PC9z cGFuPjwvc3Bhbj48IVtlbmRpZl0+PHNwYW4gbGFuZz1FTiBzdHlsZT0nZm9udC1zaXplOjEyLjBw dDtsaW5lLWhlaWdodDoxNDAlO2ZvbnQtZmFtaWx5OiJHZW9yZ2lhIiwic2VyaWYiO2NvbG9yOmJs YWNrJz4mbHQ7L3AmZ3Q7PG86cD48L286cD48L3NwYW4+PC9wPjxwIGNsYXNzPU1zb05vcm1hbCBz dHlsZT0nbXNvLW1hcmdpbi10b3AtYWx0OmF1dG87bXNvLW1hcmdpbi1ib3R0b20tYWx0OmF1dG87 bGluZS1oZWlnaHQ6MTQwJSc+PHNwYW4gbGFuZz1FTiBzdHlsZT0nZm9udC1zaXplOjEyLjBwdDts aW5lLWhlaWdodDoxNDAlO2ZvbnQtZmFtaWx5OiJHZW9yZ2lhIiwic2VyaWYiO2NvbG9yOmJsYWNr Jz5VcGRhdGUgZXJyb3JzIDo8bzpwPjwvbzpwPjwvc3Bhbj48L3A+PHAgY2xhc3M9TXNvTm9ybWFs IHN0eWxlPSdtc28tbWFyZ2luLXRvcC1hbHQ6YXV0bzttc28tbWFyZ2luLWJvdHRvbS1hbHQ6YXV0 bzttYXJnaW4tbGVmdDozNy4wcHQ7dGV4dC1pbmRlbnQ6LS4yNWluO2xpbmUtaGVpZ2h0OjE0MCU7 bXNvLWxpc3Q6bDEgbGV2ZWwxIGxmbzInPjwhW2lmICFzdXBwb3J0TGlzdHNdPjxzcGFuIGxhbmc9 RU4gc3R5bGU9J2ZvbnQtc2l6ZToxMC4wcHQ7bGluZS1oZWlnaHQ6MTQwJTtmb250LWZhbWlseTpT eW1ib2w7Y29sb3I6cmVkJz48c3BhbiBzdHlsZT0nbXNvLWxpc3Q6SWdub3JlJz4mbWlkZG90Ozxz cGFuIHN0eWxlPSdmb250OjcuMHB0ICJUaW1lcyBOZXcgUm9tYW4iJz4mbmJzcDsmbmJzcDsmbmJz cDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgPC9zcGFuPjwvc3Bhbj48L3NwYW4+PCFb ZW5kaWZdPjxiPjxzcGFuIGxhbmc9RU4gc3R5bGU9J2ZvbnQtc2l6ZToxMi4wcHQ7bGluZS1oZWln aHQ6MTQwJTtmb250LWZhbWlseToiR2VvcmdpYSIsInNlcmlmIjtjb2xvcjpyZWQnPltUdWUgTWFy IDI1IDAzOjA2OjEyIDIwMTRdIHVwZGF0ZWRhdGFiYXNlLnBsOiBEQkQ6Om15c3FsOjpkYiBkbyBm YWlsZWQ6IER1cGxpY2F0ZSBjb2x1bW4gbmFtZSAnYm9ycm93ZXJudW1iZXInIGF0IC9ob21lL2tv aGEva29oYWNsb25lL2luc3RhbGxlci9kYXRhL215c3FsL3VwZGF0ZWRhdGFiYXNlLnBsIGxpbmUg NzIyNC48bzpwPjwvbzpwPjwvc3Bhbj48L2I+PC9wPjxwIGNsYXNzPU1zb05vcm1hbCBzdHlsZT0n bXNvLW1hcmdpbi10b3AtYWx0OmF1dG87bXNvLW1hcmdpbi1ib3R0b20tYWx0OmF1dG87bWFyZ2lu LWxlZnQ6MzcuMHB0O3RleHQtaW5kZW50Oi0uMjVpbjtsaW5lLWhlaWdodDoxNDAlO21zby1saXN0 OmwxIGxldmVsMSBsZm8yJz48IVtpZiAhc3VwcG9ydExpc3RzXT48c3BhbiBsYW5nPUVOIHN0eWxl PSdmb250LXNpemU6MTAuMHB0O2xpbmUtaGVpZ2h0OjE0MCU7Zm9udC1mYW1pbHk6U3ltYm9sO2Nv bG9yOnJlZCc+PHNwYW4gc3R5bGU9J21zby1saXN0Oklnbm9yZSc+Jm1pZGRvdDs8c3BhbiBzdHls ZT0nZm9udDo3LjBwdCAiVGltZXMgTmV3IFJvbWFuIic+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7 Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IDwvc3Bhbj48L3NwYW4+PC9zcGFuPjwhW2VuZGlmXT48 Yj48c3BhbiBsYW5nPUVOIHN0eWxlPSdmb250LXNpemU6MTIuMHB0O2xpbmUtaGVpZ2h0OjE0MCU7 Zm9udC1mYW1pbHk6Ikdlb3JnaWEiLCJzZXJpZiI7Y29sb3I6cmVkJz5bVHVlIE1hciAyNSAwMzow NjoxMiAyMDE0XSB1cGRhdGVkYXRhYmFzZS5wbDogREJEOjpteXNxbDo6ZGIgZG8gZmFpbGVkOiBF cnJvciBvbiByZW5hbWUgb2YgJy4va29oYS9wYXRyb25pbWFnZScgdG8gJy4va29oYS8jc3FsMi02 ZDktNGQ0JyAoZXJybm86IDE1MikgYXQgL2hvbWUva29oYS9rb2hhY2xvbmUvaW5zdGFsbGVyL2Rh dGEvbXlzcWwvdXBkYXRlZGF0YWJhc2UucGwgbGluZSA3MjQzLjxvOnA+PC9vOnA+PC9zcGFuPjwv Yj48L3A+PHAgY2xhc3M9TXNvTm9ybWFsIHN0eWxlPSdtc28tbWFyZ2luLXRvcC1hbHQ6YXV0bztt c28tbWFyZ2luLWJvdHRvbS1hbHQ6YXV0bzttYXJnaW4tbGVmdDozNy4wcHQ7dGV4dC1pbmRlbnQ6 LS4yNWluO2xpbmUtaGVpZ2h0OjE0MCU7bXNvLWxpc3Q6bDEgbGV2ZWwxIGxmbzInPjwhW2lmICFz dXBwb3J0TGlzdHNdPjxzcGFuIGxhbmc9RU4gc3R5bGU9J2ZvbnQtc2l6ZToxMC4wcHQ7bGluZS1o ZWlnaHQ6MTQwJTtmb250LWZhbWlseTpTeW1ib2w7Y29sb3I6cmVkJz48c3BhbiBzdHlsZT0nbXNv LWxpc3Q6SWdub3JlJz4mbWlkZG90OzxzcGFuIHN0eWxlPSdmb250OjcuMHB0ICJUaW1lcyBOZXcg Um9tYW4iJz4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsg PC9zcGFuPjwvc3Bhbj48L3NwYW4+PCFbZW5kaWZdPjxiPjxzcGFuIGxhbmc9RU4gc3R5bGU9J2Zv bnQtc2l6ZToxMi4wcHQ7bGluZS1oZWlnaHQ6MTQwJTtmb250LWZhbWlseToiR2VvcmdpYSIsInNl cmlmIjtjb2xvcjpyZWQnPltUdWUgTWFyIDI1IDAzOjA2OjEyIDIwMTRdIHVwZGF0ZWRhdGFiYXNl LnBsOiBEQkQ6Om15c3FsOjpkYiBkbyBmYWlsZWQ6IEVycm9yIG9uIHJlbmFtZSBvZiAnLi9rb2hh L3BhdHJvbmltYWdlJyB0byAnLi9rb2hhLyNzcWwyLTZkOS00ZDQnIChlcnJubzogMTUyKSBhdCAv aG9tZS9rb2hhL2tvaGFjbG9uZS9pbnN0YWxsZXIvZGF0YS9teXNxbC91cGRhdGVkYXRhYmFzZS5w bCBsaW5lIDcyNDMuPG86cD48L286cD48L3NwYW4+PC9iPjwvcD48cCBjbGFzcz1Nc29Ob3JtYWw+ PG86cD4mbmJzcDs8L286cD48L3A+PC9kaXY+PC9ib2R5PjwvaHRtbD4= --===============9217388809529524100==-- From gmc@esilibrary.com Tue Mar 25 18:56:46 2014 From: Galen Charlton To: koha-devel@lists.koha-community.org Subject: Re: [Koha-devel] Update database error on Koha install Date: Tue, 25 Mar 2014 10:56:35 -0700 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============7144464627690425492==" --===============7144464627690425492== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Hi, On Tue, Mar 25, 2014 at 8:38 AM, Scott Kushner wrote: > Does anyone know how to get around this? It seems that I'm stuck in a loop > with the installer and cannot get out! > > Any help would be appreciated. It looks like some manual SQL would be called for, following the steps in the relevant database schema update. Specifically, since it looks like that the borrowernumber column is already present, probably from a previous run, you should try: [1] UPDATE patronimage LEFT JOIN borrowers USING ( cardnumber ) SET patronimage.borrowernumber =3D borrowers.borrowernumber; [2] ALTER TABLE patronimage DROP FOREIGN KEY patronimage_fk1; It's possible that this one may fail if no such foreign key with that name exists. If so, that's fine, you can continue on: [3] ALTER TABLE patronimage DROP PRIMARY KEY, ADD PRIMARY KEY( borrowernumber= ); [4] ALTER TABLE patronimage DROP cardnumber; [5] ALTER TABLE patronimage ADD FOREIGN KEY ( borrowernumber ) REFERENCES borrowers ( borrowernumber ) ON DELETE CASCADE ON UPDATE CASCADE; If you get this far, the final step is to tell Koha that you've successfully installed that DB revision: UPDATE systempreferences SET value =3D '3.1300030' WHERE variable =3D 'Versio= n'; After that, you should be able to proceed with the rest of the schema upgrade. Regards, Galen --=20 Galen Charlton Manager of Implementation Equinox Software, Inc. / The Open Source Experts email: gmc@esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web: http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org --===============7144464627690425492==--