[Move] Phpbb by Przemo ->PhpBB3
[Move] Phpbb by Przemo ->PhpBB3
Pytanie. Jak przenieść/zmodifikować baze z Przemo tak by normalnie bez przeszkód działała pod phpBB3?
Ostatnio zmieniony 26 maja 2009, 10:45 przez Reon, łącznie zmieniany 1 raz.
Re: [Move] Phpbb by Przemo ->PhpBB3
zapoznaj się z artykułem: http://phpbb.pl/artykuly-k22/64/
Re: [Move] Phpbb by Przemo ->PhpBB3
Błąd nr 1
Kod: Zaznacz cały
SQL ERROR [ mysql4 ]
Nieznana kolumna 'users.user_dateformat' w field list [1054]
SQL
SELECT users.user_id, users.user_id AS poster_id, users.user_active, users.user_level, users.user_regdate, users.username, users.user_password, users.user_posts, users.user_email, users.user_lastvisit, users.user_lang, users.user_timezone, users.user_dateformat, users.user_interests, users.user_occ, users.user_website, users.user_msnm, users.user_yim, users.user_aim, users.user_icq, users.user_from, users.user_rank, users.user_avatar, users.user_avatar_type, users.user_new_privmsg, users.user_last_privmsg, users.user_emailtime, users.user_notify, users.user_notify_pm, users.user_allow_pm, users.user_allow_viewonline, users.user_viewemail, users.user_actkey, users.user_popup_pm AS popuppm, users.user_allowhtml AS html, users.user_allowbbcode AS bbcode, users.user_allowsmile AS smile, users.user_attachsig AS attachsig, users.user_sig, users.user_sig_bbcode_uid AS old_bbcode_uid, users.user_regdate AS post_time FROM phpbb_users users WHERE (users.user_id <> -1) ORDER BY users.user_id LIMIT 2000
BACKTRACE
FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()
FILE: includes/db/mysql.php
LINE: 221
CALL: dbal_mysql->sql_query()
FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mysql->_sql_query_limit()
FILE: install/install_convert.php
LINE: 1233
CALL: dbal->sql_query_limit()
FILE: install/install_convert.php
LINE: 203
CALL: install_convert->convert_data()
FILE: install/index.php
LINE: 405
CALL: install_convert->main()
FILE: install/index.php
LINE: 282
CALL: module->load()
Re: [Move] Phpbb by Przemo ->PhpBB3
dobra. Jak by ktos miał jeszcze pytania to. błąd u góry naprawia się zapytaniem w SQL:
Kod: Zaznacz cały
alter table phpbb_users add user_dateformat varchar(60) default '|j M Y|, \o H:i' not null;