SQL code check

[Jon Frost]

Can someone check this code is correct please. It doesnt seem to work for me, i think ive missed something out.

UPDATE phpbb_config SET config_name = 'portal_version', config_value = '0.3.B9', is_dynamic = 0 WHERE CONVERT(`phpbb_config`.`config_name` USING utf8) = 'portal_version'; 

DROP TABLE IF EXISTS phpbb_portal; 
CREATE TABLE phpbb_portal ( 
config_name varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL default '', 
config_value text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL default '', 
is_dynamic tinyint(1) unsigned NOT NULL default '0', 
PRIMARY KEY (config_name), 
KEY is_dynamic (is_dynamic) 
) DEFAULT CHARSET=utf8 COLLATE=utf8_bin; 

DELETE FROM `phpbb_config` WHERE CONVERT( `phpbb_config`.`config_name` USING utf8 ) = 'portal_shoutbox_b_fade_color' LIMIT 1 ; 
DELETE FROM `phpbb_config` WHERE CONVERT( `phpbb_config`.`config_name` USING utf8 ) = 'portal_shoutbox_b_table_height' LIMIT 1 ; 
DELETE FROM `phpbb_config` WHERE CONVERT( `phpbb_config`.`config_name` USING utf8 ) = 'portal_shoutbox_fade_color' LIMIT 1 ; 
DELETE FROM `phpbb_config` WHERE CONVERT( `phpbb_config`.`config_name` USING utf8 ) = 'portal_shoutbox_table_height' LIMIT 1 ; 
DELETE FROM `phpbb_config` WHERE CONVERT( `phpbb_config`.`config_name` USING utf8 ) = 'portal_shoutbox_b_height' LIMIT 1 ; 
DELETE FROM `phpbb_config` WHERE CONVERT( `phpbb_config`.`config_name` USING utf8 ) = 'portal_shoutbox_height' LIMIT 1 ; 

UPDATE `plusxl40`.`phpbb_config` SET `config_name` = 'portal_chatbox_number' WHERE CONVERT( `phpbb_config`.`config_name` USING utf8 ) = 'portal_shoutbox_number' LIMIT 1 ; 

INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('portal_chatbox_deafault_delay', '15', 0); 
INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('portal_chatbox_session_time', '300', 0);

A thank you.

Jon

 

[psyr33n]

TIAS - run it through PHPMyAdmin which will spurt errors if there are any.