Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
6 registered (Bjab, Stan, Dunny, driv, SteveS, id242), 25 Guests and 14 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 12/25/03
Posts: 125
Top Posters (30 Days)
Ruben 51
Gizmo 24
DennyP 24
Dunny 15
SteveS 14
AllenAyres 12
SD 10
dbremer 10
drkknght00 9
doug 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Topic Options
#201167 - 11/12/07 11:15 AM SQL ERROR: Unable to do_query,
missjada Offline
stranger
Registered: 11/12/07
Posts: 2
Greetings,
I did a search on the subject and could not find anything that was similar to the problem that I was having. I made an attempt to upgrade to the version 7 and now i am receiving the following message. SQL ERROR: Unable to do_query:

Can anyone help?

Thank you


Edited by missjada (11/12/07 11:19 AM)
Top
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."
#201175 - 11/12/07 02:26 PM Re: SQL ERROR: Unable to do_query, [Re: missjada]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Is there anything else to the error, or is that the complete message? If that's it, then it seems to be completely missing the query itself.

What version are you upgrading from?
Top
#201177 - 11/12/07 09:24 PM Re: SQL ERROR: Unable to do_query, [Re: Rick]
missjada Offline
stranger
Registered: 11/12/07
Posts: 2
SQL ERROR: Unable to do_query: SELECT COUNT(*), SUM(B_Topic) FROM w3t_Posts WHERE ( (B_Posted > 1191149392 AND B_Posted <> 4294967295) OR (B_Posted = 4294967295 AND B_Sticky > 1191149392) ) AND B_Approved = 'yes' AND B_Board = 'websites'
SQL ERROR: Unable to do_query: SELECT COUNT(*), SUM(B_Topic) FROM w3t_Posts WHERE ( (B_Posted > 1190663031 AND B_Posted <> 4294967295) OR (B_Posted = 4294967295 AND B_Sticky > 1190663031) ) AND B_Approved = 'yes' AND B_Board = 'personal'


That is the error message that I am receiving and I am upgrading from 6.0.2
Top
#201188 - 11/13/07 01:23 AM Re: SQL ERROR: Unable to do_query, [Re: missjada]
Yarp™ Offline
Registered: 08/30/06
Posts: 1513
Loc: Breda, NL
The upgrade should take palce from either:
UBB.threads 6.5.x
UBB.classic 6.7.x
Your 6.02 install (don't know if you had classic or threads) should be upgraded first to either one of above version (which are available for download in the members area) before the upgrade to the 7.x series.
_________________________
Top
#201191 - 11/13/07 04:18 AM Re: SQL ERROR: Unable to do_query, [Re: Yarp™]
Gizmo Offline

Registered: 06/05/06
Posts: 14995
Loc: Portland, OR; USA
I'm pretty sure that all of the upgrade docs in every location all state UBB.T6.5.x or UBB.C6.7.x as the only real requirement as well...
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Due Date Calculator-Calculate When Your Baby is Due
by StewartMyduedate
12:54 AM
Temporary Password email not being received
by
05/24/12 10:02 PM
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
Forum Stats
10491 Members
36 Forums
33842 Topics
181709 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image