Unable to add messages - fix

Posted: Sat Aug 19, 2006 5:52 am

Hi ppl,
I just installed RavenNuke76 v2.02.02 Distro and I noticed I cannot add messages.
After a little look I found why.
table nuke_messages look like this:

Code:

DROP TABLE IF EXISTS `nuke_message`;


CREATE TABLE `nuke_message` ( `mid` int(11) NOT NULL auto_increment, `title` varchar(100) NOT NULL default '', `content` text NOT NULL, `date` varchar(14) NOT NULL default '', `expire` int(7) NOT NULL default '0', `active` int(1) NOT NULL default '1', `view` int(1) NOT NULL default '1', `mlanguage` varchar(30) NOT NULL default '', PRIMARY KEY  (`mid`) ) TYPE=MyISAM;

insert query look like this(admin/modules/messages.php line 319):

Code:

$result = $db->sql_query("insert into " . $prefix . "_message values (NULL, '$add_title', '$add_content', '$add_mdate', '$add_expire', '$add_active', '$add_view', '$ingroups', '$add_mlanguage')");

Notice $ingroups' have no field in table.
Fix:

Code:

ALTER TABLE `nuke_message` ADD `groups` int(10) default '0'AFTER `view`;

Not sure about field lenght but 10 should be enough.
Hope it helps.
Regards,
Enforcer

registered · Posted: Sat Aug 19, 2006 6:29 am

The field `groups` is added as a part of the NSN Groups install, which is Step 2 in the installSQL.php script. All but the last step in that script is required for RavenNuke to run (as you can see).

Posted: Sat Aug 19, 2006 7:09 am

Hmm, then something went wrong, I used installer...and i found those queries..

Code:

ALTER TABLE `nuke_blocks` ADD `groups` TEXT NOT NULL AFTER `view`;


ALTER TABLE `nuke_message` ADD `groups` TEXT NOT NULL AFTER `view`;


ALTER TABLE `nuke_modules` ADD `groups` TEXT NOT NULL AFTER `view`;

However, only nuke_message wasn't updated.
Strange...

Posted: Sat Aug 19, 2006 8:52 am

That is strange. And this was a completely fresh installation? If so, can you try to re-do the database again and see if you get this again? I have never seen this happen where some of the updates were made but not all (at least not with these simple few for NSN Groups).

Posted: Sat Aug 19, 2006 9:33 am

Well. I reinstalled again from scratch and this didn't occured again.
It look like everything is OK.
Maybe was a MySql glitch..
Installation is fresh, but I'll port from a PHP nuke 7.9 needed content.

Posted: Sat Aug 19, 2006 5:35 pm

Quote:

but I'll port from a PHP nuke 7.9 needed content.

Don't forget to "downgrade" the DB unless you are an expert at Nuke and how to get all the data in the right place.... there are numerous threads about Downgrading if you need them...

Posted: Sat Aug 19, 2006 5:59 pm

Thank you for your support, I really appreciate.
But I already finished importing/converting, I uploaded my site and now is working like a charm. It was enough to do this only by queries.
I'm not a nuke expert, but I learnt in hard way Smile

And I'm not totally PHP/MySql noob Smile

I've tried several Nuke forks (around 5-6, can't say for sure) and I started to be a bit disappointed till I found RavenNuke and I must say I love it. Stable, fast, secure.

Posted: Sat Aug 19, 2006 6:03 pm

Quote:

Stable, fast, secure

Wait until you see 2.10.00... we have started to clean up the code a bit and have many bug fixes.... it is lightning fast and we haven't even tuned any SQL yet. Wink

Posted: Sat Aug 19, 2006 6:14 pm

Quote:

Wait until you see 2.10.00

Gee, I can't wait Very Happy

I fact I have a couple of questions, and if I already started a thread I'll post them here.
1. where I can post some little addons/mods for modules?
2.This is a problem that I can't figure out how to solve it.
I was on host with PHP 51.2 and MySQL 5.x.x, all was working with no erors but I had to quit cuz it is very slow.
Now I found a host that seem ok but runs PHP 4.x.x (dont know sure)
and I get a blank page if this block of code is not deactivated (mainfile.php):

Quote:

