Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v2.02.02 Distro
Author Message
Enforcer
New Member
New Member


Joined: Aug 19, 2006
Posts: 23
Location: Timisoara, Romania

PostPosted: Sat Aug 19, 2006 5:52 am Reply with quote

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
 
View user's profile Send private message Visit poster's website
montego
Site Admin


Joined: Aug 29, 2004
Posts: 9449
Location: Arizona

PostPosted: Sat Aug 19, 2006 6:29 am Reply with quote

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).

_________________
Only registered users can see links on this board! Get registered or login!
Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
Enforcer
PostPosted: Sat Aug 19, 2006 7:09 am Reply with quote

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...
 
montego
PostPosted: Sat Aug 19, 2006 8:52 am Reply with quote

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).
 
Enforcer
PostPosted: Sat Aug 19, 2006 9:33 am Reply with quote

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.
 
montego
PostPosted: Sat Aug 19, 2006 5:35 pm Reply with quote

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...
 
Enforcer
PostPosted: Sat Aug 19, 2006 5:59 pm Reply with quote

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.
 
montego
PostPosted: Sat Aug 19, 2006 6:03 pm Reply with quote

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
 
Enforcer
PostPosted: Sat Aug 19, 2006 6:14 pm Reply with quote

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?
 
montego
PostPosted: Sat Aug 19, 2006 6:56 pm Reply with quote

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.
 
Enforcer
PostPosted: Sun Aug 20, 2006 8:24 am Reply with quote

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.
 
montego
PostPosted: Sun Aug 20, 2006 9:16 am Reply with quote

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!
 
Enforcer
PostPosted: Sun Aug 20, 2006 10:04 am Reply with quote

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 )
 
montego
PostPosted: Sun Aug 20, 2006 11:09 am Reply with quote

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.
 
synaptyx
Hangin' Around


Joined: Jul 20, 2006
Posts: 41

PostPosted: Wed Jan 17, 2007 5:55 am Reply with quote

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
 
View user's profile Send private message
Display posts from previous:       
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v2.02.02 Distro

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©