David Tingen

We have some errors in the System Logs. I send you the screenshot with today's errors.

Sorry it was the wrong image. There is only the Logs error. We already checked and there are no damaged tables in the database. Can you check our forum please?

Hi Marc We already updated the database to version 8, we also already changed the database tables to InnoDB, but the error notifications continue to appear in our administration panel. Can you check what the problem is, please?

This is the error from today in the system logs: System Logs 403 invalid_api_key Array 2 hours ago The URL of page the error occurred on was Not available #0 /home/chapala/public_html/webboard/applications/core/sources/IndexNow/IndexNow.php(117): IPS\_Log::log('403 invalid_api...', 'IndexNow') #1 /home/chapala/public_html/webboard/applications/core/extensions/core/Queue/IndexNow.php(57): IPS\core\_IndexNow->send(Array) #2 /home/chapala/public_html/webboard/system/Task/Task.php(54): IPS\core\extensions\core\Queue\_IndexNow->run(Array, 0) #3 /home/chapala/public_html/webboard/applications/core/tasks/queue.php(43): IPS\_Task::runQueue() #4 /home/chapala/public_html/webboard/system/Task/Task.php(382): IPS\core\tasks\_queue->IPS\core\tasks\{closure}() #5 /home/chapala/public_html/webboard/applications/core/tasks/queue.php(55): IPS\_Task->runUntilTimeout(Object(Closure)) #6 /home/chapala/public_html/webboard/system/Task/Task.php(281): IPS\core\tasks\_queue->execute() #7 /home/chapala/public_html/webboard/system/Task/Task.php(244): IPS\_Task->run() #8 /home/chapala/public_html/webboard/applications/core/interface/task/task.php(72): IPS\_Task->runAndLog() #9 {main}

Hi Stuart Our Hosting service has already repaired the database, but the error notification continues to appear. Can you go to our forum and see what the problem is, please? Attached I send the images of the support section of our panel.

How can I move all the tables from MyISAM to InnoDB?

Hi Jim: This is what our hosting answered: “To avoid this from happening, it would be the best to optimize the database : https://www.hostgator.com/help/article/how-to-optimize-a-mysql-database-using-phpmyadmin And for these tables (if applicable/possible) you might consider creating indexes for because they're over 100,000 rows: 104435 iBBS_core_statistics MyISAM 115772 iBBS_forums_posts MyISAM 127764 iBBS_core_search_index MyISAM 130392 iBBS_core_moderator_logs MyISAM 152086 iBBS_core_members_logins InnoDB 157279 iBBS_core_reputation_index MyISAM 285939 iBBS_core_members_known_ip_addresses MyISAM 296175 iBBS_forums_archive_posts MyISAM Please know that this is not part of our scope of support and you will need an expert to do this on your behalf if not familiar” We have already optimized the database. From the other suggestion, would it help if we deleted the content from past years? And if so, How could we do it? If deleting content doesn't help, Do you have someone you recommend to do this job?

In my panel I get a notification of an error: Repeated log entries. Our hosting service has already repaired the database, but the error continues to appear. Can you help me solve this problem please. This is the error that the notification shows: Reoccurring system log entries may be indicative of a problem that should be addressed. A summary of the top reoccurring recent log entries are shown below. Review the system log for further details. Message Count INSERT INTO `iBBS_core_view_updates` ( `classname`, `id` ) VALUES ( 'IPS\forums\Forum', 1 ) IPS\Db\Exception: Duplicate entry 'IPS\forums\Forum-1' for key 'classname_and_id' (1062) #0 /home/chapala/public_html/webboard/system/Db/Db.php(941): IPS\_Db->preparedQuery('/*chapala_chapa...', Array) #1 /home/chapala/public_html/webboard/system/Content/ViewUpdates.php(50): IPS\_Db->insert('core_view_updat...', Array) #2 /home/chapala/public_html/webboard/applications/forums/modules/front/forums/forums.php(113): IPS\forums\_Forum->updateViews() #3 /home/chapala/public_html/webboard/applications/forums/modules/front/forums/forums.php(38): IPS\forums\modules\front\forums\_forums->_forum(Object(IPS\forums\Forum)) #4 /home/chapala/public_html/webboard/system/Dispatcher/Controller.php(118): IPS\forums\modules\front\forums\_forums->manage() #5 /home/chapala/public_html/webboard/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute() #6 /home/chapala/public_html/webboard/index.php(13): IPS\_Dispatcher->run() #7 {main} 112 SELECT classname, id, count(*) AS count FROM `iBBS_core_view_updates` AS `core_view_updates` GROUP BY `classname`,`id` LIMIT 20 Table './chapala_chapala_com_new/iBBS_core_view_updates' is marked as crashed and should be repaired 62

