{"action":"created","issue":{"url":"https://api.github.com/repos/pellcorp/opendb/issues/74","labels_url":"https://api.github.com/repos/pellcorp/opendb/issues/74/labels{/name}","comments_url":"https://api.github.com/repos/pellcorp/opendb/issues/74/comments","events_url":"https://api.github.com/repos/pellcorp/opendb/issues/74/events","html_url":"https://github.com/pellcorp/opendb/issues/74","id":72775786,"number":74,"title":"Upgrade from 1.0.6 to 1.6 failing","user":{"login":"q1x","id":1175880,"avatar_url":"https://avatars.githubusercontent.com/u/1175880?v=3","gravatar_id":"","url":"https://api.github.com/users/q1x","html_url":"https://github.com/q1x","followers_url":"https://api.github.com/users/q1x/followers","following_url":"https://api.github.com/users/q1x/following{/other_user}","gists_url":"https://api.github.com/users/q1x/gists{/gist_id}","starred_url":"https://api.github.com/users/q1x/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/q1x/subscriptions","organizations_url":"https://api.github.com/users/q1x/orgs","repos_url":"https://api.github.com/users/q1x/repos","events_url":"https://api.github.com/users/q1x/events{/privacy}","received_events_url":"https://api.github.com/users/q1x/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":16,"created_at":"2015-05-03T09:03:21Z","updated_at":"2015-10-08T22:09:26Z","closed_at":null,"body":"I'm a long time user of OpenDB. I started with a 0.8x install and have upgraded it to 1.0.6 some time ago. This was happily running on an Ubuntu 8.0.4 vm for years. I've recently killed the VM and installed a new 14.04 install and I'm now trying to upgrade to the latest opendb version.\r\n\r\nI have the old database restored and moved the old webroot to the new server, that is all working fine.\r\nHowever, Trying to upgrade to 1.6 I had several errors pointing me to first upgrade to 1.5 before trying to upgrade to 1.6. \r\n\r\nI've downloaded the 1.5.0.4, however that fails the upgrade with a lot of SQL errors and corrupts my database (all items are gone).\r\n\r\nCan you tell me what the recommended upgrade path would be in this case?\r\n"},"comment":{"url":"https://api.github.com/repos/pellcorp/opendb/issues/comments/146700663","html_url":"https://github.com/pellcorp/opendb/issues/74#issuecomment-146700663","issue_url":"https://api.github.com/repos/pellcorp/opendb/issues/74","id":146700663,"user":{"login":"MartinWunderli","id":14999963,"avatar_url":"https://avatars.githubusercontent.com/u/14999963?v=3","gravatar_id":"","url":"https://api.github.com/users/MartinWunderli","html_url":"https://github.com/MartinWunderli","followers_url":"https://api.github.com/users/MartinWunderli/followers","following_url":"https://api.github.com/users/MartinWunderli/following{/other_user}","gists_url":"https://api.github.com/users/MartinWunderli/gists{/gist_id}","starred_url":"https://api.github.com/users/MartinWunderli/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MartinWunderli/subscriptions","organizations_url":"https://api.github.com/users/MartinWunderli/orgs","repos_url":"https://api.github.com/users/MartinWunderli/repos","events_url":"https://api.github.com/users/MartinWunderli/events{/privacy}","received_events_url":"https://api.github.com/users/MartinWunderli/received_events","type":"User","site_admin":false},"created_at":"2015-10-08T22:09:26Z","updated_at":"2015-10-08T22:09:26Z","body":"\n    \nHi\nI tried both. Upgrading from 1.0.5 to 1.5.0.7 on Ubuntu 8.04 and on 14.04 (I did only once the final step from 1.5.0.7 to 1.6.0, on Ubuntu 14.04, thought it would fix the problem, but it did not). So same effect on both Ubuntus, blank page when inserting items. The last test and the error log were on Ubuntu 14.04 though. \nCheersMartin\n\n\nSent from my Samsung device\n\n-------- Original message --------\nFrom: Jason Pell <notifications@github.com> \nDate: 10/9/2015  00:01  (GMT+01:00) \nTo: pellcorp/opendb <opendb@noreply.github.com> \nCc: MartinWunderli <martin@wunderli.ch> \nSubject: Re: [opendb] Upgrade from 1.0.6 to 1.6 failing (#74) \n\nH,\n\n\n\nDid you upgrade to 1.6.0 on the ubuntu 14.04 server?  Do you have error log\n\nfor the ubuntu 14.04.\n\n\n\n\n\n\n\n\n\nOn Wed, Oct 7, 2015 at 4:38 AM, MartinWunderli <notifications@github.com>\n\nwrote:\n\n\n\n> Hmmmh, will not give up...\n\n>\n\n> I tried the 1.5.0.7 upgrade on the old server (mysql 5.0). Creating a new\n\n> item after upgrade to 1.5.0.7 showed the usual page, not blank.Fine!\n\n> But then the upgrade 1.6.0 screen went blank after I clicked next (on\n\n> Ubuntu 8.04/opendb 1.5.0.7/mysql 5.0). Ooops.\n\n>\n\n> Cheers\n\n> Martin\n\n>\n\n> —\n\n> Reply to this email directly or view it on GitHub\n\n> <https://github.com/pellcorp/opendb/issues/74#issuecomment-145939943>.\n\n>\n\n\n\n—\nReply to this email directly or view it on GitHub.\n\n\n  \n  \n\n\n\n"}}