Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Aug 2002
Posts: 51
Power User
Power User
Offline
Joined: Aug 2002
Posts: 51
OK I have run into two more problems. One I can duplicate here on this site..


Problem 1
--------
I have a help button on my site that I wanted to link straight to my Help category(#8). I assumed the URL would be:
http://www.pokemon-trading-cards.net/ubbthreads/ubbthreads.php?Cat=8

When I use this URL and click on any of the 4 forums therein I start getting SQL errors
SQL ERROR: Unable to do_query: SELECT Bo_Number,Bo_Title,Bo_Keyword,Bo_Cat,Bo_CatName,Bo_Sorter FROM w3t_Boards WHERE (Bo_Read_Perm LIKE '%-3-%' OR Bo_Read_Perm LIKE '%-1-%') AND (Bo_Cat = ) ORDER BY Bo_Cat,Bo_Sorter
You have an error in your SQL syntax near ') ORDER BY Bo_Cat,Bo_Sorter ' at line 5

I noticed that after I used the above url, the cat=8 followed me everywhere, including when I altered my display preferences to show Categories only on the main index.

When I did this and then clicked the main index button from the My Home page, it sent me to
http://www.pokemon-trading-cards.net/ubbthreads/categories.php?Cat=8

where I get more SQL errors

On every page you get these errors, if you change the cat=8 to cat= in the url, the errors go away.

OK, so I was surfing both my site and this one and noticed that in the urls it is always 'cat=' so I wanted to see what url the programming used.. which brings me to

problem 2.
----------
I found the url I should be using is this:
http://www.pokemon-trading-cards.net/ubbthreads/ubbthreads.php?Cat=&C=8

The problem is, for this url to work, you must be logged in AND have your display preferences set to display categories only on the home page

I am able to duplicate this here on ubbdev.com with this url:

https://www.ubbdev.com/threads/php/ubbthreads.php?Cat=&C=2

It does not matter if I am logged in here or not, when I go to the above url I see all categories and all forums.

If I edit my preferences here to show categories only, the above url works and I only see cat2 and related forums

Last edited by webwolfe; 08/26/2002 9:26 PM.
Sponsored Links
Entire Thread
Subject Posted By Posted
Greatly Disappointed webwolfe_dup1 08/24/2002 12:16 AM
Re: Greatly Disappointed AllenAyres 08/24/2002 12:31 AM
Re: Greatly Disappointed AllenAyres 08/24/2002 12:33 AM
Re: Greatly Disappointed msula 08/24/2002 12:37 AM
Re: Greatly Disappointed JoshPet 08/24/2002 4:03 AM
Re: Greatly Disappointed JoshPet 08/24/2002 4:12 AM
Re: Greatly Disappointed webwolfe_dup1 08/24/2002 8:24 AM
Re: Greatly Disappointed webwolfe_dup1 08/24/2002 8:37 AM
Re: Greatly Disappointed JoshPet 08/24/2002 8:42 AM
Re: Greatly Disappointed AllenAyres 08/24/2002 9:29 AM
Re: Greatly Disappointed navaho 08/24/2002 9:29 AM
Re: Greatly Disappointed Gardener 08/24/2002 5:02 PM
Re: Greatly Disappointed Aglavalin 08/25/2002 9:37 AM
Re: Greatly Disappointed webwolfe_dup1 08/25/2002 5:34 PM
Re: Greatly Disappointed AllenAyres 08/26/2002 6:58 AM
Re: Greatly Disappointed navaho 08/26/2002 8:36 PM
Re: Greatly Disappointed webwolfe_dup1 08/26/2002 9:56 PM
Re: Greatly Disappointed webwolfe_dup1 08/27/2002 4:23 AM
Re: Greatly Disappointed navaho 08/27/2002 5:24 AM
Re: Greatly Disappointed navaho 08/27/2002 5:24 AM
Re: Greatly Disappointed JoshPet 08/27/2002 6:26 AM
Re: Greatly Disappointed webwolfe_dup1 08/27/2002 8:00 AM
Re: Greatly Disappointed navaho 08/27/2002 10:23 AM
Re: Greatly Disappointed webwolfe_dup1 08/27/2002 12:43 PM
Re: Greatly Disappointed webwolfe_dup1 08/28/2002 5:22 PM
Re: Greatly Disappointed AllenAyres 08/28/2002 7:58 PM
Re: Greatly Disappointed webwolfe_dup1 08/28/2002 8:27 PM
Re: Greatly Disappointed Aglavalin 08/29/2002 2:20 AM
Re: Greatly Disappointed Dave_L_dup1 08/29/2002 3:13 AM
Re: Greatly Disappointed msula 08/29/2002 3:24 AM
Re: Greatly Disappointed navaho 08/29/2002 6:25 AM
Re: Greatly Disappointed AllenAyres 08/29/2002 8:17 AM
Re: Greatly Disappointed webwolfe_dup1 08/29/2002 8:14 PM
Re: Greatly Disappointed navaho 08/29/2002 10:40 PM
Re: Greatly Disappointed ProStockJohn 04/29/2003 12:08 AM
Re: Greatly Disappointed JoshPet 04/29/2003 3:01 AM
Re: Greatly Disappointed AllenAyres 04/29/2003 3:13 AM
Re: Greatly Disappointed msula 04/29/2003 3:13 AM
Re: Greatly Disappointed AKD96 04/30/2003 12:14 AM
Re: Greatly Disappointed ProStockJohn 04/30/2003 8:26 PM
Re: Greatly Disappointed Astaran 04/30/2003 9:07 PM
Re: Greatly Disappointed msula 04/30/2003 10:29 PM
Re: Greatly Disappointed AKD96 05/01/2003 2:44 AM
Re: Greatly Disappointed Astaran 05/01/2003 2:15 PM
Re: Greatly Disappointed AllenAyres 05/01/2003 4:00 PM
Re: Greatly Disappointed ProStockJohn 05/01/2003 7:16 PM
Re: Greatly Disappointed Ian_W 05/01/2003 8:03 PM
Re: Greatly Disappointed AllenAyres 05/01/2003 8:45 PM
Re: Greatly Disappointed omegatron 05/01/2003 11:47 PM
Re: Greatly Disappointed ProStockJohn 05/04/2003 10:21 PM
Re: Greatly Disappointed JoshPet 05/05/2003 1:41 AM

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
Nettomo
Nettomo
Germany, Bremen
Posts: 417
Joined: November 2001
Forum Statistics
Forums63
Topics37,575
Posts293,932
Members13,824
Most Online6,139
Sep 21st, 2024
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,835
Greg Hard 4,625
Top Posters(30 Days)
Gizmo 2
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2025 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.1
(Snapshot build 20240918)