Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
6 registered members (Ruben, peter gariepy, Gizmo, Basil, jbergmann, Geoff), 54 guests, and 395 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Gizmo
Gizmo
Portland, OR; USA
Posts: 16,830
Joined: June 2006
Show All Member Profiles 
Top Posters(30 Days)
isaac 53
Gizmo 40
Geoff 32
Morgan 30
ECNet 17
Ruben 12
Mark S 11
JAISP 10
Bert 8
Latest Photos
Chinese Buddhist temple.
My buddha beads.
Rendered Walls
Multi-Screen wallpaper
Stockholm Metro
Previous Thread
Next Thread
Print Thread
Version 7.1.1 Server Migration Issues #218776
11/05/08 02:46 AM
11/05/08 02:46 AM
Joined: Jan 2004
Posts: 39
Chicago
J
Jim Offline OP
newbie
Jim  Offline OP
newbie
J
Joined: Jan 2004
Posts: 39
Chicago
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?



Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
Re: Version 7.1.1 Server Migration Issues [Re: Jim] #218787
11/05/08 11:29 AM
11/05/08 11:29 AM
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline
Former Developer
Rick  Offline
Former Developer
R
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
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.

Re: Version 7.1.1 Server Migration Issues [Re: Rick] #218826
11/05/08 08:49 PM
11/05/08 08:49 PM
Joined: Jan 2004
Posts: 39
Chicago
J
Jim Offline OP
newbie
Jim  Offline OP
newbie
J
Joined: Jan 2004
Posts: 39
Chicago
Thanks Rick!
I'm working on the upgrade, but need to change the way 7.4 performs search before we can implement.


Re: Version 7.1.1 Server Migration Issues [Re: Jim] #218827
11/05/08 09:35 PM
11/05/08 09:35 PM
Joined: Jun 2006
Posts: 16,830
Portland, OR; USA
Gizmo Online tapedshut
UBB.threads Developer
Gizmo  Online Tapedshut
UBB.threads Developer
Joined: Jun 2006
Posts: 16,830
Portland, OR; USA
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.
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!
Re: Version 7.1.1 Server Migration Issues [Re: Gizmo] #218828
11/06/08 12:53 AM
11/06/08 12:53 AM
Joined: Jan 2004
Posts: 39
Chicago
J
Jim Offline OP
newbie
Jim  Offline OP
newbie
J
Joined: Jan 2004
Posts: 39
Chicago
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

Re: Version 7.1.1 Server Migration Issues [Re: Jim] #218829
11/06/08 04:50 AM
11/06/08 04:50 AM
Joined: Nov 2006
Posts: 3,390
ntdoc Offline
Carpal Tunnel
ntdoc  Offline
Carpal Tunnel
Joined: Nov 2006
Posts: 3,390
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.


Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Active Links - reduce the length?
by peter gariepy. 01/22/18 12:53 AM
Upgrading from 7.6.0 to 7.6.1
by Baldeagle. 01/20/18 01:07 PM
Odd behavior with marking forums as read
by Baldeagle. 01/20/18 12:51 PM
Subscription Pending Auto Update to Active
by Geoff. 01/18/18 09:04 AM
7.6.1.1 Custom Tag Editor (YouTube)
by Mark S. 01/15/18 02:58 PM
Forum Statistics
Forums36
Topics35,050
Posts190,785
Members12,051
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.1.1