EmonCMS V9 Upgrade Fail

Submitted by welbaz on Fri, 13/11/2015 - 09:35

Dear All,

I have been using emoncms v8.5 for around a year. It has been efficient and it has been running perfectly through out the last year. I thouhg out upgrading to v9 to make up for the new engines.

Its running on a big machine (Windows 7- 64 bit - 32 gb ram). I followed all the upgrade processes but actually I forgot to use the $updatelogin = true;

The overall system is running, yet I can't create any new feeds. I get the famous error: ERROR: Feed could not be created, undefined

Please note that I can download the past data, I can visualize them which means that the emoncms can access the folders. Yet I can't create any new feed since the update. This is the current configuration of my folders, but it doesn't really seem to be a folder allocation issue cause I can access my previous data.

'phpfiwa'=>array(
            'datadir'=>'E:/emoncmsdata/phpfiwa/'
        ),
        'phpfina'=>array(
            'datadir'=>'E:/emoncmsdata/phpfina/'
        ),
        'phptimeseries'=>array(
           'datadir'=>'E:/emoncmsdata/phptimeseries/'
        )
    );

please note that I tried with the double slashes but it didn't make any diffeerence. If you have any idea or hints, please share.

Re: EmonCMS V9 Upgrade Fail

Submitted by firefox7518 on Fri, 13/11/2015 - 13:49.

I actually had the same issues but it was not the folders for me. I did a clean install of emoncms v9.1 and then was cheking if I can create feeds which worked with the same settings file.

I went on and used this newly created db schema and imported the old data into the newly created schema. Since then everything is working for me. As this did help I did not dig into the differences of the old db to the new db.

Re: EmonCMS V9 Upgrade Fail

Submitted by welbaz on Fri, 13/11/2015 - 14:48.

Thanks alot firefox. You are absolutely right. There is a problem with the databse. I have created a fresh installation and it did work, but when I try to migrate or import data from the old database the same error happens again. How did you import your data??

Thanks again!

Re: EmonCMS V9 Upgrade Fail

Submitted by firefox7518 on Fri, 13/11/2015 - 19:09.

I'm using MySQL Workbench for the admin tasks. This makes it rather easy. I made a backup of the "old" data and just imported/restored the data, without structure, back to the new schema. Make sure to select all the options for that and also the correct restore schema. Otherwise you end up overwriting your existing data, so be careful when doing it and of course always take backups first and store them safe somewhere.

You can also simply copy paste the data from one table to the other in MySQL Workbench but thats of course a little bit of work to do there :-). It can take some time too. In my case it had to copy almost 4000 feeds within RAM and dump it back :-) I tried that once too and worked out perferct.

Regards
Andi

Re: EmonCMS V9 Upgrade Fail

Submitted by welbaz on Tue, 17/11/2015 - 10:13.

Thanks Andi !! I tried this out but it didn't also work. Yet, I found out the problem is with the declaration of the process engine in the feed table. It has taken me lots of time to figure this out, but it worked finally.

regards

Sam

Re: EmonCMS V9 Upgrade Fail

Submitted by firefox7518 on Tue, 17/11/2015 - 15:14.

Interessting, Can you give a little more details about that? Did you had some feeds with unsupported feeds?

I have to check my backup and the actual running copy. Maybe I corrected that during copying the data over but couldn't remember. Like you I took me quite some time as there was no obvious fault or error message which explained the issue.

Thx
Andi

Archived Forum