Critical errors after delete a member group

[KTN]

I created a member group only accept when they requested. But I saw errors and I deleted that group. But now I have too many errors of same thing.

Guest
https://taketakho.oo.gd/cron.php
/home/atwaypi1/public_html/taketakho.oo.gd/Sources/tasks/GroupAct-Notify.php(Line42)

Type of error: Critical
Error message:[Select]
..................................
Database error, given array of integer values is empty. (request_list)
Function: execute

I look up the line 42 ,


41:        array(
==>42:               'request_list' => $this->_details['request_list'],
43:            )
44:         );

[Doug Heffernan]

Can you run this sql query and let us know the results?

Code Select Expand

SELECT * FROM smf_background_tasks WHERE task_class = 'GroupAct_Notify_Background';
If you are using a database prefix other than smf_, you must append that to the table name instead.

[Steve]

Interesting ... my MalwareBytes blocked the link due to phishing ...

[KTN]

Can you run this sql query and let us know the results?

Code Select Expand

SELECT * FROM smf_background_tasks WHERE task_class = 'GroupAct_Notify_Background';
If you are using a database prefix other than smf_, you must append that to the table name instead.

Showing rows 0 - 0 (1 total, Query took 0.0005 seconds.)

I check a row and export it, they are following

Code Select Expand

--
-- Table structure for table `ttk2_background_tasks`
--

CREATE TABLE `ttk2_background_tasks` (
  `id_task` int(10) UNSIGNED NOT NULL,
  `task_file` varchar(255) NOT NULL DEFAULT '',
  `task_class` varchar(255) NOT NULL DEFAULT '',
  `task_data` mediumtext NOT NULL,
  `claimed_time` int(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ttk2_background_tasks`
--

INSERT INTO `ttk2_background_tasks` (`id_task`, `task_file`, `task_class`, `task_data`, `claimed_time`) VALUES
(202276, '$sourcedir/tasks/GroupAct-Notify.php', 'GroupAct_Notify_Background', '{\"member_id\":1,\"member_ip\":\"xxx.xx.xxx.xxx\",\"request_list\":[],\"status\":\"approve\",\"reason\":\"\",\"time\":1671128715}', 1671773293);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `ttk2_background_tasks`
--
ALTER TABLE `ttk2_background_tasks`
  ADD PRIMARY KEY (`id_task`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `ttk2_background_tasks`
--
ALTER TABLE `ttk2_background_tasks`
  MODIFY `id_task` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=204585;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;



[KTN]

 didn't I do it right or how should I do it right? How can I run sql queries?

[Doug Heffernan]

didn't I do it right or how should I do it right? How can I run sql queries?

You can run it in the SQL tab of the database that you have used to install the smf forum.

[KTN]

didn't I do it right or how should I do it right? How can I run sql queries?

You can run it in the SQL tab of the database that you have used to install the smf forum.

Showing rows 0 - 0 (1 total, Query took 0.0006 seconds.)

That is the result I got.

[KTN]

I got over 300 errors (above mentioned) every day. Should I reinstall the SMF and backup/ restore my database file. My concern is, it will go away or do I still need to take care of my database table?