Cron Jobs

[Mortgage]

Hi,

Trying to fix Crons from my other thread. Running Cron Job command and I get an error in the error_log.

Is this Chevereto side or server?

Cron Job Tried/Tested:

/usr/local/bin/php /public_html/cli.php -C cron

/usr/local/bin/alt-php74 /public_html/cli.php -C cron

[15-Nov-2021 20:45:04 Europe/London]
Aw, snap! Internal Server Error [debug @ print,error_log] - https://chv.to/v3debug

** errorId # **
>> PDOException [42000]: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1
At /public_html/lib/G/classes/class.db.php:155

Stack trace:
#0 /public_html/lib/G/classes/class.db.php(155): PDOStatement->execute()
#1 /public_html/app/lib/classes/class.queue.php(223): G\DB->exec()
#2 /public_html/app/lib/classes/class.queue.php(195): CHV\Queue::logAttempt(Array)
#3 /public_html/app/cron.php(50): CHV\Queue::process(Array)
#4 /public_html/app/cron.php(32): storageDelete()
#5 /public_html/app/loader.php(233): require_once('/public_html/app/cron.php')
#6 /public_html/cli.php(36): include_once('/public_html/app/loader.php')

This only broke after updating (fresh install) to v3.20.14.

Apologies I didn't reply never got a notification of your response until today's email informing ticket closed. I'll be purchasing extra support for the CDN shortly.

 

[Rodolfo]

Hi,

This is Chevereto related, this is the function causing issues:

    public static function logAttempt($ids)
    {
        if (!is_array($ids)) {
            $ids = [$ids];
        }
        $db = DB::getInstance();
        $db->query('UPDATE ' . DB::getTable('queues') . ' SET queue_attempts = queue_attempts + 1, queue_status = IF(queue_attempts > 3, "failed", "pending") WHERE queue_id IN (' . implode(',', $ids) . ')');
        $db->exec();
    }

Chances are that $ids is [] so the WHERE clause ends like WHERE queue_id IN ().

1. Open this file app/lib/classes/class.queue.php

2. Change this:

        if (!is_array($ids)) {
            $ids = [$ids];
        }

To this:

        if (!is_array($ids)) {
            $ids = [$ids];
        }
        if($ids === []) {
            return;
        }

Does it fix the issue?

 

[Mortgage]

To this:

        if (!is_array($ids)) {
            $ids = [$ids];
        }
        if($ids === []) {
            return;
        }

Does it fix the issue?

Hi @Rodolfo,

Yes, I can confirm that fixed the issue. Cron last ran 2021-11-19 16:03:03 UTC.

Although the cron is now running for the first time ever, queues table is still full. Think this is going to require extra support package.

I've some other stuff in error_log, should I share that here or new thread?

 

[Mortgage]

Okay, so emptying the queues table via:

TRUNCATE TABLE queues;

This then allows deleting to work without issues and cron is also removing from BunnyCDN.

Is this okay? As I'm assuming all the other queues are just dead and sitting due to been manually deleted over the yrs so it's getting suck.

This also seems to cause local disk used stats to be negative (-32118297 B) value.

 

[Rodolfo]

Is this okay?

In this context id could be ok.

This also seems to cause local disk used stats to be negative (-32118297 B) value.

👉 https://v3-docs.chevereto.com/settings/tools.html#regenerate-external-storage-stats

 

[Mortgage]

In this context id could be ok.

Thanks!

All my issues are now resolved. Legend!