Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
3 registered members (Gizmo, isaac, KirkW), 78 guests, and 221 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Bad Frog
Bad Frog
Coast of Maine
Posts: 749
Joined: May 2008
Show All Member Profiles 
Top Posters(30 Days)
isaac 22
Gizmo 18
TheBrit 14
Zarzal 12
SteveS 8
Ruben 4
jorb 4
Latest Photos
Test
Testing to drag photos
Comfortable Cats
Test
BSA photos
Previous Thread
Next Thread
Print Thread
[FIXED for 7.1b5] SQL errors #173662
01/15/07 05:05 PM
01/15/07 05:05 PM
G
gliderdad  Offline OP
veteran
Joined: Jun 2006
Posts: 1,475
NY
I upgraded to latest beta version on my test site. I am getting a bunch of sql erros.

Code
Script: /home/glidercentral/htdocs/ubbthreads/libs/ubbthreads.inc.php - Line: 2171 
select
t2.USER_TIME_OFFSET,t2.USER_TOPIC_VIEW_TYPE,t2.USER_TIME_FORMAT,t1.USER_DISPLAY_NAME,t1.USER_PASSWORD,t1.USER_SESSION_ID, t1.USER_MEMBERSHIP_LEVEL, t2.USER_TOTAL_PM, t1.USER_ID, t1.USER_IS_BANNED,t1.USER_IS_UNDERAGE, t2.USER_STYLE,t2.USER_HIDE_LEFT_COLUMN,t2.USER_HIDE_RIGHT_COLUMN,t2.USER_LANGUAGE,t2.USER_MOOD,t2.USER_RELATIVE_TIME
from ubbt_USERS AS t1,
ubbt_USER_PROFILE as t2
where t1.USER_ID = ''
and t1.USER_ID = t2.USER_ID
- Unknown column 't2.USER_LANGUAGE' in 'field list'

Script: /home/glidercentral/htdocs/ubbthreads/scripts/postlist.inc.php - Line: 203 
SELECT FORUM_TITLE,FORUM_DESCRIPTION,FORUM_ID,FORUM_POSTS,FORUM_LAST_POST_TIME,FORUM_IS_MODERATED,FORUM_TOPICS,FORUM_SORT_ORDER,FORUM_LAST_POSTER_ID,FORUM_LAST_TOPIC_ID,FORUM_LAST_POST_ID,FORUM_LAST_POSTER_NAME,FORUM_LAST_POST_SUBJECT,FORUM_LAST_POST_ICON,FORUM_IMAGE,CATEGORY_ID,FORUM_PARENT,FORUM_IMAGE
FROM ubbt_FORUMS
WHERE FORUM_IS_ACTIVE = '1'
AND FORUM_ID IN ()
ORDER BY FORUM_SORT_ORDER
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
ORDER BY FORUM_SORT_ORDER' at line 4


Need a little help here. The second one won't let users post, no rush like I said its on my test site.

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: SQL errors [Re: gliderdad] #173664
01/15/07 05:07 PM
01/15/07 05:07 PM
G
gliderdad  Offline OP
veteran
Joined: Jun 2006
Posts: 1,475
NY
Also when the error message comes back

Quote:
You do not have permssions to create a new topic on this forum.

Please use your back button to return to the previous page.


Permission is spelt wrong

Re: SQL errors [Re: gliderdad] #173666
01/15/07 05:09 PM
01/15/07 05:09 PM
R
Rick  Offline
Former Developer
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
Did you run through the install/upgrade.php script? The first error is a missing field that was added in the step where it alters the database.

Re: SQL errors [Re: gliderdad] #173667
01/15/07 05:11 PM
01/15/07 05:11 PM
jgeoff  Offline
Pooh-Bah
Joined: Aug 2006
Posts: 1,944
NJ

Rick - the original post above is not auto wrapping/scrolling in IE 6 or 7; it's all out of wack and really, really, really wide...


