Digerdoo Posted January 20, 2005 Share Posted January 20, 2005 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 More sharing options...
KennethS Posted January 20, 2005 Share Posted January 20, 2005 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 More sharing options...
user99999999 Posted January 20, 2005 Share Posted January 20, 2005 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'); Link to comment Share on other sites More sharing options...
Digerdoo Posted January 20, 2005 Author Share Posted January 20, 2005 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 Link to comment Share on other sites More sharing options...
KennethS Posted January 20, 2005 Share Posted January 20, 2005 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 More sharing options...
Digerdoo Posted January 20, 2005 Author Share Posted January 20, 2005 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] Link to comment Share on other sites More sharing options...
wheeloftime Posted January 20, 2005 Share Posted January 20, 2005 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. Link to comment Share on other sites More sharing options...
Digerdoo Posted January 20, 2005 Author Share Posted January 20, 2005 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 Link to comment Share on other sites More sharing options...
wheeloftime Posted January 20, 2005 Share Posted January 20, 2005 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. Link to comment Share on other sites More sharing options...
Digerdoo Posted January 20, 2005 Author Share Posted January 20, 2005 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 ! Link to comment Share on other sites More sharing options...
wheeloftime Posted January 21, 2005 Share Posted January 21, 2005 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: Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.