Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
2 registered (driv, Outdoorking), 40 Guests and 14 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 11/22/06
Posts: 163
Top Posters (30 Days)
Ruben 51
DennyP 24
Gizmo 24
Dunny 15
SteveS 14
AllenAyres 12
dbremer 10
SD 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
#20617 - 12/02/01 06:52 PM MySQL problem
Anonymous
Unregistered

Hi,

I moved to a new server and I re-install my forum.
Everything seems to be working fine except when I go to the main menu I get this error:
</font><blockquote><font size="1" face="">quote:</font><hr /><font size="" face="">
SQL ERROR: Unable to do_query: SELECT Bo_Title,Bo_Description,Bo_Keyword,Bo_Total,Bo_Last,Bo_Number,Bo_Moderated,Bo_Read_Perm,Bo_Write_Perm,Bo_Threads,Bo_Sorter,Bo_Poster FROM w3t_Boards WHERE Bo_Cat = 1 AND (Bo_Read_Perm LIKE '%-3-%' OR Bo_Read_Perm LIKE '%-1-%') ORDER BY Bo_Sorter
Unknown column 'Bo_Poster' in 'field list': 1054
Warning: Supplied argument is not a valid MySQL result resource in /home/www/mysite/forum/mysql.inc.php on line 83
</font><hr /></blockquote><font size="" face="">and non of the category shows up.
All the admin menu works fine I can add and edit the forum without any problem.

Any Idea <img border="0" title="" alt="[Confused]" src="images/icons/confused.gif" />

Thanks
Top
#20618 - 12/02/01 07:41 PM Re: MySQL problem
Anonymous
Unregistered

Moved this thread from the UBB Post Installation support forum.

Original thread (now closed) can be viewed here

Doug
Moderator: Cool Customers
Captain Kirk: "Once again we've saved civilization as we know it."
Dr. McCoy: "And the good news is they're not going to prosecute."
Top
#20619 - 12/02/01 07:53 PM Re: MySQL problem
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
This looks like you are running a newer version of UBBThreads on the new server. It is saying that the Bo_Poster column is unknown and this field was added in 5.4.4. You will need to find out what version you were running and what version you are running and then run the necessary altertable files from the UPGRADING doc to get your database current.

-------------------
Rick Baker
UBBThreads developer
Top
#20620 - 12/02/01 09:33 PM Re: MySQL problem
Anonymous
Unregistered

Thanks, I got that resolved.

I forgot how to remove the Powered by UBB... at the bottom.

Also, next to the navigation buttoms there is also a text for each bottom. Like add post buttom there is "add post" in text next to the image. how do I remove the text?

Thanks
Top
#20621 - 12/05/01 09:27 PM Re: MySQL problem
Anonymous
Unregistered

Anyone? Any Idea???? <img border="0" title="" alt="[Confused]" src="images/icons/confused.gif" />
Top
#20622 - 12/06/01 12:00 AM Re: MySQL problem
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
All the text is stored in the language files. If you open up the generic.php language file you will see a section that is commented for what you are trying to achieve. Basically you just need to comment out the section where it describes to get rid of the navigation words.

-------------------
Rick Baker
UBBThreads developer
Top



Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Due Date Calculator-Calculate When Your Baby is Due
by StewartMyduedate
Today at 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