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

Через PhpMyAdmin, вкладка SQL.

Спасибо! Сделал. Все работает.

И еще один вопросик, не под данной теме:

Когда скидываешь ссылку в сообщение, ссылка получается не полностью, а только на половину:

post-56951-0-39105100-1408895198_thumb.jpg

 

Как такое исправить?

 

 

UPD: Все исправил. Поставил патчик для версии 3.4.5.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

 

Последняя 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               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

Share this post


Link to post
Share on other sites

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

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

Share this post


Link to post
Share on other sites

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

Устанавливаю 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               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

Какая? ""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               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

 

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

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

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

 

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

Share this post


Link to post
Share on other sites

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

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

Share this post


Link to post
Share on other sites

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

 

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

Share this post


Link to post
Share on other sites

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

 

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

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