[SYSLOG] latest - php error - Error: Unknown column '' in 'WHERE'

[anarkia1976]

Hi guys,

we have this error:

2026-03-30 14:10:25 - CMDPHP SQL Backtrace: (/plugins/syslog/syslog_process.php[189]:syslog_remove_items(), /plugins/syslog/functions.php[612]:syslog_db_execute_prepared(), /plugins/syslog/database.php[82]:db_execute_prepared())
2026-03-30 14:10:25 - CMDPHP ERROR: A DB Exec Failed!, Error: Unknown column '' in 'WHERE'
2026-03-30 14:10:25 - CMDPHP PHP ERROR WARNING Backtrace: (/plugins/syslog/syslog_process.php[189]:syslog_remove_items(), /plugins/syslog/functions.php[556]:CactiErrorHandler())
2026-03-30 14:10:25 - ERROR PHP WARNING in Plugin 'syslog': Trying to access array offset on value of type null in file: /var/www/html/cacti/plugins/syslog/functions.php on line: 556

thanks a lot
stefano

[TheWitness]

What Cacti version @anarkia1976?

[anarkia1976]

What Cacti version @anarkia1976?

hi @TheWitness,
Latest 1.2.x branch. Thanks a lot.

[anarkia1976]

Hi @TheWitness, do you have check if the problem can be fixed? thanks a lot.

[TheWitness]

Sorry been quite busy. Is it possible to back off to the last tag? I'm assuming you were running with develop.

[TheWitness]

Syslog tag. I think 1.2.x is ready. Just needs testing this week. Very active if you've been tracking.

[arno-st]

it's $syslog_incoming_config that is empty when calling function syslog_remove_items

Still digging to find out where it is define exactly.

[arno-st]

To solve the issue I add $syslog_incoming_config in the list of global value on syslog_connect.
And that solve the error.

I let you validated it
function syslog_connect() { global $syslog_incoming_config, $config, $syslog_cnn, $syslogdb_default, $local_db_cnn_id, $remote_db_cnn_id;

[TheWitness]

I don't see that variable used in syslog_connect @arno-st.

[TheWitness]

Do you have a config.php in the syslog directory? If not, create one from the config.php.dist and make sure the settings are correct before doing so. That's the issue.

[TheWitness]

This was a recent change in behavior.

[arno-st]

@TheWitness I now it's not used in this function, but at least it's the only place where it's Initialized.
And I know I'm not a PHP guru, but if the variable is not define as global, it won't be usable anywhere else, that why I was thinking that define it here will solve the problem. And it does.

And yes my config.php is well defined

[anarkia1976]

Hi @TheWitness @arno-st ,

sorry but the problem is still presente:

2026-04-13 13:51:24 - CMDPHP PHP ERROR Backtrace: (CactiShutdownHandler())
2026-04-13 13:51:24 - ERROR PHP ERROR: Uncaught ArgumentCountError: Too few arguments to function get_username(), 0 passed in /var/www/html/cacti/plugins/syslog/syslog_removal.php on line 286 and exactly 1 expected in /var/www/html/cacti/lib/functions.php:3002 Stack trace: #0 /var/www/html/cacti/plugins/syslog/syslog_removal.php(286): get_username() #1 /var/www/html/cacti/plugins/syslog/syslog_removal.php(102): api_syslog_removal_save() #2 /var/www/html/cacti/plugins/syslog/syslog_removal.php(54): form_save() #3 {main} thrown in file: /var/www/html/cacti/lib/functions.php on line: 3002

thanks
stefano

[TheWitness]

Okay, my bad. I'll be able to get to this like Wednesday night. In the mean time, search for that and change to:

get_username($_SESSION['sess_user_id']);

Yea, the develop branch runs a bit differently.

[arno-st]

@anarkia1976 it's not the same problem
At first it was an undefined column
CMDPHP ERROR: A DB Exec Failed!, Error: Unknown column '' in 'WHERE'

And Now you take about a username error. Did you still have the DB exec failed ?
I didn't see any correction about that in the code

[anarkia1976]

Okay, my bad. I'll be able to get to this like Wednesday night. In the mean time, search for that and change to:

get_username($_SESSION['sess_user_id']);

Yea, the develop branch runs a bit differently.

Hi @TheWitness , any news abot a possibile fix? thanks a lot.