thumpn8974

|
Posted:
Mon Oct 10, 2011 10:26 am |
|
Here is the script for the SQL if anyone wants it:
Quote: | (mysql): SELECT * FROM `nuke_bbtopics` (mysql): SELECT * FROM `nuke_bbtopics` (mysql): SELECT * FROM `nuke_bbtopics` (mysql): SELECT * FROM `nuke_bbposts` (mysql): SELECT * FROM `nuke_bbvote_desc` (mysql): CREATE TABLE `nuke_pf_config` (`keyfld` int(11) NOT NULL auto_increment,`apptxt` longtext NOT NULL,`admaddr` text NOT NULL,`emdetail` tinyint(1) NOT NULL default '0',`fpdetail` tinyint(1) NOT NULL default '0',`group_id` mediumint( NOT NULL default '0',`forum_id` smallint(5) NOT NULL default '0',`tytxt` longtext NOT NULL,`noapptxt` longtext NOT NULL,`termsloc` tinyint(1) NOT NULL,`termspagetxt` longtext NOT NULL,`appson` tinyint(1) NOT NULL default '1',`current` tinyint(1) NOT NULL default '0',`formtitle` varchar(64) NOT NULL default '',`appslimit` tinyint(1) NOT NULL default '0',`appslimitno` int(11) NOT NULL default '0',`appsfull` tinyint(1) NOT NULL default '0',`group_add` mediumint( NOT NULL default '0',`block_multi_apps` tinyint(1) NOT NULL default '1',`email_admin` tinyint(1) NOT NULL default '1',`mailgroup` tinyint(1) NOT NULL default '0',`topicwatch` tinyint(1) NOT NULL default '0',`emuser` tinyint(1) NOT NULL default '0',`formno` int(11) NOT NULL default '0',`annon` tinyint(1) NOT NULL default '0',`VertAlign` tinyint(1) NOT NULL default '0',`auto_group` tinyint(1) NOT NULL default '0',`approvtxt` longtext NOT NULL,`denytxt` longtext NOT NULL,`formlist` tinyint(1) NOT NULL default '0',`compat` BOOL NOT NULL default '0',`emhtml` BOOL NOT NULL default '0',`restrict_group` BOOL NOT NULL default '0',`group_restrict` mediumint( NOT NULL default '0',`listapp` BOOL NOT NULL default '0',`showuser` BOOL NOT NULL default '0',`blockscroll` BOOL NOT NULL default '0',`rccolor` varchar(15) NOT NULL default '0',`dccolor` varchar(15) NOT NULL default '0',`accolor` varchar(15) NOT NULL default '0',`appslnsperpg` smallint(6) NOT NULL default '0',`setmanager` BOOL NOT NULL default '0',`group_manager` int(11) NOT NULL default '0',`approvedword` varchar(25) NOT NULL default '',`deniedword` varchar(25) NOT NULL default '',`recievedword` varchar(25) NOT NULL default '',`useauc` tinyint(1) NOT NULL,`addpoll` tinyint(1) NOT NULL,`poll_text` longtext NOT NULL,`poll_length` int(11) NOT NULL default '0',`poll_view_switch` tinyint(1) NOT NULL,`poll_options` longtext NOT NULL,`yani` text NOT NULL,`SubmitButton` varchar(24) NOT NULL default '',UNIQUE KEY `keyfld` (`keyfld`)) AUTO_INCREMENT=0 1050: Table 'nuke_pf_config' already exists
ADOConnection._Execute() % line 0, file: adodb.inc.php
ADOConnection.Execute() % line 0, file: functions_sql.php
PFsql_db.sql_query() % line 0, file: PForms_Install_200.php
install_1_0_1() % line 0, file: PForms_Install_200.php
Table 'nuke_pf_config' already existsCREATE TABLE `nuke_pf_config` (`keyfld` int(11) NOT NULL auto_increment,`apptxt` longtext NOT NULL,`admaddr` text NOT NULL,`emdetail` tinyint(1) NOT NULL default '0',`fpdetail` tinyint(1) NOT NULL default '0',`group_id` mediumint( NOT NULL default '0',`forum_id` smallint(5) NOT NULL default '0',`tytxt` longtext NOT NULL,`noapptxt` longtext NOT NULL,`termsloc` tinyint(1) NOT NULL,`termspagetxt` longtext NOT NULL,`appson` tinyint(1) NOT NULL default '1',`current` tinyint(1) NOT NULL default '0',`formtitle` varchar(64) NOT NULL default '',`appslimit` tinyint(1) NOT NULL default '0',`appslimitno` int(11) NOT NULL default '0',`appsfull` tinyint(1) NOT NULL default '0',`group_add` mediumint( NOT NULL default '0',`block_multi_apps` tinyint(1) NOT NULL default '1',`email_admin` tinyint(1) NOT NULL default '1',`mailgroup` tinyint(1) NOT NULL default '0',`topicwatch` tinyint(1) NOT NULL default '0',`emuser` tinyint(1) NOT NULL default '0',`formno` int(11) NOT NULL default '0',`annon` tinyint(1) NOT NULL default '0',`VertAlign` tinyint(1) NOT NULL default '0',`auto_group` tinyint(1) NOT NULL default '0',`approvtxt` longtext NOT NULL,`denytxt` longtext NOT NULL,`formlist` tinyint(1) NOT NULL default '0',`compat` BOOL NOT NULL default '0',`emhtml` BOOL NOT NULL default '0',`restrict_group` BOOL NOT NULL default '0',`group_restrict` mediumint( NOT NULL default '0',`listapp` BOOL NOT NULL default '0',`showuser` BOOL NOT NULL default '0',`blockscroll` BOOL NOT NULL default '0',`rccolor` varchar(15) NOT NULL default '0',`dccolor` varchar(15) NOT NULL default '0',`accolor` varchar(15) NOT NULL default '0',`appslnsperpg` smallint(6) NOT NULL default '0',`setmanager` BOOL NOT NULL default '0',`group_manager` int(11) NOT NULL default '0',`approvedword` varchar(25) NOT NULL default '',`deniedword` varchar(25) NOT NULL default '',`recievedword` varchar(25) NOT NULL default '',`useauc` tinyint(1) NOT NULL,`addpoll` tinyint(1) NOT NULL,`poll_text` longtext NOT NULL,`poll_length` int(11) NOT NULL default '0',`poll_view_switch` tinyint(1) NOT NULL,`poll_options` longtext NOT NULL,`yani` text NOT NULL,`SubmitButton` varchar(24) NOT NULL default '',UNIQUE KEY `keyfld` (`keyfld`)) AUTO_INCREMENT=0
Table 'nuke_pf_config' already existserror Message: Table 'nuke_pf_config' already exists SQL Error
(mysql): CREATE TABLE `nuke_pf_questions` (`fldnum` int(10) unsigned NOT NULL auto_increment,`fldord` int(11) NOT NULL default '0',`fldname` text NOT NULL,`requrd` char(1) NOT NULL default '',`inuse` char(1) NOT NULL default '',`format` char(1) NOT NULL default '',`parent` smallint(6) NOT NULL default '0',`isdel` tinyint(1) NOT NULL default '0',`formno` int(11) NOT NULL default '0',`rgextxt` text,`tarows` smallint(6) NOT NULL default '0',`tacols` smallint(6) NOT NULL default '0',`tatxt` longtext NOT NULL,`talign` varchar(6) NOT NULL,`rpos` varchar(20) NOT NULL,`ralign` varchar(6) NOT NULL,`qfnr` tinyint(1) NOT NULL,`qufl` tinyint(1) NOT NULL,`qframe` tinyint(1) NOT NULL, UNIQUE KEY `fldnum` (`fldnum`)) AUTO_INCREMENT=0 1050: Table 'nuke_pf_questions' already exists
ADOConnection._Execute() % line 0, file: adodb.inc.php
ADOConnection.Execute() % line 0, file: functions_sql.php
PFsql_db.sql_query() % line 0, file: PForms_Install_200.php
install_1_0_1() % line 0, file: PForms_Install_200.php
Table 'nuke_pf_questions' already existsCREATE TABLE `nuke_pf_config` (`keyfld` int(11) NOT NULL auto_increment,`apptxt` longtext NOT NULL,`admaddr` text NOT NULL,`emdetail` tinyint(1) NOT NULL default '0',`fpdetail` tinyint(1) NOT NULL default '0',`group_id` mediumint( NOT NULL default '0',`forum_id` smallint(5) NOT NULL default '0',`tytxt` longtext NOT NULL,`noapptxt` longtext NOT NULL,`termsloc` tinyint(1) NOT NULL,`termspagetxt` longtext NOT NULL,`appson` tinyint(1) NOT NULL default '1',`current` tinyint(1) NOT NULL default '0',`formtitle` varchar(64) NOT NULL default '',`appslimit` tinyint(1) NOT NULL default '0',`appslimitno` int(11) NOT NULL default '0',`appsfull` tinyint(1) NOT NULL default '0',`group_add` mediumint( NOT NULL default '0',`block_multi_apps` tinyint(1) NOT NULL default '1',`email_admin` tinyint(1) NOT NULL default '1',`mailgroup` tinyint(1) NOT NULL default '0',`topicwatch` tinyint(1) NOT NULL default '0',`emuser` tinyint(1) NOT NULL default '0',`formno` int(11) NOT NULL default '0',`annon` tinyint(1) NOT NULL default '0',`VertAlign` tinyint(1) NOT NULL default '0',`auto_group` tinyint(1) NOT NULL default '0',`approvtxt` longtext NOT NULL,`denytxt` longtext NOT NULL,`formlist` tinyint(1) NOT NULL default '0',`compat` BOOL NOT NULL default '0',`emhtml` BOOL NOT NULL default '0',`restrict_group` BOOL NOT NULL default '0',`group_restrict` mediumint( NOT NULL default '0',`listapp` BOOL NOT NULL default '0',`showuser` BOOL NOT NULL default '0',`blockscroll` BOOL NOT NULL default '0',`rccolor` varchar(15) NOT NULL default '0',`dccolor` varchar(15) NOT NULL default '0',`accolor` varchar(15) NOT NULL default '0',`appslnsperpg` smallint(6) NOT NULL default '0',`setmanager` BOOL NOT NULL default '0',`group_manager` int(11) NOT NULL default '0',`approvedword` varchar(25) NOT NULL default '',`deniedword` varchar(25) NOT NULL default '',`recievedword` varchar(25) NOT NULL default '',`useauc` tinyint(1) NOT NULL,`addpoll` tinyint(1) NOT NULL,`poll_text` longtext NOT NULL,`poll_length` int(11) NOT NULL default '0',`poll_view_switch` tinyint(1) NOT NULL,`poll_options` longtext NOT NULL,`yani` text NOT NULL,`SubmitButton` varchar(24) NOT NULL default '',UNIQUE KEY `keyfld` (`keyfld`)) AUTO_INCREMENT=0
CREATE TABLE `nuke_pf_questions` (`fldnum` int(10) unsigned NOT NULL auto_increment,`fldord` int(11) NOT NULL default '0',`fldname` text NOT NULL,`requrd` char(1) NOT NULL default '',`inuse` char(1) NOT NULL default '',`format` char(1) NOT NULL default '',`parent` smallint(6) NOT NULL default '0',`isdel` tinyint(1) NOT NULL default '0',`formno` int(11) NOT NULL default '0',`rgextxt` text,`tarows` smallint(6) NOT NULL default '0',`tacols` smallint(6) NOT NULL default '0',`tatxt` longtext NOT NULL,`talign` varchar(6) NOT NULL,`rpos` varchar(20) NOT NULL,`ralign` varchar(6) NOT NULL,`qfnr` tinyint(1) NOT NULL,`qufl` tinyint(1) NOT NULL,`qframe` tinyint(1) NOT NULL, UNIQUE KEY `fldnum` (`fldnum`)) AUTO_INCREMENT=0
Table 'nuke_pf_questions' already existserror Message: Table 'nuke_pf_questions' already exists SQL Error
(mysql): CREATE TABLE `nuke_pf_data` (`appno` int(11) NOT NULL auto_increment,`userno` int(11) NOT NULL default '0',`adate` text NOT NULL,`formno` int(11) NOT NULL default '0',`appstatus` tinyint(4) NOT NULL default '0',`qanda` longtext NOT NULL,`terms_on` tinyint(1) NOT NULL default '0',`terms_agree` tinyint(1) NOT NULL default '0',`user_ip` varchar(20) NOT NULL default '',`postid` int(11) NOT NULL default '0',`topid` int(11) NOT NULL default '0',`specialresponse` text NOT NULL,PRIMARY KEY (`appno`)) TYPE=MyISAM AUTO_INCREMENT=0 ; 1050: Table 'nuke_pf_data' already exists
ADOConnection._Execute() % line 0, file: adodb.inc.php
ADOConnection.Execute() % line 0, file: functions_sql.php
PFsql_db.sql_query() % line 0, file: PForms_Install_200.php
install_1_0_1() % line 0, file: PForms_Install_200.php
Table 'nuke_pf_data' already existsCREATE TABLE `nuke_pf_config` (`keyfld` int(11) NOT NULL auto_increment,`apptxt` longtext NOT NULL,`admaddr` text NOT NULL,`emdetail` tinyint(1) NOT NULL default '0',`fpdetail` tinyint(1) NOT NULL default '0',`group_id` mediumint( NOT NULL default '0',`forum_id` smallint(5) NOT NULL default '0',`tytxt` longtext NOT NULL,`noapptxt` longtext NOT NULL,`termsloc` tinyint(1) NOT NULL,`termspagetxt` longtext NOT NULL,`appson` tinyint(1) NOT NULL default '1',`current` tinyint(1) NOT NULL default '0',`formtitle` varchar(64) NOT NULL default '',`appslimit` tinyint(1) NOT NULL default '0',`appslimitno` int(11) NOT NULL default '0',`appsfull` tinyint(1) NOT NULL default '0',`group_add` mediumint( NOT NULL default '0',`block_multi_apps` tinyint(1) NOT NULL default '1',`email_admin` tinyint(1) NOT NULL default '1',`mailgroup` tinyint(1) NOT NULL default '0',`topicwatch` tinyint(1) NOT NULL default '0',`emuser` tinyint(1) NOT NULL default '0',`formno` int(11) NOT NULL default '0',`annon` tinyint(1) NOT NULL default '0',`VertAlign` tinyint(1) NOT NULL default '0',`auto_group` tinyint(1) NOT NULL default '0',`approvtxt` longtext NOT NULL,`denytxt` longtext NOT NULL,`formlist` tinyint(1) NOT NULL default '0',`compat` BOOL NOT NULL default '0',`emhtml` BOOL NOT NULL default '0',`restrict_group` BOOL NOT NULL default '0',`group_restrict` mediumint( NOT NULL default '0',`listapp` BOOL NOT NULL default '0',`showuser` BOOL NOT NULL default '0',`blockscroll` BOOL NOT NULL default '0',`rccolor` varchar(15) NOT NULL default '0',`dccolor` varchar(15) NOT NULL default '0',`accolor` varchar(15) NOT NULL default '0',`appslnsperpg` smallint(6) NOT NULL default '0',`setmanager` BOOL NOT NULL default '0',`group_manager` int(11) NOT NULL default '0',`approvedword` varchar(25) NOT NULL default '',`deniedword` varchar(25) NOT NULL default '',`recievedword` varchar(25) NOT NULL default '',`useauc` tinyint(1) NOT NULL,`addpoll` tinyint(1) NOT NULL,`poll_text` longtext NOT NULL,`poll_length` int(11) NOT NULL default '0',`poll_view_switch` tinyint(1) NOT NULL,`poll_options` longtext NOT NULL,`yani` text NOT NULL,`SubmitButton` varchar(24) NOT NULL default '',UNIQUE KEY `keyfld` (`keyfld`)) AUTO_INCREMENT=0
CREATE TABLE `nuke_pf_questions` (`fldnum` int(10) unsigned NOT NULL auto_increment,`fldord` int(11) NOT NULL default '0',`fldname` text NOT NULL,`requrd` char(1) NOT NULL default '',`inuse` char(1) NOT NULL default '',`format` char(1) NOT NULL default '',`parent` smallint(6) NOT NULL default '0',`isdel` tinyint(1) NOT NULL default '0',`formno` int(11) NOT NULL default '0',`rgextxt` text,`tarows` smallint(6) NOT NULL default '0',`tacols` smallint(6) NOT NULL default '0',`tatxt` longtext NOT NULL,`talign` varchar(6) NOT NULL,`rpos` varchar(20) NOT NULL,`ralign` varchar(6) NOT NULL,`qfnr` tinyint(1) NOT NULL,`qufl` tinyint(1) NOT NULL,`qframe` tinyint(1) NOT NULL, UNIQUE KEY `fldnum` (`fldnum`)) AUTO_INCREMENT=0
CREATE TABLE `nuke_pf_data` (`appno` int(11) NOT NULL auto_increment,`userno` int(11) NOT NULL default '0',`adate` text NOT NULL,`formno` int(11) NOT NULL default '0',`appstatus` tinyint(4) NOT NULL default '0',`qanda` longtext NOT NULL,`terms_on` tinyint(1) NOT NULL default '0',`terms_agree` tinyint(1) NOT NULL default '0',`user_ip` varchar(20) NOT NULL default '',`postid` int(11) NOT NULL default '0',`topid` int(11) NOT NULL default '0',`specialresponse` text NOT NULL,PRIMARY KEY (`appno`)) TYPE=MyISAM AUTO_INCREMENT=0 ;
Table 'nuke_pf_data' already existserror Message: Table 'nuke_pf_data' already exists SQL Error
ERROR(1050) Table 'nuke_pf_data' already exists
ERROR 28 - Unable to create response table!
CREATE TABLE `nuke_pf_data` (`appno` int(11) NOT NULL auto_increment,`userno` int(11) NOT NULL default '0',`adate` text NOT NULL,`formno` int(11) NOT NULL default '0',`appstatus` tinyint(4) NOT NULL default '0',`qanda` longtext NOT NULL,`terms_on` tinyint(1) NOT NULL default '0',`terms_agree` tinyint(1) NOT NULL default '0',`user_ip` varchar(20) NOT NULL default '',`postid` int(11) NOT NULL default '0',`topid` int(11) NOT NULL default '0',`specialresponse` text NOT NULL,PRIMARY KEY (`appno`)) TYPE=MyISAM AUTO_INCREMENT=0 ;.
Error: (1050) Table 'nuke_pf_data' already exists |
|
|
|