Code: Selecteer alles
Could not obtain post/user information.
DEBUG MODE
SQL Error : 1054 Unknown column 'u.user_from_provincie_flag' in 'field list'
SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_from_flag, u.user_from_provincie_flag, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, u.user_allow_viewonline, u.user_session_time, u.user_birthday, u.user_next_birthday_greeting, u.user_gender, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM farmer_posts p, farmer_users u, farmer_posts_text pt WHERE p.topic_id = 41 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15
Line : 399
File : viewtopic.php
Code: Selecteer alles
Could not update users table
DEBUG MODE
SQL Error : 1054 Unknown column 'user_from_provincie_flag' in 'field list'
UPDATE farmer_users SET user_email = 'torrentgame.nl@gmail.com', user_icq = '315324956', user_website = 'http://www.torrentgame.nl/forum', user_occ = '', user_from = 'Dalen/Drenthe/Holland', user_from_flag = 'netherlands.gif', user_from_provincie_flag = 'drenthe.png', user_interests = '', user_birthday = '6007', user_next_birthday_greeting = '2006', user_sig = '', user_sig_bbcode_uid = '', user_viewemail = 1, user_aim = 'MicWie', user_yim = 'Diablo_Gamer', user_msnm = 'michaelwiekens{AT}hotmail{DOT}com', user_attachsig = 0, user_allowsmile = 1, user_allowhtml = 0, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_pm = 1, user_popup_pm = 1, user_timezone = 2, user_dateformat = 'd M Y h:i a', user_lang = 'dutch', user_style = 2, user_active = 1, user_actkey = '', user_gender = '1' WHERE user_id = 2
Line : 600
File : usercp_register.php
ik ben bang dat het een SQL error is kan iemand mij daar bij helpen
de SQL regels zijn
Code: Selecteer alles
ALTER TABLE phpbb_users ADD user_from_provincie_flags varchar(25) NULL AFTER user_from_flag;
CREATE TABLE phpbb_provincie_flags (
flag_id int(10) NOT NULL auto_increment,
flag_name varchar(25),
flag_image varchar(25),
PRIMARY KEY (flag_id)
);
INSERT INTO phpbb_provincie_flags (flag_id, flag_name, flag_image) VALUES ('','Drenthe','drenthe.png');
INSERT INTO phpbb_provincie_flags (flag_id, flag_name, flag_image) VALUES ('','Flevoland','flevol.png');
INSERT INTO phpbb_provincie_flags (flag_id, flag_name, flag_image) VALUES ('','Friesland','friesl.png');
INSERT INTO phpbb_provincie_flags (flag_id, flag_name, flag_image) VALUES ('','Gelderland','gelderl.png');
INSERT INTO phpbb_provincie_flags (flag_id, flag_name, flag_image) VALUES ('','Groningen','groning.png');
INSERT INTO phpbb_provincie_flags (flag_id, flag_name, flag_image) VALUES ('','Limburg','limburg.png');
INSERT INTO phpbb_provincie_flags (flag_id, flag_name, flag_image) VALUES ('','Noord-Brabant','nbrab.png');
INSERT INTO phpbb_provincie_flags (flag_id, flag_name, flag_image) VALUES ('','Noord-Holland','nhollan.png');
INSERT INTO phpbb_provincie_flags (flag_id, flag_name, flag_image) VALUES ('','Overijssel','overijs.png');
INSERT INTO phpbb_provincie_flags (flag_id, flag_name, flag_image) VALUES ('','Utrecht','utrecht.png');
INSERT INTO phpbb_provincie_flags (flag_id, flag_name, flag_image) VALUES ('','Zeeland','zeeland.png');
INSERT INTO phpbb_provincie_flags (flag_id, flag_name, flag_image) VALUES ('','Zuid-Holland','zhollan.png');
