WP_MySQL_Token::get_value() throws error when importing wp_aioseo_notifications SQL query #250

Activity

1. JanJakes commented on Oct 8, 2025

   

   JanJakes

   on Oct 8, 2025

   Last edited by JanJakes

   Member

   More actions

   @wojtekn This is just a guess, but maybe it could be fixed by #263. I tried this test and it's passing:

   public function testWpAioSeoNotifications(): void {
   	$this->assertQuery( '
   		CREATE TABLE `wp_aioseo_notifications` (
   		`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
   		`slug` varchar(13) NOT NULL,
   		`addon` varchar(64) DEFAULT NULL,
   		`title` text NOT NULL,
   		`content` longtext NOT NULL,
   		`type` varchar(64) NOT NULL,
   		`level` text NOT NULL,
   		`notification_id` bigint(20) unsigned DEFAULT NULL,
   		`notification_name` varchar(255) DEFAULT NULL,
   		`start` datetime DEFAULT NULL,
   		`end` datetime DEFAULT NULL,
   		`button1_label` varchar(255) DEFAULT NULL,
   		`button1_action` varchar(255) DEFAULT NULL,
   		`button2_label` varchar(255) DEFAULT NULL,
   		`button2_action` varchar(255) DEFAULT NULL,
   		`dismissed` tinyint(1) NOT NULL DEFAULT 0,
   		`new` tinyint(1) NOT NULL DEFAULT 1,
   		`created` datetime NOT NULL,
   		`updated` datetime NOT NULL,
   		PRIMARY KEY (`id`),
   		UNIQUE KEY `ndx_aioseo_notifications_slug` (`slug`),
   		KEY `ndx_aioseo_notifications_dates` (`start`,`end`),
   		KEY `ndx_aioseo_notifications_type` (`type`),
   		KEY `ndx_aioseo_notifications_dismissed` (`dismissed`)
   		) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
   	' );
   	$this->assertQuery( '/*!40101 SET character_set_client = @saved_cs_client */;' );
   	$this->assertQuery( "INSERT INTO `wp_aioseo_notifications` (`id`, `slug`, `addon`, `title`, `content`, `type`, `level`, `notification_id`, `notification_name`, `start`, `end`, `button1_label`, `button1_action`, `button2_label`, `button2_action`, `dismissed`, `new`, `created`, `updated`) VALUES (1,'685cd5b8915ac',NULL,'Have you connected your site to Google Search Console?','AIOSEO can now verify whether your site is correctly verified with Google Search Console and that your sitemaps have been submitted correctly. Connect with Google Search Console now to ensure your content is being added to Google as soon as possible for increased rankings.','warning','[\"all\"]',NULL,'search-console-site-not-connected','2025-06-26 05:08:08',NULL,'Connect to Google Search Console','https://route#aioseo-settings&aioseo-scroll=google-search-console-settings&aioseo-highlight=google-search-console-settings:webmaster-tools?activetool=googleSearchConsole',NULL,NULL,0,0,'2025-06-26 05:08:08','2025-06-26 05:08:08');" );
   	$this->assertQuery( "INSERT INTO `wp_aioseo_notifications` (`id`, `slug`, `addon`, `title`, `content`, `type`, `level`, `notification_id`, `notification_name`, `start`, `end`, `button1_label`, `button1_action`, `button2_label`, `button2_action`, `dismissed`, `new`, `created`, `updated`) VALUES (2,'686f93f119b0f',NULL,'Email Reports','Stay ahead in SEO with our new email digest! Get the latest tips, trends, and tools delivered right to your inbox, helping you optimize smarter and faster. Enable it today and never miss an update that can take your rankings to the next level.','info','[\"all\"]',NULL,'email-reports-enable-reminder','2025-07-10 10:20:33',NULL,'Enable Email Reports','https://route#aioseo-settings&aioseo-scroll=aioseo-email-summary-row&aioseo-highlight=aioseo-email-summary-row:advanced','All Good, I\'m already getting it','http://action#notification/email-reports-enable',0,0,'2025-07-10 10:20:33','2025-07-10 10:20:33');" );
   	$this->assertQuery( "INSERT INTO `wp_aioseo_notifications` (`id`, `slug`, `addon`, `title`, `content`, `type`, `level`, `notification_id`, `notification_name`, `start`, `end`, `button1_label`, `button1_action`, `button2_label`, `button2_action`, `dismissed`, `new`, `created`, `updated`) VALUES (3,'689c4057c5e2c',NULL,'[New] AI Content Generator: Supercharge Your Content Creation!','<img src=\"data:image/webp;base64,iVBORw0KGgoAAAANSUhEUgAAAZAAAAA+CAMAAAAyAL3UAAAAWlBMVEUEYeAVteTl8vzD4PaSx+8Tcr9TvekJX7MkfPMFYNZEmuwyuehKqucpl+wEZ+Y0ivINde8IceIRj+wQldwQjdsRnuIPgu4OhNwKeuAgpecVrucUteb///8BZPnkOgnlAAAAAnRSTlMwMI8My2cAAAAJcEhZcwAADsQAAA7EAZUrDhsAABrkSURBVHjarZyNgqo8r4XnU7GIIGALBdze/22erCT9AWH27HdOwQIVcaaPK2lLydfX4/2R2pB6U5qpbaepLMu2xWpKrP1Utj2V0cvcyqnH+5LajlNbtW3TUl4UVWFaXKSdTIudpvWm8O1E+yiZRnrr2Y7VOHbjODaVptYY+qSvvG8a2rQe7/ii8YY2rpIC75rGuYZOwauYkOMD7okipPrJaa41zaaovfF14+q6qprC1Q3tz3VR1K6eZ9qr7dzQifRVzTw3jaWyeXB2Hqwt5nmh9U4FM22vd10KO8/3uTD3uy3qunD32c53pIVWpNc1JmeK67W+14W9zle60nUorvV8p3fuZr4XX1/vnURVL0tvTN+2N3MjMO2tD0DM7UaVXBouN53pTZ+AvDtaK+BsmAJVfmuKaWIqRYE3KB8NYZnMaAoqJiYEBDxGqiSkqiEgDX22MOBZ0MmmmqupqCrjC0oEyTT0ZuHwJp1ZGNp78l7BhwJkbgKQWRZTNEXhHX28NsbRF3i5VDGbGV820+dNvRAQ7y1dCNeb6TudL4aCeBC1GjQGANFkvLN3T+fcab27whbWLHcsCoTqm3b5RRe7Xw2dUtTmSl/vhoI+VSzXqyVS9/oACKoWCjAGBLjiaWnLiQp6gsOH2CtvPd7HB0asqpAqiqwsDGqUGLDWDDDdClJJa/xkJvzHEEjbQCHdKDQogUIBEFS1xjUTapiANJXxWvse5a6lcj4DtduYJw6deToDGLiWAuEFQJyjyzZEejZNXbBgCnCpiYWjzMy01jOVuIY0UThbLPhLPFXivNRLUsj9XgNHfS8ApLAeVXuvgaOwrI+kEMZBYlroW+ydtFQMlNO2Huh0+tOhLgA7BlIyEJgkqvi+vAENbFhZqkwUyK3reyFSlh2AvGGyQpogBlJTMFmsECOFE4CMExmtERrhBBotgJBdMRMB8S1+wvjVUyEBoco2zyeV4gRPNkeAeAWC03CG2ypkRqrnhjUk1zPNDNy+mG1TeCjEzXIBqnhH9qm2hoFgAyAGFgtXGUggc8088CrIQM34mcz0UyfGs6VTt0AksbwzILMlIMWd6F5nAlK4XSBlBoSqvYcEOjZLHQO5oUCAdDcyWVBNV3a00hlsslC/sEQkJUPVb3AK5yMcBimE6Bjg4KKRFdJBIxAQkJCEnsSBRGRggaAkKie1mamhsokUYnSnofrHtzTQTSMfiECq4EPmipFQZeOyMIGNsVTdbO+oJmnDQGa8BYXgrx1EIYMpFAiEMYtCFtQ2eNQMpODqBA7jSCFU9AKQFwNJ1o3KSSQGho1yR18Fk4UPUxF97P49kDL88IXNuiTuipUqhUfHEikJSIlf/khqkxqnteQ8HsreKK9WnPrYtM9n+2yeBAUvOuSK1U2WVgXGP/ffmAXIEwqpFMpHavIDZ52ZD9LCEsG1Blpq/P5VB+rCKQOpZX4t4LGIQJbX/SC9VhukXSBks2IVd1r5t9uWUteV+UlK5cFL14pLKZkLkJRju1oYQ9hyASuEnAh4kIzAhRIOaQf1nC2tVvxT679wXN5sz1OLRRKZYb7iUs2HiVyMO8Ihdg/2io+pumvyKKHikTGGRUEFi7Us94+KP0r7QMKvXis5KiDapXAgqU+ngsa7e/fUAAALWssxUBHN8DG/xyzktKAPtLOo+kbl0erShAOmxZj4FSg8P0jou4EHJMJEhmYQQQiYtTh+lBbVB3sRre86AAiZvhHeh0ReL/DQ7BjNPpC3+IJui6Xs9tKjU10Qj54W2YfKynLMl5AxjaxQXHoXjBbxwCIK4dTqS3cazWN1N88ESV+cJx7PpiYWtIDL0DAWJfKPaLh5AI0MC7QBE7Wb7kkfgQiSgEmbFaLXIZBAhMTyFjf9Vu8ALMrqLTR4eZBMwOP9ABQ6II2gHcuCSjTWaIQM9NFFHHRE1TgSEUlPelcUM0Y2OascyaaoWRWizpmJ4ODdOUASHooGL7VKcRtxwF4NrJAlamReqSFDsqyI3BXH6y5k7hFPYvQ6AsKeHT/x3H9Hh66mq8tsFhX2jwej0QyefSWFlcuA8WKT1Wby6ARKyz4Eja1nKx5DBaHGKPj7IxevDd6ch2U/kmo+2K1D334sj0ENljh5duY1r5rd1dG/Mhp4/cCBHJssdSV/Tz1WWnrQeJA4QAMq6SATGVJh9z7mMglmSzx7RBFXtlftGDxHtm2T6cqlsudFVjD0NKijYaM1b5efIWEUvEIhwbtrmlUW1DDeMWWvRX1IbqY+PMq3QI7TA+tjk3rNdIVIkr/XNMqL17JjDlIsTJLhOkxszp5pE2zZqNu9ZDMuzXNgCzdgtfTipeFsEBMWdkKKotDtEEUCLrm753U5Ti8oZXl9k34OpHurQ0EjSmF8MIloWDdsvfpjeQU6ykINVra3AyPLA5MAZg1oh4kVBs+nYsCRAqEdyuUl2TbN2a5qRHQCqYDCsAiMWbYfInkl67UcQ/n6MQp5sTJ4iTBucQk0xHyxQqQRtoNiFJWkpYtFwYz9RSUboahCAo3xCImgiFhAxA6RS6Cxy0SEEQUTwPBQI0EZwGQfRqTBEkFafqWQiAPygC7eSR83YXJ75FT6uLDRehwKRDYTZZPoYkoC2dUJM4ivjEWQSLJdjlfd2ITEZlpRqcjWikyeRzgyKENGRnDICPA8f9MSFoPFe4dEvn7CIu4qlIgksLjJ67ZGwiZLTNehzSIQjAPbcWIqwmLKhDJtoHhB4UUfPlJB9XvVh1eVJCTPDEfYJlkwEOzaQSXyrVSSTII4BrVZOsKy5GBW1gowlkORfP1QIArj3QkMJVKe/+ymU7uCwlRW/n0Kq8pknAKaCfnEQpmYxLTCQLnPNoTjKZl/ehWIBxXOHGOJSJxicQGJsmFnMtiAhIoSlWMcORYWyTJHJqj+YaeVFRZd95D8SytLoDyy9tXpz0E6q9XibnuvSGT5pAIUarOmThCw7WIiU8bFjzkNn22hFT86WgTGk3Z4y4JxLuDAXqYSzi0lGDAbZBLVYgf7DZTMzfPolm6WZa+hFTUSWSy/8CGdaIRpdOLOmcntz2F6xCZwnyERHr3AUCg5Fl5YJmK0OsEiTGQdJx/JeDZYtPDKdsozCKgESMDDedZKEIgTPILEChdt/mpmmQSMl2WvYsW7iGjsgZcfYudEeQyfjayXcvlGH/+gkE6dxzvz5t8AoTf7R/TrAUmgwtmkVKapiwvrhHBMUy6PwMOLWChTdcjGMQvGwpaLl5FAgIXIIhCRjcVegKJYbNgHAOQ2tL4CBCuKsQdaWXQ05dhqvZbU5F3+eyurizjQ1u3eyaXfvgOi3p3NFvXjo8GibEpqmTIcSKEgggnLlLGZUPOT1H9YlM7Tgw9xgChgwpgOwaEFcJyuIhJnnXJQy2WFjBVxWFUG71sRi6x2Fwm3tYZFlk+79crcyCu6kd/5kNBDfz+kVfUXhfRqtOBJ+l6w9AIF24m5MIS2qquWoQQ0LJIgFpCYoA8v4pjGiCJjAhowV6oRLy6FUDgM9l7rRrgIESdUHJA4GyUy8GqhkiFwAQoGYdV0fehEFDJkNmve8ehx/W3HMPTQUyNLW7x/UQj6JiqRR306nc6K5EL7IwtElVJLY+1cM4sxs2CsjUkVkkyYp2WCBfPBUnmxWaQOYPDBdjnCQturfsE1yiRYMIvVPYM0NhlcfVKI8oiZ3e2jLInJnm9PMJb/2sqKPZHukdpY3OtQIO1N0zkHcuvRV5Txrb7ntzqRyIV2RxFLT/ZrTB+7RIEEaUzRYPHGA6xqhRZGQpvo2fmFc6AQfT1d9gUsEq8KsUEoYr0sCtiKpTRkexHGlb7gw6PoOMq8b7FeQSPM4RuVfP0URmhlBYmwAvS/DJPb1kDYat1EIaWcKP5EgBAL4Ogn/tTpfBIiU5+5lEgnpppOmoTGxI5EhDIlqfjxSucIDrZcXuVxCkTcymjZnA6g2KiRDMqQ88EXBESbtCQih24kpuW/9tS7uK9DWLdDH3I5JyDS0uLsInUijiQASUeniuDUqDHaoWWXBdspAcL77Fa8KAUgJINCBIgmh+o71awc2qtVI+DiIwqrS4QTmSRGCY8AiT7F5iJBK3jXYL1Wzaxl+e1ob5caWLTc3pnJqsMkrDNpoD0nIDKSAlVQVaC8WikEFqub6K2T6KVSo0XWqb5cro1YLlLeNF4vlxocKny2qhxoVFwIIA6zTB0O4UZqnFPXjeDwHhga3gWpi2cYdPKl5sqfa8wrpcMmoKD968wY6roeLL0HDtfLmT6CPf2CGTRmOvkiPcT5er0P8+V8zTWy186KPfXlvzZ7u2ygN/ZBEpAq/NgBpMqA9KqRB6q6PLHNIiT4f7x8YuprMWUTi+V8vkAfF+3ut2KjTvzT/nNyrA+1bOoY6Kc/+eycxl/DOZlewj6qGturDDEwA7rO5aIOBlrRL78QkYG2Mx2fCJIOSpxmG7+AgKg9OAMJlZ8X/JPzTkvrFYaykif5f1CI9gyhjxzIymSdMpMlVouWM8wV/rPpw2ThoBU2k0I6pyExARLGYzIgLo7aVAJEj8++3gDhnzNLBSrhZtcljvAIkHCtWg4lXa2b/4iwTwzhfE77CiT+EadZgKDgMg/xPtW81y38tiPy9fO7U+9wl/C9UciF55Xz37Vy6qIQamtN+GfZIrHNyhQiza++jzAIC650ndilnMVpnKq2gWWLTp1FdG4mx5D1nKbCOR8+BF/ANKxtGovZ8VacO06/eCZwaZoLF8LhnIgLjmYGQt9DJusskuHi6NT5kLBAb2cGgsYJmTvtjWyHF1+ZOJZfdQy7dCdEmKgLWTV7sdfH39fNBI0QEdRQKY4kiKLMgJwUh0I5aWNL6h453Af+XReBODma4CAqOYfc+1W8xScQ5qF/mUdtsydB5TOQkxNpkGDoelc9urhBZWPdRdwHrjwkICfmwWBOAuSkd0nSXcPtWG/yIsuv7hi+87uFG4WcOOHXcmtXCgle5CzDvwAxrX1IVEgfkUzilSbeqbmyPR1UvA1AUJdwpxemJ+eQy2cxTNLsnTYKiUBQcuYPg5+AEDt2dtyuQOLSIToWLPOV7XEE4vh3ACBQ0pWBXKWxFYd990dPFm1j/WLopEs+5HHkQ841FbaXtQ8BklZ0z93ly2OjkEAHLNDWYcvWskeJlQ1LVuUK6S+525JCH4BsFMLtMrgPqeY/0uwKqfasBcdW6uzq/KYOA7lKD+UStT9YpwqpxYBRikA23fU1klfWEzmc6/D18xuG2b2Q26qnHv43LipPCsSITyeB5LVHNuuxUoi2soKxOvetvDvxYd0rgY1CLuJkOV1jb1EVIoIJEqk3Dp6BnMKHKwESFFJn1xWFSNv4LL8pfH5wAsTtAwlT6HS+w8qRvFY3RF6/dOpdvHnLAtnpGJ7a2+O8NlncEVndxmpDK0uHG7kfInjYXoilwhv+T/AP6CkKEOXDba919z2ZrJVCJg+3cLLSxjoFk3WJ3UY9UoU0bMVCagKQWjw+bxUIdVOGYLLYdq0UIg2tbas3OI/v2r0/HTrRbqESeew3e0+3y9apq0u/tHjgUGp8rRDpqeOwOkk5t5EneWNSIFuFCCxIhX7kG4VsTBbLgolIk5YLzuzmqdvjxX07L0BcMGBXei8BYQK6DQrZOHUbgfANdnEhw9ZeJSqvX98xVKMV7k7t9kPa09qp99AImjF6q+rMXRH1IZlEQiMfAhGhVNwnv4hJ2wBBBx11UFf1OTZ7p7VCuNeeufXwBQACoZyr+srNXlFIBHKVZvyFjdIQGlm1OBPufCoQat5K76S+htavAuGG1sI3qnbvGAZTtW+zfjzrROfHCZHbYcdw08oiJBO7cvQP5UdfrVtZfZ852UvUjDoctVF9dOqt+vH0oWYKTj34kGrVMfS+ST3NM2vnGr/ABwMmPkQsVxgYTj5EeoCnPzIYZm3oGKa/1A6ZyRKvvtNZzyY5LL9tZa28+vunQMi2cX9QFVL+0S57amWxYz/p7Qrti+gwCOSiJqsICul51IP6KV7GBKh3yD31vJUlIyOX2PBNQyX4bYuxki9wyYeIU6cCOfd0zX2IG+TLau2myBdY6RPiQmEMOIz5zsPqLm42TS7vqP8nhWQjvqlneDswWRsgD7kpwrdE5AZir/k2tVVd+9QXoeMqjKfw4G+v+URo6GcsA8IYUlyNBcOJy8Y1jV8lun7tsmNb15XT0UcXb5HIEDAPN6YkY8B4xj0MDeM1y/Ajxh9ru7pXxfMYl61AXrGz/uuxrDgA/wiDJxHJ+YjH6ZaI8JLmMh5C4fsjyIpJdxUEZwUzKIQKtomEDMz7wETG5H+SHONgGj4Oxn+mNDJv82V7w0SG4efUzNqdCSQzHH7p1BMWHVwMXZHyYGLWucyHshKK8NrDEAcYtSBQYT5RINMGR4ZE7yFqa/cnOBRFRsTv0Aij8jFTFqvbJKt7VNrk3Xsg4bWaBrT8ZtZJQsI9kfdtnYwuq9Tn03yPkOQwEoYpYJDUrzY74lBbNf0Mh4sCiTeq/L4wbH5z1ymH9S2r7V2qIU4s/dRHGlT8hQ/ptgrJb4lEFjd9mWzg/SHWSqdo5SgeHyKJspimnEj/gWFNJGQC4ntr5dLLBXN1hCO7d7iyT1sWcR5KRDLLwMlHC2tZ9wmXX02U60LXsNMB+FvsiyQs6/QIc+UeYWrWY0sigMiFkfnxQxA+qCNz5mmsZMcu6RL2Iwu3b6dsAKHSsBtjdSwP7RZKn3DYv0n1rU//p7GsRzbe+84UspvElfPELJ0J9OnFuy7YKp7WILMeEpJpz0xFFtFzZCTC3XWdpfWMGBILvUflVtNPNoYqmicl4HaVkakjIdFnqpbPccXX2mL9upUld3Ifq7nWx0z4eZG1A+k2MGRK0CSTs4RCN6X8e42siDAJns+oMEZMkkPtRyirmQ3+uE2V4XA7Exy2NDbuPD7ups8kbJu9r2zeyfLbub3v7OGQ0Bd5H/MIT1Jl0uCHRfJp8DzzWtTRh6k/OpeUSw8tVehu6JwTmQaU5gFRhY86A+gZDdXzs0n10ZqyLhqqv8FITd0NEn16Z++GYRpajHNOlv/+BFUXp77nN3J3RYKZJrdHhkMeE9EJpKoNoTJhvjVXfprn2+tUxSnNmFt3/6bcWI0BxBisFWbA87RSTLvCnGuZw8gO4+mP2lNZI+obHAnDsDMvSyYBLeLTl51JJ2l08XCm3L8p5KFTs6LZun0QWT1q2Ie1C4+GJI3I5PdeWXRJHGkeaadzF2VyL09+1zmMgCEzrMMUOR+nkmLiOyZcO55szUhkBulT58c9Iwnee9qsA+72HcYQp5TG+deBgs2f3ZGpWcFi7T8jsh7IWg6BlG3144Sh9Bih7HHLHvvk6aPTP1xqm5pRZmZljyW4CgMfdcUrv+JhlYpC+SZVjeMnqfgxEcHS5O9f62/SNWyuuk/ZHJ9MCG3dub7+Y7pnT1IdAOEqbL9NJYf9y1Nf9oi+WIYnDUUdXnhVLZOL/PLlKCHCVlWN6k8Ex5OrPWS7DLHqovHoUoQHvM8a0dnuz6b+cZrDsgrmQEhsJo35b5V/lWByeQKS17d3DLUC2+r7KtNYjAEHiBCTso2P45I88kspjIxEzCoOyYjMYUWUP6+hm6pWFTLyxEURQpW4CJZ6jUR5VFsitmnq5hmfLnTNTyHUKSxgtqcR5ZLJqncIhOiYGtbvntYMyUHf8CuGIVUI38ikVCK5ThgJiATXkXhEmayQKBGOHBfWpA/HVKARfbSwUQRpiXKh10z5rEiaqJQolpBgtvSJtuZ7GN9wyYRSZ08XEoF6gyPHsisQQfJNs7dsf5DKrUJyImXw5KVCTSzaanWA9xo9RXEggAk0wjIRjeiT0dMziiEw2IhDkMySzdUHC9VIeBbX/sBMMYDvtJITERx14HCPViqugUiISxqB3Hc7I1+rOL1/RVK2K4F0YrcQ+1KBqLkLVi/hCFmrEWSDwWqSRBiJB5amlQgCY6j9egNG1VFnRksWotIk6xUlUqnB+hfvsc9D/Yjy4Iqus6rPZJEWBXHdSuRIIVEgpUHw5ELDuyYSfTGZoI4bR46N6dYrFnnodorRSBFDcm2kDGq/4hdMlhF5cJBMCfMDN9JzDomgpRsFInFgab9AHEzjBYKpfFMVlXComgIQCgTBbDSgX9PgVlWKp/yMNW6yRpnPOCw1rbMKBS9cb05QfGAjLV397V8R3rSwvr5+wCjoDIvYv4nEMEeJHAGRpe1NGxSAfeRUw+VU3PgIcfs4FOmt7AGipy3ilSJ0VvvAsGMKD+uNpwt6jmjtkSGqNY6kCIdU74TEIN4rvDiXTgYKeSLONUdvkp8+gygKZtC4wjjUcuUaXyE8LO15HCFMLAHxrigaNzmJcW0Q4noI4XuH8LOvEQXYVfXsbG0JjrNU6shhIZw1lc2NawaHM40dCjdbj2iMbp6NjV4ED6ZTlXO02JqIEDxr6ztd/G6H+32m/butDcKNFosz90VK5zuC9EoAuQMgwqDVyKPFjWocsWE5aK8pkN1kH3EwCciNDukMDLVLxF4i0kpkvxSvF5FVObgrftG6w0GqYzYhZizRGM2k8atRTqjGZ9uIxWpSe9YYiTVeIbw1Il63hmPw0gUKjvlKZAuEw/SIXE0Xd17iLcfwvTbGU0bE8UbCWHvExsYvuJglhnVhjZfPFoYo1MbNElV2wEnWOA0sJ8Fnrhy3FzpxCBPLMXkLi4DVM1235ijZDMSaxTiUIgZwoUExvwESw/SinzcZKIBDWPMNDiZQGnkb9StUCj5DIvZ2rUSRE9+vQMq24BjliG5NNU0/fiPx35GBTysmi/ZHlJpipLcIB5HQsMrJERgOxFtM9CoahCP2iIUssZM1+jXH6mWTxVQmDX6NkGWqkCa2mEzDYawR9bgxNZ1NVBA82SDqO9jOHGG5xhkFVSPVL+0Ns8HtDsJRy4xRidt750pHUF4ShKGMLlE7jyjZd6MBea0t7oMB8Lt3xwq5I/h7BPIQhXRGRUAQuv52y4CwQjgCP5X1N0ajAXuJx1uAjJSh0tuCI8TD5BUcfD8BGVkQ8N+QychApgmV2LJCQpzrJoQe53jvAmSiHTDwAQgihyMgtQDxchpCH0/MSRXCsX9CgGsoBGGsEXecQ1pbQz9dYJgtLsh7lKmN4h88VSkHIl9EIRyYKeAIQGYAoXW2pAqcvZhF3kMkccsxry0BeR0opP7f/wFVg1jJPsX2wgAAAABJRU5ErkJggg==\" alt=\"\" class=\"wp-image-1276\" style=\"object-fit:cover\"/>\n\n<p>Tired of the endless grind of crafting content, SEO titles, meta descriptions, social media posts, and FAQs?&nbsp;</p>\n\n<p>We get it! Creating high-quality, optimized content can be challenging and time-consuming. That\'s why we\'re thrilled to introduce AIOSEO\'s new <strong>AI Content Generator</strong>!</p>\n\n<p>Automatically generate content snippets like:</p>\n\n<p>? FAQs<br>? Key points<br>? Social media posts<br>? Email copy<br>? SEO titles and meta descriptions&nbsp;</p>\n\n<p>... and much more to come!</p>\n\n<p>Update to AIOSEO 4.8.4 now to unlock these powerful AI features and transform your content creation process! ?</p>','success','[\"4-x\",\"lite\"]',1270,NULL,'2025-07-09 13:36:07',NULL,'Learn More','https://aioseo.com/new-ai-content-generator/?utm_source=WordPress&utm_medium=plugin-notification&utm_campaign=aioseo-484-v4-x-lite','Get AIOSEO Pro','https://aioseo.com/lite-upgrade/?utm_source=WordPress&utm_medium=plugin-notification&utm_campaign=aioseo-484-v4-x-lite',0,0,'2025-08-13 07:35:51','2025-09-21 19:12:01');" );
   	$this->assertQuery( "INSERT INTO `wp_aioseo_notifications` (`id`, `slug`, `addon`, `title`, `content`, `type`, `level`, `notification_id`, `notification_name`, `start`, `end`, `button1_label`, `button1_action`, `button2_label`, `button2_action`, `dismissed`, `new`, `created`, `updated`) VALUES (4,'68b5184c74ce5',NULL,'Introducing Site Audit in AIOSEO 4.8.6','<p>Tired of guessing why your website isn’t ranking higher? Or frustrated by SEO tools that give you too much data but no clear answers?</p>\n\n<p>We’ve supercharged our SEO Analyzer to give you crystal-clear insights and action steps—right inside your WordPress dashboard!</p>\n\n<p>Now you can:</p>\n\n<p>? Scan your <strong>entire site</strong> for common SEO issues.</p>\n\n<p>? View issues <strong>page-by-page</strong> or <strong>by issue type</strong>.</p>\n\n<p>? <strong>Get instant tooltips</strong>, 1-click fixes, and quick keyword additions.</p>\n\n<p>? <strong>Track progress</strong> with satisfying visual checkmarks.</p>\n\n<p>Update to AIOSEO 4.8.6 today and take the guesswork out of SEO!</p>','success','[\"4-x\",\"lite\"]',1298,NULL,'2025-08-27 00:00:00',NULL,'Learn More','https://aioseo.com/site-audit-announcement/?utm_source=WordPress&utm_medium=plugin-notification&utm_campaign=486-v4-x-lite','Get AIOSEO Pro','https://aioseo.com/lite-upgrade/?utm_source=WordPress&utm_medium=plugin-notification&utm_campaign=486-v4-x-lite',0,0,'2025-09-01 03:51:40','2025-09-21 19:12:01');" );
   }
2. sejas

   added a commit that references this issue on Oct 8, 2025

   Fix file encoding like: WordPress/sqlite-database-integration#250

   d897a9e
3. sejas commented on Oct 8, 2025

   

   sejas

   on Oct 8, 2025

   More actions

   While working on Automattic/wp-cli-sqlite-command#13 , I found that the error of this issue was also related to the encoding of the file.

   I fixed it by converting the encoding to UTF-8 when needed Automattic/wp-cli-sqlite-command@d897a9e

   Here is the error I got when not converting the encoding:

   Error: SQLite import could not execute statement: INSERT INTO `wp_aioseo_notifications` (`id`, `slug`, `addon`, `title`, `content`, `type`, `level`, `notification_id`, `notification_name`, `start`, `end`, `button1_label`, `button1_action`, `button2_label`, `button2_action`, `dismissed`, `new`, `created`, `updated`) VALUES (4,'68b5184c74ce5',NULL,'Introducing Site Audit in AIOSEO 4.8.6','<p>Tired of guessing why your website isn�t ranking higher? Or frustrated by SEO tools that give you too much data but no clear answers?</p>\n\n<p>We�ve supercharged our SEO Analyzer to give you crystal-clear insights and action steps�right inside your WordPress dashboard!</p>\n\n<p>Now you can:</p>\n\n<p>? Scan your <strong>entire site</strong> for common SEO issues.</p>\n\n<p>? View issues <strong>page-by-page</strong> or <strong>by issue type</strong>.</p>\n\n<p>? <strong>Get instant tooltips</strong>, 1-click fixes, and quick keyword additions.</p>\n\n<p>? <strong>Track progress</strong> with satisfying visual checkmarks.</p>\n\n<p>Update to AIOSEO 4.8.6 today and take the guesswork out of SEO!</p>','success','[\"4-x\",\"lite\"]',1298,NULL,'2025-08-27 00:00:00',NULL,'Learn More','https://aioseo.com/site-audit-announcement/?utm_source=WordPress&utm_medium=plugin-notification&utm_campaign=486-v4-x-lite','Get AIOSEO Pro','https://aioseo.com/lite-upgrade/?utm_source=WordPress&utm_medium=plugin-notification&utm_campaign=486-v4-x-lite',0,0,'2025-09-01 03:51:40','2025-09-21 19:12:01');
       at SQLImporter.importDatabase (/Users/macbookpro/Documents/projects-m3.nosync/studio/dist/main/index.js:14424:17)
       at async SQLImporter.import (/Users/macbookpro/Documents/projects-m3.nosync/studio/dist/main/index.js:14638:7)
       at async importBackup (/Users/macbookpro/Documents/projects-m3.nosync/studio/dist/main/index.js:15807:12)
       at async importSite (/Users/macbookpro/Documents/projects-m3.nosync/studio/dist/main/index.js:16264:20)
   
4. JanJakes

   closed this as completedon Oct 10, 2025