webmaster69 Posted October 21, 2005 Share Posted October 21, 2005 I installed this great program over a month ago, I check the stats everyday. I have made no recent mods. Then this morning, in the control panel where I view the stats, Insead of the stats it's showing this insead: 1104 - The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay SELECT o.orders_id FROM orders o, visitors v WHERE o.customers_id = v.customers_id AND o.customers_id = '163' AND (to_days(o.date_purchased) - to_days(v.date)) = 0 order by o.orders_id desc [TEP STOP] It looks like a database fault? but everything else seems to be fine. I would really appreciate any help. Thanks Link to comment Share on other sites More sharing options...
Guest Posted October 21, 2005 Share Posted October 21, 2005 Your web host has changed MySQL settings - talk to them :-" Matti Link to comment Share on other sites More sharing options...
webmaster69 Posted October 21, 2005 Author Share Posted October 21, 2005 I installed this great program over a month ago, I check the stats everyday. I have made no recent mods. Then this morning, in the control panel where I view the stats, Insead of the stats it's showing this insead: 1104 - The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay SELECT o.orders_id FROM orders o, visitors v WHERE o.customers_id = v.customers_id AND o.customers_id = '163' AND (to_days(o.date_purchased) - to_days(v.date)) = 0 order by o.orders_id desc [TEP STOP] It looks like a database fault? but everything else seems to be fine. I would really appreciate any help. Thanks I checked with my host and nothing has changed. I deleted all data through admin panel, (which I really wanted to keep) It all seems fine again now and is logging new vistors. I am just worried it may happen again Link to comment Share on other sites More sharing options...
webmaster69 Posted November 15, 2005 Author Share Posted November 15, 2005 I installed this great program over a month ago, I check the stats everyday. I have made no recent mods. Then this morning, in the control panel where I view the stats, Insead of the stats it's showing this insead: 1104 - The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay SELECT o.orders_id FROM orders o, visitors v WHERE o.customers_id = v.customers_id AND o.customers_id = '163' AND (to_days(o.date_purchased) - to_days(v.date)) = 0 order by o.orders_id desc [TEP STOP] It looks like a database fault? but everything else seems to be fine. I would really appreciate any help. Thanks If I delete some of the entries from the table it works again. So it look likes the table only holds upto a certain limit then produces this error. I think I need to set the table to hold more entries. has anyone got any ideas? Help!!! Link to comment Share on other sites More sharing options...
webmaster69 Posted November 20, 2005 Author Share Posted November 20, 2005 If I delete some of the entries from the table it works again. So it look likes the table only holds upto a certain limit then produces this error. I think I need to set the table to hold more entries. has anyone got any ideas? Help!!! Any Database experts?? Link to comment Share on other sites More sharing options...
webmaster69 Posted December 7, 2005 Author Share Posted December 7, 2005 Any Database experts?? The error also appeared at the bottom of the product info page. I have now fixed it !!! :D Link to comment Share on other sites More sharing options...
breamillman Posted December 18, 2005 Share Posted December 18, 2005 The error also appeared at the bottom of the product info page. I have now fixed it !!! :D HOW do you fix it?? Its now happening to me. It started on the Product info pages when I hit like 1800 products. ??? Any help in letting me know how you fixed it (without deleting products)- would be greatly appreciated. Many thanks. ~BREA Link to comment Share on other sites More sharing options...
webmaster69 Posted December 19, 2005 Author Share Posted December 19, 2005 HOW do you fix it?? Its now happening to me. It started on the Product info pages when I hit like 1800 products. ??? Any help in letting me know how you fixed it (without deleting products)- would be greatly appreciated. Many thanks. ~BREA Don't delete anything, I will look into it and let you know what I did Link to comment Share on other sites More sharing options...
webmaster69 Posted December 19, 2005 Author Share Posted December 19, 2005 Don't delete anything, I will look into it and let you know what I did Backup your pages before you amend them. catalog/admin/visitors.php At around line 30 As far as I can remember I added the following 2 lines; // SQL_BIG_SELECTS = 1 - added to solve 1104 MYSQL error message tep_db_query("set sql_big_selects=1"); // Dont change anything below this line // Clean-up Visitors Trace // SQL_BIG_SELECTS = 1 - added to solve 1104 MYSQL error message tep_db_query("set sql_big_selects=1"); tep_db_query("DELETE FROM " . TABLE_VISITORS_TRACE . " where (TO_DAYS(now()) - TO_DAYS(date) > '" . $trace_days . "')"); // set the top level domain function visitor_get_top_level_domain($url) { if (strpos($url, '://')) { $url = parse_url($url); $url = $url['host']; ------------------------------------------------------------------------ to cure your products info error, catalog/product_info.php around line 135 As far as I can remember I added the following 2 lines; // SQL_BIG_SELECTS = 1 - added to solve 1104 MYSQL error message tep_db_query("set sql_big_selects=1"); <?php // SQL_BIG_SELECTS = 1 - added to solve 1104 MYSQL error message tep_db_query("set sql_big_selects=1"); $products_attributes_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "'"); $products_attributes = tep_db_fetch_array($products_attributes_query); if ($products_attributes['total'] > 0) { ?> Let me know how you get on. Link to comment Share on other sites More sharing options...
Amrahp Posted December 22, 2008 Share Posted December 22, 2008 Hello, Does anyone have a clue why my "uri colum" won't fill up in the visitors_trace table resulting in an empty pop up window and no trace of what pages the customers have visited? Everything else works perfect!! It's only that one and only column that doesn't get filled with data! <_< Link to comment Share on other sites More sharing options...
Amrahp Posted January 2, 2009 Share Posted January 2, 2009 Hello,Does anyone have a clue why my "uri colum" won't fill up in the visitors_trace table resulting in an empty pop up window and no trace of what pages the customers have visited? Everything else works perfect!! It's only that one and only column that doesn't get filled with data! <_< Anyone...? Please... Link to comment Share on other sites More sharing options...
broker Posted April 27, 2009 Share Posted April 27, 2009 Have it to, my visited pages only shows me: http://website.com can any one help please? Broker Link to comment Share on other sites More sharing options...
rsteinert Posted October 7, 2009 Share Posted October 7, 2009 Have it to, my visited pages only shows me: http://website.com can any one help please? Broker As far as I can tell the table isn't filling because your server has Register Globals set to "off". There is a fix on the contribution page, "Make this work with register globals off & Time Zone offset mod" which I installed and so far, so good..... Go to http://www.oscommerce.com/community/contributions,4067. Link to comment Share on other sites More sharing options...
vantec Posted November 5, 2010 Share Posted November 5, 2010 As far as I can tell the table isn't filling because your server has Register Globals set to "off". There is a fix on the contribution page, "Make this work with register globals off & Time Zone offset mod" which I installed and so far, so good..... Go to http://www.oscommerce.com/community/contributions,4067. that will correct it, but in my case was necessary to do something else! went to /catalog/admin/visitors.php where is: $trace_string .= '<td><a href="' . HTTP_SERVER . $trace['uri'] . '" target="_blank"><font size="2">' . chunk_split($trace["uri"],80,"<br>") . '</font></a></td></tr>'; change to: $trace_string .= '<td><a href="' . $trace['uri'] . '" target="_blank"><font size="2">' . chunk_split($trace["uri"],80,"<br>") . '</font></a></td></tr>'; otherwise it would never open the visited url! ;) Now my problem: how do I make the number appear over the graphics? <_< Thanks in advance Regards Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.