Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> RavenNuke(tm) v2.5x
Author Message
dad7732
RavenNuke(tm) Development Team



Joined: Mar 18, 2007
Posts: 1242

PostPosted: Thu Jan 02, 2014 8:13 pm Reply with quote

I've seen the solution somewhere but cannot find where.

The IP2C table won't load:

Fatal error: Call to undefined function gzfile() in /home/***removed***/INSTALLATION/installSQL.php on line 420
 
View user's profile Send private message
Guardian2003
Site Admin



Joined: Aug 28, 2003
Posts: 6795
Location: Ha Noi, Viet Nam

PostPosted: Thu Jan 02, 2014 8:51 pm Reply with quote

Does this ring any bells? [ Only registered users can see links on this board! Get registered or login! ]
 
View user's profile Send private message Send e-mail
dad7732







PostPosted: Thu Jan 02, 2014 9:13 pm Reply with quote

Yes, but that didn't fix anything. The fix back then is still in place.
 
Guardian2003







PostPosted: Thu Jan 02, 2014 9:35 pm Reply with quote

Then I don't know the answer as I haven't experienced it myself. The gzfile() function is a native function in PHP versions 4 and 5 so it may be some rare server configuration we're dealing with.
Unfortunately it's 2.30 am here so I'm out of time for today but is it possible to maybe load the IP2C sql files directly into phpmyadmin? I don't have a local copy here to check for you sorry!
 
dad7732







PostPosted: Thu Jan 02, 2014 9:50 pm Reply with quote

Loading it directly via PHPMyadmin doesn't work, file too large. Bigdump doesn't work either for some reason.
 
hicuxunicorniobestbuildpc
The Mouse Is Extension Of Arm



Joined: Aug 13, 2009
Posts: 1008
Location: Netherland

PostPosted: Fri Jan 03, 2014 4:40 am Reply with quote

Since nothing is working for you I would like you to be more specific with the errors you are getting.

Quote:
Bigdump doesn't work either for some reason


I am really curious to know why Bigdump didn't work for you. Can you post the error you are getting?

My experience with Bigdump:

If you back up your data from phpMyadmin you need to remove any comment or rest of unnecessary code. Take a look.

Code:
-- phpMyAdmin SQL Dump

-- version 3.4.7.1
-- http://www.phpmyadmin.net
--
-- Host: blablab
-- Generato il: Gen 03, 2014 alle 11:35
-- Versione del server: 5.0.92
-- Versione PHP: 5.3.8

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `Sqlnumber`
--

-- --------------------------------------------------------

--
-- Table structure for table `nuke_banner`
--

CREATE TABLE IF NOT EXISTS `nuke_banner` (
  `bid` int(11) NOT NULL auto_increment,
  `cid` int(11) NOT NULL default '0',
  `name` varchar(50) NOT NULL default '',
  `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,
  `position` int(10) NOT NULL default '0',
  `active` tinyint(1) NOT NULL default '1',
  `ad_class` varchar(5) NOT NULL default '',
  `ad_code` text NOT NULL,
  `ad_width` int(4) default '0',
  `ad_height` int(4) default '0',
  PRIMARY KEY  (`bid`),
  KEY `cid` (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;


You will only need this

Code:
--

-- Table structure for table `nuke_banner`
--

CREATE TABLE IF NOT EXISTS `nuke_banner` (
  `bid` int(11) NOT NULL auto_increment,
  `cid` int(11) NOT NULL default '0',
  `name` varchar(50) NOT NULL default '',
  `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,
  `position` int(10) NOT NULL default '0',
  `active` tinyint(1) NOT NULL default '1',
  `ad_class` varchar(5) NOT NULL default '',
  `ad_code` text NOT NULL,
  `ad_width` int(4) default '0',
  `ad_height` int(4) default '0',
  PRIMARY KEY  (`bid`),
  KEY `cid` (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;



I read almost all your post here and it looks like you don't give us enough information. Shocked Confused
 
View user's profile Send private message Visit poster's website
dad7732







PostPosted: Tue Jan 07, 2014 10:20 am Reply with quote

Found the problem. Didn't realize that I was running a previous version of PHPMyAdmin and when exporting the IP2C file I had to turn OFF "Extended Inserts". Once that was done, BigDump worked just fine.
 
kguske
Site Admin



Joined: Jun 04, 2004
Posts: 6404

PostPosted: Tue Jan 07, 2014 11:06 am Reply with quote

dad7732, just a note that I removed the sensitive info from your original post. Don't want to give too much info to malicious visitors...

_________________
I google, therefore I exist...
nukeSEO - nukeFEED - nukePIE - nukeSPAM - nukeWYSIWYG
 
View user's profile Send private message
dad7732







PostPosted: Tue Jan 07, 2014 5:12 pm Reply with quote

kguske wrote:
dad7732, just a note that I removed the sensitive info from your original post. Don't want to give too much info to malicious visitors...


Thanks, wasn't really thinking about it at the time, more frustrated than thinking clearly. Rolling Eyes
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> RavenNuke(tm) v2.5x

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 ©