Union blocker setting

mega · New Member Joined: Jun 03, 2004 Posts: 11

I've got Sentinel on 2 sites, one 7.1.1 NSN (hope to see a 7.3 NSN) and a 6.9 patched up thanks to chatserv. My issue on the 6.9 install is the Union blocker setting always reverts to off when I save my settings. Any ideas on why this might be?

Raven · Posted: Thu Jun 03, 2004 10:53 am

Are you using v1.1 or v1.2?

mega · New Member Joined: Jun 03, 2004 Posts: 11

I've got 1.1 on both sites. 1.2 is available? I don't see it listed anywhere.

mega · New Member Joined: Jun 03, 2004 Posts: 11

For whatever reason the installer didn't put act_union in the nuke_nsnst_config table, even after uninstalling it and trying it again. I ended up just exporting that table from my 7.1.1 site and using that. Oddly enough Sentinel on the 6.9 site passed a union test without it.

mega · New Member Joined: Jun 03, 2004 Posts: 11

I upgraded both sites to 1.2, the 7.1.1 site again had no problems, but the 6.9 site showed "Reset Blocker nuke_nsnst_config failed" for the union switch, and I can only seem to change it manually in the db.

Raven · Posted: Fri Jun 04, 2004 4:48 am

Very peculiar Mr. Spock, very peculiar!!

Find this code in includes/sentinel.php

Code:

$db->sql_query("UPDATE ".$prefix."_nsnst_config SET config_value='$config_value' WHERE config_name='$config_name'");

and change it to

Code:

mysql_query("UPDATE ".$prefix."_nsnst_config SET config_value='$config_value' WHERE config_name='$config_name'") or die("Update failed. Mysql said: ".mysql_error());

Let me know what the actual mysql error message is.

mega · New Member Joined: Jun 03, 2004 Posts: 11

It is most illogical. Smile

This is even stranger, when I change the code as you requested, all the switches work fine, change it back and the union switch is stuck again.

Raven · Posted: Fri Jun 04, 2004 7:48 am

) - Great! Problem solved!

Muffin · Client Joined: Apr 10, 2004 Posts: 649 Location: UK

My Sentinal includes/sentinal.php file has the first block of code there, so should I change mine to this also please?

I dont have a clue if my Union switch is stuck cos I dont understand it lol

It all seems to be working ok tho Embarassed

Raven · Posted: Fri Jun 04, 2004 5:12 pm

No. While it doesn't hurt anything, as long as yours works then leave it. You know it works if you are able to change it and it saves the value.

Muffin · Client Joined: Apr 10, 2004 Posts: 649 Location: UK

Thank you Raven.

It's very confusing for a newbie. Embarassed

Raven · Posted: Fri Jun 04, 2004 5:45 pm

Don't be! Chatserv has been confused forever and he's perfectly happy <MUHAHAHAHAHA>

chatserv · Posted: Fri Jun 04, 2004 5:58 pm

Me confused? what are you talking about? I'm confused but i'm very happy though Mr. Green

Muffin · Client Joined: Apr 10, 2004 Posts: 649 Location: UK

lol

I'm always confused maybe we should form a club rofl

stephen2417 · Posted: Fri Jun 04, 2004 6:32 pm

Yes really.. Now im confused too..

Raven can you tell us why chat is confused? or is this an inside joke?

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

I found a similar problem when updating the configuration. I noticed that the act_union configuration option was being updated in the table - but the field name was UNI0N (with a zero), not union (with the letter O). I had applied an earlier mod by DJMAZE that replaced instances of union (including, in this case, the field names of tables created through PHP) with UNI0N (the number zero). I'll need to back out that mod...maybe someone else had the same problem.