IPB 3.4.X "Driver Error" There appears to be an error with the database.

Подписчики

8 мая 201313 г

Здравствуйте!

maxplay.info Driver Error

There appears to be an error with the database.

If you are seeing this page, it means there was a problem communicating with our database. Sometimes this error is temporary and will go away when you refresh the page. Sometimes the error will need to be fixed by an administrator before the site will become accessible again.

You can try to refresh the page by clicking here

← Return to the index

Возникла ошибка при работе с базой данных.

К сожалению, на данный момент из-за технических проблем с базой данных, форум не может обработать ваш запрос. О проблеме уже сообщено администрации форума.

Вот такая ошибка при регистрации.

Кодировка верная.(несколько раз даже менял)

В логах MySQL ошибок нет.

Подскажите пожалуйста:)

23 сентября 20196 г

upd: нашел выход самостоятельно, если кому надо то вот:

Find the following file admin\applications\core\modules_admin\mycp\dashboard.php

Change line 377 to
$online	= $this->DB->buildAndFetch( array( 'select' => 'count(*) as fixme', 'from' => 'sessions', 'where' => "running_time > {$time}" ) );
Change line 379 to
$stats['active_users']	= $online['fixme'];
Of course you don't have to use the word "fixme". You can use any word so long as you don't use "rows"!.

24 сентября 20196 г

Подумал что создавать тему лишнее, покопался в поиске и наткнулся на эту тему.

upd: нашел выход самостоятельно, если кому надо то вот:

http://ipbskins.ru/forum/topic15840.html/

24 сентября 20196 г

Да, интересно, что я в процессе гугления натыкался на совет заменять rows,но поначалу это не избавило от проблемы. Видимо не в том участке, или может банально не сохранил?

Спасибо за ссылку, я наверное взял верхнюю тему в списке после поиска и не дошел до этой

4 месяца спустя...

25 января 20206 г

Здраствуйте в чом возможно быть проблема

Logs

