News Module - Users get "_error" on white page whe

Regular Joined: Aug 15, 2006 Posts: 66

With reference to this post: Only registered users can see links on this board! Get registered or login!

I have a similar problem as Oriona had with my site getting hacked. I have since moved to a new server, put in a fresh install of 7.6 patched with sentinal and repaired and reinstalled the database. I have no problems with posting news from the admin module, but when posting from the users module it simply hangs to a white page with _error as the text module. (The language module for the news does not appear to be complete).

I've looked through the code and followed all the instructions above - however I'm not missing any fields that I could see and nothing else appeared out of place. Here's the table structure:

Code:

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


  `associated` text NOT NULL,


  PRIMARY KEY  (`sid`),


  KEY `sid` (`sid`),


  KEY `catid` (`catid`),


  KEY `counter` (`counter`),


  KEY `topic` (`topic`)

I've had other issues with the news module - such as news items not opening at odd times and hanging as unresolved IP address (I've posted about this seperately a few months ago Only registered users can see links on this board! Get registered or login!). I think the two issues are related.

registered · Posted: Sat Oct 28, 2006 11:55 pm

Check the queue table structure. For 7.6, it should look like

Code:




CREATE TABLE nuke_queue (


  qid smallint(5) unsigned NOT NULL auto_increment,


  uid mediumint(9) NOT NULL default '0',


  uname varchar(40) NOT NULL default '',


  subject varchar(100) NOT NULL default '',


  story text,


  storyext text NOT NULL,


  timestamp datetime NOT NULL default '0000-00-00 00:00:00',


  topic varchar(20) NOT NULL default '',


  alanguage varchar(30) NOT NULL default '',


  PRIMARY KEY  (qid),


  KEY qid (qid),


  KEY uid (uid),


  KEY uname (uname)


) TYPE=MyISAM;

Posted: Sun Oct 29, 2006 12:10 am

Hi Evaders,

Checked and okay.

I've actually reinstalled both tables and then reinstalled all new news items since the site got hacked and I don't have a problem. So it appears to the "_Error" could have something to do with the data from the old table before I upgraded etc - though the fields seem to be the same.... I'm just going to hold off for now on adding the old news data until I find out what it is that's causing the problem.

I still have the intermittent re-direction problem so it doesn't appear as if that is caused by the same problem : (

Thanks for help again.