Jump to content
equilla

Support Thread for Supertracker Contribution

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

Share this post


Link to post
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

Share this post


Link to post
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

Share this post


Link to post
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?

Share this post


Link to post
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!!!

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
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

Share this post


Link to post
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

Share this post


Link to post
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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
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?

Share this post


Link to post
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?

Share this post


Link to post
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 :)

Share this post


Link to post
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]

Share this post


Link to post
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

Share this post


Link to post
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..

Share this post


Link to post
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

Share this post


Link to post
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

Share this post


Link to post
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

Share this post


Link to post
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.

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
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!

Share this post


Link to post
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!

Share this post


Link to post
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!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×