Installation won't work

Duke · 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

Raven · Posted: Mon Feb 06, 2006 12:31 am

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.

Duke · 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).

Raven · Posted: Mon Feb 06, 2006 1:57 am

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

Duke · 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

Duke · 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

Raven · Posted: Mon Feb 06, 2006 3:05 am

Did the PM files work?

Duke · 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!

Duke · 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;

Duke · 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.