Mass Mail Database Error

The only error after upgrade is a mass mail error.

Database error in

Query:

SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1

Mysql error: Table '******_site.sys_localization_languages' doesn't exist

Found error in the file '/home/******/public_html/inc/classes/BxDolEmailTemplates.php' at line 35.
Called 'getOne' function with erroneous argument #0.

The BxDolEmailTemplates.php file in 7.0.2 is smaller then in 7.0.3 so I have tried to update the BxDolEmailTemplates.php file with the up to date one in the full dolphin 7.0.3 package due to it not being in the patch package but no luck. So there must be some thing missing from the patch to update the database that is causing the error.

So if any one got any ideas it would be helpful.

Any one had any luck with this error?

It looks like 'sys_localization_languages' table is missing from your database,  try running the following sql that creates the table and hopefully the issue should get resolved

CREATE TABLE IF NOT EXISTS `sys_localization_languages` (
`ID` tinyint(3) unsigned NOT NULL auto_increment,
`Name` varchar(5) NOT NULL default '',
`Flag` varchar(2) NOT NULL default '',
`Title` varchar(255) NOT NULL default '',
PRIMARY KEY  (`ID`),
UNIQUE KEY `Name` (`Name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;



INSERT INTO `sys_localization_languages` (`ID`, `Name`, `Flag`, `Title`) VALUES (1, 'en', 'gb', 'English');

P.S: I have not tested this script, so please run it at your own risk. To be safe, you can have your database backed up before you run the script. But it's a pretty simple script, so it should be okay to run it, i guess...

Nope still getting the error when sending mass mail.

This is the section in BxDolEmailTemplates.php that is causing the truble:

/**
* Class constructor.
*/
function BxDolEmailTemplates() {
$sLang = getParam('lang_default');
if(empty($sLang))
$sLang = 'en';

$this->iDefaultLangId = $GLOBALS['MySQL']->getOne("SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='" . $sLang . "' LIMIT 1");
$this->aDefaultKeys = array(
'Domain' => $GLOBALS['site']['url'],
'SiteName' => $GLOBALS['site']['title'],
);
}

As you can see from screen shout that are there in the database what am i missing?

Mass mail is send from cronjob. Check if you have correct cronjob command. Maybe you moved site from one directory to another and/or switch to another db and forgot to update Dolphin cronjob accordingly.

Nope i did not move, there was no changes to database. All I done was upgrade. I sent message out before upgrade and did not get that error. Then sent a message after upgrade and get that error every time a set of emails are sent out.

Are you receiving this error via mail ? Please can you send more debug info via PM ?