Installation won't work

Posted: Sun Feb 05, 2006 10:47 pm

At any rate, after editing the file, I now come up with this new and exciting error:

ERROR! The exact error message that your MySQL server reported is Query was empty.

Any ideas?

Thanks

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

That's just what it means, no sarcasm intended. Some how your editing has either made the query a comment or it's not reading the file.

Posted: Mon Feb 06, 2006 1:27 am

Ya I know what you're saying but for the life of me I can't figure out what I'm doing wrong. I swear, this is the most trouble I've had with phpnuke since I started using it over 2 years ago.

All I did was replace -- with # as was stated earlier and that's it.

Code:




# phpMyAdmin SQL Dump


# version 2.6.0-pl3


# http://www.phpmyadmin.net


#


# Host: localhost


# Generation Time: Dec 16, 2005 at 10:49 PM


# Server version: 3.23.58


# PHP Version: 4.3.10


#


# Database: `mysitename_com_-_testing`


#





# --------------------------------------------------------





#


# Table structure for table `nuke_authors`


#





DROP TABLE IF EXISTS `nuke_authors`;


CREATE TABLE `nuke_authors` ( `aid` varchar(25) NOT NULL default '', `name` varchar(50) default NULL, `url` varchar(255) NOT NULL default '', `email` varchar(255) NOT NULL default '', `pwd` varchar(40) default NULL, `counter` int(11) NOT NULL default '0', `radminsuper` tinyint(1) NOT NULL default '1', `admlanguage` varchar(30) NOT NULL default '', PRIMARY KEY  (`aid`) ) TYPE=MyISAM;





#


# Dumping data for table `nuke_authors`


#





# --------------------------------------------------------





#


# Table structure for table `nuke_autonews`


#





DROP TABLE IF EXISTS `nuke_autonews`;


