Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Jun 2002
Posts: 7
Lurker
Lurker
Offline
Joined: Jun 2002
Posts: 7
Howdy,

A user sent me this error, and I can recreate it as well...

After submitting a "Notify Moderator of this post", it gives a page that returns to the forum. This page, if you let it run until it automatically sends you back to the forum works fine, but if you click the link that sends you back I get this error:

SQL ERROR: Unable to do_query: SELECT B_Main FROM w3t_Posts WHERE B_Number =
You have an error in your SQL syntax near '' at line 5
Warning: Supplied argument is not a valid MySQL result resource in /usr/www/users/amazz20/ubbthreads/mysql.inc.php on line 83

This happened on a 6.0 as well as 6.0 br2...

Maybe a little nit picky, but just trying to either get help, or give some

Sponsored Links
Joined: Mar 2002
Posts: 305
Enthusiast
Enthusiast
Offline
Joined: Mar 2002
Posts: 305
Confirmed here as well.

The link "Return to Forum" is coded:

code:
http://www.yoursite.com/ubbthreads/showflat.php?Cat=&Board=ABC&Number=&page=0&view=collapsed&sb=5&o=&fpart=1&vc=1



I think the problem is that it's missing the thread number after [:"red"]&Number=[/].

Last edited by Lisa_P; 06/13/2002 12:48 AM.

[:"red"]Lisa[/]
Joined: Sep 1999
Posts: 76
Power User
Power User
Offline
Joined: Sep 1999
Posts: 76
In templates/default/donotifymod.tmpl, line 26, change:

<a href="{$config['phpurl']}/$what.php?Cat=$Cat&Board=$Board&Number=$Mnumber&page=$page&view=$view&sb=$sb&o=$o&fpart=$fpart&vc=$vc">

to

<a href="{$config['phpurl']}/$what.php?Cat=$Cat&Board=$Board&Number=$Number&page=$page&view=$view&sb=$sb&o=$o&fpart=$fpart&vc=$vc">

It was a typo with $Number being $Mnumber.

Joined: Apr 2002
Posts: 1,768
Addict
Addict
Offline
Joined: Apr 2002
Posts: 1,768
Another place where error_reporting((E_ALL) would have automatically found the mistake.

Joined: Jun 2002
Posts: 7
Lurker
Lurker
Offline
Joined: Jun 2002
Posts: 7
Thank you all for the help It's working fine now

Sponsored Links
Joined: Dec 2000
Posts: 1,471
Addict
Addict
Offline
Joined: Dec 2000
Posts: 1,471
this one is still in 6.01

Joined: May 1999
Posts: 3,039
Guru
Guru
Offline
Joined: May 1999
Posts: 3,039
Yes, any threads that didn't get closed didn't make it into 6.0.1. There were so many fixes done that I really needed to push out the changes so far.


UBB.threads Developer
Joined: Mar 2002
Posts: 305
Enthusiast
Enthusiast
Offline
Joined: Mar 2002
Posts: 305
Just a note to anyone that didn't change this yet, the fix didn't make it into 6.0.2, so you need to make the above change or the link won't work.


[:"red"]Lisa[/]
Joined: May 1999
Posts: 3,039
Guru
Guru
Offline
Joined: May 1999
Posts: 3,039
I got this in for the next release this time


UBB.threads Developer

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)