Author Topic: WordPress database error: [table 'ip2nationCountries' doesn't exist] (Read 12227 times)

os2mac · « **on:** 03 January 2009, 03:27 »

WordPress database error: [table 'thunderb_wp_1.ip2nationCountries' doesn't exist]
SELECT c.country, c.code FROM ip2nationCountries c, ip2nation i WHERE i.ip < INET_ATON('69.178.28.196') AND c.code = i.country ORDER BY i.ip DESC LIMIT 1

That error comes up when I open the useronline dash board. any ideas?

GaMerZ · « **Reply #1 on:** 03 January 2009, 06:15 »

What version of WP and WP-Useronline are you using? I can't seem to reproduce this problem eventhough I do not have the "ip2nationCountries" table in my database.

1. Go To http://www.ip2nation.com/ip2nation/Download
2. It will prompt you to download a ZIP file called "ip2nation.zip"
3. After downloading, extract the ZIP file "ip2nation.zip"
4. You should see the SQL file called "ip2nation.sql"
5. Go to phpMyAdmin and select your database
6. Click On The Import Tab of phpMyAdmin
7. Under "File to import" and then under "Location of the text file", click on "Browse"
8. Then browse for the SQL file "ip2nation.sql"
9. Click "Go"

It should take a few seconds and 2 tables will be created.

os2mac · « **Reply #2 on:** 03 January 2009, 16:25 »

For the record I am using WP2.7 and the latest version of WP-Useronline.

GaMerZ · « **Reply #3 on:** 03 January 2009, 16:32 »

So am I and I can't reproduce this issue. Anyway, follow the instructions and this problem should be solved.

os2mac · « **Reply #4 on:** 03 January 2009, 17:41 »

GaMerZ, this corrected the problem.... the ip@nations data on the install had dupes in it... I had to import it by hand.
removing the dupes as I went..

kscurloc · « **Reply #5 on:** 04 January 2009, 03:28 »

I, too, had the same issue installing this in WP2.7. Using your "ip2nation.zip" file and following your instructions fixed the problem.

GaMerZ · « **Reply #6 on:** 04 January 2009, 07:12 »

Thanks, it is my bad, I have updated the readme.html with this mandatory ip2nation installation instructions.

skywolfyx1 · « **Reply #7 on:** 24 January 2009, 23:12 »

i solved this problem thanks bless god

WindowsObserver · « **Reply #8 on:** 11 February 2009, 02:04 »

Lester - I use several of your plugins and they are great. I am unable to upgrade this one due to the same error noted above. I did donwload the sql to import to my SQL dbase however it erros saying the file is too big.

Any ideas how to correct this?

Thanks.

GaMerZ · « **Reply #9 on:** 11 February 2009, 02:31 »

You may need to contact your host about it because it can't be to big.

Texas Heat · « **Reply #10 on:** 18 May 2009, 17:40 »

I apologize for being so ignorant -- but how do I find my database? I'm comfortable with everything else, but don't have a clue where I need to upload the file.

GaMerZ · « **Reply #11 on:** 19 May 2009, 00:53 »

phpmyadmin ask your host and read the 2nd post in this thread.

Texas Heat · « **Reply #12 on:** 19 May 2009, 17:43 »

Thanks for the tip. Apparently my mistake was that I was looking for a specific database within the SQL database.

atablefortwo · « **Reply #13 on:** 04 June 2009, 15:43 »

Looks like I have the same problem with this error

WordPress database error: [table 'atablef1_atablefortwo.ip2nationCountries' doesn't exist]
SELECT c.country, c.code FROM ip2nationCountries c, ip2nation i WHERE i.ip < INET_ATON('203.18.237.148') AND c.code = i.country ORDER BY i.ip DESC LIMIT 1

I followed instructions on 2nd post, but the URL is down or broken... I cant get it working to download the file as requested.
any clue?

AndrewRH · « **Reply #14 on:** 04 June 2009, 16:36 »

These days, there is a Wordpress plug-in for everything!

Try installing this: wp-ip2nation installer by Dave Lighthart.

~Andrew~

atablefortwo · « **Reply #15 on:** 05 June 2009, 00:09 »

Thanks Andrew!

After I downloaded it, I still need to import the SQL file into my database as stated in step 2.
At first I tried to just upload the folder into the plugins folder and it didn't work, still give me same error.

Hope that helps the others.

Thanks!

thuviengiadinh.com · « **Reply #16 on:** 08 June 2009, 13:17 »

Quote from: GaMerZ on 03 January 2009, 06:15

What version of WP and WP-Useronline are you using? I can't seem to reproduce this problem eventhough I do not have the "ip2nationCountries" table in my database.

1. Go To http://www.ip2nation.com/ip2nation/Download
2. It will prompt you to download a ZIP file called "ip2nation.zip"
3. After downloading, extract the ZIP file "ip2nation.zip"
4. You should see the SQL file called "ip2nation.sql"
5. Go to phpMyAdmin and select your database
6. Click On The Import Tab of phpMyAdmin
7. Under "File to import" and then under "Location of the text file", click on "Browse"
8. Then browse for the SQL file "ip2nation.sql"
9. Click "Go"

It should take a few seconds and 2 tables will be created.

I come from Vietnam, my website is http://Thuviengiadinh.com, just then I also have such errors, and I follow the instructions and you are correct that error. I respectfully thank you. I take a long time that is not correct that error. Please visit my web site.

Sincerely thank you.
http://Thuviengiadinh.com

GaMerZ · « **Reply #17 on:** 08 June 2009, 14:01 »

Sorry I don't understand what you are saying.

thuviengiadinh.com · « **Reply #18 on:** 08 June 2009, 14:45 »

Quote from: GaMerZ on 08 June 2009, 14:01

Sorry I don't understand what you are saying.

I also this error:

Quote

WordPress database error: [table 'thunderb_wp_1.ip2nationCountries' doesn't exist]
SELECT c.country, c.code FROM ip2nationCountries c, ip2nation i WHERE i.ip < INET_ATON('69.178.28.196') AND c.code = i.country ORDER BY i.ip DESC LIMIT 1

According to instructions I have above is correct that error, thank you

GaMerZ · « **Reply #19 on:** 08 June 2009, 14:51 »

You got that error because the table ip2nationCountries is not created. Follow the instruction and that will lead you to the creation of the table.

News:

Author Topic: WordPress database error: [table 'ip2nationCountries' doesn't exist] (Read 12227 times)