What's wrong with this code?

[chronicoles]

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!

[bubblegum.anarchy]

change DEFAULT "3" to DEFAULT '3'

[chronicoles]

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:

[bubblegum.anarchy]

There does not appear to be anything syntatically wrong with the ALTER query provided - what was the error message?

[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

[fenway]

I don't see the comma in that error.