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


Joined: Jan 09, 2006
Posts: 56
Location: Under your bed

PostPosted: Sun Feb 05, 2006 10:47 pm Reply with quote

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
 
View user's profile Send private message Send e-mail Visit poster's website
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 17077

PostPosted: Mon Feb 06, 2006 12:31 am Reply with quote

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.


Last edited by Raven on Mon Feb 06, 2006 1:38 am; edited 1 time in total 
View user's profile Send private message
Duke
PostPosted: Mon Feb 06, 2006 1:27 am Reply with quote

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
PostPosted: Mon Feb 06, 2006 1:57 am Reply with quote

You misread the earlier post. You need to replace the 2 -- with 2 ##, not just one.
 
Duke
PostPosted: Mon Feb 06, 2006 2:18 am Reply with quote

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
PostPosted: Mon Feb 06, 2006 2:34 am Reply with quote

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
PostPosted: Mon Feb 06, 2006 3:05 am Reply with quote

Did the PM files work?
 
Duke
PostPosted: Mon Feb 06, 2006 3:06 am Reply with quote

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
PostPosted: Mon Feb 06, 2006 3:45 am Reply with quote

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
PostPosted: Mon Feb 06, 2006 3:57 am Reply with quote

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.
 
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 ©