if ($phpver >= '4.0.4pl1' && isset($_SERVER['HTTP_USER_AGENT']) && strstr($_SERVER['HTTP_USER_AGENT'],'compatible')) {
if (extension_loaded('zlib')) {
@ob_end_clean();
ob_start('ob_gzhandler');
}
} elseif ($phpver > '4.0' && isset($_SERVER['HTTP_ACCEPT_ENCODING']) && !empty($_SERVER['HTTP_ACCEPT_ENCODING'])) {
if (strstr($_SERVER['HTTP_ACCEPT_ENCODING'], 'gzip')) {
if (extension_loaded('zlib')) {
$do_gzip_compress = true;
ob_start(array('ob_gzhandler',5));
ob_implicit_flush(0);
if (ereg("MSIE", $_SERVER['HTTP_USER_AGENT'])) {
header('Content-Encoding: gzip');
}
}
}
}

Any ideeas?

Posted: Sat Aug 19, 2006 6:56 pm

Well, we prefer one topic per thread, but since you asked so nicely. Laughing

Quote:

where I can post some little addons/mods for modules?

Please expound a bit on what you are wanting. This is a bit vague. Thanks.

Quote:

This is a problem that I can't figure out how to solve it.

Look up the terms "'ob_gzhandler'" or "gzip" here in the forums. Your issue may be covered.

Posted: Sun Aug 20, 2006 8:24 am

Quote:

Look up the terms "'ob_gzhandler'" or "gzip" here in the forums. Your issue may be covered.

I did, but can't find solutions for this issue, mostly are about
"output handler ' ob_gzhandler ' cannot be used twice".

Quote:

Please expound a bit on what you are wanting. This is a bit vague. Thanks

Well, I mean a place like "User Contributions" to post their addons/fixes.
I saw "Scripts- General" section, but is for ppl asking for help.

Posted: Sun Aug 20, 2006 9:16 am

Quote:

Well, I mean a place like "User Contributions" to post their addons/fixes.
I saw "Scripts- General" section, but is for ppl asking for help.

Ok, I understand better now. Thank you. Well, I could see these going under Modules or Blocks depending upon which they are for and I could also see some going under "How To".

Unfortunately, I don't know enough about your other question and the differences between 4.x and 5.x that you be causing this. I'd suggest a separate thread with a descriptive subject for this specific issue.

Thanks!

Posted: Sun Aug 20, 2006 10:04 am

PHP version is 4.4.0, but I tested on 4.3.10 aswell on 5.1.2 and is working.
I suspect is something related to hoster's settings.
I guess is not a major concern if I let deactivated this portion of code.
IMO a "Users Contributors" may help, some ppl can have really nice ideas (and willing to share) Smile

I'm not a specialist on nothing, but I have some ideeas and I'll try to apply them and I'd like to have a place to share them.
In this way I'll be able to donate at least pieces of code since I cannot donate money (In my coutry PayPal do not operate so I cannot accept/give donations, cannot buy from outside of country.. and this sux big time - to see stuff at half price than can currently get and no way to buy them Sad

)

Posted: Sun Aug 20, 2006 11:09 am

Feel free to contribute where you feel it makes sense. The most important thing to do is make sure your topic titles are as descriptive as possible and good keywords in the text of your post so that others seeking something you have posted will find it.

Hangin' Around Joined: Jul 20, 2006 Posts: 41

Enforcer wrote:

Hi ppl,
I just installed RavenNuke76 v2.02.02 Distro and I noticed I cannot add messages.
After a little look I found why.
table nuke_messages look like this:

Code:

DROP TABLE IF EXISTS `nuke_message`;


CREATE TABLE `nuke_message` ( `mid` int(11) NOT NULL auto_increment, `title` varchar(100) NOT NULL default '', `content` text NOT NULL, `date` varchar(14) NOT NULL default '', `expire` int(7) NOT NULL default '0', `active` int(1) NOT NULL default '1', `view` int(1) NOT NULL default '1', `mlanguage` varchar(30) NOT NULL default '', PRIMARY KEY  (`mid`) ) TYPE=MyISAM;

insert query look like this(admin/modules/messages.php line 319):

Code:

$result = $db->sql_query("insert into " . $prefix . "_message values (NULL, '$add_title', '$add_content', '$add_mdate', '$add_expire', '$add_active', '$add_view', '$ingroups', '$add_mlanguage')");

Notice $ingroups' have no field in table.
Fix:

Code:

ALTER TABLE `nuke_message` ADD `groups` int(10) default '0'AFTER `view`;

Not sure about field lenght but 10 should be enough.
Hope it helps.
Regards,
Enforcer

Hi, just to say thanks. This tip saved me a shedload of trouble. Smile