Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


Mikepo last won the day on May 8 2019

Mikepo had the most liked content!

Profile Information

  • Real Name
  • Gender
  • Location

Recent Profile Visitors

12,217 profile views
  1. Mikepo

    Stripe v3 module for SCA

    if you use the Stripe_CLI executable, as shown on the Stripe help pages, you can get the webhook to connect to the Stripe servers from a local XAMPP server. I've done this to check my test environment.
  2. Mikepo

    Emails not sending

    Can you log on to your domain webmail? When logged into your webmail can you send an email to your aol account? Which version of osC are you using? Are you using sendmail or smtp?
  3. Hi Mike

    The database changes in were increasing the varchars to 255. I created an update script for Gary but he's not included it in the package. You can use the following SQL.

    /* Update to existing installations adjusting VARCHARs to 255 in length */

    ALTER TABLE categories
    CHANGE COLUMN categories_image categories_image VARCHAR(255) NOT NULL;

    ALTER TABLE categories_description
    CHANGE COLUMN categories_name categories_name  VARCHAR(255) NOT NULL,
    CHANGE COLUMN categories_seo_keywords categories_seo_keywords VARCHAR(255) NOT NULL,
    CHANGE COLUMN categories_seo_title categories_seo_title  VARCHAR(255) NOT NULL;

    ALTER TABLE manufacturers
    CHANGE COLUMN manufacturers_name manufacturers_name VARCHAR(255) NOT NULL,
    CHANGE COLUMN manufacturers_image manufacturers_image VARCHAR(255);

    ALTER TABLE manufacturers_info
    CHANGE COLUMN manufacturers_seo_keywords manufacturers_seo_keywords VARCHAR(255)  NULL,
    CHANGE COLUMN manufacturers_seo_title manufacturers_seo_title VARCHAR(255) NULL;

    ALTER TABLE orders_products
    CHANGE COLUMN products_model products_model VARCHAR(255),
    CHANGE COLUMN products_name products_name VARCHAR(255) NOT NULL;

    ALTER TABLE orders_products_attributes
    CHANGE COLUMN products_options products_options VARCHAR(255) NOT NULL,
    CHANGE COLUMN products_options_values products_options_values VARCHAR(255) NOT NULL;

    ALTER TABLE products
    CHANGE COLUMN products_model products_model VARCHAR(255),
    CHANGE COLUMN products_image products_image VARCHAR(255);

    ALTER TABLE products_description
    CHANGE COLUMN products_name products_name VARCHAR(255) NOT NULL DEFAULT '',
    CHANGE COLUMN products_seo_keywords products_seo_keywords VARCHAR(255) NULL ,
    CHANGE COLUMN products_seo_title products_seo_title VARCHAR(255) NULL ;

    ALTER TABLE products_images
    CHANGE COLUMN image image VARCHAR(255);

    ALTER TABLE products_options
    CHANGE COLUMN products_options_name products_options_name VARCHAR(255) NOT NULL DEFAULT '';

    ALTER TABLE products_options_values
    CHANGE COLUMN products_options_values_name products_options_values_name VARCHAR(255) NOT NULL DEFAULT '';



    1. Mikepo


      Thanks Mark, that saved be time!


    2. mfleeson


      No worries. The original git update to Gary had this script in but he didn't include it in the update.

    3. ecartz

      ecartz is available on GitHub, but for updates, the SQL is here. 

  4. Mikepo

    View Counter

    This is just for information only. Project honey pot software isn't installed. Their site allows you to see what others are stating for the IP address identified. You can leave comment too! Just ban the IP to stop the event happening again. Hope that helps.
  5. @JcMagpie Your test site for phoenix show a horizontal category menu. Do you have that module available for the latest pheonix version Mike
  6. Mikepo

    HoneyPot Captcha

    @mhsuffolk The problem maybe this: When honey pot finds an issue the user is taken back to the pre-populated create_account.php page so the user can correct the issue. That is how it works, however the math question updates (without the user realising) and the form shows the previous answer which is now wrong. The math question has to be answered again. I must say that I'm using @burt math hook in frozen. I did try the math option in honeypot, but as previously mentioned by others the math check in honeypot didn't work for me, it seemed to stop everything even with the right answer. Hope this helps? I ended up not using honeypot on live shops (I was just trying the module on test installations). I just use gary's math hook on live shops and the problem with fake/spamming accounts have ceased.
  7. Mikepo

    HoneyPot Captcha

    @mhsuffolk I've just installed v1.8. All ok here. I'm adding the UK/GB postcode check too. Seems to ok too!
  8. Mikepo

    HoneyPot Captcha

    @mhsuffolk I'm seeing the same here on my shop. They must be switching off java in the browser, and selecting the first country in the list. My site should only accept UK postcodes, but with Java off they can enter any character string. I just block their IP. They are usually from a bad IP source! check on projecthoneypot.org. I don't use Honeypot Captcha, but have been considering it, and if your suggestion can be incorporated that would be good.
  9. I like the hooks in the admin/categories.php. The need to modify the core file is now not required, and will make admin addons so simple. Thanks 🙂 @burt
  10. I do disagree with these statements. I have a site based on frozen, and it will do until my test environment using Phoenix is up and running. Phoenix is easier to use in terms of its modular format. The latest Product_info layout confirms this. The sitewide hook system is also very flexible. I've just added custom text based upon the payment method selected by the customer, without modifying the core files. Just two additional files define the hook, and the text inserted just where I need it. (I'm not a professional programmer) I'm having to upgrade old addons which were based on BS3, but that is just necessary with any upgrade. I don't expect to have a live Phoenix site running until mid-next year, but in the meantime I'll develop my knowledge of Phoenix and redesign my site and make it very flexible to meet the changing needs for the future.
  11. Mikepo

    Stripe v3 module for SCA

    @raiwa, I agree no order comment on the invoice
  12. Mikepo

    Stripe v3 module for SCA

    Testing version 1.0.9 here on my local server and shop, all seems to be OK. Thank you @asro2004, @raiwa & @mhsuffolk Mike
  13. Mikepo

    Stripe v3 module for SCA

    @asro2004, I added the <style> block at the location specified, but it didn't work. So I added the code to the user.css. Now it works. Why? I don't know. Just thought I would pass on the issue/solution.
  14. Mikepo

    Stripe v3 module for SCA

    @ars2004 ok, I have now added the Stripe module on a fresh install of Phoenix, running php7.0.31, buntu unix, XAMPP for Linux 7.0.31 and still get the following error Fatal error: Uncaught Error: Cannot access empty property in /xxx/xxxx/xxx/xxx/includes/modules/payment/stripe_sca.php:393 Stack trace: #0 /xxxx/xxxx/xxxx/xxxx/includes/classes/payment.php(161): stripe_sca->confirmation() #1 /xxxx/xxxxx/xxxx/xxxx/checkout_confirmation.php(212): payment->confirmation() #2 {main} thrown in /xxxx/xxx/xx/xxxxx/includes/modules/payment/stripe_sca.php on line 393 code is: $this->$intent = \Stripe\PaymentIntent::create($params); As I'm not fully understanding OOP, I can't track down the error. So any help would be very much appreciated. Thanks Mike
  15. Mikepo

    Stripe v3 module for SCA

    So, installed the latest version to my live shop, and again got this fatal error when attempting to go to checkout_confirmation.php Fatal error: Uncaught Error: Cannot access empty property in /xxxx/xxxx/xxxx/includes/modules/payment/stripe_sca.php:393 So, it's not the problem with running on a local server, as the live shop is in direct communication to the stripe servers. I'll keep looking, but I'm a lose here now I'm installing this on BS Frozen.