CRBatchelor Posted October 2, 2007 Share Posted October 2, 2007 After installing Supertracker does not show up as available reports. and when I try to navigate to it directly, i get "Access Denied" from forbidden.php... Any thoughts? The client side is collecting the information correctly. --Chris Batchelor-- Quote Link to comment Share on other sites More sharing options...
homewetbar Posted October 10, 2007 Share Posted October 10, 2007 After installing Supertracker does not show up as available reports. and when I try to navigate to it directly, i get "Access Denied" from forbidden.php... Any thoughts? The client side is collecting the information correctly. --Chris Batchelor-- You have admin access levels installed sounds like. Allow access to the file in the access level controls. Quote Most Valuable OsCommerce Contributions: Also Purchased (AP) Preselection (cuts this resource hogging query down to nothing) -- Contribution 3294 FedEx Automated Labels -- Contribution 2244 RMA Returns system -- Contribution 1136 Sort Products By Dropdown -- Contribution 4312 Ultimate SEO URLs -- Contribution 2823 Credit Class & Gift Voucher -- Contribution 282 Cross-Sell -- Contribution 5347 Link to comment Share on other sites More sharing options...
Guest Posted October 10, 2007 Share Posted October 10, 2007 (edited) I installed this mod and I get this error: 1146 - Table 'databasename.supertracker' doesn't exist SELECT order_id, referrer, landing_page FROM supertracker where order_id IN ('21','20','19') AND completed_purchase = 'true' ORDER BY order_id DESC [TEP STOP] How can I fix this? Thanks!!! Edited October 10, 2007 by ibasq Quote Link to comment Share on other sites More sharing options...
Guest Posted October 10, 2007 Share Posted October 10, 2007 I installed this mod and I get this error: 1146 - Table 'databasename.supertracker' doesn't exist SELECT order_id, referrer, landing_page FROM supertracker where order_id IN ('21','20','19') AND completed_purchase = 'true' ORDER BY order_id DESC [TEP STOP] How can I fix this? Thanks!!! OK - ignore this.. this is what I got when I tried the sales tracker mod.. now I am trying supertracker and I get this: Warning: fopen(includes/GeoIP.dat) [function.fopen]: failed to open stream: No such file or directory in /home/habitude/public_html/includes/geoip.inc on line 322 Warning: ftell(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 276 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 277 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 303 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 311 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 396 Fatal error: error traversing database - perhaps it is corrupt? in /home/habitude/public_html/includes/geoip.inc on line 416 When this happened I removed: //Do the superstats business require(DIR_WS_CLASSES . 'supertracker.php'); $tracker = new supertracker; $tracker->update(); From application_top.php and then it loaded fine. Why can't I get some luck with a tracker?? I just need to be able to track sales by referrals... argh.. help pleeeaasse? Quote Link to comment Share on other sites More sharing options...
Guest Posted October 10, 2007 Share Posted October 10, 2007 OK - ignore this.. this is what I got when I tried the sales tracker mod.. now I am trying supertracker and I get this: Warning: fopen(includes/GeoIP.dat) [function.fopen]: failed to open stream: No such file or directory in /home/habitude/public_html/includes/geoip.inc on line 322 Warning: ftell(): supplied argument is not a valid stream resource in /home/habitude/public_html/includes/geoip.inc on line 276 When this happened I removed: //Do the superstats business require(DIR_WS_CLASSES . 'supertracker.php'); $tracker = new supertracker; $tracker->update(); From application_top.php and then it loaded fine. Why can't I get some luck with a tracker?? I just need to be able to track sales by referrals... argh.. help pleeeaasse? I finally got this to work - now it seems the ppc feature isn't working.. time to research - haha.. I tried going to www.mydomain.com/index.php?ref=googlad&keyw=keyword and made a test purchase but I don't see any stats showing up for it...?? Any ideas anyone? Thanks!!! Quote Link to comment Share on other sites More sharing options...
CRBatchelor Posted October 11, 2007 Share Posted October 11, 2007 I am running CRE 6.2.10 Pro and I am still getting these errors. You have admin access levels installed sounds like. Allow access to the file in the access level controls. Quote Link to comment Share on other sites More sharing options...
CRBatchelor Posted October 12, 2007 Share Posted October 12, 2007 The problem I am now running into is that once I select a report it shoots me back to the login screen.... I am running CRE 6.2.10 Pro and I am still getting these errors. Quote Link to comment Share on other sites More sharing options...
wpeloqui Posted October 12, 2007 Share Posted October 12, 2007 Hello, I just installed version 3.2b and I have this problem when the main page loads. I commented out the code in application_top.php for the time being. It appears to have something to do with the sessions, I have sessions turned off in configuration (except for prevent spider sessions). I am fairly new at this and I have looked through the thread for something similar. I did see comments about sessions, but nothing seems to match. 1054 - Unknown column 'sesskey' in 'where clause' select * from supertracker where sesskey = '2ad0639bafd291833a55234c6bcb1030' [TEP STOP] Thank you, Willie Quote Link to comment Share on other sites More sharing options...
wpeloqui Posted October 12, 2007 Share Posted October 12, 2007 Hello, I just installed version 3.2b and I have this problem when the main page loads. I commented out the code in application_top.php for the time being. It appears to have something to do with the sessions, I have sessions turned off in configuration (except for prevent spider sessions). I am fairly new at this and I have looked through the thread for something similar. I did see comments about sessions, but nothing seems to match. 1054 - Unknown column 'sesskey' in 'where clause' select * from supertracker where sesskey = '2ad0639bafd291833a55234c6bcb1030' [TEP STOP] Thank you, Willie Quote Link to comment Share on other sites More sharing options...
zeeshop Posted October 21, 2007 Share Posted October 21, 2007 hi Just installed v3.1b with Agent(or sales rep) Tracking from mbuswell. new installed followed all instruction. when finishes and opened website gives me this error 1054 - Unknown column 'agent' in 'field list' INSERT INTO `supertracker` (`ip_address`, `browser_string`, `country_code`, `country_name`, `referrer`,`referrer_query_string`,`landing_page`,`exit_page`,`time_arrived`,`last_click`, `agent`) VALUES ('82.17.66.30','Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.2; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30)','gb', 'United Kingdom', '', '','/','/index.php','2007-10-21 14:23:59','2007-10-21 14:23:59','') [TEP STOP] when i made changes in /catalog/includes/application_top.php from " //Do the superstats business require(DIR_WS_CLASSES . 'supertracker.php'); $tracker = new supertracker; $tracker->update(); " to " //Do the superstats business require(DIR_WS_CLASSES . 'supertracker.php'); $tracker = new supertracker; // $tracker->update(); " it work site opened perfectly... please someone advise if this is correct way to fix this problem and if my supper tracker will work normall. kind regards zee Quote Link to comment Share on other sites More sharing options...
zeeshop Posted October 21, 2007 Share Posted October 21, 2007 hi reference to my previous p[ost, I just realise that I am not getting any update of visite in admin area, it may be because of this application_top.php file changes. any help will highly appretiated. regards zee Quote Link to comment Share on other sites More sharing options...
Guest Posted October 24, 2007 Share Posted October 24, 2007 hi Just installed v3.1b with Agent(or sales rep) Tracking from mbuswell. new installed followed all instruction. when finishes and opened website gives me this error 1054 - Unknown column 'agent' in 'field list' INSERT INTO `supertracker` (`ip_address`, `browser_string`, `country_code`, `country_name`, `referrer`,`referrer_query_string`,`landing_page`,`exit_page`,`time_arrived`,`last_click`, `agent`) VALUES ('82.17.66.30','Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.2; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30)','gb', 'United Kingdom', '', '','/','/index.php','2007-10-21 14:23:59','2007-10-21 14:23:59','') [TEP STOP] when i made changes in /catalog/includes/application_top.php from " //Do the superstats business require(DIR_WS_CLASSES . 'supertracker.php'); $tracker = new supertracker; $tracker->update(); " to " //Do the superstats business require(DIR_WS_CLASSES . 'supertracker.php'); $tracker = new supertracker; // $tracker->update(); " it work site opened perfectly... please someone advise if this is correct way to fix this problem and if my supper tracker will work normall. kind regards zee I've just installed this contrib for the first time, and get the exact same problem. I've gone through the whole process twice with the same results. Possible issue with the install instructions, or mistake in the tool which creates the netry into database? Quote Link to comment Share on other sites More sharing options...
Guest Posted October 24, 2007 Share Posted October 24, 2007 I've just installed this contrib for the first time, and get the exact same problem. I've gone through the whole process twice with the same results. Possible issue with the install instructions, or mistake in the tool which creates the netry into database? Im no expert, but I think I have found the problem. There is no field called "agent" created within the install instructions, which say; CREATE TABLE `supertracker` ( `tracking_id` bigint(20) NOT NULL auto_increment, `ip_address` varchar(15) NOT NULL default '', `browser_string` varchar(255) NOT NULL default '', `country_code` char(2) NOT NULL default '', `country_name` varchar(100) NOT NULL default '', `customer_id` int(11) NOT NULL default '0', `order_id` int(11) NOT NULL default '0', `referrer` varchar(255) NOT NULL default '', `referrer_query_string` varchar(255) NOT NULL default '', `landing_page` varchar(255) NOT NULL default '', `exit_page` varchar(100) NOT NULL default '', `time_arrived` datetime NOT NULL default '0000-00-00 00:00:00', `last_click` datetime NOT NULL default '0000-00-00 00:00:00', `num_clicks` int(11) NOT NULL default '1', `added_cart` varchar(5) NOT NULL default 'false', `completed_purchase` varchar(5) NOT NULL default 'false', `categories_viewed` varchar(255) NOT NULL default '', `products_viewed` varchar(255) NOT NULL default '', `cart_contents` mediumtext NOT NULL, `cart_total` int(11) NOT NULL default '0', PRIMARY KEY (`tracking_id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; No mention of an agent field. How would you go about adding this field and what parameters should it have? Quote Link to comment Share on other sites More sharing options...
Guest Posted October 24, 2007 Share Posted October 24, 2007 Im no expert, but I think I have found the problem. There is no field called "agent" created within the install instructions, which say; CREATE TABLE `supertracker` ( `tracking_id` bigint(20) NOT NULL auto_increment, `ip_address` varchar(15) NOT NULL default '', `browser_string` varchar(255) NOT NULL default '', `country_code` char(2) NOT NULL default '', `country_name` varchar(100) NOT NULL default '', `customer_id` int(11) NOT NULL default '0', `order_id` int(11) NOT NULL default '0', `referrer` varchar(255) NOT NULL default '', `referrer_query_string` varchar(255) NOT NULL default '', `landing_page` varchar(255) NOT NULL default '', `exit_page` varchar(100) NOT NULL default '', `time_arrived` datetime NOT NULL default '0000-00-00 00:00:00', `last_click` datetime NOT NULL default '0000-00-00 00:00:00', `num_clicks` int(11) NOT NULL default '1', `added_cart` varchar(5) NOT NULL default 'false', `completed_purchase` varchar(5) NOT NULL default 'false', `categories_viewed` varchar(255) NOT NULL default '', `products_viewed` varchar(255) NOT NULL default '', `cart_contents` mediumtext NOT NULL, `cart_total` int(11) NOT NULL default '0', PRIMARY KEY (`tracking_id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; No mention of an agent field. How would you go about adding this field and what parameters should it have? OK, so in answer to my own question. I went into myphp admin, added a new field called agent, as a varchar 100. Sorted :) Quote Link to comment Share on other sites More sharing options...
lawatches Posted October 24, 2007 Share Posted October 24, 2007 I just tried installing super tracker and this is the error I am getting. Please help. tracy 1054 - Unknown column 'agent' in 'field list' INSERT INTO `supertracker` (`ip_address`, `browser_string`, `country_code`, `country_name`, `referrer`,`referrer_query_string`,`landing_page`,`exit_page`,`time_arrived`,`last_click`, `agent`) VALUES ('71.104.226.211','Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.8) Gecko/20071008 Firefox/2.0.0.8','us', 'United States', '', '','/','/index.php','2007-10-24 16:27:11','2007-10-24 16:27:11','') [TEP STOP] Quote Link to comment Share on other sites More sharing options...
lawatches Posted October 24, 2007 Share Posted October 24, 2007 I just read the problem another user had and i noticed that they added a field into my php called agent. How can I add that field? sorry , I am so new tracy Quote Link to comment Share on other sites More sharing options...
Guest Posted October 25, 2007 Share Posted October 25, 2007 I just read the problem another user had and i noticed that they added a field into my php called agent. How can I add that field? sorry , I am so new tracy Tracy, As part of your hosting account, you should be able to log into a piece of software called MyPHPadmin, which basically you need to use to edit your oscommerce database. One you have that first bit sussed, just open up the SUPERTRACKER part of the database, and you will see a list of fields such as customerid, countrycode, etc etc. You WONT find one called AGENT, which is what is causing your problem. You need to add a field called AGENT, setting it as a VARCHAR If this doesnt make any sense at all drop me a pm.. Quote Link to comment Share on other sites More sharing options...
bigbuba0 Posted October 26, 2007 Share Posted October 26, 2007 Tracy,As part of your hosting account, you should be able to log into a piece of software called MyPHPadmin, which basically you need to use to edit your oscommerce database. One you have that first bit sussed, just open up the SUPERTRACKER part of the database, and you will see a list of fields such as customerid, countrycode, etc etc. You WONT find one called AGENT, which is what is causing your problem. You need to add a field called AGENT, setting it as a VARCHAR If this doesnt make any sense at all drop me a pm.. thanks guys, did exactly what you said and it works like a charm Quote Link to comment Share on other sites More sharing options...
PJ2006 Posted October 28, 2007 Share Posted October 28, 2007 I have two issues with or following the installation. When I click on the report for Top Agents, I get: 1054 - Unknown column 'agent' in 'group statement' SELECT *, COUNT(*) as total FROM supertracker GROUP BY agent order by total DESC [TEP STOP] In the installation instructions it says For CRE Loaded do this: I'm not sure what CRE stands for or which file to make these changes Fantastic report Many thanks Lotti Quote Link to comment Share on other sites More sharing options...
PJ2006 Posted October 28, 2007 Share Posted October 28, 2007 I have two issues with or following the installation. When I click on the report for Top Agents, I get: 1054 - Unknown column 'agent' in 'group statement' SELECT *, COUNT(*) as total FROM supertracker GROUP BY agent order by total DESC [TEP STOP] In the installation instructions it says For CRE Loaded do this: I'm not sure what CRE stands for or which file to make these changes Fantastic report Many thanks Lotti Sorry, saw the answer above after posting, but would like to know what CRE is. Thanks Quote Link to comment Share on other sites More sharing options...
Guest Posted October 29, 2007 Share Posted October 29, 2007 Sorry, saw the answer above after posting, but would like to know what CRE is. Thanks If anyone in the know is readint his thread, an update to this contrib is urgently needed to prevent lots of people having to do the above. Quote Link to comment Share on other sites More sharing options...
thisheart Posted October 30, 2007 Share Posted October 30, 2007 I have just installed contribution. When I load my shop it is only a blank page. I have added the agents field but that didn't do anything. Can't seem to get it to work! any ideas? Quote Link to comment Share on other sites More sharing options...
PJ2006 Posted November 2, 2007 Share Posted November 2, 2007 I've installed this on another site and now get: Warning: fopen(includes/GeoIP.dat) [function.fopen]: failed to open stream: No such file or directory in /home/mydom/public_html/catalog/includes/geoip.inc on line 322 Warning: ftell(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 276 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 277 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 311 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Fatal error: error traversing database - perhaps it is corrupt? in /home/mydom/public_html/catalog/includes/geoip.inc on line 416 This was after inserting the Agent row in the table - I have no idea what I've done wrong, I've been at it 2 hours now! Quote Link to comment Share on other sites More sharing options...
CRBatchelor Posted November 3, 2007 Share Posted November 3, 2007 Looks to me like you are missing or have a damaged version of the geoip database. --Chris-- I've installed this on another site and now get: Warning: fopen(includes/GeoIP.dat) [function.fopen]: failed to open stream: No such file or directory in /home/mydom/public_html/catalog/includes/geoip.inc on line 322 Warning: ftell(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 276 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 277 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 279 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 303 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 311 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Warning: fseek(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 394 Warning: fread(): supplied argument is not a valid stream resource in /home/mydom/public_html/catalog/includes/geoip.inc on line 396 Fatal error: error traversing database - perhaps it is corrupt? in /home/mydom/public_html/catalog/includes/geoip.inc on line 416 This was after inserting the Agent row in the table - I have no idea what I've done wrong, I've been at it 2 hours now! Quote Link to comment Share on other sites More sharing options...
PJ2006 Posted November 5, 2007 Share Posted November 5, 2007 Tracy,As part of your hosting account, you should be able to log into a piece of software called MyPHPadmin, which basically you need to use to edit your oscommerce database. One you have that first bit sussed, just open up the SUPERTRACKER part of the database, and you will see a list of fields such as customerid, countrycode, etc etc. You WONT find one called AGENT, which is what is causing your problem. You need to add a field called AGENT, setting it as a VARCHAR If this doesnt make any sense at all drop me a pm.. can someone give me the syntax for this I've tried everything and can't add the row! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.