Cannot submit news with phpnuke 6.7.

Nuke Soldier Joined: Jan 01, 2005 Posts: 12

Hi

I am also having trouble submitting news. I am running phpnuke 6.7 (I know this is old but so is my server environment.)

The story so far:

My news section was working fine until:

1) I tried to move my config.php – didn’t work and I had to put it back again.
2) I installed a style and uninstalled it once I realised that my news section wasn’t working.

When I am submitting news in the first instance as an ordinary user, I have to preview it first. So I hit preview and all that happens is that I end up on my index page. I also cannot submit news any other way as I keep getting the same result.

I’m pulling out my hair here because my PHP/MySQL is rusty and I wasn’t any good at it when it wasn’t rusty.

I’ve been looking through this thread and I have pulled out an example of my news dumps for you to see if you can spot the problem in about 2 seconds flat.

I’m not sure if I should have posted a new thread when Disgruntled Tech showed us an example of what the table structure should look like in the “Cannot submit News after PHP Nuke 7.0 upgrade” post. I have because I haven’t upgraded and I’m talking about PHP-Nuke 6.7. He did give me an idea of what I had to show you to help you help me sort the problem out though. Here are the table structures:

nuke_stories is this:

Quote:

CREATE TABLE `writers_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( Cool

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',
`associated` text NOT NULL,
PRIMARY KEY (`sid`),
KEY `sid` (`sid`),
KEY `catid` (`catid`),
KEY `counter` (`counter`),
KEY `topic` (`topic`)
) TYPE=MyISAM AUTO_INCREMENT=16 ;

And nuke_autonews is this:

Quote:

DROP TABLE IF EXISTS `writers_autonews`;
CREATE TABLE `writers_autonews` (
`anid` int(11) NOT NULL auto_increment,
`catid` int(11) NOT NULL default '0',
`aid` varchar(30) NOT NULL default '',
`title` varchar(80) NOT NULL default '',
`time` varchar(19) NOT NULL default '',
`hometext` text NOT NULL,
`bodytext` text NOT 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',
`associated` text NOT NULL,
PRIMARY KEY (`anid`),
KEY `anid` (`anid`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

I was looking at the differences and all that I could see was the last lines were different. For instance:

nuke_stories should read like this:

Quote:

TYPE=MyISAM AUTO_INCREMENT=4 ;

Instead I have:

Quote:

TYPE=MyISAM AUTO_INCREMENT=16 ;

nuke_autonews should read like this:

Quote:

TYPE=MyISAM AUTO_INCREMENT=1 ;

Instead I have:

Quote:

TYPE=MyISAM AUTO_INCREMENT=2 ;

Just different increment values.

Please tell me could this be causing my problem?

Or is it something else altogether?

I much appreciate any help you can give me!

Yours sincerely,

Craig Johnson.

PS I'm asking you only because I would rather not play with it and possibly make a pig's ear out of it.

Nuke Soldier Joined: Jan 01, 2005 Posts: 12

Any ideas people?

Please help me!
Craig.