Jump to content
Дизайн и модификация IPS Community IPBSkinsBETA
Search In
  • More options...
Find results that contain...
Find results in...
Sign in to follow this  
Alphonce

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

Recommended Posts

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

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

 

 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 строчке какая-то лажа, но как и что исправить?

Edited by MyrOsLove

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
Подумал что создавать тему лишнее, покопался в поиске и наткнулся на эту тему.
upd: нашел выход самостоятельно, если кому надо то вот:

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

  • Upvote 1

Share this post


Link to post
Share on other sites

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

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

Share this post


Link to post
Share on other sites

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

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


 

 

Share this post


Link to post
Share on other sites

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

  • Upvote 1

Share this post


Link to post
Share on other sites

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

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

Screenshot_1.png.5c1e4167ba982296a06f54152e6f36e5.png

 

Edited by DELET

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
14 часов назад, newbie сказал:

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

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

Share this post


Link to post
Share on other sites
28.01.2020 в 00:05, DELET сказал:

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

Да.

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

Share this post


Link to post
Share on other sites

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

 

Share this post


Link to post
Share on other sites
54 минуты назад, студент сказал:

Unknown column 'event_title_seo' in 'field list'

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

Share this post


Link to post
Share on other sites
32 минуты назад, Атаман сказал:

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

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

Share this post


Link to post
Share on other sites
11 минут назад, студент сказал:

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

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

event_title_seo' 

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

Share this post


Link to post
Share on other sites
14 минут назад, Атаман сказал:

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


event_title_seo' 

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

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

pref_emoticons

pref_error_logs

еще есть pref_cal_events

Edited by студент

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...