Скрытый текст


 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Sat, 25 Jan 2020 18:43:40 +0000
 Error: 1062 - Duplicate entry '0' for key 'PRIMARY'
 IP Address: 128.124.23.155 - /index.php?app=core&module=task
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: INSERT INTO task_logs (`log_title`,`log_date`,`log_ip`,`log_desc`) VALUES('Архивация',1579977820,'128.124.23.155','0 штук архивировано')
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/classes/class_taskmanager.php                                | [db_main_mysql].insert                                                        | 515               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/core/tasks/archive.php                                  | [class_taskmanager].appendTaskLog                                             | 94                |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/classes/class_taskmanager.php                                | [task_item].runTask                                                           | 208               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 |                                                                            | [class_taskmanager].runTask                                                   |                   |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Sat, 25 Jan 2020 18:44:26 +0000
 Error: 1062 - Duplicate entry '0' for key 'PRIMARY'
 IP Address: 128.124.23.155 - /index.php?app=core&module=task
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: INSERT INTO task_logs (`log_title`,`log_date`,`log_ip`,`log_desc`) VALUES('Тема дня и обзор форума',1579977866,'128.124.23.155','Ежедневный отчет о темах и сообщениях отправлен')
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/classes/class_taskmanager.php                                | [db_main_mysql].insert                                                        | 515               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/forums/tasks/dailydigest.php                            | [class_taskmanager].appendTaskLog                                             | 94                |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/classes/class_taskmanager.php                                | [task_item].runTask                                                           | 208               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 |                                                                            | [class_taskmanager].runTask                                                   |                   |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Sat, 25 Jan 2020 18:48:24 +0000
 Error: 1062 - Duplicate entry '0' for key 'PRIMARY'
 IP Address: 128.124.23.155 - /index.php?app=core&module=task
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: INSERT INTO task_logs (`log_title`,`log_date`,`log_ip`,`log_desc`) VALUES('Очистка MySQL',1579978104,'128.124.23.155','Убиты «заснувшие» mysql процессы')
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/classes/class_taskmanager.php                                | [db_main_mysql].insert                                                        | 515               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/core/tasks/mysqlcleanup.php                             | [class_taskmanager].appendTaskLog                                             | 123               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/classes/class_taskmanager.php                                | [task_item].runTask                                                           | 208               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 |                                                                            | [class_taskmanager].runTask                                                   |                   |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'


 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Fri, 24 Jan 2020 11:59:05 +0000
 Error: 1062 - Duplicate entry '0' for key 'PRIMARY'
 IP Address: 77.111.247.159 - /index.php?app=core&module=task
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: INSERT INTO task_logs (`log_title`,`log_date`,`log_ip`,`log_desc`) VALUES('Обновление данных RSS импорта',1579867145,'77.111.247.159','Импорт RSS завершен (0)')
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/classes/class_taskmanager.php                                | [db_main_mysql].insert                                                        | 515               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/forums/tasks/rssimport.php                              | [class_taskmanager].appendTaskLog                                             | 159               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/classes/class_taskmanager.php                                | [task_item].runTask                                                           | 208               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 |                                                                            | [class_taskmanager].runTask                                                   |                   |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'


 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Thu, 23 Jan 2020 12:00:51 +0000
 Error: 1044 - Access denied for user 'a466756'@'localhost' to database 'hostworldcarding1'
 IP Address: 77.111.247.35 - /
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Thu, 23 Jan 2020 12:01:29 +0000
 Error: 1044 - Access denied for user 'a466756'@'localhost' to database 'hostworldcarding1'
 IP Address: 77.111.247.35 - /
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Thu, 23 Jan 2020 12:01:31 +0000
 Error: 1044 - Access denied for user 'a466756'@'localhost' to database 'hostworldcarding1'
 IP Address: 77.111.247.35 - /
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Thu, 23 Jan 2020 12:01:33 +0000
 Error: 1044 - Access denied for user 'a466756'@'localhost' to database 'hostworldcarding1'
 IP Address: 77.111.247.35 - /
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Thu, 23 Jan 2020 12:01:37 +0000
 Error: 1044 - Access denied for user 'a466756'@'localhost' to database 'hostworldcarding1'
 IP Address: 77.111.247.35 - /
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Thu, 23 Jan 2020 12:47:36 +0000
 Error: 1062 - Duplicate entry '0' for key 'PRIMARY'
 IP Address: 77.111.247.35 - /index.php?app=core&module=task
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: INSERT INTO task_logs (`log_title`,`log_date`,`log_ip`,`log_desc`) VALUES('Архивация',1579783656,'77.111.247.35','0 штук архивировано')
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/classes/class_taskmanager.php                                | [db_main_mysql].insert                                                        | 515               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/core/tasks/archive.php                                  | [class_taskmanager].appendTaskLog                                             | 94                |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/classes/class_taskmanager.php                                | [task_item].runTask                                                           | 208               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 |                                                                            | [class_taskmanager].runTask                                                   |                   |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Thu, 23 Jan 2020 12:52:44 +0000
 Error: 1062 - Duplicate entry '0' for key 'PRIMARY'
 IP Address: 176.114.1.145 - /index.php?app=core&module=task
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: INSERT INTO task_logs (`log_title`,`log_date`,`log_ip`,`log_desc`) VALUES('Очистка MySQL',1579783964,'176.114.1.145','Убиты «заснувшие» mysql процессы')
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/classes/class_taskmanager.php                                | [db_main_mysql].insert                                                        | 515               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/core/tasks/mysqlcleanup.php                             | [class_taskmanager].appendTaskLog                                             | 123               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/classes/class_taskmanager.php                                | [task_item].runTask                                                           | 208               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 |                                                                            | [class_taskmanager].runTask                                                   |                   |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Thu, 23 Jan 2020 12:53:02 +0000
 Error: 1062 - Duplicate entry '0' for key 'PRIMARY'
 IP Address: 176.114.1.145 - /index.php?s=aee7ad88b43a6db805944dd163398d76&app=core&module=task
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: INSERT INTO task_logs (`log_title`,`log_date`,`log_ip`,`log_desc`) VALUES('Тема дня и обзор форума',1579783982,'176.114.1.145','Ежедневный отчет о темах и сообщениях отправлен')
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/classes/class_taskmanager.php                                | [db_main_mysql].insert                                                        | 515               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/forums/tasks/dailydigest.php                            | [class_taskmanager].appendTaskLog                                             | 94                |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/classes/class_taskmanager.php                                | [task_item].runTask                                                           | 208               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 |                                                                            | [class_taskmanager].runTask                                                   |                   |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Thu, 23 Jan 2020 13:15:57 +0000
 Error: 1062 - Duplicate entry '0' for key 'PRIMARY'
 IP Address: 77.111.247.35 - /index.php?app=core&module=task
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: INSERT INTO task_logs (`log_title`,`log_date`,`log_ip`,`log_desc`) VALUES('Ежечасная очистка',1579785357,'77.111.247.35','Старые коды подтверждения, сессии и результаты поиска удалены')
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/classes/class_taskmanager.php                                | [db_main_mysql].insert                                                        | 515               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/core/tasks/cleanout.php                                 | [class_taskmanager].appendTaskLog                                             | 143               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/classes/class_taskmanager.php                                | [task_item].runTask                                                           | 208               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 |                                                                            | [class_taskmanager].runTask                                                   |                   |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Thu, 23 Jan 2020 13:16:55 +0000
 Error: 1062 - Duplicate entry '0' for key 'PRIMARY'
 IP Address: 77.111.247.35 - /index.php?app=core&module=task
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: INSERT INTO task_logs (`log_title`,`log_date`,`log_ip`,`log_desc`) VALUES('Удаление устаревших уведомлений',1579785415,'77.111.247.35','500 уведомлений удалено')
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/classes/class_taskmanager.php                                | [db_main_mysql].insert                                                        | 515               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/members/tasks/prunenotifications.php                    | [class_taskmanager].appendTaskLog                                             | 93                |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/classes/class_taskmanager.php                                | [task_item].runTask                                                           | 208               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 |                                                                            | [class_taskmanager].runTask                                                   |                   |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Thu, 23 Jan 2020 13:17:11 +0000
 Error: 1062 - Duplicate entry '0' for key 'PRIMARY'
 IP Address: 77.111.247.35 - /index.php?app=core&module=task
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: INSERT INTO task_logs (`log_title`,`log_date`,`log_ip`,`log_desc`) VALUES('Очиска отметок о прочтении',1579785431,'77.111.247.35','Удалено 0 маркеров сообщений, удалено 1471 не используемых записей')
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/classes/class_taskmanager.php                                | [db_main_mysql].insert                                                        | 515               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/core/tasks/itemmarkers.php                              | [class_taskmanager].appendTaskLog                                             | 101               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/classes/class_taskmanager.php                                | [task_item].runTask                                                           | 208               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 |                                                                            | [class_taskmanager].runTask                                                   |                   |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Thu, 23 Jan 2020 13:17:35 +0000
 Error: 1062 - Duplicate entry '0' for key 'PRIMARY'
 IP Address: 77.111.247.35 - /index.php?app=core&module=task
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: INSERT INTO task_logs (`log_title`,`log_date`,`log_ip`,`log_desc`) VALUES('Ежедневная перестройка статистики',1579785455,'77.111.247.35','Статистика обновлена')
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/classes/class_taskmanager.php                                | [db_main_mysql].insert                                                        | 515               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/core/tasks/rebuildstats.php                             | [class_taskmanager].appendTaskLog                                             | 97                |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/classes/class_taskmanager.php                                | [task_item].runTask                                                           | 208               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 |                                                                            | [class_taskmanager].runTask                                                   |                   |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Thu, 23 Jan 2020 13:17:47 +0000
 Error: 1062 - Duplicate entry '0' for key 'PRIMARY'
 IP Address: 77.111.247.35 - /index.php?app=core&module=task
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: INSERT INTO task_logs (`log_title`,`log_date`,`log_ip`,`log_desc`) VALUES('Снятие Баллов Предупреждений',1579785467,'77.111.247.35','Задача по снятию предупреждений')
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/classes/class_taskmanager.php                                | [db_main_mysql].insert                                                        | 515               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/members/tasks/warnings.php                              | [class_taskmanager].appendTaskLog                                             | 108               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/classes/class_taskmanager.php                                | [task_item].runTask                                                           | 208               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 |                                                                            | [class_taskmanager].runTask                                                   |                   |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Thu, 23 Jan 2020 13:18:44 +0000
 Error: 1062 - Duplicate entry '0' for key 'PRIMARY'
 IP Address: 77.111.247.35 - /index.php?app=core&module=task
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: INSERT INTO task_logs (`log_title`,`log_date`,`log_ip`,`log_desc`) VALUES('Удаление публикаций.',1579785524,'77.111.247.35','6 сообщений и 2 тем полностью удалены')
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/classes/class_taskmanager.php                                | [db_main_mysql].insert                                                        | 515               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/forums/tasks/permadelete.php                            | [class_taskmanager].appendTaskLog                                             | 187               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/classes/class_taskmanager.php                                | [task_item].runTask                                                           | 208               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 |                                                                            | [class_taskmanager].runTask                                                   |                   |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Thu, 23 Jan 2020 13:19:13 +0000
 Error: 1062 - Duplicate entry '0' for key 'PRIMARY'
 IP Address: 77.111.247.35 - /index.php?app=core&module=task
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: INSERT INTO task_logs (`log_title`,`log_date`,`log_ip`,`log_desc`) VALUES('Обновление Объявлений форума',1579785553,'77.111.247.35','Объявления обновлены')
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/classes/class_taskmanager.php                                | [db_main_mysql].insert                                                        | 515               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/forums/tasks/announcements.php                          | [class_taskmanager].appendTaskLog                                             | 91                |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/classes/class_taskmanager.php                                | [task_item].runTask                                                           | 208               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 |                                                                            | [class_taskmanager].runTask                                                   |                   |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Thu, 23 Jan 2020 13:38:04 +0000
 Error: 1062 - Duplicate entry '0' for key 'PRIMARY'
 IP Address: 77.111.247.35 - /index.php?app=core&module=task
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: INSERT INTO task_logs (`log_title`,`log_date`,`log_ip`,`log_desc`) VALUES('Очистка кеша',1579786684,'77.111.247.35','Очищены кеши контента - удалено 1135 записей ')
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/classes/class_taskmanager.php                                | [db_main_mysql].insert                                                        | 515               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/core/tasks/contentcache.php                             | [class_taskmanager].appendTaskLog                                             | 83                |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/classes/class_taskmanager.php                                | [task_item].runTask                                                           | 208               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 |                                                                            | [class_taskmanager].runTask                                                   |                   |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Thu, 23 Jan 2020 20:36:28 +0000
 Error: 1062 - Duplicate entry '0' for key 'PRIMARY'
 IP Address: 77.111.247.192 - /index.php?app=core&module=task
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: INSERT INTO task_logs (`log_title`,`log_date`,`log_ip`,`log_desc`) VALUES('Очистка Заблокированных Аккаунтов',1579811788,'77.111.247.192','1 старых аккаунтов, ожидающих активации, удалено')
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/classes/class_taskmanager.php                                | [db_main_mysql].insert                                                        | 515               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/members/tasks/removelocked.php                          | [class_taskmanager].appendTaskLog                                             | 160               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/classes/class_taskmanager.php                                | [task_item].runTask                                                           | 208               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 |                                                                            | [class_taskmanager].runTask                                                   |                   |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Thu, 23 Jan 2020 20:37:16 +0000
 Error: 1062 - Duplicate entry '0' for key 'PRIMARY'
 IP Address: 77.111.247.192 - /index.php?app=core&module=task
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: INSERT INTO task_logs (`log_title`,`log_date`,`log_ip`,`log_desc`) VALUES('Ежедневная очистка',1579811835,'77.111.247.192','0 XML-RPC записей журнала удалено, 0 потерянных прикрепленных файлов удалено, 0 подписок очищено')
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/classes/class_taskmanager.php                                | [db_main_mysql].insert                                                        | 515               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/forums/tasks/dailycleanout.php                          | [class_taskmanager].appendTaskLog                                             | 214               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/classes/class_taskmanager.php                                | [task_item].runTask                                                           | 208               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 |                                                                            | [class_taskmanager].runTask                                                   |                   |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Thu, 23 Jan 2020 20:54:26 +0000
 Error: 1062 - Duplicate entry '0' for key 'PRIMARY'
 IP Address: 77.111.245.162 - /index.php?app=core&module=task
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: INSERT INTO task_logs (`log_title`,`log_date`,`log_ip`,`log_desc`) VALUES('Оптимизация таблиц SQL',1579812866,'77.111.245.162',' 5 таблиц оптимизировано')
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/classes/class_taskmanager.php                                | [db_main_mysql].insert                                                        | 515               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/core/tasks/optimize.php                                 | [class_taskmanager].appendTaskLog                                             | 132               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/classes/class_taskmanager.php                                | [task_item].runTask                                                           | 208               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 |                                                                            | [class_taskmanager].runTask                                                   |                   |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Thu, 23 Jan 2020 20:55:04 +0000
 Error: 1062 - Duplicate entry '0' for key 'PRIMARY'
 IP Address: 77.111.245.162 - /index.php?app=core&module=task
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: INSERT INTO task_logs (`log_title`,`log_date`,`log_ip`,`log_desc`) VALUES('Очистка кеша Minify',1579812904,'77.111.245.162','Старые файлы, созданные minify, удалены')
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/classes/class_taskmanager.php                                | [db_main_mysql].insert                                                        | 515               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/core/tasks/minifycleanup.php                            | [class_taskmanager].appendTaskLog                                             | 112               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/classes/class_taskmanager.php                                | [task_item].runTask                                                           | 208               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 |                                                                            | [class_taskmanager].runTask                                                   |                   |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Thu, 23 Jan 2020 20:58:14 +0000
 Error: 1062 - Duplicate entry '0' for key 'PRIMARY'
 IP Address: 77.111.245.18 - /index.php?app=core&module=task
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: INSERT INTO task_logs (`log_title`,`log_date`,`log_ip`,`log_desc`) VALUES('Очистка журналов',1579813094,'77.111.245.18','Журналы очищены')
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/classes/class_taskmanager.php                                | [db_main_mysql].insert                                                        | 515               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/core/tasks/logprune.php                                 | [class_taskmanager].appendTaskLog                                             | 208               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/classes/class_taskmanager.php                                | [task_item].runTask                                                           | 208               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 |                                                                            | [class_taskmanager].runTask                                                   |                   |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

