Jump to content


  • Content count

  • Joined

  • Last visited

  1. uncentaur

    SEARCH BOX don't show nothing

    hi i figure it up what the issue might be: when i started to add contributions to my osc script i have changed the db structure and i left the search query unchanged. if i will upload here the original db structure and 2 search files and the new db structure and the new 2 files, can anybody change the new 2 search file for thet my search boz to work? thank you regards
  2. hi everybody i'm building a shop(www.i-playsex.com) and using oscommerce contributions... until now it works...but also i have problems like: SEARCH BOX is not working, when i do a search it show's me blank page..also when i push the "advanced search" button i can't see the search form, is all blank i have installed the: Advanced Search - Attributes http://www.oscommerce.com/community/contri...h+by+attributes also i have installed Monika's help to PoZel: http://forums.oscommerce.com/index.php?sho...p;#entry1143626 also i have used this help: http://forums.oscommerce.com/index.php?sho...p;hl=search+box but nothing here are the 2 files that i have got now: http://i-playsex.com/search.html (advanced_search.php) and (advanced_search_result), maby it can help can somebody give some help? thanks
  3. uncentaur

    ADMIN don't load ?

    issue resolved: follow this post: http://forums.oscommerce.com/index.php?showtopic=155989 and you will resolve your admin blank page issue regards
  4. uncentaur

    ADMIN don't load ?

    hi i just have installed oscommerce in www.i-playsex.com and the admin section si not laoding in browser: www.i-playsex.com/admin ?? can anyone help me? thank you
  5. Thank you very much for help, i have resolve it. :rolleyes: Best regards ;)
  6. hi i have this issue in the admin side: Tools/Newsletter Manager: "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 '-20, 20' at line 1 select newsletters_id, title, length(content) as content_length, module, date_added, date_sent, status, locked from newsletters order by date_added desc limit -20, 20" can any one can help me? thank you regards
  7. uncentaur

    Use Search-Engine Safe URLs ERROR !

    hi i have not found any split_page_results.php files, BUT i resolved my "zero" issue: i have des-installed my oscommerce and installed from scratch, but changing the oscommerce.sql file from the install folder. i have searched and replaced every en, english with ro,romanian and then run the install and now is working thanks regards
  8. uncentaur

    Use Search-Engine Safe URLs ERROR !

    hi i have installed: 1. Ultimate SEO URLs - Ultimate SEO URLs - 2.1d with optional Admin settable Product and Category URLs http://www.oscommerce.com/community/contri...,all/search,seo 2. header tags for novices - header_tags_for_novice_v2 http://www.oscommerce.com/community/contri...l/search,novice 3. 1054 - Unknown column 'p.products_id' in 'on clause' http://www.monikamathe.com/oscommerce/mysql5.txt and all work great until i remove the default 3 languages and install romanian language (romanian language is a clone of english language) now it shows me zero price too all products, i can add products but it shows me zero price too also it shows me this errorors: on admin/clients/orders: " 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 '-20, 20' at line 1 select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by o.orders_id DESC limit -20, 20 " on admin/reports/best sellers: " 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 '-20, 20' at line 1 select p.products_id, p.products_ordered, pd.products_name from products p, products_description pd where pd.products_id = p.products_id and pd.language_id = '1' and p.products_ordered > 0 group by pd.products_id order by p.products_ordered DESC, pd.products_name limit -20, 20 " on admin/catalog/categories/products: it shows me zero products and categories thank you for your time regards
  9. uncentaur

    Use Search-Engine Safe URLs ERROR !

    thanks for reply i have installed the Ultimate SEO URLs: http://www.oscommerce.com/community/contributions,2823 before but i had some other errors that i couldn't fix up: like the prices to all products to my store reseted to zero and even when i added a product to store, with a price different then zero the product showed up with zero price in store i will try to re-install it and come back thanks again
  10. hi i have installed this contribution: AP URL Rewriting http://www.oscommerce.com/community/contri.../search,rewrite and when a customer wants to add a product to his product cart, the cart remains zero this happens only when the Use Search-Engine Safe URLs (still in development) option in admin site is TRUE, like it should be for html links here is my page: www.i-playsex.com can anybody can provide me any help please? thanks