Previous Thread
Next Thread
Print Thread
Hop To
Joined: Jun 2006
Posts: 67
C
journeyman
journeyman
C Offline
Joined: Jun 2006
Posts: 67
I upgraded today and got this error once I got to the confirmation that the updgrade was complete this happens.

UBB Error
We encountered a problem. The reason reported was

Database error only visible to forum administrators

Please click back to return to the previous page.

Joined: Jun 2006
Posts: 16,301
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,301
Likes: 116
You'll either have to enable MySQL logging and view the log file, or edit the libs/mysql.inc.php file and set the show_errors line to 1.


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!
Joined: Jun 2006
Posts: 67
C
journeyman
journeyman
C Offline
Joined: Jun 2006
Posts: 67
Thanks. I am unable to login but I was able to change the show_errors line to 1. Below is the message.

We encountered a problem. The reason reported was

Script: /var/www/vhosts/jamaicans.com/httpdocs/forums/libs/ubbthreads.inc.php
Line#: 2231
SQL Error: Unknown column 't1.USER_RULES_ACCEPTED' in 'field list'
SQL Error #: 1054
Query: 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,t1.USER_RULES_ACCEPTED from ubbth7_USERS AS t1, ubbth7_USER_PROFILE as t2 where t1.USER_ID = '7741' and t1.USER_ID = t2.USER_ID

Please click back to return to the previous page.

Joined: Jun 2006
Posts: 16,301
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,301
Likes: 116
Did you run install/upgrade.php ?


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!
Joined: Jun 2006
Posts: 67
C
journeyman
journeyman
C Offline
Joined: Jun 2006
Posts: 67
Submitted a ticket and they fixed the db (Thanks Rick). I ran upgrade.php and everything seems to be working fine.


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Version 7.7.5 Images suddenly not displaying
by Stovebolt - 05/04/2024 11:19 AM
Bots
by Outdoorking - 04/13/2024 5:08 PM
Can you add html to language files?
by Baldeagle - 04/07/2024 2:41 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
This is not a bug, but a suggestion
by Baldeagle - 04/05/2024 11:25 PM
Who's Online Now
3 members (ahmed047, Nightcrawler, 1 invisible), 566 guests, and 148 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 20240506)