IP2C Not Loaded

Posted: Thu Jan 02, 2014 8:13 pm

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

Posted: Thu Jan 02, 2014 8:51 pm

Does this ring any bells? [ Only registered users can see links on this board! Get registered or login! ]

Posted: Thu Jan 02, 2014 9:13 pm

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

Posted: Thu Jan 02, 2014 9:35 pm

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!

Posted: Thu Jan 02, 2014 9:50 pm

Loading it directly via PHPMyadmin doesn't work, file too large. Bigdump doesn't work either for some reason.

Posted: Fri Jan 03, 2014 4:40 am

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

Posted: Tue Jan 07, 2014 10:20 am

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.

Site Admin Joined: Jun 04, 2004 Posts: 6433

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

Posted: Tue Jan 07, 2014 5:12 pm

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