Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

help wanted not impossible


Digerdoo

Recommended Posts

Posted

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]

Posted

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"

Posted
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');

Posted
It seems like your missing the define in database_tables.php

 

define('TABLE_VISITORS', 'visitors');

 

 

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

Posted

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"

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

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

Posted
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

Posted
not working.. same problem..hmmmmmmm

 

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.

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

Archived

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

×
×
  • Create New...