help wanted not impossible

[Digerdoo]

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]

[KennethS]

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

[user99999999]

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]

<{POST_SNAPBACK}>

 

It seems like your missing the define in database_tables.php

 

define('TABLE_VISITORS', 'visitors');

[Digerdoo]

It seems like your missing the define in database_tables.php

 

define('TABLE_VISITORS', 'visitors');

<{POST_SNAPBACK}>

 

 

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

[KennethS]

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

[Digerdoo]

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

<{POST_SNAPBACK}>

 

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]

[wheeloftime]

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

<{POST_SNAPBACK}>

 

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.

[Digerdoo]

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.

<{POST_SNAPBACK}>

 

not working.. same problem..hmmmmmmm

[wheeloftime]

not working.. same problem..hmmmmmmm

<{POST_SNAPBACK}>

 

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.

[Digerdoo]

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.

<{POST_SNAPBACK}>

 

 

H U R A A ! ! !

 

NOW IT WORKS.. :thumbsup:

 

THANKS TO YOU VERY MUCH !

[wheeloftime]

H U R A A  ! ! ! 

 

NOW IT WORKS..  :thumbsup:

 

THANKS TO YOU  VERY MUCH !

<{POST_SNAPBACK}>

 

Your welcome. Glad to hear you got it working :thumbsup: