При попытке дать администратора
Код: Выделить всё
Couldn't delete auth access info
DEBUG MODE
SQL 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 auth_mod = 0' at line 3
DELETE FROM hall_auth_access WHERE group_id = AND auth_mod = 0
Line : 187
File : admin_ug_auth.php
При попытке обратно снять права вылезает это:
Код: Выделить всё
Could not obtain moderator status
DEBUG MODE
SQL 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 aa.group_id = ug.group_id AND aa.auth_mod = 1 GROUP BY ug.use' at line 3
SELECT ug.user_id, COUNT(auth_mod) AS is_auth_mod FROM phpbb_auth_access aa, phpbb_user_group ug WHERE ug.user_id IN () AND aa.group_id = ug.group_id AND aa.auth_mod = 1 GROUP BY ug.user_id
Line : 575
File : admin_ug_auth.php
Комманда инсерта:
Код: Выделить всё
INSERT INTO `newhog_forums`.`phpbb_users` (`user_id`, `user_active`, `username`, `user_password`, `user_session_time`, `user_session_page`, `user_lastvisit`, `user_regdate`, `user_level`, `user_posts`, `user_timezone`, `user_style`, `user_lang`, `user_dateformat`, `user_new_privmsg`, `user_unread_privmsg`, `user_last_privmsg`, `user_login_tries`, `user_last_login_try`, `user_emailtime`, `user_viewemail`, `user_attachsig`, `user_allowhtml`, `user_allowbbcode`, `user_allowsmile`, `user_allowavatar`, `user_allow_pm`, `user_allow_viewonline`, `user_notify`, `user_notify_pm`, `user_popup_pm`, `user_rank`, `user_avatar`, `user_avatar_type`, `user_email`, `user_icq`, `user_website`, `user_from`, `user_sig`, `user_sig_bbcode_uid`, `user_aim`, `user_yim`, `user_msnm`, `user_occ`, `user_interests`, `user_actkey`, `user_newpasswd`, `user_warnings`) VALUES ('". $user_id ."', '1', '". $username ."', MD5('Pa1ssw3d'), '0', '0', '0', UNIX_TIMESTAMP( ), '0', '0', '4.00', '1', 'russian', 'd M Y H:i', '0', '0', '0', '0', '0', NULL, NULL, '1', '0', '1', '1', '1', '1', '1', '1', '0', '0', '0', NULL, '0', '" .$email. "', '" .$icq. "', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0');"
Версия phpBB 2.0.23
Модов всяких много, но при тестовой установке все работало.
Версия PHP: 4.x
Используемая СУБД и её версия: MySQL 4.x