GangsterBB.NET (Ver. 7.6.1.1)
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
Browsers: Chrome, Firefox, & Safari (iPhone); No IE, ever!
Re: SQL errors [Re: jgeoff] #173668
01/15/07 05:23 PM
01/15/07 05:23 PM
G
gliderdad  Offline OP
veteran
Joined: Jun 2006
Posts: 1,475
NY
Yes the only issue I had during upgrade was had to change a few file permissions in languages/english from 664 to 666. Everything else went through fine

Re: SQL errors [Re: gliderdad] #173671
01/15/07 05:37 PM
01/15/07 05:37 PM
R
Rick  Offline
Former Developer
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
Hmm, did it actually get to the portion where it was altering the database? It should have had a list of approximately 15 steps on this section where each one said OK in green.

Re: SQL errors [Re: Rick] #173672
01/15/07 05:43 PM
01/15/07 05:43 PM
G
gliderdad  Offline OP
veteran
Joined: Jun 2006
Posts: 1,475
NY
Yes and everything said ok

Last edited by gliderdad; 01/15/07 05:44 PM.
Re: SQL errors [Re: gliderdad] #173674
01/15/07 05:45 PM
01/15/07 05:45 PM
R
Rick  Offline
Former Developer
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
Ok, try this. Try running the following SQL command and see what fields are actually in your USER_PROFILE table, there should have been several added:

show fields from ubbt_USER_PROFILE

Re: SQL errors [Re: Rick] #173677
01/15/07 05:51 PM
01/15/07 05:51 PM
G
gliderdad  Offline OP
veteran
Joined: Jun 2006
Posts: 1,475
NY
checked wrong board, brb

Last edited by gliderdad; 01/15/07 05:51 PM.
Re: SQL errors [Re: gliderdad] #173678
01/15/07 05:51 PM
01/15/07 05:51 PM
R
Rick  Offline
Former Developer
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
Ok, do you see these fields in the list?

USER_CUSTOM_TITLE
USER_LANGUAGE
USER_MOOD
USER_REPORT_POST_NOTIFY
USER_RELATIVE_TIME

Re: SQL errors [Re: Rick] #173680
01/15/07 05:56 PM
01/15/07 05:56 PM
G
gliderdad  Offline OP
veteran
Joined: Jun 2006
Posts: 1,475
NY
57 feilds, Yes I see them. Here is the list
Quote:
USER_ID int(9) PRI 0
USER_REAL_EMAIL varchar(50) MUL
USER_DISPLAY_EMAIL varchar(50) YES
USER_SIGNATURE text YES
USER_DEFAULT_SIGNATURE text YES
USER_HOMEPAGE varchar(150) YES
USER_OCCUPATION varchar(150) YES
USER_HOBBIES varchar(200) YES
USER_LOCATION varchar(200) YES
USER_START_VIEW varchar(20) cfrm
USER_FAVORITES_TAB varchar(10) forums
USER_FAVORITES_SORT varchar(10) reply
USER_TOPIC_VIEW_TYPE varchar(10) flat
USER_TOPICS_PER_PAGE int(1) YES
USER_NOTIFY_ON_PM char(3) no
USER_ICQ varchar(200) YES
USER_YAHOO varchar(200) YES
USER_MSN varchar(200) YES
USER_AIM varchar(200) YES
USER_EXTRA_FIELD_1 varchar(200) YES
USER_EXTRA_FIELD_2 varchar(200) YES
USER_EXTRA_FIELD_3 varchar(200) YES
USER_EXTRA_FIELD_4 varchar(200) YES
USER_EXTRA_FIELD_5 varchar(200) YES
USER_AVATAR varchar(150) YES
USER_SHOW_AVATARS tinyint(1) 1
USER_VISIBLE_ONLINE_STATUS char(3) YES yes
USER_ACCEPT_PM char(3) YES yes
USER_EMAIL_WATCHLISTS tinyint(1) 0
USER_TITLE varchar(100) YES
USER_POSTS_PER_TOPIC char(2) YES
USER_TEMPORARY_PASSWORD varchar(32) YES
USER_NAME_COLOR varchar(15) YES
USER_TIME_OFFSET varchar(10) YES
USER_TOTAL_PM int(4) YES 0
USER_TOTAL_POSTS int(9) YES 0
USER_SHOW_SIGNATURES char(3) YES
USER_RATING int(1) YES
USER_TOTAL_RATES mediumint(6) 0
USER_AVATAR_WIDTH int(4) YES 0
USER_AVATAR_HEIGHT int(4) YES 0
USER_ACCEPT_ADMIN_EMAILS char(3) YES
USER_BIRTHDAY varchar(10) MUL 0
USER_PUBLIC_BIRTHDAY int(1) 0
USER_TIME_FORMAT varchar(30) YES
USER_IGNORE_LIST text YES
USER_FLOOD_CONTROL_OVERRIDE mediumint(8) YES
USER_STYLE mediumint(4) 0
USER_UNAPPROVED_POST_NOTIFY tinyint(1) 0
USER_TEXT_EDITOR varchar(10) YES standard
USER_HIDE_LEFT_COLUMN tinyint(1) 1
USER_HIDE_RIGHT_COLUMN tinyint(1) 1
USER_CUSTOM_TITLE varchar(255) YES
USER_LANGUAGE varchar(50) YES
USER_MOOD varchar(50) YES
USER_REPORT_POST_NOTIFY tinyint(1) 0
USER_RELATIVE_TIME tinyint(1) YES

