chronicoles

This is what I got. ALTER TABLE 'phpbb2_users' ADD 'user_reg_ip' TEXT NULL ADD 'user_reg_host' TEXT NULL +++ Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''phpbb2_users' ADD 'user_reg_ip' TEXT NULL ADD 'user_reg_host' TEXT NULL' at line 1

Thanks! Sorry for the late reply but I tried that and it worked. But I have another problem... ALTER TABLE `phpbb2_users` ADD `user_reg_ip` TEXT NULL, ADD `user_reg_host` TEXT NULL; I tried to run it but it gave me an error message instead. And I even tried to change the ` to '. Help again, please. D:

This is regarding my phpBB forum and the Global Announcement modification... This is what I was given in the instructions I downloaded. ALTER TABLE phpbb_forums ADD auth_globalannounce TINYINT (2) DEFAULT "3" NOT NULL AFTER auth_announce; ALTER TABLE phpbb_auth_access ADD auth_globalannounce TINYINT (1) not null AFTER auth_announce; I made it go through this generator, so I copied and pasted the code into a blank file and saved it as db_update.php but when I entered it into the link, it gave me this: Parse error: parse error, unexpected T_LNUMBER in /home/katya03/public_html/forum/db_update.php on line 57 And this is what it said on line 57... $sql[] = "ALTER TABLE " . $table_prefix . "forums ADD auth_globalannounce TINYINT (2) DEFAULT "3" not null AFTER auth_announce"; Help please!