Ограничение скачивания для групп Прохожие и Пользователи

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

Followers

May 8, 201313 yr

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

maxplay.info Driver Error

There appears to be an error with the database.

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

You can try to refresh the page by clicking here

← Return to the index

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

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

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

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

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

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

August 24, 201412 yr

Для вопросов которые не касаются темы создаем отдельные темы. Не будем нарушать правила форума.

5 weeks later...

September 24, 201412 yr

Помогите исправить пожалуйста ошибки:

Последняя SQL ошибка (Сегодня, 02:12)

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Wed, 24 Sep 2014 02:12:44 +0000
Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
IP Address: 178.120.178.139 - /index.php?app=core&module=global&section=lostpass
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT username FROM account WHERE id=
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File                                                                       | Function                                                                      | Line No.          |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
|                                                                            | [syncAppMemberSync].onPassChange                                              |                   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/core.php                                                | [].call_user_func_array                                                       | 2281              |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/core/modules_public/global/lostpass.php                 | [iPSLib].runMemberSync                                                        | 276               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/core/modules_public/global/lostpass.php                 | [public_core_global_lostpass].lostPasswordValidate                            | 58                |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php                                       | [public_core_global_lostpass].doExecute                                       | 306               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

September 24, 201412 yr

Ошибка в синтаксисе sql запроса - WHERE id=

В интеграции, или что там ставили что использует запросы к не стандартным таблицам, в memberSync.php найдите метод onPassChange и исправьте проблемный sql запрос.

2 months later...

December 17, 201411 yr

Помогите решить данную ошибку пожалуйста

Устанавливаю IPB 3.4.6

Вот:

Driver Error
There appears to be an error with the database.
mySQL query error: INSERT INTO _pfields_groups (pf_group_id, pf_group_name, pf_group_key) VALUES
(1, 'Контакты', 'contact'),
(2, 'Информация', 'profile_info')

SQL error: Data too long for column 'pf_group_name' at row 1
SQL error code: 1406
Date: Thursday 18th December 2014 04:02:36 AM


----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Thu, 18 Dec 2014 04:02:36 +0000
Error: 1406 - Data too long for column 'pf_group_name' at row 1
IP Address: 127.0.0.1 - /forum/admin/install/index.php?app=install§ion=install&do=sql
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: INSERT INTO _pfields_groups (pf_group_id, pf_group_name, pf_group_key) VALUES
(1, 'Контакты', 'contact'),
(2, 'Информация', 'profile_info')
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File                                                                       | Function                                                                      | Line No.          |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| C:\AppServ\www\forum\admin\setup\applications\install\sections\install.php | [install_install].install_sql                                                 | 89                |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| C:\AppServ\www\forum\admin\setup\sources\base\ipsController_setup.php      | [install_install].doExecute                                                   | 258               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

December 17, 201411 yr

SQL error: Data too long for column 'pf_group_name' at row 1

Поле 'pf_group_name' имеет размер 255 - varchar(255) NOT NULL. Я не знаю какую кодировку можно было умудрится выбрать чтобы превысить этот размер словами 'Контакты' и 'Информация'. Удалите базу и создайте ее еще раз, внимательно указав кодировку по умолчанию. Предварительно рекомендуется прочесть инструкцию по установке Устанавливаем Invision Power Board 3.

1 month later...

February 7, 201511 yr

Какая? ""Driver Error" There appears to be an error with the database"?
Если "да", то показывайте логи.

Такая ошибка:

SQL error: Access denied for user 'darksoul'@'localhost' (using password: NO)

SQL error code: 1045

Date: Friday 06th February 2015 05:55:33 PM

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Fri, 06 Feb 2015 17:55:33 +0000
Error: 1045 - Access denied for user 'darksoul'@'localhost' (using password: NO)
IP Address: 188.187.60.244 - /forum/index.php?app=core&module=global§ion=login&do=process
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File                                                                       | Function                                                                      | Line No.          |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/sources/handlers/han_login.php                                       | [login_external].authenticate                                                 | 732               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/handlers/han_login.php                                       | [han_login].loginAuthenticate                                                 | 355               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/core/modules_public/global/login.php                    | [han_login].verifyLogin                                                       | 458               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/core/modules_public/global/login.php                    | [public_core_global_login].doLogin                                            | 107               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php                                       | [public_core_global_login].doExecute                                          | 306               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

в АЦ логи пусты, что делать?

February 7, 201511 yr

У вас не правильно указан пароль или логин для подключения к бд. Проверьте методы авторизации которые могут использовать сторонние подключения, в частности - Система > Модули авторизации > Внешняя авторизация.

February 8, 201511 yr

Логин и пароль правильные, проверил, может это из-за того, что у форума и сайта 2 разные базы данных, но при этом 1 пользователь и форум находится в подпапке?

February 8, 201511 yr

Вы не там смотрели. Речь о методах авторизации. В логах это конкретно указано - включен метод внешней авторизации [login_external]. Отключите этот метод.

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

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

