Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

help wanted not impossible


Digerdoo

Recommended Posts

1146 - Table 'wltradata.TABLE_VISITORS' doesn't exist

 

select counter, customers_id FROM TABLE_VISITORS where browser_ip = '12.15.125.121' AND browser_language = 'fi' AND to_days(now()) - to_days(date) < 1

 

[TEP STOP]

Link to comment
Share on other sites

Whats the question, which page is this coming from, and what did you do to cause the error?

Kenneth S

--------------

Customer "Are you a real programmer?"

Me "No, but I did stay at a Holiday Inn Express last night"

Link to comment
Share on other sites

1146 - Table 'wltradata.TABLE_VISITORS' doesn't exist

 

select counter, customers_id FROM TABLE_VISITORS where browser_ip = '12.15.125.121' AND browser_language = 'fi' AND to_days(now()) - to_days(date) < 1

 

[TEP STOP]

 

It seems like your missing the define in database_tables.php

 

define('TABLE_VISITORS', 'visitors');

Link to comment
Share on other sites

put the line somewhere near the top of your application_top.php file and see if the error still happens.

Kenneth S

--------------

Customer "Are you a real programmer?"

Me "No, but I did stay at a Holiday Inn Express last night"

Link to comment
Share on other sites

put the line somewhere near the top of your application_top.php file and see if the error still happens.

 

thanks now comes error :

 

1146 - Table 'wltradata.visitors_trace' doesn't exist

 

insert into visitors_trace (date,customers_id,browser_ip,uri) values (now(),'0','22.45.213.77','/')

 

[TEP STOP]

Link to comment
Share on other sites

but if i create table visitors same error message comes.. :o

 

Assuming you have installed Visitors Webstat 2.x there is a note in the instructions that you might have to chance the the table name depending on the osC version you use.

The one with the package says :

CREATE TABLE `osc_visitors` (
 `browser_id` int(11) NOT NULL auto_increment,
 `customers_id` int(11) NOT NULL default '0',
 `date` datetime NOT NULL default '0000-00-00 00:00:00',
 `online` datetime NOT NULL default '0000-00-00 00:00:00',
 `counter` int(12) NOT NULL default '1',
 `browser_ip` varchar(15) NOT NULL default '',
 `browser_language` varchar(16) NOT NULL default '',
 `language` varchar(16) NOT NULL default '',
 `referer` varchar(96) NOT NULL default '',
 `uri` varchar(96) NOT NULL default '',
 PRIMARY KEY  (`browser_id`)
) TYPE=MyISAM AUTO_INCREMENT=18989;

 

while for me, and probably for you also, it should be:

CREATE TABLE `visitors` (
 `browser_id` int(11) NOT NULL auto_increment,
 `customers_id` int(11) NOT NULL default '0',
 `date` datetime NOT NULL default '0000-00-00 00:00:00',
 `online` datetime NOT NULL default '0000-00-00 00:00:00',
 `counter` int(12) NOT NULL default '1',
 `browser_ip` varchar(15) NOT NULL default '',
 `browser_language` varchar(16) NOT NULL default '',
 `language` varchar(16) NOT NULL default '',
 `referer` varchar(96) NOT NULL default '',
 `uri` varchar(96) NOT NULL default '',
 PRIMARY KEY  (`browser_id`)
) TYPE=MyISAM AUTO_INCREMENT=18989;

 

Just delete the osc_visitors table from your database and run the changed SQL query. That should fix it.

Link to comment
Share on other sites

Assuming you have installed Visitors Webstat 2.x there is a note in the instructions that you might have to chance the the table name depending on the osC version you use.

The one with the package says :

CREATE TABLE `osc_visitors` (
?`browser_id` int(11) NOT NULL auto_increment,
?`customers_id` int(11) NOT NULL default '0',
?`date` datetime NOT NULL default '0000-00-00 00:00:00',
?`online` datetime NOT NULL default '0000-00-00 00:00:00',
?`counter` int(12) NOT NULL default '1',
?`browser_ip` varchar(15) NOT NULL default '',
?`browser_language` varchar(16) NOT NULL default '',
?`language` varchar(16) NOT NULL default '',
?`referer` varchar(96) NOT NULL default '',
?`uri` varchar(96) NOT NULL default '',
?PRIMARY KEY ?(`browser_id`)
) TYPE=MyISAM AUTO_INCREMENT=18989;

 

while for me, and probably for you also, it should be:

CREATE TABLE `visitors` (
?`browser_id` int(11) NOT NULL auto_increment,
?`customers_id` int(11) NOT NULL default '0',
?`date` datetime NOT NULL default '0000-00-00 00:00:00',
?`online` datetime NOT NULL default '0000-00-00 00:00:00',
?`counter` int(12) NOT NULL default '1',
?`browser_ip` varchar(15) NOT NULL default '',
?`browser_language` varchar(16) NOT NULL default '',
?`language` varchar(16) NOT NULL default '',
?`referer` varchar(96) NOT NULL default '',
?`uri` varchar(96) NOT NULL default '',
?PRIMARY KEY ?(`browser_id`)
) TYPE=MyISAM AUTO_INCREMENT=18989;

 

Just delete the osc_visitors table from your database and run the changed SQL query. That should fix it.

 

not working.. same problem..hmmmmmmm

Link to comment
Share on other sites

Hmm, strange, that did the trick for me after I read the note about the table name when I already created the osc_visitors table.

Have you double checked all steps to be taken ? After I solved the table name problem it ran fine.

 

 

H U R A A ! ! !

 

NOW IT WORKS.. :thumbsup:

 

THANKS TO YOU VERY MUCH !

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...