Error with Notify Me

[AsTecModels]

Hi All,

I have followed the instructions (correctly I hope) and everything works apart from sending the notification out that a product is back in stock. I get and HTTP500 error and here is the error log, hopefully it throws so light on the case.

thrown in /home/aztecmodelsco/public_html/includes/system/versioned/1.0.8.1/database_core.php on line 67
[09-Apr-2026 15:57:32 Europe/London] PHP Fatal error: Uncaught mysqli_sql_exception: Table 'aztecmodelsco_phoen79.newsletters' doesn't exist in /home/aztecmodelsco/public_html/includes/system/versioned/1.0.8.1/database_core.php:67
Stack trace:
#0 /home/aztecmodelsco/public_html/includes/system/versioned/1.0.8.1/database_core.php(67): mysqli->query()
#1 /home/aztecmodelsco/public_html/admin123/includes/classes/query_parser.php(41): database_core->query()
#2 /home/aztecmodelsco/public_html/admin123/includes/classes/paginator.php(28): query_parser->count()
#3 /home/aztecmodelsco/public_html/admin123/includes/actions/newsletters/views/default.php(75): Paginator->__construct()
#4 /home/aztecmodelsco/public_html/admin123/newsletters.php(38): require('/home/aztecmode...')
#5 {main}
thrown in /home/aztecmodelsco/public_html/includes/system/versioned/1.0.8.1/database_core.php on line 67
[09-Apr-2026 16:00:00 Europe/London] PHP Fatal error: Uncaught mysqli_sql_exception: Table 'aztecmodelsco_phoen79.newsletters' doesn't exist in /home/aztecmodelsco/public_html/includes/system/versioned/1.0.8.1/database_core.php:67
Stack trace:
#0 /home/aztecmodelsco/public_html/includes/system/versioned/1.0.8.1/database_core.php(67): mysqli->query()
#1 /home/aztecmodelsco/public_html/includes/system/versioned/1.0.8.1/database_core.php(119): database_core->query()
#2 /home/aztecmodelsco/public_html/admin123/includes/actions/newsletters/insert.php(45): database_core->perform()
#3 /home/aztecmodelsco/public_html/admin123/includes/segments/process_action.php(19): require('/home/aztecmode...')
#4 /home/aztecmodelsco/public_html/admin123/newsletters.php(16): require('/home/aztecmode...')
#5 {main}
thrown in /home/aztecmodelsco/public_html/includes/system/versioned/1.0.8.1/database_core.php on line 67
[09-Apr-2026 16:08:25 Europe/London] PHP Fatal error: Uncaught mysqli_sql_exception: Table 'aztecmodelsco_phoen79.newsletters' doesn't exist in /home/aztecmodelsco/public_html/includes/system/versioned/1.0.8.1/database_core.php:67
Stack trace:
#0 /home/aztecmodelsco/public_html/includes/system/versioned/1.0.8.1/database_core.php(67): mysqli->query()
#1 /home/aztecmodelsco/public_html/includes/system/versioned/1.0.8.1/database_core.php(119): database_core->query()
#2 /home/aztecmodelsco/public_html/admin123/includes/actions/newsletters/insert.php(45): database_core->perform()
#3 /home/aztecmodelsco/public_html/admin123/includes/segments/process_action.php(19): require('/home/aztecmode...')
#4 /home/aztecmodelsco/public_html/admin123/newsletters.php(16): require('/home/aztecmode...')
#5 {main}
thrown in /home/aztecmodelsco/public_html/includes/system/versioned/1.0.8.1/database_core.php on line 67

[AsTecModels]

From what I understand something is missing from the database but not sure how to add the missing bit (assuming I am right).

[burt]

newsletters doesn't exist.

Take from 1106 SQL;

Code: Select all

CREATE TABLE newsletters (
  newsletters_id int NOT NULL auto_increment,
  title varchar(255) NOT NULL,
  content text NOT NULL,
  module varchar(255) NOT NULL,
  date_added datetime NOT NULL,
  date_sent datetime,
  status int(1),
  locked int(1) DEFAULT '0',
  PRIMARY KEY (newsletters_id)
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

Run the above code in PHPMyAdmin or via Hosting Control Panel.

[AsTecModels]

Thank you