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
slackbladder69
New Member
New Member


Joined: Jul 17, 2006
Posts: 5

PostPosted: Mon Jul 17, 2006 4:47 am Reply with quote

Firstly many thanks to those involved in making this version of NUKE available. After being hacked too many times while on 7.8 I decided to use RavenNuke76(tm) Version 2.02.02 and be secure in knowing it's been coded by those that know what they are doing!!

My problem is that even though I can SUBMIT NEWS, PREVIEW NEWS, I can not POST news to the database. They are there if you submit them outside of the admin news system (Submit_News/index.php) but when I come to POST them, they disappear, no errors, no news Sad

Site is a fresh install, but I have pulled some parts of the OLD MySQL db in to it (with no mismatches of fields, etc) including users, forum data, etc, etc.

Other sections that allow for POSTING to db work fine, just not the NEWS!

Any ideas?

Many thanks Very Happy
 
View user's profile Send private message
kguske
Site Admin


Joined: Jun 04, 2004
Posts: 6383

PostPosted: Mon Jul 17, 2006 4:56 am Reply with quote

It sounds like there is a problem with the stories table. Check that to see if it needs to be repaired or if there are fields missing or extra fields added. Compare it to the SQL in your RN download.

_________________
I google, therefore I exist...
Only registered users can see links on this board! Get registered or login!
 
View user's profile Send private message
slackbladder69
PostPosted: Mon Jul 17, 2006 5:08 am Reply with quote

You're the 'daddy' Very Happy

Offending field:

`rating_ip` varchar(15) default '0'

Have similar problem with POSTING BLOCKS, so will check that out now Very Happy

Appreciate the speedy and helpful reply man!! Very Happy
 
slackbladder69
PostPosted: Mon Jul 17, 2006 5:18 am Reply with quote

Hmn- no joy with the BLOCK issue, both structures are the same.

Can't ADD a new block, either by making a new one via admin or uploading a block file then selecting it via admin.

Any more ideas?
 
Guardian2003
Site Admin


Joined: Aug 28, 2003
Posts: 6793
Location: Ha Noi, Viet Nam

PostPosted: Mon Jul 17, 2006 5:39 am Reply with quote

Did you use the installer to create all the new tables etc?
Check the nuke_blocks table and see if you have a field called 'groups' I think you might have missed a step.
 
View user's profile Send private message Send e-mail
slackbladder69
PostPosted: Mon Jul 17, 2006 6:51 am Reply with quote

AHH! Thx Guardian (it's too hot today isn't it!!) Just noticed I should have used rn76_nsngroups.sql also - DOH!

Will try it now Smile
 
slackbladder69
PostPosted: Mon Jul 17, 2006 7:25 am Reply with quote

Works a treat Very Happy Thx for your help !
 
Guardian2003
PostPosted: Mon Jul 17, 2006 7:34 am Reply with quote

Not a problem.
 
oriona
New Member
New Member


Joined: Jul 24, 2006
Posts: 10

PostPosted: Fri Jul 28, 2006 2:29 am Reply with quote

Hello

I have a similar problem. I have compared table and they seem to be the same. What else could be wrong?

Thanks

_________________
Only registered users can see links on this board! Get registered or login!
project managment 
View user's profile Send private message MSN Messenger
gregexp
The Mouse Is Extension Of Arm


Joined: Feb 21, 2006
Posts: 1497
Location: In front of a screen....HELP! lol

PostPosted: Fri Jul 28, 2006 2:54 am Reply with quote

Similar? If this is the same problem, Post your table structure and let us review it for you.

Other then that, it would be a coding problem

Have you made any changes to the nuke files?

Its just that I have an idea of what your problem is, just not specific enough to start naming files to look at.

If you could please be a bit more specific.

Turning $display_errors=true in config.php should REALLY help.
It should produce an error to allow for a more specific problem.

_________________
For those who stand shall NEVER fall and those who fall shall RISE once more!! 
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number
oriona
PostPosted: Fri Jul 28, 2006 3:06 am Reply with quote

Thanks for quick response. Hope this is helpful.

/*Column Information For - P.nuke_stories*/
--------------------------------------------------------

