iscnitzan Posted September 6, 2006 Share Posted September 6, 2006 Hello everyone, I stumbled upon a big problem when changing to a server which had SQL 4.1.x installed instead of the more common 4.0.x. The problem is that the newer SQL dose not support negative results form sql_query, so we get many errors when running the OSC since many of the page splitting code has negative results... see example problem and solution here - I posted this yesterday. But - now I found that this also exists in the front-end as well. When I have no products listed as specials for example - there is an error. Also - when using the search tool - the results page is split - but the links for page 1, 2, 3, next>>> will not work! Please - if someone has an idea how to fix all that - I am open for suggestions.... I think this is a big problem for all of us since servers will be updated to new SQL's - we have to be prepared!!! Link to comment Share on other sites More sharing options...
Iggy Posted September 6, 2006 Share Posted September 6, 2006 What version os osC are you running? If it's not post Nov 11 osC update look into merging those changes into your store. HTH, Iggy Everything's funny but nothing's a joke... Link to comment Share on other sites More sharing options...
iscnitzan Posted September 6, 2006 Author Share Posted September 6, 2006 what is Nov 11 update? where do I find it? I have 2.2 MS2, and I didn't know of an update till now. :'( is the merging difficult? Link to comment Share on other sites More sharing options...
Iggy Posted September 6, 2006 Share Posted September 6, 2006 what is Nov 11 update? where do I find it? I have 2.2 MS2, and I didn't know of an update till now. :'( is the merging difficult? The latest is in downloads. There's a changes file in there you can go line for line with. If you're used to using a diff program and are familiar with merging any mods you've made with the stock files you should be OK. Iggy Everything's funny but nothing's a joke... Link to comment Share on other sites More sharing options...
iscnitzan Posted September 6, 2006 Author Share Posted September 6, 2006 The latest is in downloads. There's a changes file in there you can go line for line with. If you're used to using a diff program and are familiar with merging any mods you've made with the stock files you should be OK. Iggy Is it the file named update-20060817.txt? Link to comment Share on other sites More sharing options...
Iggy Posted September 6, 2006 Share Posted September 6, 2006 Is it the file named update-20060817.txt? It is. Includes the updates from Nov 11 05 as well IIRC. Iggy Everything's funny but nothing's a joke... Link to comment Share on other sites More sharing options...
iscnitzan Posted September 6, 2006 Author Share Posted September 6, 2006 OK, Got the update & installed the changes... but - the main problem - the error in search split_page_results linking - still exists! :'( Must admit - I also thought when installing the update that it'll surly solve it... Why don't you take a look at the error: http://www.freshnup.net/shop/advanced_sear...ywords=Dead+Sea when the page comes up - just click the link for split_page_results [Next >>>] at the top. Some how the linking is completely wrong. I hope anyone can help with this - its frustrating... Link to comment Share on other sites More sharing options...
iscnitzan Posted September 6, 2006 Author Share Posted September 6, 2006 I checked around more. maybe it has to do with the mode Ultimate SEO URLs v2.1...? the error code is generated in html_output.php, after its instructed to do the SEO URLs mode, it seems to skip the mode, and then produce the error. Link to comment Share on other sites More sharing options...
♥Vger Posted September 7, 2006 Share Posted September 7, 2006 In addition to Ultimate SEO URL's being installed it looks as though you have also turned on "Use Search Engine Friendly URL's" in your osCommerce admin panel. This is trying to rewrite URL's on pages that Ultimate SEO URL's does not rewrite, in a format which is not acceptable to the server. Switch it back to 'False', as it was originally set. Vger Link to comment Share on other sites More sharing options...
iscnitzan Posted September 7, 2006 Author Share Posted September 7, 2006 Thank you!! That did it! I can't remember if/when/or why I turned it on.... Now it works, big relief! Thanks again! :thumbsup: Link to comment Share on other sites More sharing options...
iscnitzan Posted September 11, 2006 Author Share Posted September 11, 2006 A very important update! It DID NOT solve the problem - just changed it.... When I disable Use search-engine safe URLs the search results & header links are fine... But then the Buy Now button doesn't register a purchase when clicked! Still a MAJORE problem!! I even tried disabling Ultimate URLs - that completely tossed the store into chaos, it registered me a 350 visitors and stopped responding... I still contend that there must be an interpolation error where the advanced_search_result.php just replaces = with / see this for example of URLs I get http://www.freshnup.net/shop/advanced_sear...f771d2c4322aaa2 and http://www.freshnup.net/shop/products_new....f771d2c4322aaa2 With both cases - the = was changed to / which results in an error BUT - I do not know where or how to fix it.. Can anyone help? Link to comment Share on other sites More sharing options...
♥Vger Posted September 11, 2006 Share Posted September 11, 2006 That pathway is still showing the 'Use Search Engine Friendly URL's' pathways. I'm wondering if Ultimate SEO URL's cache class has cached those pathways. Reset the SEO Cache and see if that helps. Vger Link to comment Share on other sites More sharing options...
iscnitzan Posted September 12, 2006 Author Share Posted September 12, 2006 Yes, I know they show Use search-engine safe URLs, that's because I just enabled it... When I turn Use search-engine safe URLs off - the search function is fine (just like you said it would) BUT - then the Buy Now button on the product listing page doesn't work... and that's even a bigger problem - not letting customers buy! What happens is when I turn the Use search-engine safe URLs to off the BUY NOW button URL is changing from shopping_cart.php?sort=2a&osCsid=86c6c84401aedbd4ac38ebd6f2ae36d4 to shopping_cart.php?sort=2a & a m p ; osCsid=86c6c84401aedbd4ac38ebd6f2ae36d4 Since this is a live store (with customers shopping as I write) - I prefer that clients can buy for now - while I try desperately to fix this... So far I can't win - turn it on= bad, turn it off = worst.. Got any ideas? Link to comment Share on other sites More sharing options...
iscnitzan Posted September 12, 2006 Author Share Posted September 12, 2006 I decided to play with the cache as you suggested.. resetting the SEO cache did nothing, So - I disabled cache completely and now all is working fine, I guess there was something stored wrong with the cache of links. Leads me to wonder - do I need this cache enabled? I have only 150 items (will probably be 200 by Christmas) in the store, is it necessary to have the cache enabled? Is the performance improvement notable at these levels? It's very tempting to leave cache off for now. 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.