I am wanting to add 2 lines to an Install table, yet I get a SQL Error,
all help appreciated
The 2 lines are:
ALTER TABLE gen_setts
ADD enable_proxy_deny
TINYINT( 4 ) NOT NULL ,
ADD enable_country_deny
TINYINT( 4 ) NOT NULL ;
β¦
$db_desc = βCreating <b>gen_setts</b> tableβ;
$db_query = βCREATE TABLE " . DB_PREFIX . "gen_setts
(
id
int(11) NOT NULL auto_increment,
sitename
varchar(255) NOT NULL default ββ,
site_path
varchar(255) NOT NULL default ββ,
admin_email
varchar(255) NOT NULL default ββ,
pg_paypal_email
varchar(255) NOT NULL default ββ,
pg_worldpay_id
varchar(50) NOT NULL default ββ,
pg_checkout_id
varchar(50) NOT NULL default ββ,
pg_protx_username
varchar(100) NOT NULL default ββ,
pg_protx_password
varchar(100) NOT NULL default ββ,
pg_authnet_username
varchar(100) NOT NULL default ββ,
pg_authnet_password
varchar(100) NOT NULL default ββ,
language
tinyint(4) NOT NULL default β0β,
currency
varchar(10) NOT NULL default ββ,
amount_format
tinyint(4) NOT NULL default β0β,
amount_digits
tinyint(4) NOT NULL default β0β,
currency_position
tinyint(4) NOT NULL default β0β,
max_images
tinyint(4) NOT NULL default β0β,
images_max_size
int(11) NOT NULL default β0β,
enable_hpfeat
tinyint(4) NOT NULL default β0β,
enable_catfeat
tinyint(4) NOT NULL default β0β,
enable_bold
tinyint(4) NOT NULL default β0β,
enable_hl
tinyint(4) NOT NULL default β0β,
enable_swaps
tinyint(4) NOT NULL default β0β,
cron_job_type
tinyint(4) NOT NULL default β1β,
enable_header_counter
tinyint(4) NOT NULL default β0β,
is_ssl
tinyint(4) NOT NULL default β0β,
site_path_ssl
varchar(255) NOT NULL default ββ,
account_mode
tinyint(4) NOT NULL default β0β,
max_credit
double(16,2) NOT NULL default β0.00β,
init_credit
double(16,2) NOT NULL default β0.00β,
closed_auction_deletion_days
smallint(6) NOT NULL default β0β,
enable_shipping_costs
tinyint(4) NOT NULL default β0β,
default_theme
varchar(30) NOT NULL default ββ,
metatags
text NOT NULL,
site_lang
varchar(30) NOT NULL default ββ,
admin_lang
varchar(30) NOT NULL default ββ,
always_show_buyout
tinyint(4) NOT NULL default β0β,
enable_addl_category
tinyint(4) NOT NULL default β0β,
mailer
varchar(20) NOT NULL default ββ,
sendmail_path
varchar(200) NOT NULL default ββ,
user_lang
tinyint(4) NOT NULL default β0β,
enable_sniping_feature
tinyint(4) NOT NULL default β0β,
sniping_duration
int(11) NOT NULL default β20β,
enable_private_site
tinyint(4) NOT NULL default β0β,
enable_pref_sellers
tinyint(4) NOT NULL default β0β,
pref_sellers_reduction
double(16,2) NOT NULL default β0.00β,
enable_bcc
tinyint(4) NOT NULL default β0β,
enable_asq
tinyint(4) NOT NULL default β0β,
enable_reg_approval
tinyint(4) NOT NULL default β0β,
enable_wanted_ads
tinyint(4) NOT NULL default β0β,
enable_hpfeat_desc
tinyint(4) NOT NULL default β0β,
auto_vat_exempt
tinyint(4) NOT NULL default β0β,
invoice_header
text,
invoice_footer
text,
vat_number
varchar(100) NOT NULL default ββ,
invoice_comments
mediumtext NOT NULL,
enable_bid_retraction
tinyint(4) NOT NULL default β0β,
pg_mb_email
varchar(255) NOT NULL default ββ,
min_reg_age
smallint(6) NOT NULL default β0β,
birthdate_type
tinyint(4) NOT NULL default β0β,
nb_other_items_adp
tinyint(4) NOT NULL default β0β,
maintenance_mode
tinyint(4) NOT NULL default β0β,
enable_stores
tinyint(4) NOT NULL default β0β,
account_mode_personal
tinyint(4) NOT NULL default β0β,
enable_bulk_lister
tinyint(4) NOT NULL default β1β,
suspend_over_bal_users
tinyint(4) NOT NULL default β1β,
activation_key
varchar(255) NOT NULL default ββ,
min_invoice_value
double(16,2) NOT NULL default β0.00β,
init_acc_type
tinyint(4) NOT NULL default β0β,
enable_tax
tinyint(4) default β0β,
enable_cat_counters
tinyint(4) NOT NULL default β0β,
enable_display_phone
tinyint(4) NOT NULL default β0β,
media_max_size
int(11) NOT NULL default β0β,
enable_auctions_approval
tinyint(4) NOT NULL default β0β,
approval_categories
text NOT NULL,
is_mod_rewrite
tinyint(4) NOT NULL default β0β,
buyout_process
tinyint(4) NOT NULL default β0β,
sell_nav_position
tinyint(4) NOT NULL default β1β,
nb_autorelist_max
int(11) NOT NULL default β0β,
site_logo_path
varchar(255) NOT NULL default βimages/probidlogo.gifβ,
time_offset
tinyint(4) NOT NULL default β0β,
max_media
tinyint(4) NOT NULL default β1β,
enable_other_items_adp
tinyint(4) NOT NULL default β0β,
debug_load_time
tinyint(4) NOT NULL default β1β,
debug_load_memory
tinyint(4) NOT NULL default β0β,
pg_nochex_email
varchar(255) NOT NULL default ββ,
signup_settings
tinyint(4) NOT NULL default β0β,
mcrypt_enabled
tinyint(4) NOT NULL default β0β,
mcrypt_key
varchar(255) NOT NULL default ββ,
makeoffer_process
tinyint(4) NOT NULL,
enable_duration_change
tinyint(4) NOT NULL,
duration_change_days
int(11) NOT NULL,
enable_seller_verification
tinyint(4) NOT NULL,
makeoffer_private
TINYINT NOT NULL ,
seller_verification_mandatory
TINYINT NOT NULL ,
enable_proxy_deny
TINYINT( 4 ) NOT NULL ,
enable_country_deny
TINYINT( 4 ) NOT NULL ,
PRIMARY KEY (id
)
) ENGINE=MyISAM COMMENT=βTable with General Settingsβ AUTO_INCREMENT=2 ;β;
β¦
A Mysql error has occurred while running the script:
The query you are trying to run is invalid
Mysql Error Output: 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 '; PRIMARY KEY (`id`) ) ENGINE=MyISAM COMMENT='Table with General Settings' A' at line 98
SQL Query: CREATE TABLE `gen_setts` ( `id` int(11) NOT NULL auto_increment, `sitename` varchar(255) NOT NULL default '', `site_path` varchar(255) NOT NULL default '', `admin_email` varchar(255) NOT NULL default '', `pg_paypal_email` varchar(255) NOT NULL default '', `pg_worldpay_id` varchar(50) NOT NULL default '', `pg_checkout_id` varchar(50) NOT NULL default '', `pg_protx_username` varchar(100) NOT NULL default '', `pg_protx_password` varchar(100) NOT NULL default '', `pg_authnet_username` varchar(100) NOT NULL default '', `pg_authnet_password` varchar(100) NOT NULL default '', `language` tinyint(4) NOT NULL default '0', `currency` varchar(10) NOT NULL default '', `amount_format` tinyint(4) NOT NULL default '0', `amount_digits` tinyint(4) NOT NULL default '0', `currency_position` tinyint(4) NOT NULL default '0', `max_images` tinyint(4) NOT NULL default '0', `images_max_size` int(11) NOT NULL default '0', `enable_hpfeat` tinyint(4) NOT NULL default '0', `enable_catfeat` tinyint(4) NOT NULL default '0', `enable_bold` tinyint(4) NOT NULL default '0', `enable_hl` tinyint(4) NOT NULL default '0', `enable_swaps` tinyint(4) NOT NULL default '0', `cron_job_type` tinyint(4) NOT NULL default '1', `enable_header_counter` tinyint(4) NOT NULL default '0', `is_ssl` tinyint(4) NOT NULL default '0', `site_path_ssl` varchar(255) NOT NULL default '', `account_mode` tinyint(4) NOT NULL default '0', `max_credit` double(16,2) NOT NULL default '0.00', `init_credit` double(16,2) NOT NULL default '0.00', `closed_auction_deletion_days` smallint(6) NOT NULL default '0', `enable_shipping_costs` tinyint(4) NOT NULL default '0', `default_theme` varchar(30) NOT NULL default '', `metatags` text NOT NULL, `site_lang` varchar(30) NOT NULL default '', `admin_lang` varchar(30) NOT NULL default '', `always_show_buyout` tinyint(4) NOT NULL default '0', `enable_addl_category` tinyint(4) NOT NULL default '0', `mailer` varchar(20) NOT NULL default '', `sendmail_path` varchar(200) NOT NULL default '', `user_lang` tinyint(4) NOT NULL default '0', `enable_sniping_feature` tinyint(4) NOT NULL default '0', `sniping_duration` int(11) NOT NULL default '20', `enable_private_site` tinyint(4) NOT NULL default '0', `enable_pref_sellers` tinyint(4) NOT NULL default '0', `pref_sellers_reduction` double(16,2) NOT NULL default '0.00', `enable_bcc` tinyint(4) NOT NULL default '0', `enable_asq` tinyint(4) NOT NULL default '0', `enable_reg_approval` tinyint(4) NOT NULL default '0', `enable_wanted_ads` tinyint(4) NOT NULL default '0', `enable_hpfeat_desc` tinyint(4) NOT NULL default '0', `auto_vat_exempt` tinyint(4) NOT NULL default '0', `invoice_header` text, `invoice_footer` text, `vat_number` varchar(100) NOT NULL default '', `invoice_comments` mediumtext NOT NULL, `enable_bid_retraction` tinyint(4) NOT NULL default '0', `pg_mb_email` varchar(255) NOT NULL default '', `min_reg_age` smallint(6) NOT NULL default '0', `birthdate_type` tinyint(4) NOT NULL default '0', `nb_other_items_adp` tinyint(4) NOT NULL default '0', `maintenance_mode` tinyint(4) NOT NULL default '0', `enable_stores` tinyint(4) NOT NULL default '0', `account_mode_personal` tinyint(4) NOT NULL default '0', `enable_bulk_lister` tinyint(4) NOT NULL default '1', `suspend_over_bal_users` tinyint(4) NOT NULL default '1', `activation_key` varchar(255) NOT NULL default '', `min_invoice_value` double(16,2) NOT NULL default '0.00', `init_acc_type` tinyint(4) NOT NULL default '0', `enable_tax` tinyint(4) default '0', `enable_cat_counters` tinyint(4) NOT NULL default '0', `enable_display_phone` tinyint(4) NOT NULL default '0', `media_max_size` int(11) NOT NULL default '0', `enable_auctions_approval` tinyint(4) NOT NULL default '0', `approval_categories` text NOT NULL, `is_mod_rewrite` tinyint(4) NOT NULL default '0', `buyout_process` tinyint(4) NOT NULL default '0', `sell_nav_position` tinyint(4) NOT NULL default '1', `nb_autorelist_max` int(11) NOT NULL default '0', `site_logo_path` varchar(255) NOT NULL default 'images/probidlogo.gif', `time_offset` tinyint(4) NOT NULL default '0', `max_media` tinyint(4) NOT NULL default '1', `enable_other_items_adp` tinyint(4) NOT NULL default '0', `debug_load_time` tinyint(4) NOT NULL default '1', `debug_load_memory` tinyint(4) NOT NULL default '0', `pg_nochex_email` varchar(255) NOT NULL default '', `signup_settings` tinyint(4) NOT NULL default '0', `mcrypt_enabled` tinyint(4) NOT NULL default '0', `mcrypt_key` varchar(255) NOT NULL default '', `makeoffer_process` tinyint(4) NOT NULL, `enable_duration_change` tinyint(4) NOT NULL, `duration_change_days` int(11) NOT NULL, `enable_seller_verification` tinyint(4) NOT NULL, `makeoffer_private` TINYINT NOT NULL , `seller_verification_mandatory` TINYINT NOT NULL , `enable_proxy_deny` TINYINT( 4 ) NOT NULL , `enable_country_deny` TINYINT( 4 ) NOT NULL ; PRIMARY KEY (`id`) ) ENGINE=MyISAM COMMENT='Table with General Settings' AUTO_INCREMENT=2 ;