Jump to content

spcs

Members
  • Content count

    19
  • Joined

  • Last visited

  1. spcs

    Links Manager II

    sorry for the spam, but the fix you mention earlier in the thread seems to fix "1064 - You have an error in your SQL syntax; .../... syntax to use near '-20, 20' at line 1" issue as mention in you readme.txt and few other oscommerce site.
  2. spcs

    Links Manager II

    it seems that the offset is negative and since mysql 4.1, mysql does not accept a negative offset. But I had that issue with another contrib which I fixed with the fix you proposed sometime ago :) I'm going to try to add manually a link into the DB, humm same issue.
  3. spcs

    Links Manager II

    I already have this line into the file, I'm using the latest version of oscommerce. line 38 into admin/includes/classes/split_page_results.php $sql_query .= " limit " . max($offset, 0) . ", " . $max_rows_per_page; Any other hints ? :) I'm trying to debug a bit many thanks for your help I'm refering to the link manager v1 thread where you are/were actif "http://forums.oscommerce.com/index.php?showtopic=97493&st=140&p=688244entry688244" and the only anwser from the guy who submitted the error was "I dont know what happened but everything is normal now " which is not helping me so much. hope that's not going to disapear like that, I would like to understand ! On the creload forum ( I dont have a creload !!! just a basic oscommerce with few contrib ) but a guy seems to have the issue and it seems that they are refering to multilangue issue http://forums.creloaded.com/Forums/viewtop...sc/start=0.html my oscommerce website has 3 languages.
  4. spcs

    Links Manager II

    changes has been roll back and it seems like I have the same issue. I dont have any cache enable during this test. Thanks for the help :)
  5. spcs

    Links Manager II

    Dear all, First of all thank you for this contrib. I installed the latest version of links manager II v1.19 and it seems I have a query issue. Looking around using google, it seems that some people also have it but i was not able to find a fix in any of the thread/website i found. Here is the Sql error i have : Into the admin section, I added a Link category.when I click on "links" in order to add a link, here is the error I recieve : Warning: Division by zero in /***/catalog/admin/includes/classes/split_page_results.php on line 33 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-0, MAX_LINKS_DISPLAY' at line 1 select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_reciprocal_disable, l.links_status from links l left join ( links_description ld ) on ( l.links_id = ld.links_id ) order by ld.links_title limit -0, MAX_LINKS_DISPLAY [TEP STOP] I'm not a developer any help would be very grateful I'm running mysql 5.0.45
  6. both are working for me, i dont have products_id into continue button url after the second one ! my french forum post has been updated with both !
  7. ok let's say with your workaround :)
  8. posted on the french oscommerce forum replying to my post with a link to this forum you name + fix http://www.oscommerce-fr.info/forum/index....st&p=269362 thank you again :)
  9. Your fix seems to be working !! nice catch :) thank you a lot again for your time and your help on this. As it could affect few people, we should submit this bug with your fix :)
  10. It's seems that the continue shopping button is adding a products_id= in the url when it shouldn't because you are from a category! the continue button url should contain products_id only when you have clicked on buy now button from the product page itself. There is an issue somewhere :)
  11. 2-2.2e is working for me without validation and with Independent SEO Url, to fix the "continue shopping" bug that I mentioned earlier into the thread there is a work around : http://addons.oscommerce.com/info/2986 I dont know why this guy did this addon, but that's a workaround to solve the products_id bug. My current setup is 2-2.2e with "Independent SEO Url" and the continue shopping fix, everything is working fine. I had one bug with 2.1d SEO and Independent SEO Url which was where sometimes on the category box on the left between navigation and categories i had "CCCCCCCCCCCCCCC", dunno why. :) btw, thank a lot for your help on this ! and I hope to have better relation with google now :) did you find back the continue shopping button on your setup ?
  12. not the latest one but the one before 2.2rc2 i believe ( I still have to find time to move to 2.2 rc2a )
  13. during all my checks regarding this bug, i noticed that some people have issues with this button : it disapear with IE or firefox. You should have line 209 shopping_cart.php : <td class="main"><?php echo '<a href="' . tep_href_link($navigation->path[$back]['page'], tep_array_to_string($navigation->path[$back]['get'], array('action')), $navigation->path[$back]['mode']) . '">' . tep_image_button('button_continue_shopping.gif', IMAGE_BUTTON_CONTINUE_SHOPPING) . '</a>'; ?>
  14. same issue with W3C off go on the demo page http://demo.oscommerce.com/ You want to buy a product, you click on "buy now" button for this product you are redirected to the shopping cart http://demo.oscommerce.com/shopping_cart.php then you have this continue button in the middle of the page !
  15. same issue using 2.1d ( first version ) or 2.2e ( with lines starting by "$this->ValidateName" commented out ) the continue boutton url when i'm into the shopping cart ( after i added the product A ) is http://www.shop.com/categorie-c-11.html?so...roducts_id=4242 (4242 = A product id ) We could have a workaround modifying the continue boutton itself with "java script:history.back(1)" , but that's a work around, that doesn't solve this actual issue.
×