Database error after Upgraded to 7.0.1

Not sure why I am getting database error notification after upgraded to 7.0.1. Here is the error I am receiving on email

Database error in

Query:

SELECT `id`, `email`, `subject`, `body` FROM `sys_sbs_queue` ORDER BY `id` LIMIT 0, 

Mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Found error in the file '/home/public_html/community/inc/classes/BxDolCronNotifies.php' at line 44.

Called 'getAll' function with erroneous argument #.

Also getting an Cron notification as below each time when a Cron job runs

      <div style="border:2px solid red;padding:4px;width:600px;margin:0px auto;">
<div style="text-align:center;background-color:red;color:white;font-weight:bold;">Error</div>
<div style="text-align:center;">Database query error</div>
</div>

Is there anyone have similar issue.

how to fix this.

Thank

Another Day past.............................
Quote · 28 Apr 2010

After taking close look into the /inc/classes/BxDolCronNotifies.php file I found that $iProcess  field have value as spaces. Not sure why it is.

$iPerStart = getParam('msgs_per_start');

$iFullCount = (int)$GLOBALS['MySQL']->getOne('SELECT COUNT(*) FROM `sys_sbs_queue`');

if($iFullCount) {
$iProcess = $iFullCount < $iPerStart ? $iFullCount : $iPerStart;

$sResult .= "\n- Start email send -\n";
$sResult .= "Total queued emails: " . $iFullCount . "\n";
$sResult .= "Ready for send: " . $iProcess . "\n";

$aMails = $GLOBALS['MySQL']->getAll("SELECT `id`, `email`, `subject`, `body` FROM `sys_sbs_queue` ORDER BY `id` LIMIT 0, " . $iProcess);

This Query fails because $iProcess have the value as spaces. But I am not sure why this spaces.

From where the $iPerStart is getting the value

Any help

Another Day past.............................
Quote · 29 Apr 2010

Ok I have fixed this issue

Actually value for 'msgs_per_start' field  is from `sys_options` table. But somehow this value was spaces hence nothing assigned to the $iPerStart

I have updated the 'msgs_per_start' row value to 50 and issue is fixed.

Another Day past.............................
Quote · 29 Apr 2010

Check if you have 'msgs_per_start' setting option. For some reason it is missing in your installation.

It maybe because you had some RC version, but not 7.0.0 - and update should not be applied in this case !!! you need to apply incremental updates step by step and do not skip any update. If this is a case then you can have a lot of different errors - I recommend to restore site from backup and upgrade to 7.0.0 first and then to 7.0.1.

Rules → http://www.boonex.com/terms
Quote · 29 Apr 2010

Check if you have 'msgs_per_start' setting option. For some reason it is missing in your installation.

It maybe because you had some RC version, but not 7.0.0 - and update should not be applied in this case !!! you need to apply incremental updates step by step and do not skip any update. If this is a case then you can have a lot of different errors - I recommend to restore site from backup and upgrade to 7.0.0 first and then to 7.0.1.

Where is the msgs_per_start' setting option???

I had 7.0.0 version. I upgraded each RC version from 1 to 5 one by one and after that upgraded final 7.0.0 version when it was released.

Now upgraded to 7.0.1.

Am I missing something?

Another Day past.............................
Quote · 29 Apr 2010
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.