26 января 20206 г

Смотрите таблицу task_logs. Проверяйте, чтобы был включен AUTO_INCREMENT

26 января 20206 г

Я хотел обновить форум с ipb на IPS4 ошибка Table 'crdobnal35.core_themes' doesn't exist

Скрытый текст

Screenshot_1.png.5c1e4167ba982296a06f54152e6f36e5.png

Изменено 26 января 20206 г пользователем DELET

27 января 20206 г

Написано, что таблицы core_themes нет в бд.

27 января 20206 г

14 часов назад, newbie сказал:

Написано, что таблицы core_themes нет в бд.

Надо создавать или как

29 января 20206 г

28.01.2020 в 00:05, DELET сказал:

Надо создавать или как

Да.

А вообще странно, что нет таблицы. Значит, обновление прошло не так, как должно

1 месяц спустя...

23 марта 20206 г

Здравствуйте. IPB 3.4.8 , не могу войти в админку, помогите пожалуйста.


 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Mon, 23 Mar 2020 04:55:51 +0000
 Error: 1054 - Unknown column 'event_title_seo' in 'field list'
 IP Address: 5.44.39.131 - /forum/index.php?s=79d5f71ac1dcb70ed89b8a46670928bb&app=core&module=task
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT event_id, event_title_seo, event_start_date FROM 313frm_cal_events WHERE event_end_date < 1584939351 AND ( ( FIND_IN_SET(1,event_calendar_id) ) ) AND ( ( FIND_IN_SET(2,event_perms) ) OR ( event_perms='*' ) )
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/applications/core/tasks/sitemapgenerator.php                         | [sitemap_core_calendar].generate                                              | 663               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/classes/class_taskmanager.php                                | [task_item].runTask                                                           | 208               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 |                                                                            | [class_taskmanager].runTask                                                   |                   |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Mon, 23 Mar 2020 08:05:41 +0000
 Error: 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 'rows FROM 313frm_sessions WHERE running_time > 1584949841' at line 1
 IP Address: 109.239.25.66 - /forum/admin/index.php?adsess=8a83b9ed63a7ed2d4d9bacad83db7e5a
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT count(*) as rows FROM 313frm_sessions WHERE running_time > 1584949841
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/base/ipsController.php                                       | [admin_core_mycp_dashboard].doExecute                                         | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Mon, 23 Mar 2020 08:11:11 +0000
 Error: 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 'rows FROM 313frm_sessions WHERE running_time > 1584950171' at line 1
 IP Address: 109.239.25.66 - /forum/admin/index.php?adsess=8a83b9ed63a7ed2d4d9bacad83db7e5a
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT count(*) as rows FROM 313frm_sessions WHERE running_time > 1584950171
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/base/ipsController.php                                       | [admin_core_mycp_dashboard].doExecute                                         | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Mon, 23 Mar 2020 08:11:12 +0000
 Error: 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 'rows FROM 313frm_sessions WHERE running_time > 1584950172' at line 1
 IP Address: 109.239.25.66 - /forum/admin/index.php?adsess=8a83b9ed63a7ed2d4d9bacad83db7e5a
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT count(*) as rows FROM 313frm_sessions WHERE running_time > 1584950172
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/base/ipsController.php                                       | [admin_core_mycp_dashboard].doExecute                                         | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Mon, 23 Mar 2020 08:11:14 +0000
 Error: 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 'rows FROM 313frm_sessions WHERE running_time > 1584950174' at line 1
 IP Address: 109.239.25.66 - /forum/admin/index.php?adsess=8a83b9ed63a7ed2d4d9bacad83db7e5a
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT count(*) as rows FROM 313frm_sessions WHERE running_time > 1584950174
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/base/ipsController.php                                       | [admin_core_mycp_dashboard].doExecute                                         | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Mon, 23 Mar 2020 08:34:57 +0000
 Error: 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 'rows FROM 313frm_sessions WHERE running_time > 1584951597' at line 1
 IP Address: 109.239.25.66 - /forum/admin/index.php?adsess=8a83b9ed63a7ed2d4d9bacad83db7e5a
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT count(*) as rows FROM 313frm_sessions WHERE running_time > 1584951597
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/base/ipsController.php                                       | [admin_core_mycp_dashboard].doExecute                                         | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Mon, 23 Mar 2020 08:34:59 +0000
 Error: 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 'rows FROM 313frm_sessions WHERE running_time > 1584951599' at line 1
 IP Address: 109.239.25.66 - /forum/admin/index.php?adsess=8a83b9ed63a7ed2d4d9bacad83db7e5a
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT count(*) as rows FROM 313frm_sessions WHERE running_time > 1584951599
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/base/ipsController.php                                       | [admin_core_mycp_dashboard].doExecute                                         | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Mon, 23 Mar 2020 08:35:00 +0000
 Error: 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 'rows FROM 313frm_sessions WHERE running_time > 1584951600' at line 1
 IP Address: 109.239.25.66 - /forum/admin/index.php?adsess=8a83b9ed63a7ed2d4d9bacad83db7e5a
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT count(*) as rows FROM 313frm_sessions WHERE running_time > 1584951600
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/base/ipsController.php                                       | [admin_core_mycp_dashboard].doExecute                                         | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