Field Type Collation Null Key Default Extra Privileges Comment
--------- --------------------- ----------------- ------ ------ ------- -------------- ------------------------------- -------
sid int(11) NULL PRI (NULL) auto_increment select,insert,update,references
catid int(11) NULL MUL 0 select,insert,update,references
aid varchar(30) latin1_swedish_ci select,insert,update,references
title varchar(80) latin1_swedish_ci YES (NULL) select,insert,update,references
time datetime NULL YES (NULL) select,insert,update,references
hometext text latin1_swedish_ci YES (NULL) select,insert,update,references
bodytext text latin1_swedish_ci select,insert,update,references
comments int(11) NULL YES 0 select,insert,update,references
counter mediumint(8) unsigned NULL YES (NULL) select,insert,update,references
topic int(3) NULL 1 select,insert,update,references
informant varchar(20) latin1_swedish_ci select,insert,update,references
notes text latin1_swedish_ci select,insert,update,references
ihome int(1) NULL 0 select,insert,update,references
alanguage varchar(30) latin1_swedish_ci select,insert,update,references
acomm int(1) NULL 0 select,insert,update,references
haspoll int(1) NULL 0 select,insert,update,references
pollID int(10) NULL 0 select,insert,update,references
score int(10) NULL 0 select,insert,update,references
ratings int(10) NULL 0 select,insert,update,references

/*Index Information For - R.nuke_stories*/
-------------------------------------------------------

Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment
------------ ---------- -------- ------------ ----------- --------- ----------- -------- ------ ------ ---------- -------
nuke_stories 0 PRIMARY 1 sid A 847 (NULL) (NULL) BTREE
nuke_stories 1 sid 1 sid A (NULL) (NULL) (NULL) BTREE
nuke_stories 1 catid 1 catid A (NULL) (NULL) (NULL) BTREE

/*DDL Information For - P.nuke_stories*/
-----------------------------------------------------

