Hi!
The following error is generated immediately after enabling the module, which suggests the table isn't being created correctly to begin with.

user warning: Table 'drupal5.ip2nationCountries' doesn't exist query: SELECT c.code, c.country FROM ip2nationCountries c INNER JOIN ip2nation i ON c.code = i.country WHERE i.ip < INET_ATON('::1') ORDER BY i.ip DESC LIMIT 0,1 in /Applications/MAMP/htdocs/drupal5/includes/database.mysql.inc on line 172.

Would you please fix this?

Comments

suryanto’s picture

suryanto
Primary language Indonesian
Location Bali, Indonesia
commented
Assigned: Unassigned » suryanto

Thank you for your report. I will check it in this weekend.

olio’s picture

olio commented

Hi,
I had a quick look at the install file and realized that the code of the install file ist commented out. Suryanto: Is there a reason for this ? I removed the comment tags and installed without errors.
Only PHPMyAdmin shows me a notice that in the table 'ip2nationCountries', the index types INDEX und PRIMARY shouldn't be set at the same time for the column `code`.
Thanks.

suryanto’s picture

suryanto
Primary language Indonesian
Location Bali, Indonesia
commented

Hi Olio,

Sorry, I accidentally commented out the installation file. I have already fixed it.

Thank you.

suryanto’s picture

suryanto
Primary language Indonesian
Location Bali, Indonesia
commented
Status: Active » Fixed
Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.