Previous Thread
Next Thread
Print Thread
Rate Thread
#260663 10/14/2003 11:02 PM
Joined: May 2002
Posts: 362
Junior Member
Junior Member
Offline
Joined: May 2002
Posts: 362
I'm playing around on my test site, and I have 4 or so users. All me.

When I log in as just this one account, I get the following errors:

SQL ERROR:
You have an error in your SQL syntax near ') ORDER BY t1.Bo_Sorter ' at line 9
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/psa/home/vhosts/ourfreerein.com/httpdocs/xtestxthreads/mysql.inc.php on line 133
SQL ERROR:
You have an error in your SQL syntax near ') ORDER BY t1.Bo_Sorter ' at line 9
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/psa/home/vhosts/ourfreerein.com/httpdocs/xtestxthreads/mysql.inc.php on line 133



And, none of the forums and categories show.

But, for all my others users, it does. This is 6.4b1

Anyone know what this is about?

-peter

Sponsored Links
adrienne48 #260664 10/14/2003 11:17 PM
Joined: Aug 2000
Posts: 1,609
Addict
Addict
Offline
Joined: Aug 2000
Posts: 1,609
Yeah. You have a SQL error near lines 9 and 133 of mysql.inc.php

eslmix #260665 10/14/2003 11:20 PM
Joined: May 2002
Posts: 362
Junior Member
Junior Member
Offline
Joined: May 2002
Posts: 362
lmfao! I don't get why it'd be just for one user though??

Thanks for the brilliant insight though

adrienne48 #260666 10/14/2003 11:21 PM
Joined: Aug 2000
Posts: 1,609
Addict
Addict
Offline
Joined: Aug 2000
Posts: 1,609
Hey man...anytime. Anytime.

eslmix #260667 10/14/2003 11:26 PM
Joined: May 2002
Posts: 362
Junior Member
Junior Member
Offline
Joined: May 2002
Posts: 362
Heh, I hope that bastard error pops up on you. Then we'll see who's laughing


Sponsored Links
adrienne48 #260668 10/14/2003 11:27 PM
Joined: Apr 2002
Posts: 1,768
Addict
Addict
Offline
Joined: Apr 2002
Posts: 1,768
Is that the full error message? It should display the complete query.

joeuser #260669 10/14/2003 11:28 PM
Joined: May 2002
Posts: 362
Junior Member
Junior Member
Offline
Joined: May 2002
Posts: 362
That user doesn't have admin powers, what do I need to put in for it to do that?

adrienne48 #260670 10/15/2003 10:27 AM
Joined: Apr 2002
Posts: 1,768
Addict
Addict
Offline
Joined: Apr 2002
Posts: 1,768
That's strange. If the user is not an admin, then it should display the "visible only to admin" message instead of the actual error.

If the user is an admin, the actual error should both be displayed, and stored in the MySQL error log viewable from the admin page.

joeuser #260671 10/28/2003 12:37 AM
Joined: May 2002
Posts: 362
Junior Member
Junior Member
Offline
Joined: May 2002
Posts: 362
Dave, or anyone!

I've tracked it down a bit more. The forum is fine for admins, all posts, and forums accessible like normal. However, for any regular user, the forums/posts are completely inaccessible.

The errors are:
Code
 <br />Unable to do_query: SELECT t1.Bo_Title,t1.Bo_Description,t1.Bo_Keyword, <br />t1.Bo_Total,t1.Bo_Last,t1.Bo_Number,t1.Bo_Moderated, <br />t1.Bo_Read_Perm,t1.Bo_Write_Perm,t1.Bo_Threads, <br />t1.Bo_Sorter,t1.Bo_Posterid,t1.Bo_LastMain, <br />t1.Bo_LastNumber,t2.U_Username,t3.B_Subject, <br />t3.B_Icon,t3.B_Reged,t3.B_AnonName,t1.Bo_Image <br />FROM w3t_Boards AS t1 LEFT JOIN w3t_Users AS t2 <br />ON t1.Bo_Posterid = t2.U_Number <br />LEFT JOIN w3t_Posts AS t3 ON t1.Bo_LastNumber = <br />t3.B_Number WHERE t1.Bo_Cat = 2 AND <br />(t1.Bo_Posterid = t2.U_Number OR t1.Bo_Posterid = '0') <br /> AND (t1.Bo_LastNumber = t3.B_Number <br />OR t1.Bo_LastNumber ='0') AND () <br />ORDER BY t1.Bo_Sorter <br />- You have an error in your SQL syntax near ') <br />ORDER BY t1.Bo_Sorter ' at line 9 <br /> <br />


And, it throws that error twice. It's 6.4b1, and I've modified some of the header stuff by adding global variables....

Any ideas on what's wrong? Or how I can fix it?

test board here

Then you could log in and see with
user: test
pass: test

Thanks!

adrienne48 #260672 10/28/2003 12:46 AM
Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
I've got no idea.

First I'd try with clean scripts - just to make sure that there's no bugs in whatever hacks there are.

Did you run the altertables? Any errors with those?

Sponsored Links
Daine #260673 10/28/2003 12:48 AM
Joined: May 2002
Posts: 362
Junior Member
Junior Member
Offline
Joined: May 2002
Posts: 362
No, and that's what weird. The board works completely as an admin, and as a guest. But login not as admin, and bam.

It's gotta be the cool nav system I'm working on dammit. grrrr.

Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
Group query - those members aren't a member of any user groups.

Check the config file and make sure users are being added to the user group.

But I think the regular user groups are blank.

Daine #260675 10/28/2003 2:47 AM
Joined: May 2002
Posts: 362
Junior Member
Junior Member
Offline
Joined: May 2002
Posts: 362
Josh! You're my hero!

How that happened, I have no clue. But yeah, in the config file, the new users weren't being put into a group...

WOOHOO!

So my nav system works. Hehehehe....


Thanks!

Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
It took me a bit, but when I wanted to kick someone out of a board, I used to remove all their groups so they just saw errors.


Daine #260677 10/28/2003 3:27 PM
Joined: May 2002
Posts: 362
Junior Member
Junior Member
Offline
Joined: May 2002
Posts: 362
Heh, that's not a bad idea.... Although, now when I want to ban people, I just add em' to a group where there's just one forum that displays saying we've closed due to financial issues.... lol

Though, I like this, show em' only errors business. hehehe.


Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
isaac
isaac
California
Posts: 1,157
Joined: July 2001
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)