phpBB.de

Code: Alles auswählen

SELECT * FROM phpbb_users WHERE user_id = 1;

Code: Alles auswählen

SELECT * FROM phpbb_users WHERE user_id = 1; LIMIT 0, 30;

Code: Alles auswählen

SELECT * FROM phpbb_users WHERE user_id = 1

Code: Alles auswählen

SELECT * FROM `phpbb_users` WHERE `user_id`="1" AND `user_type`="2" AND `group_id`="1" AND `user_regdate`="1297351774" AND `username`="Anonymous" AND `username_clean`="anonymous" AND `user_last_active`="1755893854" AND `user_last_confirm_key`="H7PAW0X82J" AND `user_last_search`="1755890860" AND `user_posts`="271" AND `user_lang`="en" AND `user_timezone`="Etc/GMT-1" AND `user_dateformat`="D M d, Y g:i a" AND `user_style`="4" AND `user_full_folder`="-3" AND `user_emailtime`="1697457152" AND `user_topic_sortby_type`="t" AND `user_topic_sortby_dir`="d" AND `user_post_sortby_type`="t" AND `user_post_sortby_dir`="a" AND `user_notify_pm`="1" AND `user_allow_pm`="1" AND `user_allow_viewonline`="1" AND `user_allow_viewemail`="1" AND `user_options`="895" AND `user_sig`="" AND `user_actkey_expiration`="1722310223" AND `user_form_salt`="d8ah3awfxi486hft" AND `user_new`="1" AND `user_rt_enable`="1" AND `user_rt_location`="RT_TOP" AND `user_rt_number`="5" AND `user_elonw`="1"

Code: Alles auswählen

MySQL meldet:
Unknown column 'user_rt_enable' in 'where clause'

Fehler bei der Anfrage:
SELECT * FROM `phpbb_users` WHERE `user_id`="1" AND `user_type`="2" AND `group_id`="1" AND `user_regdate`="1297351774" AND `username`="Anonymous" AND `username_clean`="anonymous" AND `user_last_active`="1755893854" AND `user_last_confirm_key`="H7PAW0X82J" AND `user_last_search`="1755890860" AND `user_posts`="271" AND `user_lang`="en" AND `user_timezone`="Etc/GMT-1" AND `user_dateformat`="D M d, Y g:i a" AND `user_style`="4" AND `user_full_folder`="-3" AND `user_emailtime`="1697457152" AND `user_topic_sortby_type`="t" AND `user_topic_sortby_dir`="d" AND `user_post_sortby_type`="t" AND `user_post_sortby_dir`="a" AND `user_notify_pm`="1" AND `user_allow_pm`="1" AND `user_allow_viewonline`="1" AND `user_allow_viewemail`="1" AND `user_options`="895" AND `user_sig`="" AND `user_actkey_expiration`="1722310223" AND `user_form_salt`="d8ah3awfxi486hft" AND `user_new`="1" AND `user_rt_enable`="1" AND `user_rt_location`="RT_TOP" AND `user_rt_number`="5" AND `user_elonw`="1" LIMIT 0, 30;

Code: Alles auswählen

SELECT * FROM phpbb_users WHERE user_id = 1

Code: Alles auswählen

user_rt_enable

Code: Alles auswählen

ALTER TABLE phpbb_users ADD COLUMN user_rt_enable TINYINT(1) DEFAULT 0;