Jump to content
thirty bees forum
  • 0

500 Error after payment


Kevin13952

Question

I downloaded a third party Stripe module and it allows me to go through the payment process.

(ThirtyBees module doesn't even show up on the checkout page.)

THe 3rd party module seems to work fine, The transaction went through.

But as soon as I press the Process Payment button on checkout screen, I get a 500 Error page returned to me.

Customers won't trust that! Help!

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0

Hi, in any case of error 500 you have to turn on  Debug Mode for the shop.  Usually this is turned off.

Copy the file you get with the error in BO then and you can read the problems then in plaintext.

Some good descriptions to do so you can find for tb and also for PS via Google.  I know there is a tb module for Stripe (use search function here in forum) which will work.  A 3rd party thing should be always the last option and then the module developer is also responsible.

Link to comment
Share on other sites

  • 0
9 hours ago, DRMasterChief said:

Hi, in any case of error 500 you have to turn on  Debug Mode for the shop.  Usually this is turned off.

Copy the file you get with the error in BO then and you can read the problems then in plaintext.

Some good descriptions to do so you can find for tb and also for PS via Google.  I know there is a tb module for Stripe (use search function here in forum) which will work.  A 3rd party thing should be always the last option and then the module developer is also responsible.

I just got this error after testing a live payment:

ThirtyBeesDatabaseException

Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '='

in file modules/revws/classes/subscription.php at line 49

SQL

        SELECT COALESCE(s.subscribed, c.newsletter, 0) AS `subscribed`
        FROM tbu7_customer c
        LEFT JOIN tbu7_revws_subscription s ON (s.email = c.email)
        WHERE c.id_customer = 1

Source file: modules/revws/classes/subscription.php

30:  private $subscribed = null;
31:
32:  public function __construct(Settings $settings, $customer) {
33:    if (is_object($customer)) {
34:      $this->customerId = (int)$customer->id;
35:      $this->email = $customer->email;
36:    } else {
37:      $this->customerId = (int)$customer;
38:    }
39:    $this->mode = $settings->getEmailRequestConsentMode();
40:  }
41:
42:  public function isSubscribed() {
43:    if (is_null($this->subscribed)) {
44:      $sql = "
45:        SELECT " . self::getSqlExpression($this->mode, 's', 'c') ." AS `subscribed`
46:        FROM "._DB_PREFIX_."customer c
47:        LEFT JOIN "._DB_PREFIX_."revws_subscription s ON (s.email = c.email)
48:        WHERE c.id_customer = ".$this->customerId;
49:      $res = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql);
50:      if (isset($res[0]['subscribed'])) {
51:        $this->subscribed = !!$res[0]['subscribed'];
52:      } else {
53:        $this->subscribed = false;
54:      }
55:    }
56:    return $this->subscribed;
57:  }
58:
59:  public function getEmail() {
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...