phpBB.de

Code: Alles auswählen

Could not update user rules view

DEBUG MODE

SQL Error : 1054 Unknown column 'user_rules' in 'field list'

UPDATE phpbb_users SET user_rules=1118337621 WHERE user_id=-1

Line : 45
File : rules.php

Code: Alles auswählen

Could not obtain the rules

DEBUG MODE

SQL Error : 1146 Table 'usr_web27_1.phpbb_rules' doesn't exist

SELECT rules, date FROM phpbb_rules

Line : 95
File : admin_forum_rules.php

Code: Alles auswählen

# 
#-----[ SQL ]------------------------------------------
#
#   If you don't know how to execute sql queries, then copy
#   mysql_install.php into your phpbb directory and run it.
#   (assuming you use mysql)
#   After process delete it.
#
#   If you don't use mysql, you'll have to edit these queries accordingly
# 
#   If you have a different table prefix then change this command accordingly. 
#   I have used the default table prefix! 
# 

CREATE TABLE phpbb_rules (
  date int(11) NOT NULL default '0',
  rules text NOT NULL,
  pm_subject varchar(255) NOT NULL default '',
  pm_message text
) ;

# 
#-----[ SQL ]------------------------------------------ 
# 
#   If you have a different table prefix then change this command accordingly. 
#   I have used the default table prefix! 
# 

INSERT INTO phpbb_rules (date,rules,pm_subject,pm_message) VALUES (0,'','Attention the Rules has been adjourned.','The Rules on this Forum has Been adjourned for so much we invite you to read again it.  \r\n  \r\nThe Administrator') ;

# 
#-----[ SQL ]------------------------------------------ 
# 
#   If you have a different table prefix then change this command accordingly. 
#   I have used the default table prefix! 
# 

ALTER TABLE phpbb_users ADD user_rules INT( 11 ) NOT NULL ;

Code: Alles auswählen

CREATE TABLE phpbb_rules ( 
  date int(11) NOT NULL default '0', 
  rules text NOT NULL, 
  pm_subject varchar(255) NOT NULL default '', 
  pm_message text 
) ;

Code: Alles auswählen

INSERT INTO phpbb_rules (date,rules,pm_subject,pm_message) VALUES (0,'','Attention the Rules has been adjourned.','The Rules on this Forum has Been adjourned for so much we invite you to read again it.  \r\n  \r\nThe Administrator') ;

Code: Alles auswählen

ALTER TABLE phpbb_users ADD user_rules INT( 11 ) NOT NULL ;