Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


clustersolutions last won the day on June 22

clustersolutions had the most liked content!


Profile Information

Recent Profile Visitors

29,771 profile views
  1. clustersolutions

    Next osCommerce v4 demo

    It'll be interesting to see the new code base and the business model.I hope there is a new framework that could draw in new developers. Devs like to work on cool stuffs. There's been a lot of cool stuffs since OSC and Phoneix--containerization, microservices, ElasticSearch, Kafka, Redis, NoSQL like Cassandra and etc...throw all the bells and whistles at it to make it awesome and stood out from the rest. Let's face it moving from OSC or Phoenix to V4 will not be an easy migration given how the original cart was so "customizable" so make it worthwhile. I spent over 15+ years in opensource/startups and am now working at a big publicly traded software company with a 30+ year old platform/code base, and it's been interesting experiencing the company and it's fortune 100 clients who are used to white gloves services trying to adopt opensource. I don't think that the question on "can it be done or how?" has been addressed yet because it isn't easy...ya, I am interested to see how this will turn out...thx! BTW, "low-codes" is the buzz word now I think...
  2. clustersolutions

    Next osCommerce v4 demo

    Hope it's alright to provide some suggestions: Record the demo session and provide the recording. The sooner people get to see the s/w, repo, and app features the better to find volunteers. For dotcomboomers they'll be thinking what's in it for me, and for millennials they probably will do things for a cause that they believe in. Wiki type content management perhaps people can submit contents that are pending approval? The thought here was to just make it open. Read a story about Elastic Search and on how the founder was dumbfounded as it gained traction after it was put in an opensource git repo. Thanks!
  3. clustersolutions

    Next osCommerce v4 demo

    i think sooner the better getting some kinda demo or repo online to keep people's interest be good for sure. if the migration was to be very complex what gives the new OSC advantage over other carts or SaaS, right?
  4. clustersolutions

    Gift vouchers

    Sure thing. It tapped into the CCGV contribution and used the following workflow: Mail GV, sent single email to an admin account. Login to customer account and redeem the GV code. GV can be retrieved from GV Sent landing page or the admin's email, and the landing page also provides an audit trail. This assume an already working GV module, and it by passed the GV queue and release steps from the original contribution. Further automation should be possible, but the implementation was quick and painless for small stores which has the need to provide store credits. I have to agree the GV purchase offer wasn't very popular for small/medium stores, and if there were a demand for it it would probably be better off partnering with Visa/MC and offering/selling their gift CC I would think. Screen capture attached. Please feel free to comment. Thanks! Oh, the customers can also see the available store credit from the account dropdown (additional hack, the store was also integrated with an ERP, which provided a pdf credit invoice under order history/status).
  5. 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.
  6. 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....
  7. 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.
  8. 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?
  9. It's been a long time and just a drive by "Hello" and hope everyone stays safe!

  10. 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..."
  11. 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...
  12. 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!
  13. 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...
  14. 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.
  15. 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...