Pagina 1 van 1
Ziet iemand de fout?
Geplaatst: 30 nov 2003, 18:52
door 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')
Geplaatst: 30 nov 2003, 18:54
door DaMnNaTiOn
Dit moet je uitvoeren in je phpMyAdmin!
Geplaatst: 30 nov 2003, 22:25
door Aeolus
welke foutmelding krijg je wanneer je dit invoert?
Geplaatst: 01 dec 2003, 13:25
door 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
Geplaatst: 01 dec 2003, 13:59
door 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
Geplaatst: 01 dec 2003, 14:03
door 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