Hi I have just had the forum moved over to MySQL version 5 in the last couple of days and I am getting this one error that repeats itself which I am listing below. Also note that I am running UBB version 7.2.2
Script: e:\inetpub\esvc000047\forum\libs\ubbthreads.inc.php - Line: 2126
replace into ubbt_CACHED_PERMISSIONS
(USER_ID,CACHED_PERMISSION_DATA,CACHED_TIMESTAMP)
values
( 'deleted' , 'a:80:{i:1;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:10;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:11;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:12;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:13;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:14;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:15;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:16;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:17;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:18;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:19;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:2;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:20;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:21;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:22;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:23;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:24;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:25;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"1\";s:5:\"reply\";s:1:\"1\";}i:26;a:3:{s:4:\"read\";s:1:\"0\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:27;a:3:{s:4:\"read\";s:1:\"0\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:28;a:3:{s:4:\"read\";s:1:\"0\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:29;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:3;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:30;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:31;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:32;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:33;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:34;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:35;a:3:{s:4:\"read\";s:1:\"0\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:36;a:3:{s:4:\"read\";s:1:\"0\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:37;a:3:{s:4:\"read\";s:1:\"0\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:38;a:3:{s:4:\"read\";s:1:\"0\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:39;a:3:{s:4:\"read\";s:1:\"0\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:4;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:40;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:41;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:42;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:43;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:44;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:45;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:46;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:47;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:48;a:3:{s:4:\"read\";s:1:\"0\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:49;a:3:{s:4:\"read\";s:1:\"0\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:5;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:50;a:3:{s:4:\"read\";s:1:\"0\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:51;a:3:{s:4:\"read\";s:1:\"0\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:52;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:53;a:3:{s:4:\"read\";s:1:\"0\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:54;a:3:{s:4:\"read\";s:1:\"0\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:55;a:3:{s:4:\"read\";s:1:\"0\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:56;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:57;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:58;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:59;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:6;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:60;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:61;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:62;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:63;a:3:{s:4:\"read\";s:1:\"0\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:64;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:65;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:66;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:67;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:68;a:3:{s:4:\"read\";s:1:\"0\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:69;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:7;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:70;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:71;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:72;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:73;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:74;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:75;a:3:{s:4:\"read\";s:1:\"0\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:76;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"1\";}i:77;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:78;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"1\";}i:79;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:8;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:80;a:3:{s:4:\"read\";s:1:\"0\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:9;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}}' , '1208275914' )
- Incorrect integer value: 'deleted' for column 'USER_ID' at row 1
Any help would be appreciated on how this can be stoped as it is annoying.
