UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support subscriptions problem

I've got my cronjob for doexpire.php running, but when I just tried to do the same for subscriptions.php i got an sql error.
</font><blockquote><font size="1" face="">quote:</font><hr /><font size="" face="">SQL ERROR: Fri, Jan 10 2003 14:28:10 -0500 Database error only visible to forum administrators

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/fordmond/public_html/ubbthreads/mysql.inc.php on line 157
SQL ERROR: Fri, Jan 10 2003 14:28:10 -0500 Database error only visible to forum administrators

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/fordmond/public_html/ubbthreads/mysql.inc.php on line 157
SQL ERROR: Fri, Jan 10 2003 14:28:10 -0500 Database error only visible to forum administrators

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/fordmond/public_html/ubbthreads/mysql.inc.php on line 157
SQL ERROR: Fri, Jan 10 2003 14:28:10 -0500 Database error only visible to forum administrators

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/fordmond/public_html/ubbthreads/mysql.inc.php on line 157
</font><hr /></blockquote><font size="" face="">myself knowing very little about mysql, this leaves me slightly lost.

www.fordmondeo.org
Mondeo Enthusiasts Group

*bump*
should i fill out a support ticket?

www.fordmondeo.org
Mondeo Enthusiasts Group

Those are kinda generic errors. Tough to tell what might be happening.

Do you get the same errors if you try and run it from the browser? Or do you get a blank page?

You might need to adjust the require line in the script to make sure it's finding the threads stuff ok.

Look for this line:

require ("../../main.inc.php");

Josh
Measurection.com Admin | ThreadsDev.com Moderator
Register to see my How To/Site Help Library Forum at ThreadsDev.com.
My threads 'tweaking' abilities are for hire.

i found this in the subscriptions.php

</font><blockquote><font size="1" face="">quote:</font><hr /><font size="" face="">// Require the library
require ("/home/fordmond/public_html/ubbthreads/main.inc.php");
require ("$thispath/languages/${$config['cookieprefix']."w3t_language"}/subscriptions.php");
$html = new html;
$mailer = new mailer;
</font><hr /></blockquote><font size="" face="">shouldnt that be /cron/php/subscriptions.php"); ??

www.fordmondeo.org
Mondeo Enthusiasts Group

No, that's correct.

What are the actual MySQL errors, as shown in your log file?

ok, heres whats in my log file.

</font><blockquote><font size="1" face="">quote:</font><hr /><font size="" face=""> Sun, Jan 12 2003 09:17:14 -0500 /ubbthreads/cron/php/subscriptions.php 62.6.98.81
Unable to do_query: SELECT t1.B_Number,t1.B_Posted,t2.U_Username,t1.B_IP,t1.B_Subject,t1.B_Body FROM w3t_Posts AS t1, w3t_Users AS t2 WHERE t1.B_Number > 89486 AND t1.B_Approved = 'yes' AND t1.B_Board = 'fao' AND t1.B_Posterid = t2.U_Number AND t1.B_Stgatus <> 'M' ORDER BY t1.B_Number ASC - Unknown column 't1.B_Stgatus' in 'where clause'

Sun, Jan 12 2003 09:17:14 -0500 /ubbthreads/cron/php/subscriptions.php 62.6.98.81
Unable to do_query: SELECT t1.B_Number,t1.B_Posted,t2.U_Username,t1.B_IP,t1.B_Subject,t1.B_Body FROM w3t_Posts AS t1, w3t_Users AS t2 WHERE t1.B_Number > 89518 AND t1.B_Approved = 'yes' AND t1.B_Board = 'mondeospotted' AND t1.B_Posterid = t2.U_Number AND t1.B_Stgatus <> 'M' ORDER BY t1.B_Number ASC - Unknown column 't1.B_Stgatus' in 'where clause'

Sun, Jan 12 2003 09:17:14 -0500 /ubbthreads/cron/php/subscriptions.php 62.6.98.81
Unable to do_query: SELECT t1.B_Number,t1.B_Posted,t2.U_Username,t1.B_IP,t1.B_Subject,t1.B_Body FROM w3t_Posts AS t1, w3t_Users AS t2 WHERE t1.B_Number > 89348 AND t1.B_Approved = 'yes' AND t1.B_Board = 'newbie' AND t1.B_Posterid = t2.U_Number AND t1.B_Stgatus <> 'M' ORDER BY t1.B_Number ASC - Unknown column 't1.B_Stgatus' in 'where clause'

Sun, Jan 12 2003 09:17:14 -0500 /ubbthreads/cron/php/subscriptions.php 62.6.98.81
Unable to do_query: SELECT t1.B_Number,t1.B_Posted,t2.U_Username,t1.B_IP,t1.B_Subject,t1.B_Body FROM w3t_Posts AS t1, w3t_Users AS t2 WHERE t1.B_Number > 59482 AND t1.B_Approved = 'yes' AND t1.B_Board = 'News' AND t1.B_Posterid = t2.U_Number AND t1.B_Stgatus <> 'M' ORDER BY t1.B_Number ASC - Unknown column 't1.B_Stgatus' in 'where clause'
</font><hr /></blockquote><font size="" face="">i only posted 4, in total theres a lot more. Is it creating one of these for every forum? I can post more if it'll help you.

www.fordmondeo.org
Mondeo Enthusiasts Group

Ah... Known bug.

You have to fix a typo

http://community.infopop.net/6/ubb.x?a=tpc&s=729094322&f=6183028913&m=7703082096

B_Stgatus should be B_Status


<img border="0" title="" alt="[Big Grin]" src="images/icons/grin.gif" />

Josh
Measurection.com Admin | ThreadsDev.com Moderator
Register to see my How To/Site Help Library Forum at ThreadsDev.com.
My threads 'tweaking' abilities are for hire.

IT WORKS!!! <img border="0" title="" alt="[Big Grin]" src="images/icons/grin.gif" />
Thanks very much guys!!! <img border="0" title="" alt="[Cool]" src="images/icons/cool.gif" />

www.fordmondeo.org
Mondeo Enthusiasts Group