Last edited by gliderdad; 01/15/07 05:56 PM.
Re: SQL errors [Re: gliderdad] #173682
01/15/07 05:58 PM
01/15/07 05:58 PM
R
Rick  Offline
Former Developer
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
Ok, that doesn't make much sense then. Are you sure the updated code is pointing at the correct database and not a database without the updated fields?

Re: SQL errors [Re: Rick] #173694
01/15/07 06:38 PM
01/15/07 06:38 PM
R
Rick  Offline
Former Developer
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
Ok, so this turned out not to be a missing field problem. The problem is if you have a forum where users can view, but then subforums that they don't have access to. There is a slight change that needs to be applied to scripts/postlist.inc.php to fix this.

Line 1186, basically just about at the end, looks like this:

Code
        } // end foreach
        return $inlist;
} // end get_subforums


Just change that, to this:

Code
        } // end foreach
        if (!$inlist) $inlist = "''";
        return $inlist;
} // end get_subforums

Re: SQL errors [Re: Rick] #173725
01/15/07 07:53 PM
01/15/07 07:53 PM
G
gliderdad  Offline OP
veteran
Joined: Jun 2006
Posts: 1,475
NY
Thanks again Rick, all is working good now.

Re: SQL errors [Re: Rick] #173746
01/15/07 09:15 PM
01/15/07 09:15 PM
ntdoc  Offline
Carpal Tunnel
Joined: Nov 2006
Posts: 3,390
So is that considered a bug then Rick?

Re: SQL errors [Re: ntdoc] #173748
01/15/07 09:22 PM
01/15/07 09:22 PM
R
Rick  Offline
Former Developer
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
Yep, definite bug.

Re: SQL errors [Re: Rick] #173750
01/15/07 10:01 PM
01/15/07 10:01 PM
Daryl Fawcett  Offline
addict
Joined: Jun 2006
Posts: 596
Canada
Will that be fixed before the final release of version 7.1 ???

Re: SQL errors [Re: Daryl Fawcett] #173753
01/15/07 10:23 PM
01/15/07 10:23 PM
Gizmo  Online Tapedshut
UBB.threads Developer
Joined: Jun 2006
Posts: 17,017
Portland, OR; USA
Likely, thats what public beta is for lol... Though I wonder if the bug I found the other day is fixed in this public beta or if it's still in the wild... crikey... lol


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.
Need to Upgrade?
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!

Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Calendar Function
by TheBrit. 12/17/18 10:05 PM
Speaking of Http to https, complaints from user
by PianoWorld. 12/16/18 03:40 PM
update multilanguage site problem
by Zarzal. 12/15/18 04:20 PM
Char coding utf-8 and older forums
by Zarzal. 12/15/18 03:59 PM
table issue
by TheBrit. 12/13/18 06:05 PM
Forum Statistics
Forums36
Topics35,182
Posts191,702
Members12,123
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.2