[RESOLVED] ERROR: Feed could not be created, undefined

Hi!

Haven’t added any new feeds recently, but now I am having trouble when creating new feed from input, or to change already existing feed.

I have upgrades to ubuntu 16lts and php7. everything else seems to be working ok.

Any thoughts where to look? All the paths and permissions are ok and verified.

 

 // Engines working folder. Default is /var/lib/phpfiwa,phpfina,phptimeseries
    // On windows or shared hosting you will likely need to specify a different data directory--
    // Make sure that emoncms has write permission's to the datadirectory folders
    'phpfiwa'=>array(
        'datadir' => '/var/lib/phpfiwa/'
    ),
    'phpfina'=>array(
        'datadir' => '/var/lib/phpfina/'
    ),
    'phptimeseries'=>array(
        'datadir' => '/var/lib/phptimeseries/'

 

 

Server Information
Emoncms	Version	9.7.7 | 2016.10.29
Modules	admin, app, dashboard, event, eventp, feed, input, process, schedule, time, user, vis
Server	OS	Linux 4.4.0-45-generic
Host	server server (127.0.1.1)
Date	2016-11-03 23:09:33 EET
Uptime	23:09:33 up 1:02, 1 user, load average: 0,01, 0,02, 0,04
HTTP	Server	Apache/2.4.18 (Ubuntu) HTTP/1.1 CGI/1.1 80
Database	Version	MySQL 5.7.16-0ubuntu0.16.04.1
Host	localhost (127.0.0.1)
Date	2016-11-03 23:09:33 (UTC 02:00‌​)
Stats	Uptime: 3700 Threads: 1 Questions: 5088 Slow queries: 0 Opens: 185 Flush tables: 1 Open tables: 100 Queries per second avg: 1.375
Redis	Version	3.0.6
Host	localhost:6379 (127.0.0.1)
Size	114 keys (517.22K)Flush
Uptime	0 days
Memory	RAM	
Used 7,33%
Total: 5,75 GB Used: 431,46 MB Free: 5,33 GB
Swap	
Used 0,00%
Total: 7,45 GB Used: 0 B Free: 7,45 GB
Disk	Mount	Stats
/	
Used 9,36%
Total: 139,14 GB Used: 13,02 GB Free: 119,03 GB
/var	
Used 1,45%
Total: 146,46 GB Used: 2,13 GB Free: 136,87 GB
/run/cgmanager/fs	
Used 0,00%
Total: 100 KB Used: 0 B Free: 100 KB
PHP	Version	7.0.8-0ubuntu0.16.04.3 (Zend Version 3.0.0)
Modules	Core   date   libxml   openssl   pcre   zlib   filter   hash   Reflection   SPL   session   standard   apache2handler   mysqlnd   PDO   xml   calendar   ctype   dom   exif   fileinfo   ftp   gettext   iconv   json   mcrypt   mysqli   pdo_mysql   Phar   posix   readline   redis   shmop   SimpleXML   sockets   sysvmsg   sysvsem   sysvshm   tokenizer   wddx   xmlreader   xmlwriter   xsl   Zend OPcache  

 

I am grateful for any info, what helps me on…

Kristo

Morning is always smarter than evenings.

found my solution from here: https://github.com/emoncms/emoncms/issues/561

Problem was caused by MySQL having a strict mode set which won’t allow INSERT or UPDATE commands with empty fields where the schema doesn’t have a default value set.

and after adding :

[mysqld]
sql_mode=""

to /etc/mysql/my.cnf file, and restarted sql service, everything worked and I was able to add feeds again.

Thank You