|
Joined: Jun 2006
Posts: 1,344
veteran
|
veteran
Joined: Jun 2006
Posts: 1,344 |
I upgraded to latest beta version on my test site. I am getting a bunch of sql erros.
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.
|
|
|
|
Joined: Jun 2006
Posts: 1,344
veteran
|
veteran
Joined: Jun 2006
Posts: 1,344 |
Also when the error message comes back 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
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
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.
|
|
|
|
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
|
|
|
|
Joined: Jun 2006
Posts: 1,344
veteran
|
veteran
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
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
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.
|
|
|
|
Joined: Jun 2006
Posts: 1,344
veteran
|
veteran
Joined: Jun 2006
Posts: 1,344 |
Yes and everything said ok
Last edited by gliderdad; 01/15/2007 6:44 PM.
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
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
|
|
|
|
Joined: Jun 2006
Posts: 1,344
veteran
|
veteran
Joined: Jun 2006
Posts: 1,344 |
checked wrong board, brb
Last edited by gliderdad; 01/15/2007 6:51 PM.
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
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
|
|
|
|
Joined: Jun 2006
Posts: 1,344
veteran
|
veteran
Joined: Jun 2006
Posts: 1,344 |
57 feilds, Yes I see them. Here is the list 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.
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
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?
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
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:
} // end foreach
return $inlist;
} // end get_subforums
Just change that, to this:
} // end foreach
if (!$inlist) $inlist = "''";
return $inlist;
} // end get_subforums
|
|
|
|
Joined: Jun 2006
Posts: 1,344
veteran
|
veteran
Joined: Jun 2006
Posts: 1,344 |
Thanks again Rick, all is working good now.
|
|
|
|
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?
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
Will that be fixed before the final release of version 7.1 ???
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 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
|
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
1 members (Ruben),
814
guests, and
236
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|