Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


Everything posted by clustersolutions

  1. clustersolutions

    Gift vouchers

    gift voucher portion can be hacked into also provide store credit. some to consider...oh, gave great audit trail when needed too.
  2. clustersolutions

    Need help with Database issue - site is down

    Hmm "site has been online for 14 years and never seen this issue.." is kinda a funny statement...also "repair the whos online db..." I know this is a serious issue and there's nothing funny about it...k, couple questions: why was it that you need to repair the whosonilne table? safe to assume your osc prod db tables are running entirely on InnoDB? You hosting is providing mysql with binlog (transaction logging) that is good for recovery or replication etc. Very well. So for mysql the default isolation level is REPEATABLE READ and don't ask me why while the rest of the DBs in this world seems to defaults to READ COMMITTED. READ COMMITTED is good so your hosting company knew what they were doing and had modified the default isolation level of myql...again, very well... K, try this... fix the reason that caused the whosonline table to be corrupted. check to see if there is an index on the time_last_click column. mysql row level locking locks by index and without it it may try to obtain a table level lock which typically is a no no. so the index may help. can't image the whosonline table is huge and if it was i would make sure that u run analyze table to update the table stats so the engine optimizer runs in tip-top shape. it is the whosonline table...try truncating it... Good luck! Oh, one more thing, you can also set the session isolation level to repeatable read before doing the repair...if u think that's the reason that the repair table was failing....
  3. clustersolutions

    New management and osCommerce v4

    Thanks for the info.! Congrats and that's awesome! Glad to had done a drive by here...looking forward to checking out V4 for sure.
  4. clustersolutions

    New management and osCommerce v4

    Cool, does new management also mean total ownership of the brand/codes/sites and everything? Nice! Will Harold play any part in the new management?
  5. It's been a long time and just a drive by "Hello" and hope everyone stays safe!

  6. clustersolutions

    ULTIMATE Seo Urls 5 - by FWR Media

    You can't do it. It needs the product id unique key. Now, you can put a unique index on the column that you want to use as your permalink, and then you should be able to convert the "permalink" desc to product id "upstream" of any "product_id" requirements and use it that way...that would be the easiest hack. But if you get a lot of errors as you are creating that unique index...you would have some cleanup work to do...by then you should know what I mean "it needs an unique key..."
  7. clustersolutions

    Paypal Standard Order Status Not Updated

    @milerwan Ok, I have to check my Paypal setting... IPN disabled. PDT - Website payment preference -> auto return -> on -> back to checkout_process.php URL, PDT -> on. These should be the minimum, I may have to modify checkout_process to work with PDT...
  8. clustersolutions

    Paypal Standard Order Status Not Updated

    Anyone else is having problem with Paypal Standard not updating the order status at completion? Mine isn't updating the order status if the customer didn't click on "Go Back To Merchant". Thanks for your help! Tim
  9. clustersolutions

    Paypal Standard Order Status Not Updated

    @milerwan, hey, what verion of OSC and Paypal and etc. that you are using? Mine was on BS, probably Edge, and I had to reinstall Paypal somehow. Also, it seems that I had to setup IPN and PDT on Paypal to get it to work. Did you do that? I will have to look into it some more when I have a chance to remember what I did...LMK. Thx!
  10. clustersolutions

    Customer Credit

    CCGV, but I don't know which version is the best to start with, but you can hack the gift voucher side to generate credit for customers, once your get the module to work. The hack is simple. The gift card feature was never useful for me, sold zero gift cards anyway...I had used it for give me your email and get $10 credit in your account as well as for return/exchange and etc...
  11. clustersolutions

    ULTIMATE Seo Urls 5 - by FWR Media

    Hmm...true, clean code is important... I don't know if this banaid is better than the previous one, but they both offer a similar solution. I would really do a var_dump($text_array) or print_r($text_array) just before the foreach statement to get a stack trace of the argument. You really need to know why PHP was complaining. In fact, the foreach statement wasn't just looking for an array, and it was expecting an associative array. FWR is a smart dude, I would definitely understood why before deciding on a fix. That would be my approach...some upstream setting may just fix the warning.
  12. clustersolutions

    ULTIMATE Seo Urls 5 - by FWR Media

    Don't think MySQL cache works at this time, but u did not say much about the version of your OSC and environment. Anyway, just use file cache, I was gonna rewrite the DB cache part but had decided to wait after hearing the 2.4 release announcement at that time...
  13. Ah...hello...you can't have such associative array... This is ok. $slicks = []; This append to the array.. $slicks[] = []; I would just comment out those lines and see what happens. Yeah, I took one look at the stock image gallery and went to bxslider and never looked back...
  14. @Bobber , I hope no one minds me tell you this. @oscoMMarket had shared with me that his posts are being moderated from this point forward. So, I think be patience and if he had responded it may take a while for it to become available.
  15. clustersolutions

    ULTIMATE Seo Urls 5 - by FWR Media

    I see the benefit of keep the product name based url constant, but I am not sure the benefit of removing .html. I think it said path rewrite must have .html. So, no!? With Product Listing Ad, CPC company often modify the production title to get higher impression/click thru rate base on seasonal behavior...
  16. clustersolutions

    Cant install Excel Populate

    Ah, IIS, what!? Just kidding, your definitely missing some steps during your hack. In the old OSC, that should be defined in the filenames.php file.
  17. clustersolutions

    Cant install Excel Populate

    @nickjansen Try this. It's just an anchor. I hope you get the idea of it being in an array form. Don't shoot me, I think I am changing core codes. <?php /* $Id$ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2010 osCommerce Released under the GNU General Public License */ $cl_box_groups[] = array( 'heading' => BOX_HEADING_CATALOG, 'apps' => array( array( 'code' => FILENAME_CATEGORIES, 'title' => BOX_CATALOG_CATEGORIES_PRODUCTS, 'link' => tep_href_link(FILENAME_CATEGORIES) ), array( 'code' => FILENAME_PRODUCTS_ATTRIBUTES, 'title' => BOX_CATALOG_CATEGORIES_PRODUCTS_ATTRIBUTES, 'link' => tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES) ), array( 'code' => FILENAME_EXCEL, 'title' => 'Excel Populate', 'link' => tep_href_link(FILENAME_EXCEL) ), array( 'code' => FILENAME_MANUFACTURERS, 'title' => BOX_CATALOG_MANUFACTURERS, 'link' => tep_href_link(FILENAME_MANUFACTURERS) ), array( 'code' => FILENAME_REVIEWS, 'title' => BOX_CATALOG_REVIEWS, 'link' => tep_href_link(FILENAME_REVIEWS) ), array( 'code' => FILENAME_SPECIALS, 'title' => BOX_CATALOG_SPECIALS, 'link' => tep_href_link(FILENAME_SPECIALS) ), array( 'code' => FILENAME_PRODUCTS_EXPECTED, 'title' => BOX_CATALOG_PRODUCTS_EXPECTED, 'link' => tep_href_link(FILENAME_PRODUCTS_EXPECTED) ) ) ); ?>
  18. clustersolutions

    Addon installer concept

    Long thread, I hadn't read it all yet. How about the App Marketplace concept that Harold had started? And the framework...I wonder how much work to get there... https://library.oscommerce.com/Online&en&oscom_2_4&developers&framework.
  19. clustersolutions

    untouchable genearl.php

    Well, complains are good. It helps you narrow down the problem. Check you file permission and etc. for 500 IE. The web server is complaining. If you have code error, then the PHP parser will complain. U may wanna hire someone to help you with this.
  20. clustersolutions

    ULTIMATE Seo Urls 5 - by FWR Media

    It's a matter of having options and for some of those long time OSC users being able to keep indexed URL the same moving forward would be highly desirable. I would work on it because I use it, but I found it hard to try hitting a moving target. Wow, three yrs had passed since I touched this repo...I think I stopped as I was waiting for the db module to finalize. https://github.com/clustersolutions/Ultimate_Seo_Urls_5_PRO_BS
  21. clustersolutions

    ULTIMATE Seo Urls 5 - by FWR Media

    I think at one time it probably gave an advantage. No one's every gonna know if that component was completely removed within the ranking algo, or was it just because there are just so many other important factors that are being considered now. I found it kinda hard to make comparison with mega sites that had reached a critical mass for its organic traffic. Also, keep in mind that there are other search engines, and Google isn't even allowed in China. My $0.02.
  22. clustersolutions

    Help with ot_shipping due the free shipping

    @sinopia, I believe there were quite a few places that required core code mods, may be schema as well. I hv been waiting for a stable/finalized OSC frame work b4 further dev...I would by then. Hope u known what I mean.