Read "GeoLiteCity-Blocks.csv" into database - file does not exist or is corrupt

Olivier_Asselin

Hi,

I'm trying to install GeoIp on my Vanilla forums v. 2.0.18.9

The file download and unzip steps went ok (I checked and the files are in the upload folder), but the third step fails giving me this message :

file does not exist or is corrupt

Any idea what I might be doing wrong?

Thanks,

Olivier
www.permacultureorchard.com

hgtonight

Welcome to the community!

How big is the GeoLiteCity-Location.csv file in your uploads folder?

Olivier_Asselin

Thanks! :-)

The file is 23.5 Mb

hgtonight

That sounds about right. I would delete the files and try again.

Olivier_Asselin

I've done it 3 times already, I've also used the delete tables function, then disabled, and re-enabled the plugin.

Olivier_Asselin

Just tried again, same thing. Could it be something to do with access rights?

hgtonight

Mind sharing the details of your upload folder?

I am looking for filenames, permissions, and filesizes.

Olivier_Asselin

empty
755 permaculture/pe... Nov 26 16:54 0B

GeoLiteCity-Blocks.csv
644 permaculture/pe... Dec 05 17:40 60.7M

GeoLiteCity-latest.zip
664 permaculture/pe... Dec 15 21:11 24.1M

GeoLiteCity-Location.csv
644 permaculture/pe... Dec 05 17:40 23.5M

peregrine

you can manually look at the csv file by loading into excel or looking in a text editor.

also try to manually unzip the file if it unzips and is not corrupted you are fine.

otherwise manually download the file

http://geolite.maxmind.com/download/geoip/database/GeoLiteCity_CSV/GeoLiteCity-latest.zip

and unzip it. if it unzips and is not corrupted you are fine.

perhaps they shrunk the file since r_j wrote the plugin

in any event.

try changing in class.geoipdata-plugin.php

if (file_exists($zipfile) && filesize($zipfile) > 25000000) {

try changing this line to this to remove the size requirement in

if (file_exists($zipfile) {

and that should load your file.

Olivier_Asselin

no difference. I'm still getting the same message. I did try to open the CSV it looks fine.

Olivier_Asselin

actually the problem isnt the unzipping of the file, that works fine, its the loading of the data into the DB that doesn't work.

peregrine

change line 137 to

$Sender->InformMessage(T('File GeoLiteCity-latest.zip does not exist or is corrupt!'));

change line 167 to

        $Sender->InformMessage(T('File GeoLiteCity-Blocks.csv does not exist or is corrupt!'));

then what is your error mesage.

peregrine

also change this line 154

if (file_exists($infile) && filesize($infile) > 65000000) {

to

if (file_exists($infile)) {

Olivier_Asselin

I assume you meant 176 for the second line.

Message is :
File GeoLiteCity-Blocks.csv does not exist or is corrupt!

peregrine

yes

I assume you meant 176 for the second line.

Message is : File GeoLiteCity-Blocks.csv does not exist or is corrupt!

yes

also change this line 154

if (file_exists($infile) && filesize($infile) > 65000000) {

to

if (file_exists($infile)) {

what is your error message now?

Olivier_Asselin

I didnt get the message this time. Waited a few secs while the file was being read I guess, then :

Bonk
Something funky happened. Please bear with us while we iron out the kinks.

peregrine

well, now you are making progress now read the wiki for what to do when you get bonk messages

or read the documentation for bonk messages and report the real error.

Olivier_Asselin

ok, ill try that, thanks for your help!

peregrine

so there are a few things that r_j should change in the plugin.

the inform message should tell you which file you are having a problem with.

and the sizes should be reduced.

$Sender->InformMessage

I would think it would be easier to just write manual instructions to tell person to download the zip and which directory to place it in and unzip. - would save a bunch of hassle in the long run.

peregrine

@Olivier_Asselin

obviously you are trying plugins, try this thread...

http://vanillaforums.org/discussion/25578/nominations-for-best-plugin-created-this-year

R_J

Thanks for supporting while I'm sleeping
I'll have a look at it as soon as possible!