How Did You Hear About Us? Referrals Mod [Support Thread]

Great, thanks!

I have a 500 error installing How Did You Hear About Us.

Zen Cart 2.0.1
PHP 8.3.17

Logs for example installs fine in the plugin manager.

Any suggestions?

No changes are made when trying to install, just dies in a 500 error. No log

Thanks in advance,
Melanie

Quote:

---

Originally Posted by mprough

I have a 500 error installing How Did You Hear About Us.

Zen Cart 2.0.1
PHP 8.3.17

Logs for example installs fine in the plugin manager.

Any suggestions?

No changes are made when trying to install, just dies in a 500 error. No log

Thanks in advance,
Melanie

---

The plugin's readme clearly states that Zen Cart 2.1.0 or later is required.

How Did You Hear About Us - Version: v2.0.0?

Quote:

---

Originally Posted by mprough

How Did You Hear About Us - Version: v2.0.0?

---

That's the plugin's version, which has no bearing on the version(s) of Zen Cart required. The encapsulated version of the plugin requires zc210 and later.

Quote:

---

Originally Posted by lat9

v2.0.0 of How Did You Hear About Us is now available for download: https://www.zen-cart.com/downloads.php?do=file&id=90

This version supports zc210+ and PHP 8.0+; released as an encapsulated plugin.

---

So happy to see this one converted to a plug-in. I'm having the following error while upgrading to latest ZC version:
Table '***_databasename.configuration' doesn't exist

Even though I've already installed 6 other plugins without issues.

PS: I do use prefix for the database.

Quote:

---

Originally Posted by ideasgirl

So happy to see this one converted to a plug-in. I'm having the following error while upgrading to latest ZC version:
Table '***_databasename.configuration' doesn't exist

Even though I've already installed 6 other plugins without issues.

PS: I do use prefix for the database.

---

Darn it, I know better!

Find the file /Installer/ScriptedInstaller.php in the distribution.

Change line 60 (highlighted below)

Code:

---

        $this->executeInstallerSql(
            "INSERT IGNORE INTO configuration
                (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added)
            VALUES
                ('Display \"Other\" Referral option?', 'DISPLAY_REFERRAL_OTHER', 'true', 'Display \"Other - please specify\" with text box in referral source in account creation', 5, 10, 'zen_cfg_select_option([\'true\', \'false\'], ', now()),

                ('Require Referral Source?', 'REFERRAL_REQUIRED', 'true', 'Require the Referral Source in account creation', 5, 11, 'zen_cfg_select_option([\'true\', \'false\'], ', now())"
        );

---

to

Code:

---

        $this->executeInstallerSql(
            "INSERT IGNORE INTO " . TABLE_CONFIGURATION . "
                (configuration_title, configuration_key, configuration_value,  configuration_description, configuration_group_id, sort_order,  set_function, date_added)
            VALUES
                ('Display \"Other\" Referral option?', 'DISPLAY_REFERRAL_OTHER', 'true',  'Display \"Other - please specify\" with text box in referral source in  account creation', 5, 10, 'zen_cfg_select_option([\'true\', \'false\'],  ', now()),

                ('Require Referral Source?',  'REFERRAL_REQUIRED', 'true', 'Require the Referral Source in account  creation', 5, 11, 'zen_cfg_select_option([\'true\', \'false\'], ',  now())"
        );

---

Quote:

---

Originally Posted by lat9

Darn it, I know better!

---

Yes, you do :hug: That's why it was weird to me, the error.

Thanks! That made the trick!

v2.0.2 of the encapsulated version of this plugin is now available for download: https://www.zen-cart.com/downloads.php?do=file&id=90

This version corrects issue #3 (installation fails for sites using a non-blank DB_PREFIX).