Do you have the other 7 steps of the backtrace? All the locations that 'geocitiestable' is used appear correct to me. It's possible the table didn't get added for you, try running upgrade.php manually.
I believe if the table doesn't exist it won't translate it to the prefixed version. The table would be yourprefix_geocities. I'm assuming you're using the maxmind geoip database from scripts.webmastersite.net/w...k.php?action=detail&id=542 since that's what would trigger this. If so, if upgrade.php successfully adds the able you'll need to load the data again at YourAdminPanelURL/loaddata.php?filled=1&datasource[1]=geosql&dataindex=1&part=0
I turned on debugging and tried again. I think this is the issue:
Running SQL: create table wsnlinks_geocities ( `CityId` int default '0', `CountryID` int default '0', `RegionID` int default '0', `City` varchar(90) NOT NULL, `Latitude` real default '0' NOT NULL, `Longitude` real default '0' NOT NULL, `TimeZone` varchar(18) NOT NULL, `DmaId` int default '0', `Code` varchar(12) NOT NULL, `state` varchar(255) NOT NULL, `country` varchar(255) NOT NULL, UNIQUE KEY id (id) ) ENGINE=MyISAM;
Query 55: create table wsnlinks_geocities ( `CityId` int default '0', `CountryID` int default '0', `RegionID` int default '0', `City` varchar(90) NOT NULL, `Latitude` real default '0' NOT NULL, `Longitude` real default '0' NOT NULL, `TimeZone` varchar(18) NOT NULL, `DmaId` int default '0', `Code` varchar(12) NOT NULL, `state` varchar(255) NOT NULL, `country` varchar(255) NOT NULL, UNIQUE KEY id (id) ) ENGINE=MyISAM
Comments on geocitiestable not found
Usergroup: Customer
Joined: Jul 17, 2003
Total Topics: 39
Total Comments: 100
Posted Aug 29, 2012 - 6:34 PM:
During recalculation I'm getting an error about geocitiestable not found.
Step 8 of backtrace:
File: /var/www/britnet_mybb/links/wsnadmin/updatecounters.php
Line: 67
Function: onelink
Arguments: row array
Class: onelink
Last SQL error: Table 'mybb_britnet.geocitiestable' doesn't exist
Doesn't even have the prefix that I use for my wsnlinks tables.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Do you have the other 7 steps of the backtrace? All the locations that 'geocitiestable' is used appear correct to me. It's possible the table didn't get added for you, try running upgrade.php manually.
I believe if the table doesn't exist it won't translate it to the prefixed version. The table would be yourprefix_geocities. I'm assuming you're using the maxmind geoip database from scripts.webmastersite.net/w...k.php?action=detail&id=542 since that's what would trigger this. If so, if upgrade.php successfully adds the able you'll need to load the data again at YourAdminPanelURL/loaddata.php?filled=1&datasource[1]=geosql&dataindex=1&part=0
Usergroup: Customer
Joined: Jul 17, 2003
Total Topics: 39
Total Comments: 100
Unfortunately not, it disappeared off the screen too quickly. I'll see if there's some way to get the other backtrace.
I tried to do an upgrade and I got this:
Error: The file schemas/templateschema.wsn.dist does not exist.
Upgrade complete.
Isn't there an option to disable it? I would not want this functionality on my board.
Usergroup: Customer
Joined: Jul 17, 2003
Total Topics: 39
Total Comments: 100
There is no "Browser Geolocation" option in my switches config.
Usergroup: Customer
Joined: Jul 17, 2003
Total Topics: 39
Total Comments: 100
I turned on debugging and tried again. I think this is the issue:
Running SQL: create table wsnlinks_geocities ( `CityId` int default '0', `CountryID` int default '0', `RegionID` int default '0', `City` varchar(90) NOT NULL, `Latitude` real default '0' NOT NULL, `Longitude` real default '0' NOT NULL, `TimeZone` varchar(18) NOT NULL, `DmaId` int default '0', `Code` varchar(12) NOT NULL, `state` varchar(255) NOT NULL, `country` varchar(255) NOT NULL, UNIQUE KEY id (id) ) ENGINE=MyISAM;
Query 55: create table wsnlinks_geocities ( `CityId` int default '0', `CountryID` int default '0', `RegionID` int default '0', `City` varchar(90) NOT NULL, `Latitude` real default '0' NOT NULL, `Longitude` real default '0' NOT NULL, `TimeZone` varchar(18) NOT NULL, `DmaId` int default '0', `Code` varchar(12) NOT NULL, `state` varchar(255) NOT NULL, `country` varchar(255) NOT NULL, UNIQUE KEY id (id) ) ENGINE=MyISAM
Load time so far: 0.302 seconds.
Key column 'id' doesn't exist in table
Usergroup: Customer
Joined: Jul 17, 2003
Total Topics: 39
Total Comments: 100
Hmm, not sure what happened but I now have the wsn_geolocation table. I'm loading it up with data.
Update: The data appears to be loaded s I'm going to try to redo the recounts.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
I see, fixed the create table query for the next release.
Usergroup: Customer
Joined: Jul 17, 2003
Total Topics: 39
Total Comments: 100
The data is loaded and I was able to regenerate everything without errors.
Thanks,
Nigel