Pakt MySQL niet

[Wout -- w00t]

Bij de CarInProfile MOD moet ik een bepaalde SQL code invoeren:

Code: Selecteer alles

ALTER TABLE phpbb_users ADD user_car_mark VARCHAR(255) AFTER user_interests;
ALTER TABLE phpbb_users ADD user_car_model VARCHAR(255) AFTER user_car_mark;
ALTER TABLE phpbb_users ADD user_car_year VARCHAR(255) AFTER user_car_model;
ALTER TABLE phpbb_users ADD user_car_engine VARCHAR(255) AFTER user_car_year;
ALTER TABLE phpbb_users ADD user_car_wheel VARCHAR(255) AFTER user_car_engine;
ALTER TABLE phpbb_users ADD user_car_trans VARCHAR(255) AFTER user_car_wheel;
ALTER TABLE phpbb_users ADD user_car_color VARCHAR(255) AFTER user_car_trans;
ALTER TABLE phpbb_users ADD user_car_foto VARCHAR(255) AFTER user_car_foto;

Het probleem is, dat hij dit in phpMyAdmin zegt:

Fout

SQL-query :

ALTER TABLE phpbb_users ADD user_car_mark VARCHAR( 255 ) AFTER user_interests

MySQL retourneerde:
#1060 - Duplicate column name 'user_car_mark'

Wat is er mis met de MySQL code?

[Paul]

Dan is het al uitgevoerd

[Wout -- w00t]

Als ik wil registeren, krijg ik deze fout:

Could not insert data into users table

DEBUG MODE

SQL Error : 1136 Column count doesn't match value count at row 1

INSERT INTO phpbb_users (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_sig_bbcode_uid, user_avatar, user_avatar_type, user_viewemail, user_aim, user_yim, user_msnm, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, user_level, user_allow_pm, user_active, user_actkey) VALUES (5, 'Wout -- w00t', 1144423726, 'a2e63ee01401aaeca78be023dfbb8c59', 'wout.w00t@gmail.com', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', '', 'severedesign[at]gmail[dot]com', 1, 1, 0, 1, 1, 0, 1, 1, 2, 'D M d, Y g:i a', 'dutch', 1, 0, 1, 1, '')

Line : 638
File : usercp_register.php

[Paul]

usercp_register.php niet goed aangepast