ROZWIĄZANY: Naprawa błędu sql w ipb 3.1.2

[Jaroslaw]

Witam Serdecznie,

Sprawdzałem logi błędów forum, i mam problem.

 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Wed, 01 Sep 2010 14:12:27 +0000
Error: 1146 - Table 'zbyszek2_kasia.ibf_core_sys_lang' doesn't exist
IP Address: 89.72.241.153 - /index.php
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT * FROM ibf_core_sys_lang
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File                                                                       | Function                                                                      | Line No.          |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/sources/classes/class_localization.php                               | [class_localization].rebuildLanguagesCache                                    | 135               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsRegistry.php                                         | [class_localization].__construct                                              | 970               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsRegistry.php                                         | [ips_CacheRegistry].rebuildCache                                              | 1979              |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Wed, 01 Sep 2010 14:12:31 +0000
Error: 1146 - Table 'zbyszek2_kasia.ibf_core_sys_lang' doesn't exist
IP Address: 89.72.241.153 - /index.php
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT * FROM ibf_core_sys_lang
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File                                                                       | Function                                                                      | Line No.          |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/sources/classes/class_localization.php                               | [class_localization].rebuildLanguagesCache                                    | 135               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsRegistry.php                                         | [class_localization].__construct                                              | 970               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsRegistry.php                                         | [ips_CacheRegistry].rebuildCache                                              | 1979              |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Wed, 01 Sep 2010 14:13:01 +0000
Error: 1146 - Table 'zbyszek2_kasia.ibf_core_sys_lang' doesn't exist
IP Address: 89.72.241.153 - /index.php
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT * FROM ibf_core_sys_lang
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File                                                                       | Function                                                                      | Line No.          |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/sources/classes/class_localization.php                               | [class_localization].rebuildLanguagesCache                                    | 135               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsRegistry.php                                         | [class_localization].__construct                                              | 970               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsRegistry.php                                         | [ips_CacheRegistry].rebuildCache                                              | 1979              |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

Proszę o poradę, jak naprawić owe błędy.

Dziękuję i Pozdrawiam

[DawPi]

Jakim cudem skasowałeś tabelę z zapisanymi językami?

Zapytanie:

core_sys_lang (
 lang_id mediumint(4) unsigned NOT NULL auto_increment,
 lang_short varchar(18) NOT NULL default '',
 lang_title varchar(255) NOT NULL default '',
 lang_default tinyint(1) unsigned NOT NULL default 0,
 lang_isrtl tinyint(1) unsigned NOT NULL default 0,
 lang_protected tinyint(1) NOT NULL DEFAULT 0,
 PRIMARY KEY  (lang_id),
 KEY lang_short (lang_short),
 KEY lang_default (lang_default)
);

Oczywiście z innym prefixem, bo widzę, że masz jakiś wymyślny z imieniem kochanki.

No, a potem trzeba dodać pozycję z ID języka z cache/lang_cache/.

[Pavulon]

Oczywiście z innym prefixem, bo widzę, że masz jakiś wymyślny z imieniem kochanki.

Prefix tabeli ma normalny ibf_

A zbyszek2_kasia to przecież nazwa bazy musi być

[DawPi]

A tak.. O 3.15 pisałem 'z automatu'..

[Jaroslaw]

Dodałem zapytanie, lecz wywalił mi error:

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 'ibf_core_sys_lang ( lang_id mediumint(4) unsigned NOT NULL auto_increment, ' at line 1

co robię zle ?

zapytanie jakie dodałem.

ibf_core_sys_lang (
 lang_id mediumint(4) unsigned NOT NULL auto_increment,
 lang_short varchar(18) NOT NULL default '',
 lang_title varchar(255) NOT NULL default '',
 lang_default tinyint(1) unsigned NOT NULL default 0,
 lang_isrtl tinyint(1) unsigned NOT NULL default 0,
 lang_protected tinyint(1) NOT NULL DEFAULT 0,
 PRIMARY KEY  (lang_id),
 KEY lang_short (lang_short),
 KEY lang_default (lang_default)
);

[DawPi]

O matulu.. Nic nie myślisz..

CREATE TABLE ibf_core_sys_lang (
 lang_id mediumint(4) unsigned NOT NULL auto_increment,
 lang_short varchar(18) NOT NULL default '',
 lang_title varchar(255) NOT NULL default '',
 lang_default tinyint(1) unsigned NOT NULL default 0,
 lang_isrtl tinyint(1) unsigned NOT NULL default 0,
 lang_protected tinyint(1) NOT NULL DEFAULT 0,
 PRIMARY KEY  (lang_id),
 KEY lang_short (lang_short),
 KEY lang_default (lang_default)
);

[Jaroslaw]

Table 'ibf_core_sys_lang' already exists

już była dodana ;p

No, a potem trzeba dodać pozycję z ID języka z cache/lang_cache/.

A tu konkretnie co muszę zrobić ?

[DawPi]

W PhpMyAdmin masz taką opcję - bo jak rozumiem teraz w tej tabeli nie masz nic zapisanego?

[Jaroslaw]

[DawPi]

Ee no to wszystko OK! Kiedy Ci ten błąd SQL zatem wyskoczył?

[ + ]

Date: Wed, 01 Sep 2010 14:12:27 +0000

I dopiero Ci podnosisz alarm.

[Jaroslaw]

To jeden problem z głowy

Dzięuję bardzo za fachową pomoc.

close

[DawPi]

No czekaj, to działa Ci forum czy nie? Bo nie chcę tak tego zostawić zawieszone w pół słowa..

[ + ]

A to nie.

[DawPi]

Problem ROZWIĄZANY. Jeśli są jakiekolwiek wątpliwości, pytania proszę o założenie nowego tematu.

Wszelkie uzasadnione reklamacje/pretensje/sugestie/rady przyjmuje ekipa forum.