Previous Thread
Next Thread
Print Thread
Hop To
Joined: Jan 2004
Posts: 41
J
Jim
Offline
Newbie
Newbie
J Offline
Joined: Jan 2004
Posts: 41
We recently moved our 7.1.1 installation from a BSD server to a Windows 2008 server. MySQL logs are reporting the following error: oursite.com\libs\ubbthreads.inc.php - Line: 2034
replace into ubbt_CACHED_PERMISSIONS
(USER_ID,CACHED_PERMISSION_DATA,CACHED_TIMESTAMP)
values
( 'deleted' , 'a:40:{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:\"0\";s:5:\"reply\";s:1:\"0\";}i:26;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:27;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:28;a:3:{s:4:\"read\";s:1:\"1\";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:\"0\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:34;a:3:{s:4:\"read\";s:1:\"0\";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:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:37;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:38;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:39;a:3:{s:4:\"read\";s:1:\"1\";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:5;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:7;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:\"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\";}}' , '1225866100' )
- Incorrect integer value: 'deleted' for column 'USER_ID' at row 1


Any suggestions?



Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
This was a bug in 7.1.1 and Windows servers. The cookie being sent was set to deleted instead of an actual number. This happens in a few scripts, so upgrading is really the only route to fix these.

Joined: Jan 2004
Posts: 41
J
Jim
Offline
Newbie
Newbie
J Offline
Joined: Jan 2004
Posts: 41
Thanks Rick!
I'm working on the upgrade, but need to change the way 7.4 performs search before we can implement.


Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
IIRC, 7.4 searches the same way as all 7.x...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Jan 2004
Posts: 41
J
Jim
Offline
Newbie
Newbie
J Offline
Joined: Jan 2004
Posts: 41
Gizmo,

In order to implement 7.1.1 for our forums, I had to hack the search template to prevent members from searching multiple forums.
In my 7.3.1 test site, search is dramatically different. The search pull-down defaults keyword search to all forums. I'm leaning towards forcing the Advanced Search and making similar hacks that prevent users from searching multiple forums/categories. It would be nice if this was a Control Panel option, since VBulletin reportedly has it.

Jim

Joined: Nov 2006
Posts: 3,095
Likes: 1
Carpal Tunnel
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095
Likes: 1
Wondering why that is. On our board we can search the entire database for the past 9 years and the search comes back typically in a second or less unless the board is really busy then it might take 2 to 3 seconds.

We may not have quite as many posts as you but we do have many 50K+ size posts of programming code which is a lot more dense code to search.


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
3 members (rootman, Gizmo, Nightcrawler), 562 guests, and 186 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)