Cannot post news items - they simply vanish on submitting

registered · Hangin' Around Joined: Aug 17, 2004 Posts: 43

Hi All,

I have upgraded from Nuke 7.6 to RN 2.20.01 and everything was working fine. Now all of a sudden, I cannot do any news posts. The moment I post a news article it vanishes - I can preview it etc. but cannot post to database. The following is my nuke_stories table structure -

Code:

--


-- Table structure for table `nuke_stories`


--





CREATE TABLE IF NOT EXISTS `nuke_stories` (


  `sid` int(11) NOT NULL auto_increment,


  `catid` int(11) NOT NULL default '0',


  `aid` varchar(25) NOT NULL default '' COMMENT '\0\0\0\0\0\0\0\0\0\0\0!\0\0H',


  `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 '' COMMENT '\0\0\0\0\0\0\0\0\0\0\0!\0\0H',


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


  `image` varchar(255) NOT NULL default '',


  PRIMARY KEY  (`sid`),


  KEY `sid` (`sid`),


  KEY `catid` (`catid`),


  KEY `counter` (`counter`),


  KEY `topic` (`topic`)


) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1446 ;

Anything missing or incorrect? Question

Posted: Wed Oct 15, 2008 5:40 am

Have you turned error reporting on and DB logging?

Please post back with any errors generated.

New Member Joined: Apr 11, 2008 Posts: 8

I am having the same problem but I did not upgrade the nuke. I am still using nuke8. I can preview the news posts I make but I can not post them. They just vanish without a trace.

Anyone Please help me.. I have nt changed anything or done anything jut today poof no posts.....

I even put on the display error to show the errors.... Well with most programs it shows it on he page.. well if its true with nuke nothing is showing up.. no errors so im stuck... please help...

Posted: Thu Oct 16, 2008 2:33 am

jakec wrote:

Have you turned error reporting on and DB logging?

Please post back with any errors generated.

Error reporting is on, but no errors are reports. Not sure about DB Logging Embarassed

but when I click submit, it vanishes.

Posted: Thu Oct 16, 2008 5:56 am

Look in rnconfig.php I believe the setting is in there to activate and the instructions on using it.

Posted: Fri Oct 17, 2008 4:01 am

The following errors are in the dblogs:

Code:

*** YES, THIS IS A BLANK FILE - MAKE SURE PERMISSIONS ARE 666 SO IT CAN BE WRITTEN TO ***


October 17, 2008, 3:25 pm 1054 : Unknown column 'config_name' in 'field list'


SQL was: SELECT `config_name`, `config_value` FROM `nuke_nsnsp_config`


 remote addr: 59.94.195.96


October 17, 2008, 3:25 pm 1146 : Table 'pot10000_test.nuke_mail_config' doesn't exist


SQL was: SELECT * FROM nuke_mail_config


 remote addr: 59.94.195.96


October 17, 2008, 3:25 pm 1054 : Unknown column 'config_name' in 'field list'


SQL was: SELECT `config_name`, `config_value` FROM `nuke_nsnsp_config`


 remote addr: 81.52.143.15


October 17, 2008, 3:25 pm 1146 : Table 'pot10000_test.nuke_mail_config' doesn't exist


SQL was: SELECT * FROM nuke_mail_config


 remote addr: 81.52.143.15


October 17, 2008, 3:25 pm 1146 : Table 'pot10000_test.nuke_seo_feed' doesn't exist


SQL was: SELECT * FROM nuke_seo_feed WHERE (fid>0 and active = 1) ORDER BY name, title


 remote addr: 81.52.143.15


October 17, 2008, 3:26 pm 1054 : Unknown column 'config_name' in 'field list'


SQL was: SELECT `config_name`, `config_value` FROM `nuke_nsnsp_config`


 remote addr: 116.90.164.19


October 17, 2008, 3:26 pm 1146 : Table 'pot10000_test.nuke_mail_config' doesn't exist


SQL was: SELECT * FROM nuke_mail_config


 remote addr: 116.90.164.19


October 17, 2008, 3:26 pm 1146 : Table 'pot10000_test.nuke_seo_feed' doesn't exist


SQL was: SELECT * FROM nuke_seo_feed WHERE (fid>0 and active = 1) ORDER BY name, title


 remote addr: 116.90.164.19


October 17, 2008, 3:26 pm 1054 : Unknown column 'config_name' in 'field list'


SQL was: SELECT `config_name`, `config_value` FROM `nuke_nsnsp_config`


 remote addr: 74.6.8.97


October 17, 2008, 3:26 pm 1146 : Table 'pot10000_test.nuke_mail_config' doesn't exist


SQL was: SELECT * FROM nuke_mail_config


 remote addr: 74.6.8.97


October 17, 2008, 3:26 pm 1146 : Table 'pot10000_test.nuke_seo_feed' doesn't exist


SQL was: SELECT * FROM nuke_seo_feed WHERE (fid>0 and active = 1) ORDER BY name, title


 remote addr: 74.6.8.97


October 17, 2008, 3:26 pm 1054 : Unknown column 'config_name' in 'field list'


SQL was: SELECT `config_name`, `config_value` FROM `nuke_nsnsp_config`


 remote addr: 59.94.195.96


October 17, 2008, 3:26 pm 1146 : Table 'pot10000_test.nuke_mail_config' doesn't exist


SQL was: SELECT * FROM nuke_mail_config


 remote addr: 59.94.195.96


October 17, 2008, 3:26 pm 1136 : Column count doesn't match value count at row 1


SQL was: insert into nuke_stories values (NULL, '11', 'Jibran', 'Testing a news post', now(), 'Testing a news posting to see if it is working. Working a new news posting system.', '', 0, 0, '2', 'Jibran', '', '0', 'english', '0', '0', '0', 0, 0, '2-')


 remote addr: 59.94.195.96


October 17, 2008, 3:26 pm 1054 : Unknown column 'config_name' in 'field list'


SQL was: SELECT `config_name`, `config_value` FROM `nuke_nsnsp_config`


 remote addr: 59.94.195.96


October 17, 2008, 3:26 pm 1146 : Table 'pot10000_test.nuke_mail_config' doesn't exist


SQL was: SELECT * FROM nuke_mail_config


 remote addr: 59.94.195.96


October 17, 2008, 3:26 pm 1054 : Unknown column 'config_name' in 'field list'


SQL was: SELECT `config_name`, `config_value` FROM `nuke_nsnsp_config`


 remote addr: 38.108.180.99


October 17, 2008, 3:26 pm 1146 : Table 'pot10000_test.nuke_mail_config' doesn't exist


SQL was: SELECT * FROM nuke_mail_config


 remote addr: 38.108.180.99


October 17, 2008, 3:26 pm 1146 : Table 'pot10000_test.nuke_seo_feed' doesn't exist


SQL was: SELECT * FROM nuke_seo_feed WHERE (fid>0 and active = 1) ORDER BY name, title


 remote addr: 38.108.180.99


October 17, 2008, 3:26 pm 1054 : Unknown column 'config_name' in 'field list'


SQL was: SELECT `config_name`, `config_value` FROM `nuke_nsnsp_config`


 remote addr: 67.195.37.126


October 17, 2008, 3:26 pm 1146 : Table 'pot10000_test.nuke_mail_config' doesn't exist


SQL was: SELECT * FROM nuke_mail_config


 remote addr: 67.195.37.126


October 17, 2008, 3:26 pm 1146 : Table 'pot10000_test.nuke_seo_feed' doesn't exist


SQL was: SELECT * FROM nuke_seo_feed WHERE (fid>0 and active = 1) ORDER BY name, title


 remote addr: 67.195.37.126


October 17, 2008, 3:26 pm 1054 : Unknown column 'config_name' in 'field list'


SQL was: SELECT `config_name`, `config_value` FROM `nuke_nsnsp_config`


 remote addr: 66.249.71.34


October 17, 2008, 3:26 pm 1146 : Table 'pot10000_test.nuke_mail_config' doesn't exist


SQL was: SELECT * FROM nuke_mail_config


 remote addr: 66.249.71.34


October 17, 2008, 3:26 pm 1146 : Table 'pot10000_test.nuke_seo_feed' doesn't exist


SQL was: SELECT * FROM nuke_seo_feed WHERE (fid>0 and active = 1) ORDER BY name, title


 remote addr: 66.249.71.34


October 17, 2008, 3:27 pm 1054 : Unknown column 'config_name' in 'field list'


SQL was: SELECT `config_name`, `config_value` FROM `nuke_nsnsp_config`


 remote addr: 116.90.164.19


October 17, 2008, 3:27 pm 1146 : Table 'pot10000_test.nuke_mail_config' doesn't exist


SQL was: SELECT * FROM nuke_mail_config


 remote addr: 116.90.164.19


October 17, 2008, 3:27 pm 1146 : Table 'pot10000_test.nuke_seo_feed' doesn't exist


SQL was: SELECT * FROM nuke_seo_feed WHERE (fid>0 and active = 1) ORDER BY name, title


 remote addr: 116.90.164.19


October 17, 2008, 3:27 pm 1054 : Unknown column 'config_name' in 'field list'


SQL was: SELECT `config_name`, `config_value` FROM `nuke_nsnsp_config`


 remote addr: 116.90.164.19


October 17, 2008, 3:27 pm 1146 : Table 'pot10000_test.nuke_mail_config' doesn't exist


SQL was: SELECT * FROM nuke_mail_config


 remote addr: 116.90.164.19


October 17, 2008, 3:27 pm 1146 : Table 'pot10000_test.nuke_seo_feed' doesn't exist


SQL was: SELECT * FROM nuke_seo_feed WHERE (fid>0 and active = 1) ORDER BY name, title


 remote addr: 116.90.164.19


October 17, 2008, 3:27 pm 1054 : Unknown column 'config_name' in 'field list'


SQL was: SELECT `config_name`, `config_value` FROM `nuke_nsnsp_config`


 remote addr: 116.90.164.19


October 17, 2008, 3:27 pm 1146 : Table 'pot10000_test.nuke_mail_config' doesn't exist


SQL was: SELECT * FROM nuke_mail_config


 remote addr: 116.90.164.19


October 17, 2008, 3:27 pm 1146 : Table 'pot10000_test.nuke_seo_feed' doesn't exist


SQL was: SELECT * FROM nuke_seo_feed WHERE (fid>0 and active = 1) ORDER BY name, title


 remote addr: 116.90.164.19


October 17, 2008, 3:27 pm 1054 : Unknown column 'config_name' in 'field list'


SQL was: SELECT `config_name`, `config_value` FROM `nuke_nsnsp_config`


 remote addr: 71.204.45.125


October 17, 2008, 3:27 pm 1146 : Table 'pot10000_test.nuke_mail_config' doesn't exist


SQL was: SELECT * FROM nuke_mail_config


 remote addr: 71.204.45.125


October 17, 2008, 3:27 pm 1146 : Table 'pot10000_test.nuke_seo_feed' doesn't exist


SQL was: SELECT * FROM nuke_seo_feed WHERE (fid>0 and active = 1) ORDER BY name, title


 remote addr: 71.204.45.125


October 17, 2008, 3:27 pm 1054 : Unknown column 'config_name' in 'field list'


SQL was: SELECT `config_name`, `config_value` FROM `nuke_nsnsp_config`


 remote addr: 71.204.45.125


October 17, 2008, 3:27 pm 1146 : Table 'pot10000_test.nuke_mail_config' doesn't exist


SQL was: SELECT * FROM nuke_mail_config


 remote addr: 71.204.45.125


October 17, 2008, 3:27 pm 1146 : Table 'pot10000_test.nuke_seo_feed' doesn't exist


SQL was: SELECT * FROM nuke_seo_feed WHERE (fid>0 and active = 1) ORDER BY name, title


 remote addr: 71.204.45.125


October 17, 2008, 3:28 pm 1054 : Unknown column 'config_name' in 'field list'


SQL was: SELECT `config_name`, `config_value` FROM `nuke_nsnsp_config`


 remote addr: 74.6.8.97


October 17, 2008, 3:28 pm 1146 : Table 'pot10000_test.nuke_mail_config' doesn't exist


SQL was: SELECT * FROM nuke_mail_config


 remote addr: 74.6.8.97


October 17, 2008, 3:28 pm 1146 : Table 'pot10000_test.nuke_seo_feed' doesn't exist


SQL was: SELECT * FROM nuke_seo_feed WHERE (fid>0 and active = 1) ORDER BY name, title


 remote addr: 74.6.8.97

Hmm, so many errors? I am stumped.

Posted: Fri Oct 17, 2008 5:36 am

It looks like you have a few problems with your database tables. I would recommend comparing your database to a stock RN database using a tool like mySQLDiff.

Posted: Fri Oct 17, 2008 3:48 pm

You can look in rn_core.sql file in the INSTALLATION folder of your distribution for the "official" definitions of any tables. I see no "image" field in the official definition for the stories table and that's probably what's generating the errors. I also can find no reference to nsnsp table in the INSTALLATION directory. I have no idea what that is. You should probably look through your distribution and see what program is referencing that and maybe we can figure out what's wrong. You may also need to reference the HowToInstall guide to figure out how to activate the mail and seo configurations because those tables are missing.

registered · Posted: Sat Oct 18, 2008 1:22 pm

jib_intelli, to get rid of many of these errors, simply go to the Administration Control Panel (ACP) and lick on the TegoNuke Mailer link/icon and nukeFEED one. That should take care of many of these. However, the one that is definitely the issue is this one:

October 17, 2008, 3:26 pm 1136 : Column count doesn't match value count at row 1
SQL was: insert into nuke_stories values

That is the one that is causing your specific issue. If I had to guess, you were once using NSN News (I can tell this because of the last column of data looks like a group number) and RN is NOT NSN News aware. So, you can either remove that column using phpMyAdmin, or re-install the NSN News script files.

Pretty sure this is your issue.

Posted: Sun Oct 19, 2008 1:58 am

LOVE YOU GUYS!!!

It worked!!! Thanks everyone - Problem solved! I just had an extra line in the nuke_stories structure - which as Montego said, I removed and the news posting is now working.

Posted: Sun Oct 19, 2008 6:28 am