Ziet iemand de fout?

[rambovan]

Ziet iemand hier de fout hierin?

Code: Selecteer alles

ALTER TABLE users ADD user_birthday INT DEFAULT '999999' not null
ALTER TABLE users ADD user_next_birthday_greeting INT DEFAULT '0' not null
INSERT INTO CONFIG (config_name, config_value) VALUES ("birthday_required", "0")
INSERT INTO config (config_name, config_value) VALUES ('birthday_greeting', '1')
INSERT INTO config (config_name, config_value) VALUES ('max_user_age', '100')
INSERT INTO config (config_name, config_value) VALUES ('min_user_age', '5')
INSERT INTO config (config_name, config_value) VALUES ('birthday_check_day', '7')

[DaMnNaTiOn]

Dit moet je uitvoeren in je phpMyAdmin!

[Aeolus]

welke foutmelding krijg je wanneer je dit invoert?

[michaa113]

moet het niet:

Code: Selecteer alles

ALTER TABLE phpbb_users ADD user_birthday INT DEFAULT '999999' not null 
ALTER TABLE phpbb_users ADD user_next_birthday_greeting INT DEFAULT '0' not null 
INSERT INTO phpbb_CONFIG (config_name, config_value) VALUES ("birthday_required", "0") 
INSERT INTO phpbb_config (config_name, config_value) VALUES ('birthday_greeting', '1') 
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_user_age', '100') 
INSERT INTO phpbb_config (config_name, config_value) VALUES ('min_user_age', '5') 
INSERT INTO phpbb_config (config_name, config_value) VALUES ('birthday_check_day', '7')

zijn

[rambovan]

Code: Selecteer alles

Fout

SQL-query :  

ALTER TABLE users ADD user_birthday INT DEFAULT '999999' not null 

ALTER TABLE users ADD user_next_birthday_greeting INT DEFAULT '0' not null 

INSERT INTO CONFIG (config_name, config_value) VALUES ("birthday_required", "0") 

INSERT INTO config (config_name, config_value) VALUES ('birthday_greeting', '1') 

INSERT INTO config (config_name, config_value) VALUES ('max_user_age', '100') 

INSERT INTO config (config_name, config_value) VALUES ('min_user_age', '5') 

INSERT INTO config (config_name, config_value) VALUES ('birthday_check_day', '7')

MySQL retourneerde: 


You have an error in your SQL syntax near 'ALTER TABLE users ADD user_next_birthday_greeting INT DEFAULT '0' not null 

INS' at line 2

Deze fout

[Carlo Claessen]

Code: Selecteer alles

ALTER TABLE phpbb_users ADD user_birthday INT DEFAULT '999999' not null; 
ALTER TABLE phpbb_users ADD user_next_birthday_greeting INT DEFAULT '0' not null; 
INSERT INTO phpbb_CONFIG (config_name, config_value) VALUES ("birthday_required", "0"); 
INSERT INTO phpbb_config (config_name, config_value) VALUES ('birthday_greeting', '1'); 
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_user_age', '100'); 
INSERT INTO phpbb_config (config_name, config_value) VALUES ('min_user_age', '5'); 
INSERT INTO phpbb_config (config_name, config_value) VALUES ('birthday_check_day', '7');

een ;vergeten zo te zien