hatuhay

Just dowgraded database to 5.7.35 and error remains, just opened a new ticket updating this information, so this one can be dismissed.

After upgrading to version 5.2.1 everything seems to work OK, ads being served with no issues. But trying to add new zones or banners are throwing database errors, not a single reference of thius errors on the logs. I have no clue where to start solving this. Version: Revive Adserver v5.2.1 PHP/DB: PHP 7.4.3 / Unknown 5.7.35-0ubuntu0.18.04.1 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 ( 2 , 'Home - Ultimas Noticias Responsive' , '' , 0 , 3 , '' , 300 , 250 , '' , '' , '' , '' , '' , '2021-08-03 16:28:06' , NULL , 0 ) $_POST: Array ( [_qf__zoneform] => [token] => 4df40a449204b5de293836e6024698a2 [zoneid] => [affiliateid] => 2 [zonename] => Home - Ultimas Noticias Responsive [description] => [delivery] => 0 [sizetype] => default [size] => 300x250 [width] => 300 [height] => 250 [comments] => [submit] => Guardar Cambios ) $_GET: Empty

Cannot write to database after changing BDserver to Percona 8.0.23. The issue is specifically trying to add new zones or ads, old ads and zones works perfectly. Using Revive 5.2.1 on Ubuntu 20, PHP 7.4