Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v2.00.00 - v2.02.00 Distro
Author Message
jaded
Theme Guru


Joined: Nov 01, 2003
Posts: 1006

PostPosted: Sun Jun 04, 2006 6:22 am Reply with quote

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.

_________________
Themes BB Skins Only registered users can see links on this board! Get registered or login!
Graphic Tees Only registered users can see links on this board! Get registered or login!
Paranormal Tees Only registered users can see links on this board! Get registered or login!
Ghost Stories & More Only registered users can see links on this board! Get registered or login!

Last edited by jaded on Thu Aug 17, 2006 9:00 am; edited 1 time in total 
View user's profile Send private message Visit poster's website
kguske
Site Admin


Joined: Jun 04, 2004
Posts: 6383

PostPosted: Sun Jun 04, 2006 8:21 am Reply with quote

Good point. Have you notified Bob?

_________________
I google, therefore I exist...
Only registered users can see links on this board! Get registered or login!
 
View user's profile Send private message
jaded
PostPosted: Sun Jun 04, 2006 8:25 am Reply with quote

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.
 
gregexp
The Mouse Is Extension Of Arm


Joined: Feb 21, 2006
Posts: 1497
Location: In front of a screen....HELP! lol

PostPosted: Sun Jun 04, 2006 11:57 am Reply with quote

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.

_________________
For those who stand shall NEVER fall and those who fall shall RISE once more!! 
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number
hitwalker
Sells PC To Pay For Divorce


Joined:
Posts: 5661

PostPosted: Sun Jun 04, 2006 2:07 pm Reply with quote

still?
If it was interesting enough it would have been solved by now..
the less people downgrade...the less important it gets debugging it..
 
View user's profile Send private message
Meoff
Regular
Regular


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

PostPosted: Thu Aug 17, 2006 8:16 am Reply with quote

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.
 
View user's profile Send private message Visit poster's website
jaded
PostPosted: Thu Aug 17, 2006 8:59 am Reply with quote

Smile great! I am glad that it helped you!
 
Display posts from previous:       
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v2.00.00 - v2.02.00 Distro

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©