Table Create Table
------------ -------------------------------------------------
nuke_stories CREATE TABLE `nuke_stories` (
`sid` int(11) NOT NULL auto_increment,
`catid` int(11) NOT NULL default '0',
`aid` varchar(30) NOT NULL default '',
`title` varchar(80) default NULL,
`time` datetime default NULL,
`hometext` text,
`bodytext` text NOT NULL,
`comments` int(11) default '0',
`counter` mediumint(8) unsigned default NULL,
`topic` int(3) NOT NULL default '1',
`informant` varchar(20) NOT NULL default '',
`notes` text NOT NULL,
`ihome` int(1) NOT NULL default '0',
`alanguage` varchar(30) NOT NULL default '',
`acomm` int(1) NOT NULL default '0',
`haspoll` int(1) NOT NULL default '0',
`pollID` int(10) NOT NULL default '0',
`score` int(10) NOT NULL default '0',
`ratings` int(10) NOT NULL default '0',
PRIMARY KEY (`sid`),
KEY `sid` (`sid`),
KEY `catid` (`catid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Edited By Admin: I removed the reference to your database name... some details are best not disclosed in a public forum. I replaced the database names with "P" and "R". See my post further down.
 
oriona
PostPosted: Fri Jul 28, 2006 3:14 am Reply with quote

Sorry, forgot to mention that no error messages come up at all. The stories just don't show up

thanks
 
gregexp
PostPosted: Fri Jul 28, 2006 3:53 am Reply with quote

Curious, Do you see the story in the database?
 
oriona
PostPosted: Fri Jul 28, 2006 4:01 am Reply with quote

no I don't see the story. I've posted as both user and from Admin and they both don't appear.

Thanks
 
gregexp
PostPosted: Fri Jul 28, 2006 4:45 am Reply with quote

And no errors?

When you submit a story you have no errors with $display_errors set to true?

This is definatley something someone will need to get more involved with, I'm on my way to work right now but will be back later and will attempt to solve this problem.

I cant reproduce this at all.
 
oriona
PostPosted: Fri Jul 28, 2006 4:52 am Reply with quote

Hi

You are very kind. thanks a lot and have a nice day

Onye
 
montego
Site Admin


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

PostPosted: Fri Jul 28, 2006 7:29 am Reply with quote

oriona, I edited your post above which had the table structures in them. Please note that I changed your database names to "P" and "R". My point being that these should be the same. Where did the "Index Information" come from? It had a different database on the DDL output.

_________________
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
oriona
PostPosted: Fri Jul 28, 2006 8:05 am Reply with quote

Thanks a lot. Stupid of me.

The only reason why there may be difference is probably because I copied the nuke_stories table from a previous installation of phpnuke which had been hacked several times. When I discovered and installed ravennuke, I coped the table across to recover all the poems - 847 of them.

could this explain it?

Thanks

Onye
 
Guardian2003
PostPosted: Fri Jul 28, 2006 11:40 am Reply with quote

Your table seems to be missing the field 'associated'. which should be located immediately after the 'ratings' field.
 
oriona
PostPosted: Fri Jul 28, 2006 11:46 am Reply with quote

ok. Will it work if I reinstate the table that came with RavenNuke and copy only the data into it.

Thanks

Onye
 
Guardian2003
PostPosted: Fri Jul 28, 2006 11:55 am Reply with quote

You would need to compare the data as well to see if the data has information that should be in that field.
I suspect as it didnt genreate an error the field data is missing as well so...
Back up your table data.
Delete the old table and run this to re-create it
Code:
CREATE TABLE IF NOT EXISTS $prefix.`_stories` ( `sid` int(11) NOT NULL auto_increment, `catid` int(11) NOT NULL default '0', `aid` varchar(25) NOT NULL default '', `title` varchar(80) default NULL, `time` datetime default NULL, `hometext` text, `bodytext` text NOT NULL, `comments` int(11) default '0', `counter` mediumint(8) unsigned default NULL, `topic` int(3) NOT NULL default '1', `informant` varchar(25) NOT NULL default '', `notes` text NOT NULL, `ihome` int(1) NOT NULL default '0', `alanguage` varchar(30) NOT NULL default '', `acomm` int(1) NOT NULL default '0', `haspoll` int(1) NOT NULL default '0', `pollID` int(10) NOT NULL default '0', `score` int(10) NOT NULL default '0', `ratings` int(10) NOT NULL default '0', `associated` text NOT NULL, PRIMARY KEY  (`sid`), KEY `catid` (`catid`), KEY `counter` (`counter`), KEY `topic` (`topic`) ) TYPE=MyISAM;


With your old data set you will have to add dummy data for the 'associate' field so that the number of fields in the table and in the data are back in synch.

You can do this by counting backwards from the end of each INSERT line to add ,, or if you do not feel confident enough, the easy option is, before you start, send me a copy of your INSERT data and I'll take care of it - webmasterATcode-authorsDOTcom
 
oriona
PostPosted: Fri Jul 28, 2006 12:04 pm Reply with quote

Hi Guardian2003

I've pretended to know what I'm talking about up to this point, but you've lost me now. Smile

Please in plain English, what should I send you?

Is the the data from old phpnuke only or what else?

You've been great. Thanks

Onye
 
Guardian2003
PostPosted: Fri Jul 28, 2006 12:09 pm Reply with quote

Yes when you create a back up of your table in phpmyadmin, you have the option 'Create INSERTS' if you choose this it shoul give you something like
Code:
INSERT INTO $prefix.`_bbconfig` VALUES ('config_id', '1');
- obviously that is for a different table but just wanted to show you an example of how it should look.
You will have many lines all starting with INSERT INTO and it is that data I need.
 
oriona
PostPosted: Fri Jul 28, 2006 12:26 pm Reply with quote

Hi

I've sent you and email with a text file attached

Thanks

Onye
 
Guardian2003
PostPosted: Fri Jul 28, 2006 1:54 pm Reply with quote

It occured to me after you sent me the file that there is a more elegant solution to fix this.
The fix I sent oriona was to place the following query into the phpmyadmin sql query window which would add the missing field in the correct place.
Code:
ALTER TABLE `nuke_stories` ADD `associated` TEXT NOT NULL AFTER `ratings` ;
 
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 ©