pavel01 wrote: It says this:
#
#-----[ SQL ]------------------------------------------
#
ALTER TABLE `phpbb_users` ADD `user_binary` TINYINT( 1 ) DEFAULT '0' NOT NULL ;
#
and I don't know how to do this, i am in mySQL phpmyAdmin and I don't know how to do this line, can someone please lead me through this ???
Code: Select all
ALTER TABLE `phpbb_users` ADD `user_binary` TINYINT( 1 ) DEFAULT '0' NOT NULL ;
SELECT * FROM `phpbb_users` WHERE 1
Database masterforums_com_-_phpbb - Table phpbb_users running on localhost
Error
SQL-query :
ALTER TABLE `phpbb_users` ADD `user_binary` TINYINT( 1 ) DEFAULT '0' NOT NULL
MySQL said:
#1060 - Duplicate column name 'user_binary'
[Documentation] · [Back]
Database masterforums_com_-_phpbb - Table phpbb_users running on localhost
Error
SQL-query :
SELECT *
FROM `phpbb_users`
WHERE 1
ALTER TABLE `phpbb_users` ADD `user_binary` TINYINT( 1 ) DEFAULT '0' NOT NULL LIMIT 0 ,
30
MySQL said:
#1064 - You have an error in your SQL syntax near 'ALTER TABLE `phpbb_users` ADD `user_binary` TINYINT( 1 ) DEFAULT '0' NOT ' at line 4
[Documentation] · [Back]