Reply to thread

The fix will be different for different setups. Some people may have one column, but not the other, but here's an SQL that will hopefully work;

[PHP]ALTER TABLE users ADD `youtube_embed` varchar(255) NOT NULL DEFAULT 'fRh_vgS2dFE';

ALTER TABLE users ADD `country` varchar(255) NOT NULL DEFAULT 'Unknown';

ALTER TABLE users ADD `age` varchar(255) NOT NULL;

ALTER TABLE users ADD `email_updates` varchar(255) NOT NULL DEFAULT '0';

ALTER TABLE users ADD `validation_code` varchar(255) NOT NULL;

ALTER TABLE users ADD `role` varchar(255) NOT NULL DEFAULT 'User';

ALTER TABLE users ADD `home_visible` int(1) NOT NULL DEFAULT '1';

ALTER TABLE users ADD `validated` int(1) NOT NULL DEFAULT '0';

ALTER TABLE users ADD `housekeeping_pin` int(4) NOT NULL DEFAULT '0';

ALTER TABLE users ADD `me_radio` varchar(1) NOT NULL DEFAULT '1';

ALTER TABLE users ADD `noob` int(1) NOT NULL DEFAULT '1';

ALTER TABLE users ADD `donated_times` int(3) NOT NULL DEFAULT '0';

ALTER TABLE users ADD `donated_amount` int(6) NOT NULL DEFAULT '0';

ALTER TABLE users ADD `biography` varchar(500) NOT NULL DEFAULT 'I havn\'t typed anything here yet! :)';

ALTER TABLE users ADD `header` varchar(100) NOT NULL DEFAULT 'Change me!';

ALTER TABLE users ADD `selfie` varchar(200) NOT NULL DEFAULT '%cdna%/img/profiles/default.png';

ALTER TABLE users ADD `language` varchar(2) NOT NULL DEFAULT 'EN';

ALTER TABLE users ADD `hidden` varchar(1) NOT NULL DEFAULT '0';[/PHP]

It's just all of the columns I made over time.


Top