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

Ошибки надо приводить текстом. И желательно перед этим их прочитать, ваша ошибка рассматривалась двумя постами выше.

Понятно изменил в том сообщении. В базе кодировка всех таблиц эта стоит - cp1251_general_ci так установил форум, в таблице core_tags_cache кодировку эту поставил - utf8_general_ci и все равно тоже самое, может что не так понял, обьясните пожалуйста?

Share this post


Link to post
Share on other sites

В базе кодировка всех таблиц эта стоит - cp1251_general_ci

Кодировка должна быть utf8 и сравнение (collation) utf8_general_ci (или unicode).

Перед установкой форума прочитать инструкцию.

 

Прошу помочь с решением Error: 1267

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

Share this post


Link to post
Share on other sites

По какой-то причине перестала работать главная страница, в мобильной версии все нормально, а когда переключаюсь на шаблон выводит "Driver Error"

 

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Tue, 03 Nov 2015 05:02:43 +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 '4,) AND s.login_type NOT IN (1)' at line 2
IP Address: 46.48.167.108 - /forum/
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT s.member_id, s.member_name, s.seo_name, s.member_group,p.pp_thumb_photo,m.title FROM sessions s  LEFT JOIN profile_portal p ON ( p.pp_member_id = s.member_id ) 
LEFT JOIN members m ON ( m.member_id = s.member_id )   WHERE s.running_time > 1446526063 AND s.member_group IN (,4,) AND s.login_type NOT IN (1)
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File                                                                       | Function                                                                      | Line No.          |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/sources/classes/output/publicOutput.php                              | [staffOnlineSidebarBlock].getOutput                                           | 3782              |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/classes/output/publicOutput.php(3846) : eval()'d code        | [output].templateHooks                                                        | 6                 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/classes/output/formats/html/htmlOutput.php                   | [shoutboxGlobalJs].globalTemplate                                             | 312               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/classes/output/publicOutput.php                              | [htmlOutput].fetchOutput                                                      | 2967              |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/forums/modules_public/forums/boards.php                 | [output].sendOutput                                                           | 124               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php                                       | [public_forums_forums_boards].doExecute                                       | 306               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

Share this post


Link to post
Share on other sites

По какой-то причине перестала работать главная страница, в мобильной версии все нормально, а когда переключаюсь на шаблон выводит "Driver Error"

Пересохраните настройки хука "Staff Online"

  • Upvote 2

Share this post


Link to post
Share on other sites

Пересохраните настройки хука "Staff Online"

Спасибо большое!

Share this post


Link to post
Share on other sites
Guest Tony
Date: Tue, 08 Dec 2015 04:17:14 +0000
Error: 144 - Table './forum/cache_store' is marked as crashed and last (automatic?) repair failed
IP Address: 31.135.208.8 - /
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT * FROM cache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navigation_tabs','module_cache','hooks','useragents','useragentgroups','skinsets','outputformats','skin_remap','group_cache','settings','lang_data','banfilters','stats','badwords','bbcode','mediatag','profilefields','rss_output_cache','rss_export','meta_tags','ipseo_acronyms','attachtypes','multimod','moderators','announcements','report_cache','report_plugins','ranks','reputation_levels','chatting','birthdays','calendar_events','calendars','support_staff','support_departments','support_statuses','donation_goals','blog_stats','blogmods','idm_cats','idm_mods','fi_icons' )
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File | Function | Line No. |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| adminkEsuKe1LCjW/sources/base/ipsRegistry.php | [ips_CacheRegistry]._loadCaches | 3035 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| adminkEsuKe1LCjW/sources/base/ipsRegistry.php | [ips_CacheRegistry].init | 2829 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| adminkEsuKe1LCjW/sources/base/ipsRegistry.php | [ips_CacheRegistry].instance | 575 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
[/Code]

Share this post


Link to post
Share on other sites

Выполнить sql запрос

 

REPAIR TABLE cache_store

Share this post


Link to post
Share on other sites

Добрый день.

Главная страница открывается, а если пытаешься куда нибудь зайти то выдает вот такую ошибку

mbvb.ru Driver Error

There appears to be an error with the database.

адрес форума

mbvb.ru/forum

 

что я делаю не так

Заранее спасибо.

Share this post


Link to post
Share on other sites

В случае ошибки базы данных нужно приводить логи sql ошибок из /cache/

Share this post


Link to post
Share on other sites
Date: Tue, 22 Mar 2016 11:58:41 +0000
Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
IP Address: 37.146.226.249 - /forum/index.php?/forum/4-raskodirovanie-magnitol-ford/
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT t.*,xxx.* FROM ffe_topics t  LEFT JOIN ffe_core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) )   WHERE t.forum_id=4 AND t.pinned IN (0,1) AND ( t.approved=1 ) ORDER BY t.pinned DESC,  t.last_post DESC LIMIT 0,30
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File                                                                       | Function                                                                      | Line No.          |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].renderForum                                     | 457               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].showForum                                       | 147               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php                                       | [public_forums_forums_forums].doExecute                                       | 306               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Share this post


Link to post
Share on other sites

Спасибо администратору за помощь.

Надо было в базе данных поменять кодировку на UNF8_general_ci

в core_tags_cache

 

Еще раз большое спасибо админу

Share this post


Link to post
Share on other sites

Добрый день.

 

Перенес форум на поддомен. И теперь по базе выдает ошибку

 

Date: Mon, 04 Apr 2016 11:44:46 +0000
Error: 1146 - Table 'neospidometr_11.ips_sessions' doesn't exist
IP Address: 109.188.126.29 - /
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: DELETE FROM ips_sessions WHERE ip_address='109.188.126.29'
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File                                                                       | Function                                                                      | Line No.          |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/sources/classes/session/publicSessions.php                           | [db_main_mysql].delete                                                        | 1311              |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsRegistry.php                                         | [ips_MemberRegistry].instance                                                 | 616               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

Share this post


Link to post
Share on other sites

Таблица ips_sessions отсутствует или не правильно указан префикс таблиц в /conf_global.php.

Share this post


Link to post
Share on other sites

Всем хорошего вечера.

У меня тоже с не давних пор начались проблемы,то с лс,то ссылки по типу"Самый Популярный Контент"-личка, мои публикации, иновые публикации- выдает

 

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

mySQL query error: SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,s.*,ccb.cache_content FROM 666666members m LEFT JOIN 666666pfields_content p ON ( p.member_id=m.member_id )

LEFT JOIN 666666profile_portal pp ON ( pp.pp_member_id=m.member_id )

LEFT JOIN 666666groups g ON ( g.g_id=m.member_group_id )

LEFT JOIN 666666sessions s ON ( s.member_id=m.member_id )

LEFT JOIN 666666content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=4

 

This is not a problem with the IPS Community Suite but rather with your SQL server. Please contact your host and copy the message shown above.

 

Может кто поможет мой мейл rokutno@ukr.net

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