DB error when setting up 6.3

Print Thread

Hop To

#168602 11/19/2006 11:41 PM

Joined: Nov 2006

Posts: 15

EAST HAVEN, CT

1QuickSI

stranger

1QuickSI

stranger

Joined: Nov 2006

Posts: 15

EAST HAVEN, CT

Trying to refamiliarize myself with UBBThreads and went to setup a new test board but I keep getting the following error message once everything is run:

Code

SQL ERROR: Unable to do_query: SELECT t1.Bo_Title,t1.Bo_Description,t1.Bo_Keyword,t1.Bo_Total,t1.Bo_Last,t1.Bo_Number,t1.Bo_Moderated,t1.Bo_Read_Perm,t1.Bo_Write_Perm,t1.Bo_Threads,t1.Bo_Sorter,t1.Bo_Posterid,t1.Bo_LastMain,t1.Bo_LastNumber,t2.U_Username,t3.B_Subject,t3.B_Icon,t3.B_Reged,t3.B_AnonName FROM w3t_Boards AS t1 LEFT JOIN w3t_Users AS t2 ON t1.Bo_Posterid = t2.U_Number LEFT JOIN w3t_Posts AS t3 ON t1.Bo_LastNumber = t3.B_Number WHERE t1.Bo_Cat = 1 AND (t1.Bo_Posterid = t2.U_Number OR t1.Bo_Posterid = '0') AND (t1.Bo_LastNumber = t3.B_Number OR t1.Bo_LastNumber ='0') AND (t1.Bo_Read_Perm LIKE '%-3-%' OR t1.Bo_Read_Perm LIKE '%-1-%') ORDER BY t1.Bo_Sorter 
Table 'boardname.w3t_Boards' doesn't exist
Warning: Supplied argument is not a valid MySQL result resource in /usr/local/path/to//ubbthreads/mysql.inc.php on line 131

Ideas of what went wrong?

Re: DB error when setting up 6.3 1QuickSI #168603 11/20/2006 12:16 AM
Joined: Jun 2006 Posts: 9,242 Likes: 1 Aberdeen, WA R Rick Former Developer
Rick Former Developer R Joined: Jun 2006 Posts: 9,242 Likes: 1 Aberdeen, WA	What are you clicking on when you get this message? It seems to be that the tables aren't being created. Are you getting any error s when running the createtable.php script?

Re: DB error when setting up 6.3 1QuickSI #168627 11/20/2006 10:40 AM
Joined: Nov 2006 Posts: 15 EAST HAVEN, CT 1 1QuickSI stranger
1QuickSI stranger 1 Joined: Nov 2006 Posts: 15 EAST HAVEN, CT	If I try to run createtable.php it tells me that this was already done. If I just go to the front page I get Warning: Supplied argument is not a valid MySQL result resource in /path/to/ubbthreads/mysql.inc.php on line 131 The above error is when I login and try to view the main index

Re: DB error when setting up 6.3 1QuickSI #168646 11/20/2006 5:28 PM
Joined: Jun 2006 Posts: 16,299 Likes: 116 Portland, OR; USA Gizmo
Gizmo Joined: Jun 2006 Posts: 16,299 Likes: 116 Portland, OR; USA	If theres nothing of value in the database, i'd recommend dropping it then running createtables.php again. 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

UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support DB error when setting up 6.3