CREATE TABLE `nuke_autonews` ( `anid` int(11) NOT NULL auto_increment, `catid` int(11) NOT NULL default '0', `aid` varchar(25) NOT NULL default '', `title` varchar(80) NOT NULL default '', `time` varchar(19) NOT NULL default '', `hometext` text NOT NULL, `bodytext` text NOT NULL, `topic` int(3) NOT NULL default '1', `informant` varchar(25) 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', `associated` text NOT NULL, PRIMARY KEY  (`anid`) ) TYPE=MyISAM;





#


# Dumping data for table `nuke_autonews`


#








# --------------------------------------------------------





#


# Table structure for table `nuke_banned_ip`


#





DROP TABLE IF EXISTS `nuke_banned_ip`;


CREATE TABLE `nuke_banned_ip` ( `id` int(11) NOT NULL auto_increment, `ip_address` varchar(15) NOT NULL default '', `reason` varchar(255) NOT NULL default '', `date` date NOT NULL default '0000-00-00', PRIMARY KEY  (`id`) ) TYPE=MyISAM;





#


# Dumping data for table `nuke_banned_ip`


#








# --------------------------------------------------------





#


# Table structure for table `nuke_banner`


#





DROP TABLE IF EXISTS `nuke_banner`;


CREATE TABLE `nuke_banner` ( `bid` int(11) NOT NULL auto_increment, `cid` int(11) NOT NULL default '0', `imptotal` int(11) NOT NULL default '0', `impmade` int(11) NOT NULL default '0', `clicks` int(11) NOT NULL default '0', `imageurl` varchar(100) NOT NULL default '', `clickurl` varchar(200) NOT NULL default '', `alttext` varchar(255) NOT NULL default '', `date` datetime default NULL, `dateend` datetime default NULL, `type` tinyint(1) NOT NULL default '0', `active` tinyint(1) NOT NULL default '1', PRIMARY KEY  (`bid`), KEY `cid` (`cid`) ) TYPE=MyISAM;





#


# Dumping data for table `nuke_banner`


#








# --------------------------------------------------------





#


# Table structure for table `nuke_bannerclient`


#





DROP TABLE IF EXISTS `nuke_bannerclient`;


CREATE TABLE `nuke_bannerclient` ( `cid` int(11) NOT NULL auto_increment, `name` varchar(60) NOT NULL default '', `contact` varchar(60) NOT NULL default '', `email` varchar(60) NOT NULL default '', `login` varchar(10) NOT NULL default '', `passwd` varchar(10) NOT NULL default '', `extrainfo` text NOT NULL, PRIMARY KEY  (`cid`) ) TYPE=MyISAM;





#


# Dumping data for table `nuke_bannerclient`


#








# --------------------------------------------------------





#


# Table structure for table `nuke_bbauth_access`


#





DROP TABLE IF EXISTS `nuke_bbauth_access`;


CREATE TABLE `nuke_bbauth_access` ( `group_id` mediumint(8) NOT NULL default '0', `forum_id` smallint(5) unsigned NOT NULL default '0', `auth_view` tinyint(1) NOT NULL default '0', `auth_read` tinyint(1) NOT NULL default '0', `auth_post` tinyint(1) NOT NULL default '0', `auth_reply` tinyint(1) NOT NULL default '0', `auth_edit` tinyint(1) NOT NULL default '0', `auth_delete` tinyint(1) NOT NULL default '0', `auth_sticky` tinyint(1) NOT NULL default '0', `auth_announce` tinyint(1) NOT NULL default '0', `auth_vote` tinyint(1) NOT NULL default '0', `auth_pollcreate` tinyint(1) NOT NULL default '0', `auth_attachments` tinyint(1) NOT NULL default '0', `auth_mod` tinyint(1) NOT NULL default '0', KEY `group_id` (`group_id`), KEY `forum_id` (`forum_id`) ) TYPE=MyISAM;





#


# Dumping data for table `nuke_bbauth_access`


#








# --------------------------------------------------------





#


# Table structure for table `nuke_bbbanlist`


#





DROP TABLE IF EXISTS `nuke_bbbanlist`;


CREATE TABLE `nuke_bbbanlist` ( `ban_id` mediumint(8) unsigned NOT NULL auto_increment, `ban_userid` mediumint(8) NOT NULL default '0', `ban_ip` varchar(8) NOT NULL default '', `ban_email` varchar(255) default NULL, `ban_time` int(11) default NULL, `ban_expire_time` int(11) default NULL, `ban_by_userid` mediumint(8) default NULL, `ban_priv_reason` text, `ban_pub_reason_mode` tinyint(1) default NULL, `ban_pub_reason` text, PRIMARY KEY  (`ban_id`), KEY `ban_ip_user_id` (`ban_ip`,`ban_userid`) ) TYPE=MyISAM;





#


# Dumping data for table `nuke_bbbanlist`


#








# --------------------------------------------------------





#


# Table structure for table `nuke_bbcategories`


#





DROP TABLE IF EXISTS `nuke_bbcategories`;


CREATE TABLE `nuke_bbcategories` ( `cat_id` mediumint(8) unsigned NOT NULL auto_increment, `cat_title` varchar(100) default NULL, `cat_order` mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY  (`cat_id`), KEY `cat_order` (`cat_order`) ) TYPE=MyISAM;





#


# Dumping data for table `nuke_bbcategories`


#








# --------------------------------------------------------





#


# Table structure for table `nuke_bbconfig`


#





DROP TABLE IF EXISTS `nuke_bbconfig`;


CREATE TABLE `nuke_bbconfig` ( `config_name` varchar(255) NOT NULL default '', `config_value` varchar(255) NOT NULL default '', PRIMARY KEY  (`config_name`) ) TYPE=MyISAM;





#


# Dumping data for table `nuke_bbconfig`


#





..... and so on and so forth

I'm sorry for all the seemingly stupid questions here folks, I'd just love to figure this out.

As for my outdated version of MYSQL, I contacted my webhost and the reason I can't upgrade is that Ensim doesn't suppor any version higher than my current one (or so they say).

Posted: Mon Feb 06, 2006 1:57 am

You misread the earlier post. You need to replace the 2 -- with 2 ##, not just one.

Posted: Mon Feb 06, 2006 2:18 am

I had replaced -- with ## earlier but it made no difference. The reason I changed it to one # was based from the nuke.sql install on 7.0 (the version I'm currently using).

Honestly my friend, desperation has driven me here Confused

Posted: Mon Feb 06, 2006 2:34 am

Same error message with my original, adjusted version of the file:

Code:




## phpMyAdmin SQL Dump


## version 2.6.0-pl3


## http://www.phpmyadmin.net


##


## Host: localhost


## Generation Time: Dec 16, 2005 at 10:49 PM


## Server version: 3.23.58


## PHP Version: 4.3.10


##


## Database: `gamemoviemaking_com_-_testing`


##





## --------------------------------------------------------





##


## Table structure for table `nuke_authors`


##





DROP TABLE IF EXISTS `nuke_authors`;


CREATE TABLE `nuke_authors` ( `aid` varchar(25) NOT NULL default '', `name` varchar(50) default NULL, `url` varchar(255) NOT NULL default '', `email` varchar(255) NOT NULL default '', `pwd` varchar(40) default NULL, `counter` int(11) NOT NULL default '0', `radminsuper` tinyint(1) NOT NULL default '1', `admlanguage` varchar(30) NOT NULL default '', PRIMARY KEY  (`aid`) ) TYPE=MyISAM;





##


## Dumping data for table `nuke_authors`


##





## --------------------------------------------------------





##


## Table structure for table `nuke_autonews`


##





DROP TABLE IF EXISTS `nuke_autonews`;


CREATE TABLE `nuke_autonews` ( `anid` int(11) NOT NULL auto_increment, `catid` int(11) NOT NULL default '0', `aid` varchar(25) NOT NULL default '', `title` varchar(80) NOT NULL default '', `time` varchar(19) NOT NULL default '', `hometext` text NOT NULL, `bodytext` text NOT NULL, `topic` int(3) NOT NULL default '1', `informant` varchar(25) 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', `associated` text NOT NULL, PRIMARY KEY  (`anid`) ) TYPE=MyISAM;





##


## Dumping data for table `nuke_autonews`


##








## --------------------------------------------------------





...and so on and so forth

Posted: Mon Feb 06, 2006 3:05 am

Did the PM files work?

Posted: Mon Feb 06, 2006 3:06 am

Still working on it.

I'll have to update you tomorrow because I gotta work in the morning. So far so good though is all I can say.

Thanks again for all your invaluable help!

Posted: Mon Feb 06, 2006 3:45 am

So much for going to bed Confused

I am having some troubles with the nuke_subscriptions as follows:

MySQL said: Documentation
#1171 - All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead

Code:




DROP TABLE IF EXISTS `nuke_subscriptions`;


CREATE TABLE `nuke_subscriptions` ( `id` int(10) NOT NULL auto_increment, `userid` int(10) default '0', `subscription_expire` varchar(50) NOT NULL default '', PRIMARY KEY `id` (`id`,`userid`) ) TYPE=MyISAM;

Posted: Mon Feb 06, 2006 3:57 am

Loox like I was talking out my rear.

There was no way I could sleep knowing the help you provided me in getting this installed. Thanks again Raven, much appreciated.

It's installed and I'll monkey around tomorrow to see how it's working.

I still do need some help understanding the nuke_subscriptions issue but the test site is at least functioning now.