Previous Thread
Next Thread
Print Thread
Hop To
#173662 01/15/2007 6:05 PM
Joined: Jun 2006
Posts: 1,344
G
veteran
veteran
G Offline
Joined: Jun 2006
Posts: 1,344
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.

gliderdad #173664 01/15/2007 6:07 PM
Joined: Jun 2006
Posts: 1,344
G
veteran
veteran
G Offline
Joined: Jun 2006
Posts: 1,344
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

gliderdad #173666 01/15/2007 6:09 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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.

gliderdad #173667 01/15/2007 6:11 PM
Joined: Aug 2006
Posts: 1,649
Likes: 1
Pooh-Bah
Pooh-Bah
Joined: Aug 2006
Posts: 1,649
Likes: 1

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)
PHP Version 5.6.40 / MySQL 5.7.23-23 (was 5.6.41-84.1) / Apache 2.4.54
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
jgeoff #173668 01/15/2007 6:23 PM
Joined: Jun 2006
Posts: 1,344
G
veteran
veteran
G Offline
Joined: Jun 2006
Posts: 1,344
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

gliderdad #173671 01/15/2007 6:37 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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.

Rick #173672 01/15/2007 6:43 PM
Joined: Jun 2006
Posts: 1,344
G
veteran
veteran
G Offline
Joined: Jun 2006
Posts: 1,344
Yes and everything said ok

Last edited by gliderdad; 01/15/2007 6:44 PM.
gliderdad #173674 01/15/2007 6:45 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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

Rick #173677 01/15/2007 6:51 PM
Joined: Jun 2006
Posts: 1,344
G
veteran
veteran
G Offline
Joined: Jun 2006
Posts: 1,344
checked wrong board, brb

Last edited by gliderdad; 01/15/2007 6:51 PM.
gliderdad #173678 01/15/2007 6:51 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Ok, do you see these fields in the list?

USER_CUSTOM_TITLE
USER_LANGUAGE
USER_MOOD
USER_REPORT_POST_NOTIFY
USER_RELATIVE_TIME

Rick #173680 01/15/2007 6:56 PM
Joined: Jun 2006
Posts: 1,344
G
veteran
veteran
G Offline
Joined: Jun 2006
Posts: 1,344
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/2007 6:56 PM.
gliderdad #173682 01/15/2007 6:58 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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?

Rick #173694 01/15/2007 7:38 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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

Rick #173725 01/15/2007 8:53 PM
Joined: Jun 2006
Posts: 1,344
G
veteran
veteran
G Offline
Joined: Jun 2006
Posts: 1,344
Thanks again Rick, all is working good now.

Rick #173746 01/15/2007 10:15 PM
Joined: Nov 2006
Posts: 3,095
Likes: 1
Carpal Tunnel
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095
Likes: 1
So is that considered a bug then Rick?

ntdoc #173748 01/15/2007 10:22 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Yep, definite bug.

Rick #173750 01/15/2007 11:01 PM
Joined: Jun 2006
Posts: 626
Addict
Addict
Joined: Jun 2006
Posts: 626
Will that be fixed before the final release of version 7.1 ???

Daryl Fawcett #173753 01/15/2007 11:23 PM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
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.
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!

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
0 members (), 744 guests, and 147 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)