|
Joined: Jun 2002
Posts: 7
Lurker
|
Lurker
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
|
|
|
|
Joined: Mar 2002
Posts: 305
Enthusiast
|
Enthusiast
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
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
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
Joined: Jun 2002
Posts: 7 |
Thank you all for the help It's working fine now
|
|
|
|
Joined: Dec 2000
Posts: 1,471
Addict
|
Addict
Joined: Dec 2000
Posts: 1,471 |
this one is still in 6.01
|
|
|
|
Joined: May 1999
Posts: 3,039
Guru
|
Guru
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
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
Joined: May 1999
Posts: 3,039 |
I got this in for the next release this time
UBB.threads Developer
|
|
|
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.
|
|
Posts: 5,833
Joined: January 2000
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|