Unable To Make New Survey After Downgrade FIX

Theme Guru Joined: Nov 01, 2003 Posts: 1006

This is still an issue with the downgrade script. I think someone should sticky this and get in touch with Bob to alter his downgrade script a little.

here are the table structures for both rn 7.6 and what is left after the downgrade script. This is preventing the surveys from creating.

Below is the table information left after running the downgrade.

Code:

CREATE TABLE `nuke_poll_desc` (


  `pollID` int(11) NOT NULL auto_increment,


  `pollTitle` varchar(100) NOT NULL default '',


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


  `voters` mediumint(9) NOT NULL default '0',


  `planguage` varchar(30) NOT NULL default '',


  `artid` int(10) NOT NULL default '0',


  `comments` int(11) default '0',


  PRIMARY KEY  (`pollID`),


  KEY `pollID` (`pollID`)


) TYPE=MyISAM AUTO_INCREMENT=6 ;

Below is the RN table

Code:

CREATE TABLE `nuke_poll_desc` ( 


`pollID` int(11) NOT NULL auto_increment,


`pollTitle` varchar(100) NOT NULL default '', 


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


`voters` mediumint(9) NOT NULL default '0', 


`planguage` varchar(30) NOT NULL default '', 


`artid` int(10) NOT NULL default '0',


PRIMARY KEY  (`pollID`)


) TYPE=MyISAM;

You have to change this ,remove the comments property, to get the module to function correctly. You can of course still use your current surveys, view the old ones, etc. However, You cannot make a new one at all. It results in a white page.

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

Good point. Have you notified Bob?

Posted: Sun Jun 04, 2006 8:25 am

I sent him an email via his site but have not heard back. Perhaps he is away. I do think that at least making this a sticky would make it easier for others to find for now.

Posted: Sun Jun 04, 2006 11:57 am

now i know this is still a valid point...but ive noticed this same thing on other modules....if u run a query from phpmyadmin...it doesnt matter if u fill in ALL the values...but in php...miss one and somethin wont operate correctly...curious as to why this is.

Sells PC To Pay For Divorce Joined: Posts: 5661

still?
If it was interesting enough it would have been solved by now..
the less people downgrade...the less important it gets debugging it..

Regular Joined: Aug 05, 2006 Posts: 55 Location: Thailand

I am having the exact problem described in the original post with my recent downgrade from 7.8 to RN 7.6.

Could someone be kind enough to explain in simple terms where I need to go (which file) in order to remove the "comment" property described?

EDIT- Nevermind- found it in the SQL table nuke_poll_desc and deleted it with PHPmyadmin. Problem solved.

Posted: Thu Aug 17, 2006 8:59 am

great! I am glad that it helped you!