Cannot add new zone

[wpitek]

After new instalation I add new website. Next I want add zone to this website but I get error.

Version:	Revive Adserver v4.1.4
PHP/DB:	PHP 7.2.7 / Unknown 8.0.13-
Page:	/www/admin/zone-edit.php
Error:
Query:	INSERT INTO rv_zones (affiliateid , zonename , description , delivery , zonetype , category , width , height , ad_selection , chain , prepend , append , comments , updated , oac_category_id , show_capped_no_cookie ) VALUES ( 1 , 'v2 - Default' , '' , 0 , 3 , '' , 468 , 60 , '' , '' , '' , '' , '' , '2019-02-22 12:36:55' , NULL , 0 )
$_POST:	Array ( [_qf__zoneform] => [token] => d0acb4e392580157bf1a7817a58e990d [zoneid] => [affiliateid] => 1 [zonename] => v2 - Default [description] => [delivery] => 0 [sizetype] => default [size] => 468x60 [width] => 468 [height] => 60 [comments] => [submit] => Save Changes )
$_GET:	Empty

If I paste Query to MySQL I get 'Error Code: 1364. Field 'what' doesn't have a default value'

[andrewatfornax]

MariaDB?

[whyalwaysme]

On 2/22/2019 at 8:39 PM, wpitek said:

After new instalation I add new website. Next I want add zone to this website but I get error.

Version:	Revive Adserver v4.1.4
PHP/DB:	PHP 7.2.7 / Unknown 8.0.13-
Page:	/www/admin/zone-edit.php
Error:
Query:	INSERT INTO rv_zones (affiliateid , zonename , description , delivery , zonetype , category , width , height , ad_selection , chain , prepend , append , comments , updated , oac_category_id , show_capped_no_cookie ) VALUES ( 1 , 'v2 - Default' , '' , 0 , 3 , '' , 468 , 60 , '' , '' , '' , '' , '' , '2019-02-22 12:36:55' , NULL , 0 )
$_POST:	Array ( [_qf__zoneform] => [token] => d0acb4e392580157bf1a7817a58e990d [zoneid] => [affiliateid] => 1 [zonename] => v2 - Default [description] => [delivery] => 0 [sizetype] => default [size] => 468x60 [width] => 468 [height] => 60 [comments] => [submit] => Save Changes )
$_GET:	Empty

If I paste Query to MySQL I get 'Error Code: 1364. Field 'what' doesn't have a default value'

Hello, i get the exact same problem, any solution to solve this?

Version:	Revive Adserver v4.2.1
PHP/DB:	PHP 7.3.6 / Unknown 8.0.16-
Page:	/www/admin/zone-edit.php
Error:
Query:	INSERT INTO rv_zones (affiliateid , zonename , description , delivery , zonetype , category , width , height , ad_selection , chain , prepend , append , comments , updated , oac_category_id , show_capped_no_cookie ) VALUES ( 11 , 'Egy4way - Default' , '' , 0 , 3 , '' , 468 , 60 , '' , '' , '' , '' , '' , '2019-06-27 14:25:50' , NULL , 0 )
$_POST:	Array ( [_qf__zoneform] => [token] => bc292231db6b1aa328729c09bac14573 [zoneid] => [affiliateid] => 11 [zonename] => Egy4way - Default [description] => [delivery] => 0 [sizetype] => default [size] => 468x60 [width] => 468 [height] => 60 [comments] => [submit] => Save Changes )
$_GET:	Empty

Edited June 27, 2019 by whyalwaysme

[whyalwaysme]

On 2/25/2019 at 11:36 AM, andrewatfornax said:

MariaDB?

I am using MySQL 8.0.16

[andrewatfornax]

Other forum posts suggest you may need to disable strict mode in the database for Revive Adserver to work?