Can't POST news articles

New Member Joined: Jul 17, 2006 Posts: 5

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

registered · Site Admin Joined: Jun 04, 2004 Posts: 6437

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.

Posted: Mon Jul 17, 2006 5:08 am

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

Posted: Mon Jul 17, 2006 5:18 am

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?

Posted: Mon Jul 17, 2006 5:39 am

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.

Posted: Mon Jul 17, 2006 6:51 am

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

Posted: Mon Jul 17, 2006 7:25 am

Works a treat Very Happy

Thx for your help !

Posted: Mon Jul 17, 2006 7:34 am

Not a problem.

New Member Joined: Jul 24, 2006 Posts: 10

Hello

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

Thanks

Posted: Fri Jul 28, 2006 2:54 am

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.

Posted: Fri Jul 28, 2006 3:06 am

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.

Posted: Fri Jul 28, 2006 3:14 am

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

thanks

Posted: Fri Jul 28, 2006 3:53 am

Curious, Do you see the story in the database?

Posted: Fri Jul 28, 2006 4:01 am

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

Thanks

Posted: Fri Jul 28, 2006 4:45 am

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.

Posted: Fri Jul 28, 2006 4:52 am

Hi

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

Onye

registered · Posted: Fri Jul 28, 2006 7:29 am

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.

Posted: Fri Jul 28, 2006 8:05 am

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

Posted: Fri Jul 28, 2006 11:40 am

Your table seems to be missing the field 'associated'. which should be located immediately after the 'ratings' field.

Posted: Fri Jul 28, 2006 11:46 am

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

Thanks

Onye

Posted: Fri Jul 28, 2006 11:55 am

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

Posted: Fri Jul 28, 2006 12:04 pm

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

Posted: Fri Jul 28, 2006 12:09 pm

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.

Posted: Fri Jul 28, 2006 12:26 pm

Hi

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

Thanks

Onye

Posted: Fri Jul 28, 2006 1:54 pm

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` ;