Перейти к публикации
Дизайн и модификация IPS Community IPBSkinsBETA
Поиск в
  • Дополнительно...
Искать результаты, содержащие...
Искать результаты в...
Alphonce

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

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

09/23/19 19:13 (изменено)

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

В общем, у меня такая же проблема. Не пускает в админку, в логе такое:

 

 Date: Mon, 23 Sep 2019 19:13:04 +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 sessions WHERE running_time > 1569265084' at line 1
IP Address: 195.162.83.45 - /forum/admin/index.php?adsess=43da77c909c252f9372387fe4dd4ffd5&old_
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT count(*) as rows FROM sessions WHERE running_time > 1569265084
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File                                                                       | Function                                                                      | Line No.          |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/sources/base/ipsController.php                                       | [admin_core_mycp_dashboard].doExecute                                         | 306               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

 

понимаю что в 306 строчке какая-то лажа, но как и что исправить?

Изменено пользователем MyrOsLove

Поделиться сообщением


Ссылка на сообщение

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"!.

Поделиться сообщением


Ссылка на сообщение
Подумал что создавать тему лишнее, покопался в поиске и наткнулся на эту тему.
upd: нашел выход самостоятельно, если кому надо то вот:

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

  • Upvote 1

Поделиться сообщением


Ссылка на сообщение

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

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

Поделиться сообщением


Ссылка на сообщение

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

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                                                   |                   |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'


 

 

Поделиться сообщением


Ссылка на сообщение

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

  • Upvote 1

Поделиться сообщением


Ссылка на сообщение
01/26/20 18:09 (изменено)

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

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

Screenshot_1.png.5c1e4167ba982296a06f54152e6f36e5.png

 

Изменено пользователем DELET

Поделиться сообщением


Ссылка на сообщение

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

Поделиться сообщением


Ссылка на сообщение
14 часов назад, newbie сказал:

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

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

Поделиться сообщением


Ссылка на сообщение
28.01.2020 в 00:05, DELET сказал:

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

Да.

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

Поделиться сообщением


Ссылка на сообщение

Здравствуйте. 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               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

 

Поделиться сообщением


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

Unknown column 'event_title_seo' in 'field list'

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

Поделиться сообщением


Ссылка на сообщение
32 минуты назад, Атаман сказал:

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

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

Поделиться сообщением


Ссылка на сообщение
11 минут назад, студент сказал:

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

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

event_title_seo' 

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

Поделиться сообщением


Ссылка на сообщение
03/23/20 10:40 (изменено)
14 минут назад, Атаман сказал:

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


event_title_seo' 

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

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

pref_emoticons

pref_error_logs

еще есть pref_cal_events

Изменено пользователем студент

Поделиться сообщением


Ссылка на сообщение

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

Вы должны быть пользователем, чтобы оставить комментарий

Создать аккаунт

Зарегистрируйтесь для получения аккаунта. Это просто!

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

Войти

Уже зарегистрированы? Войдите здесь.

Войти сейчас

  • Сейчас на странице   0 пользователей

    Нет пользователей, просматривающих эту страницу.

×
×
  • Создать...