Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Support Thread for Supertracker Contribution


equilla

Recommended Posts

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--

Link to comment
Share on other sites

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.

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

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 by ibasq
Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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!!!

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • 2 weeks later...

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

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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 :)

Link to comment
Share on other sites

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]

Link to comment
Share on other sites

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..

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...