Re: [Slashcode-general] T_2_5_0_160 MySQL(4) tables & firehose

[shane <sh...@lo...>]

On Jun 12, 2007, at 7:51 PM, Reid Maynard wrote:

> My barely-two-week-old install, not much on it. During the install I
> got a error about problem creating the firehose table(?) or something
> like that. Now I am returning to the issue. I logged into MySQL
> expecting to find no firehose table, but surprise, their are three
>
> firehose
> firehose_tab
> firehose_ext
>
> I have 177 in all
>
> I haven't investigated firehose via the UI,  but I am getting this  
> error
>
> Error:Slash::Display::Provider:/usr/local/perl-5.8.8/lib/site_perl/ 
> 5.8.8/i686-linux/Slash/Display/Provider.pm:81:Failed
> template lookup (returning false) on
> 'rand_mesg;firehose[misc];mainpage[default]', keys: 354, callers:
> Slash::Display line 219, Slash::FireHose line 1810, main line 69
>
> in the slashd.log
>
> -Reid

Do you experience the same thing with later tags? (161,162,163 if it  
exists)

There is a bug that may-be-related to this:

http://sourceforge.net/tracker/index.php? 
func=detail&aid=1630587&group_id=4421&atid=104421

Basically, when you do a fresh install, and you don't pick the  
Moderation Plugin, you'll see mucho errors and the install pretty  
much total fails.

However, with regard to the issue you brought up - I just checked out  
_160, then installed (selecting the Firehose plugin, and the  
Moderation plugin) and it went a-ok.

Are you sure you have a clean checkout of T_2_5_0_160?

cvs -z3 -d:pserver:ano...@sl...:/cvsroot/ 
slashcode co -P -r T_2_5_0_160 slash

Regarding the rand_mesg - that means the system's not finding the  
rand_mesg;firehose;default template in your site's database (ie table  
templates). You can do a sql query to double-check. Is it in your  
source-tree on your file system?

coolio:/usr/local/src/slash/current.untouched shane$ pwd
/usr/local/src/slash/current.untouched
coolio:/usr/local/src/slash/current.untouched shane$ cd plugins/ 
FireHose/templates/
coolio:/usr/local/src/slash/current.untouched/plugins/FireHose/ 
templates shane$ ls rand_mesg*
ls: rand_mesg*: No such file or directory

but something is calling it:

coolio:/usr/local/src/slash/current.untouched/plugins shane$ cd ..
coolio:/usr/local/src/slash/current.untouched shane$ grep -R  
'rand_mesg' *
plugins/FireHose/templates/list;firehose;default:               [%  
PROCESS rand_mesg %]

So if I update my source-tree to the latest tag

cvs -q update -dPC -r T_2_5_0_163

and repeat those two (ls & grep), I get the same results. So as of a  
much more up-to-date tag, the template's still missing.

I think you've found a bug! I filed it:

http://sourceforge.net/tracker/index.php? 
func=detail&aid=1737761&group_id=4421&atid=104421

However, the schema structure's there in mine w/o problems:


mysql> show tables like "firehose%";
+-----------------------------+
| Tables_in_slash (firehose%) |
+-----------------------------+
| firehose                    |
| firehose_tab                |
| firehose_text               |
+-----------------------------+
3 rows in set (0.00 sec)

I don't see any other firehose-related errors in my logs. Maybe you  
are misinterpreting the error you quoted with having to do with the  
Firehose plugin's schema?

  Shane