23 марта 20206 г

54 минуты назад, студент сказал:

Unknown column 'event_title_seo' in 'field list'

Добрый! Проверку БД сделайте, похоже на битую БД

23 марта 20206 г

32 минуты назад, Атаман сказал:

Добрый! Проверку БД сделайте, похоже на битую БД

как сделать проверку. объясните пожалуйста.
Форум создан очень давно и около 3 лет как закрыта регистрация и на форуме нет никакой активности. В админку тоже давно не входили. Вчера решил зайти кое-что проверить, но не смог, вылезла ошибка.

23 марта 20206 г

11 минут назад, студент сказал:

как сделать проверку. объясните пожалуйста.
Форум создан очень давно и около 3 лет как закрыта регистрация и на форуме нет никакой активности. В админку тоже давно не входили. Вчера решил зайти кое-что проверить, но не смог, вылезла ошибка.

через phpmyadmin найдите таблицу

event_title_seo'

и нажмите восстановить

23 марта 20206 г

14 минут назад, Атаман сказал:
через phpmyadmin найдите таблицу
event_title_seo' 
и нажмите восстановить

у меня нет такой таблицы. На букву е есть только 2 таблицы

pref_emoticons

pref_error_logs

еще есть pref_cal_events

Изменено 23 марта 20206 г пользователем студент

23 марта 20206 г

Доступ в админку выдайте мне в лс

Создайте аккаунт или войдите в него для комментирования

Зарегистрировать аккаунт

Войти сейчас

Подписчики

Перейти к списку тем

IPB 3.4.X "Driver Error" There appears to be an error with the database.

Рекомендованные сообщения

Создайте аккаунт или войдите в него для комментирования

Аккаунт

Навигация

Поиск

Настроить push-уведомления браузера

Chrome (Android)

Chrome (компьютер)

Safari (iOS 16.4+)

Safari (macOS)

Edge (Android)

Edge (компьютер)

Firefox (Android)

Firefox (компьютер)