Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


clustersolutions last won the day on April 28 2018

clustersolutions had the most liked content!


Profile Information

Recent Profile Visitors

28,976 profile views
  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

    @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!
  9. 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...
  10. 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.
  11. 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...
  12. 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...
  13. @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.
  14. 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...