500 Error after payment

[Kevin13952]

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!

[DRMasterChief]

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.

[Kevin13952]

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() {

[the.rampage.rado]

Could you test the thirty bees module again and check if your settings match mine (I posted them in the other thread)?