Thanks everyone for your help!

Hi Marc, I have already updated the access data Thanks for your help!

Hi Jim, Our hosting has already connected the new database, but when I entered the administration panel, a notification appeared that the "Task scan" was not working and it asked me to use the Cron method. Our hosting placed the cron code. But when I select "Use cron (Recommended)" and hit save, it doesn't save and returns to "Run Automatically with Traffic (Default)". Could you help us?

Hi Jim, Our hosting was already able to restore a database from January, but all the topics and information from January to date were lost. We asked them if they could put the new information in the database and they said "no." Could you help us with this problem? This is what they tell us in the email:

Hi Jim, When I change the name of the database, I get a 500 error. Could you help us repair the database, or is there any other way you can make our forum work correctly? And also tell us what the cost would be. Thank you

Our hosting has not been able to repair the database. They created a new database from a backup and tells us: "I recommend updating your configuration file to use the new database name and then see if the database works for your site." Could someone help us with these changes? This is what they tell us in the email:

I can't delete a topic, I have all the permissions to do this. When I try it I get this error: DELETE FROM `iBBS_core_search_index_tags` WHERE index_id IN( SELECT index_id FROM `iBBS_core_search_index` AS `core_search_index` WHERE index_class='IPS\forums\Topic' AND index_item_id=102880 ) IPS\Db\Exception: Table './chapala_chapala_com/iBBS_core_search_index' is marked as crashed and should be repaired (145) #0 /home/chapala/public_html/webboard/system/Db/Db.php(1300): IPS\_Db->preparedQuery('/*chapala_chapa...', Array) #1 /home/chapala/public_html/webboard/system/Content/Search/Mysql/Index.php(363): IPS\_Db->delete('core_search_ind...', Array) #2 /home/chapala/public_html/webboard/system/Content/Search/Mysql/Index.php(247): IPS\Content\Search\Mysql\_Index->_deleteTagsFromIndex('IPS\\forums\\Topi...', 102880) #3 /home/chapala/public_html/webboard/applications/core/sources/DeletionLog/DeletionLog.php(215): IPS\Content\Search\Mysql\_Index->removeFromSearchIndex(Object(IPS\forums\Topic)) #4 /home/chapala/public_html/webboard/system/Content/Content.php(1152): IPS\core\_DeletionLog->save() #5 /home/chapala/public_html/webboard/system/Content/Content.php(1097): IPS\_Content->logDelete(Object(IPS\Member)) #6 /home/chapala/public_html/webboard/applications/forums/sources/Topic/Topic.php(1260): IPS\_Content->modAction('delete', NULL, NULL, false) #7 /home/chapala/public_html/webboard/system/Content/Controller.php(1034): IPS\forums\_Topic->modAction('delete') #8 /home/chapala/public_html/webboard/system/Dispatcher/Controller.php(107): IPS\Content\_Controller->moderate() #9 /home/chapala/public_html/webboard/system/Content/Controller.php(50): IPS\Dispatcher\_Controller->execute() #10 /home/chapala/public_html/webboard/applications/forums/modules/front/forums/topic.php(39): IPS\Content\_Controller->execute() #11 /home/chapala/public_html/webboard/system/Dispatcher/Dispatcher.php(153): IPS\forums\modules\front\forums\_topic->execute() #12 /home/chapala/public_html/webboard/index.php(13): IPS\_Dispatcher->run() #13 {main} I already tried to repair the table but I get this error: Error: Can't create new tempfile: './chapala_chapala_com/iBBS_core_search_index.TMD' Status: Operation failed Can anybody help me please!