-
-
Notifications
You must be signed in to change notification settings - Fork 437
Temporary table names may incorrectly think they have a schema #5843
Copy link
Copy link
Closed
Labels
bugUndesired behaviourUndesired behaviourconfirmedBug is confirm by dev teamBug is confirm by dev teamresolvedA fixed issueA fixed issue
Milestone
Description
Cacti [1.3.0 Dev]
Windows 2019
The following issues have been identified in lib/boost.php (function boost_process_poller_output())
- Line 728 to 730:
$timestamp = db_fetch_cell('SELECT MIN(UNIX_TIMESTAMP(start_time))
FROM poller_time
WHERE end_time="0000-00-00"');
Should be fixed by:
$timestamp = db_fetch_cell('SELECT MIN(UNIX_TIMESTAMP(start_time))
FROM poller_time
WHERE end_time LIKE "0000-00-00%"');
-
Line 742 to 744:
$temp_table = 'poller_output_boost_temp_' . $local_data_id . '' . mt_rand() . '' . microtime(true);db_execute("CREATE TEMPORARY TABLE $temp_table LIKE poller_output_boost");
Should be fixed by:
$temp_table = 'poller_output_boost_temp';
db_execute("CREATE TABLE IF NOT EXISTS $temp_table LIKE poller_output_boost");
- Line 792:
db_execute("DROP TEMPORARY TABLE $temp_table");
Should be fixed by:
db_execute("TRUNCATE TABLE $temp_table");
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
bugUndesired behaviourUndesired behaviourconfirmedBug is confirm by dev teamBug is confirm by dev teamresolvedA fixed issueA fixed issue