UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support mysql database error

I just sent the 5.4.5 up to my server (Set it up as a stand alone until I get things set the way I want them)

I logged on and the first thing I got was......

SQL ERROR: Unable to do_query: SELECT Bo_Title,Bo_Description,Bo_Keyword,Bo_Total,Bo_Last,Bo_Number,Bo_Moderated,Bo_Read_Perm,Bo_Write_Perm,Bo_Threads,Bo_Sorter,Bo_Poster FROM w3t_Boards WHERE Bo_Cat = 1 AND (Bo_Read_Perm LIKE '%-1-%' OR Bo_Read_Perm LIKE '%-8-%' OR Bo_Read_Perm LIKE '%-11-%' OR Bo_Read_Perm LIKE '%-12-%' OR Bo_Read_Perm LIKE '%-9-%' OR Bo_Read_Perm LIKE '%-13-%' OR Bo_Read_Perm LIKE '%-15-%' OR Bo_Read_Perm LIKE '%-14-%') ORDER BY Bo_Sorter
Unknown column 'Bo_Poster' in 'field list': 1054
Warning: Supplied argument is not a valid MySQL result resource in /home/sansoo/public_html/phpforum/mysql.inc.php on line 83
SQL ERROR: Unable to do_query: SELECT

And a lot more like it.

I think i'm getting better at this, it looks like its having a problem with a new variable Bo_Poster.

I think I got the upgrade version when I downloaded it, but I don't see an altertable 5.4.4 to 5.4.5 sooooooo???? Any ideas??

Scott Cargill -WebMaster
<img src="http://www.easthillskungfu.com/salute.gif" alt=" - " />
East Hills Kung Fu San Soo

The Bo_Poster field is added in the altertable-5.4.3-5.4.3.php file. If you are upgrading from 5.4.3 or earlier you will need to run this file.

-------------------
Rick Baker
UBBThreads developer

</font><blockquote><font size="1" face="">quote:</font><hr /><font size="" face="">Originally posted by Rick Baker:
The Bo_Poster field is added in the altertable-5.4.3-5.4.3.php file. If you are upgrading from 5.4.3 or earlier you will need to run this file.

-------------------
Rick Baker
UBBThreads developer</font><hr /></blockquote><font size="" face="">Ok, 11:00pm is just too late for me to be playing around with this stuff I guess.

I looked, I was still at 5.4.3 duhhhh......

Thanks......

I ran the altertable 5.4.3-5.4.4. and that cleared up that part, any idea what causes this to pop up when I tried to post a message

</font><blockquote><font size="1" face="">quote:</font><hr /><font size="" face="">Warning: file("http://www.easthillskungfu.com/phpforum/filters/badnames") - Success in /home/sansoo/public_html/phpforum/addpost.php on line 164

Warning: Variable passed to each() is not an array or object in /home/sansoo/public_html/phpforum/addpost.php on line 165

Warning: file("http://www.easthillskungfu.com/phpforum/filters/badwords") - Success in /home/sansoo/public_html/phpforum/addpost.php on line 622

Warning: Variable passed to each() is not an array or object in /home/sansoo/public_html/phpforum/addpost.php on line 623

Warning: file("http://www.easthillskungfu.com/phpforum/filters/usertitles") - Success in /home/sansoo/public_html/phpforum/addpost.php on line 750

Warning: Variable passed to each() is not an array or object in /home/sansoo/public_html/phpforum/addpost.php on line 751
</font><hr /></blockquote><font size="" face="">Scott Cargill -WebMaster
<img src="http://www.easthillskungfu.com/salute.gif" alt=" - " />
East Hills Kung Fu San Soo

It seems some systems read their files differently. Some you can do it with a url and some need to have it as a path. I'm going to get this in as an option but for now, you probably need to change a few lines in addpost.php.

164, 662, 750 - on each of these lines you will see where it says $config[phpurl]. I think you are going to need to change that to $config[path].

-------------------
Rick Baker
UBBThreads developer

Nope... that didn't fix it,

Went through and changed those three lines, still had the problem, went through changed every occurance of phpurl to path and still got the problem.

It did get rid of all of the error messages though, but I still got the [censored] stuff all over everything including the subject heading.

Scott Cargill -WebMaster
<img src="http://www.easthillskungfu.com/salute.gif" alt=" - " />
East Hills Kung Fu San Soo

[This message was edited by Scott Cargill on 28 Oct 01 at 11:47 AM.]

Ok, I went back and sent the virgin copy of addpost.php to the server, then I changed the phpurl to path in lines 164, 621, and 750.

Line 662 is a } looks like 664 contains a phpurl but it has to do with the polling feature??

Either way, changing 164 knocked 2 error occurances out, 621 another 2 and 750 another 2.

Those three changes fixed the six error's that were echoed to the screen, but I still get the [censor] effect on both the subject as well as the body.

Scott Cargill -WebMaster
<img src="http://www.easthillskungfu.com/salute.gif" alt=" - " />
East Hills Kung Fu San Soo

You might want to check your badwords file. If this has an empty line in it or a line with just a space it could do what you are describing.

-------------------
Rick Baker
UBBThreads developer

That did it!

My ftp client was told to send .pl and .php files in ascii but the badwords, badnames etc having no extension were sent over in binary.

Thanks Rick!

LOTS better support than Sonic Foundry <img border="0" title="" alt="[Smile]" src="images/icons/smile.gif" />

Scott Cargill -WebMaster
<img src="http://www.easthillskungfu.com/salute.gif" alt=" - " />
East Hills Kung Fu San Soo