https://www.icyphoenix.com/viewtopic.php?f=28&t=3889&p=26406#p26406
-----------------------------------
JHOSMAN
Tue 18 Mar, 2008 16:53

Re: PHP121 Instant Messenger Integration
-----------------------------------
New problem  :( 

[spoiler]Error

consulta SQL:

ADD `php121_smilies` TINYINT( 1 ) DEFAULT '1' NOT NULL , ADD `php121_level` TINYINT( 1 ) DEFAULT '1' NOT NULL , ADD `php121_showrequest` TINYINT( 1 ) DEFAULT '1' NOT NULL , ADD `php121_beep_newmsg` TINYINT( 1 ) DEFAULT '1' NOT NULL , ADD `php121_focus_newmsg` TINYINT( 1 ) DEFAULT '1' NOT NULL , ADD `php121_auto_email_transcript` TINYINT( 1 ) DEFAULT '0' NOT NULL , ADD `php121_banned` TINYINT( 1 ) DEFAULT '0' NOT NULL , ADD `php121_timezone` TINYINT( 3 ) DEFAULT '0' NOT NULL , ADD `php121_timestamp` TINYINT( 1 ) DEFAULT '1' NOT NULL , ADD `php121_language` VARCHAR( 30 ) DEFAULT 'English' NOT NULL , ADD `php121_cl_update_key` int( 11 ) NOT NULL default '0', ADD `imbl_appear_offline` int( 1 ) NOT NULL default '0', ADD `imbl_away_message` varchar( 255 ) NOT NULL default '', ADD `imbl_usertheme` varchar( 64 ) NOT NULL default '', ADD `imbl_profileshowsbuddies` int( 1 ) NOT NULL default '1', ADD `imbl_general_info` text NOT NULL , ADD `imbl_profile_timestamp` varchar( 255 ) NOT NULL default '', ADD `imbl_profiletheme` varchar( 64 ) NOT NULL default '', ADD `imbl_profile_gender` varchar( 35 ) NOT NULL default '', ADD `imbl_profile_age` int( 2 ) NOT NULL default '0', ADD `imbl_profile_location` varchar( 35 ) NOT NULL default '', ADD `imbl_profile_status` varchar( 35 ) NOT NULL default '', ADD `imbl_profile_orientation` varchar( 35 ) NOT NULL default '', ADD `imbl_profile_occupation` varchar( 35 ) NOT NULL default '', ADD `imbl_profile_avataruploaded` int( 1 ) NOT NULL default '0', ADD `imbl_profile_avatarhide` int( 1 ) NOT NULL default '0', ADD `php121_tabs_timestamp` int( 11 ) NOT NULL default '0', ADD `php121_tabs_update` int( 1 ) NOT NULL default '0';

MySQL ha dicho: Documentación
#1064 - 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 'ADD `php121_smilies` TINYINT( 1 ) DEFAULT '1' NOT NULL ,
ADD `php121_level` TIN' at line 1 [/spoiler]

Edit: The SQL of [b]Chaotic[/b] if runing  :wink: that a exepcion  :roll: 

[spoiler]Error

consulta SQL:

ALTER TABLE `ip_users` ADD `php121_user_chatting` INT( 11 ) DEFAULT '0' NOT NULL ,
ADD `php121_smilies` TINYINT( 1 ) DEFAULT '1' NOT NULL ,
ADD `php121_level` TINYINT( 1 ) DEFAULT '1' NOT NULL ,
ADD `php121_showrequest` TINYINT( 1 ) DEFAULT '1' NOT NULL ,
ADD `php121_beep_newmsg` TINYINT( 1 ) DEFAULT '1' NOT NULL ,
ADD `php121_focus_newmsg` TINYINT( 1 ) DEFAULT '1' NOT NULL ,
ADD `php121_auto_email_transcript` TINYINT( 1 ) DEFAULT '0' NOT NULL ,
ADD `php121_banned` TINYINT( 1 ) DEFAULT '0' NOT NULL ,
ADD `php121_timezone` TINYINT( 3 ) DEFAULT '0' NOT NULL ,
ADD `php121_timestamp` TINYINT( 1 ) DEFAULT '1' NOT NULL ,
ADD `php121_language` VARCHAR( 30 ) DEFAULT 'English' NOT NULL ,
ADD `php121_cl_update_key` int( 11 ) NOT NULL default '0',
ADD `imbl_appear_offline` int( 1 ) NOT NULL default '0',
ADD `imbl_away_message` varchar( 255 ) NOT NULL default '',
ADD `imbl_usertheme` varchar( 64 ) NOT NULL default '',
ADD `imbl_profileshowsbuddies` int( 1 ) NOT NULL default '1',
ADD `imbl_general_info` text NOT NULL ,
ADD `imbl_profile_timestamp` varchar( 255 ) NOT NULL default '',
ADD `imbl_profiletheme` varchar( 64 ) NOT NULL default '',
ADD `imbl_profile_gender` varchar( 35 ) NOT NULL default '',
ADD `imbl_profile_age` int( 2 ) NOT NULL default '0',
ADD `imbl_profile_location` varchar( 35 ) NOT NULL default '',
ADD `imbl_profile_status` varchar( 35 ) NOT NULL default '',
ADD `imbl_profile_orientation` varchar( 35 ) NOT NULL default '',
ADD `imbl_profile_occupation` varchar( 35 ) NOT NULL default '',
ADD `imbl_profile_avataruploaded` int( 1 ) NOT NULL default '0',
ADD `imbl_profile_avatarhide` int( 1 ) NOT NULL default '0',
ADD `php121_tabs_timestamp` int( 11 ) NOT NULL default '0',
ADD `php121_tabs_update` int( 1 ) NOT NULL default '0';

MySQL ha dicho: Documentación
#1060 - Duplicate column name 'php121_user_chatting' [/spoiler]