February 8, 201511 yr

Отключил метод внешний авторизации. Проблема решилась, спасибо.

1 month later...

April 3, 201511 yr

во ту меня тоже ошибка

Date: Fri, 03 Apr 2015 07:21:57 +0000
Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND image_approved=1' at line 1
IP Address: 93.125.94.42 - /admin/index.php?adsess=31dcfe14fd176aee9ea6313e7a5c0ad8&app=members&&module=members&section=members&do=toggleSpam&member_id=10&secure_key=3635be848005f649369dd2cf651bf89f
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT COUNT(*) as images, SUM(image_comments) as comments, SUM(image_comments_queued) as comments_queued FROM gallery_images WHERE image_album_id= AND image_approved=1
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File | Function | Line No. |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications_addon/ips/gallery/extensions/memberSync.php | [gallery_albums].resync | 163 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/ips/gallery/extensions/memberSync.php | [galleryMemberSync]._recountImages | 55 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| | [galleryMemberSync].onSetAsSpammer | |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/core.php | [].call_user_func_array | 2281 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsMember.php | [iPSLib].runMemberSync | 4392 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/members/modules_admin/members/members.php | [iPSMember].flagMemberAsSpammer | 623 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/members/modules_admin/members/members.php | [admin_members_members_members]._memberToggleSpam | 129 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php | [admin_members_members_members].doExecute | 306 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

April 3, 201511 yr

@hottabychmorsby, версия галереи?

У вас отсутствует альбом галереи который прикреплен к этому пользователю. Для начала попробуйте обновить кеш форума.

1 month later...

May 7, 201511 yr

У меня такая ошибка

Date: Thu, 07 May 2015 22:15:05 +0000
Error: 1054 - Unknown column 'icq' in 'field list'
IP Address: 95.220.137.250 - /forum/index.php?app=core&module=usercp&tab=core&area=profileinfo
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: UPDATE dle_users SET land='',icq='',info='' WHERE name='admin'
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File                                                                       | Function                                                                      | Line No.          |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications/forums/extensions/memberSync.php                        | [db_main_mysql].update                                                        | 296               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
|                                                                            | [forumsMemberSync].onProfileUpdate                                            |                   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/core.php                                                | [].call_user_func_array                                                       | 2281              |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsMember.php                                           | [iPSLib].runMemberSync                                                        | 1013              |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/core/extensions/usercpForms.php                         | [iPSMember].save                                                              | 2704              |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/core/extensions/usercpForms.php                         | [usercpForms_core].saveProfileInfo                                            | 2051              |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/core/modules_public/usercp/manualResolver.php           | [usercpForms_core].saveForm                                                   | 236               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php                                       | [public_core_usercp_manualResolver].doExecute                                 | 306               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

May 8, 201511 yr

еще вот такой лог

Date: Fri, 08 May 2015 03:45:12 +0000
Error: 1054 - Unknown column 'icq' in 'field list'
IP Address: 83.220.237.90 - /forum/index.php?app=core&module=global&section=register
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: INSERT INTO dle_users (`name`,`password`,`email`,`reg_date`,`lastdate`,`user_group`,`logged_ip`,`info`,`signature`,`foto`,`fullname`,`land`,`icq`,`favorites`,`xfields`,`allowed_ip`) VALUES('Jazwa','e8ed503c484a042c5f551a6a0456df5a','jazwalenovo@gmail.com',1431056712,1431056712,4,'83.220.237.90','','','','','','','','','')
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File                                                                       | Function                                                                      | Line No.          |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications/forums/extensions/memberSync.php                        | [db_main_mysql].insert                                                        | 118               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
|                                                                            | [forumsMemberSync].onCreateAccount                                            |                   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/core.php                                                | [].call_user_func_array                                                       | 2281              |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsMember.php                                           | [iPSLib].runMemberSync                                                        | 737               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/core/modules_public/global/register.php                 | [iPSMember].create                                                            | 1942              |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/core/modules_public/global/register.php                 | [public_core_global_register].registerProcessForm                             | 65                |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

May 8, 201511 yr

Error: 1054 - Unknown column 'icq' in 'field list'
mySQL query error: INSERT INTO dle_users

dle_users эта таблица DLE. В таблице отсутствует поле icq. Либо интеграция не соответствует версии dle, или он был обновлен не правильным образом.

Добавить это поле можно следующем запросам:

ALTER TABLE dle_users ADD COLUMN `icq` varchar(20) NOT NULL DEFAULT '';

Create an account or sign in to comment

Followers

Go to topic listing

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

Featured Replies

Create an account or sign in to comment

Important Information

Account

Navigation

Search

Configure browser push notifications

Chrome (Android)

Chrome (Desktop)

Safari (iOS 16.4+)

Safari (macOS)

Edge (Android)

Edge (Desktop)

Firefox (Android)

Firefox (Desktop)