I get the following error while installing, please help:
JInstaller::install: SQL Error. DB function failed with error number 1062
Duplicate entry 'Email_Server' for key 1 SQL=INSERT INTO `jos_rstickets_settings` (`setting`, `value`) VALUES ('Email_Server', 'pop.email.com'), ('Email_Server_Port', '995'), ('Email_Address', '
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
'), ('Email_Address_Account', '
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
'), ('Email_Address_Password', 'yourpassword'), ('Email_Cron_Type', 'cron'), ('Email_Cron_Interval', '1'), ('Email_Cron_Lastcheck', '1216322510'), ('Email_Address_Fullname', 'Customer Support'), ('Frontend_TicketTime', '1'), ('Frontend_TicketCode', '1'), ('Frontend_TicketSubject', '1'), ('Frontend_StaffFullname', '1'), ('Frontend_CustomerFullname', '1'), ('Frontend_TicketPriority', '1'), ('Frontend_TicketStatus', '1'), ('Backend_TicketTime', '1'), ('Backend_TicketCode', '1'), ('Backend_TicketSubject', '1'), ('Backend_StaffFullname', '1'), ('Backend_CustomerFullname', '1'), ('Backend_TicketPriority', '1'), ('Backend_TicketStatus', '1'), ('Date_Format', 'd/m/Y'), ('Date_Format_JS', 'dd/mm/yyyy'), ('License_Code', ''), ('Autoclose_Cron_Interval', '120'), ('Autoclose_Cron_Lastcheck', '1216320710'), ('Autoclose_Interval', '1'), ('Autoclose_Email_Interval', '3'), ('Email_Server_Protocol', '/pop3'), ('Email_Server_Security', '/ssl'), ('Email_Accept_New_Tickets', 'no'), ('Email_Reply_Above', '____________________________________________________________'), ('RStickets_Link', '1'), ('RStickets_Show_Menu', '1'), ('Captcha_Enabled','1'), ('Captcha_Characters','5'), ('Captcha_Dots','1'), ('Captcha_Lines','1'), ('Captcha_Case_Sensitive','1'), ('Email_Default_Department','0'), ('Date_Timezone',''), ('RStickets_Add_Tickets','yes'), ('RStickets_MySQL_UTF8','1'), ('RStickets_Custom_User_Link',''), ('Staff_Can_Add_Tickets','all'), ('Captcha_Enabled_For','unregistered,users,staff,');
SQL =
INSERT INTO `jos_rstickets_settings`
(`setting`, `value`)
VALUES
('Email_Server', 'pop.email.com'),
('Email_Server_Port', '995'),
('Email_Address', '
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
'),
('Email_Address_Account', '
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
'),
('Email_Address_Password', 'yourpassword'),
('Email_Cron_Type', 'cron'),
('Email_Cron_Interval', '1'),
('Email_Cron_Lastcheck', '1216322510'),
('Email_Address_Fullname', 'Customer Support'),
('Frontend_TicketTime', '1'),
('Frontend_TicketCode', '1'),
('Frontend_TicketSubject', '1'),
('Frontend_StaffFullname', '1'),
('Frontend_CustomerFullname', '1'),
('Frontend_TicketPriority', '1'),
('Frontend_TicketStatus', '1'),
('Backend_TicketTime', '1'),
('Backend_TicketCode', '1'),
('Backend_TicketSubject', '1'),
('Backend_StaffFullname', '1'),
('Backend_CustomerFullname', '1'),
('Backend_TicketPriority', '1'),
('Backend_TicketStatus', '1'),
('Date_Format', 'd/m/Y'),
('Date_Format_JS', 'dd/mm/yyyy'),
('License_Code', ''),
('Autoclose_Cron_Interval', '120'),
('Autoclose_Cron_Lastcheck', '1216320710'),
('Autoclose_Interval', '1'),
('Autoclose_Email_Interval', '3'),
('Email_Server_Protocol', '/pop3'),
('Email_Server_Security', '/ssl'),
('Email_Accept_New_Tickets', 'no'),
('Email_Reply_Above', '____________________________________________________________'),
('RStickets_Link', '1'),
('RStickets_Show_Menu', '1'),
('Captcha_Enabled','1'),
('Captcha_Characters','5'),
('Captcha_Dots','1'),
('Captcha_Lines','1'),
('Captcha_Case_Sensitive','1'),
('Email_Default_Department','0'),
('Date_Timezone',''),
('RStickets_Add_Tickets','yes'),
('RStickets_MySQL_UTF8','1'),
('RStickets_Custom_User_Link',''),
('Staff_Can_Add_Tickets','all'),
('Captcha_Enabled_For','unregistered,users,staff,');Component Install: SQL error or missing or unreadable SQL file. DB function failed with error number 1062
Duplicate entry 'Email_Server' for key 1 SQL=INSERT INTO `jos_rstickets_settings` (`setting`, `value`) VALUES ('Email_Server', 'pop.email.com'), ('Email_Server_Port', '995'), ('Email_Address', '
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
'), ('Email_Address_Account', '
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
'), ('Email_Address_Password', 'yourpassword'), ('Email_Cron_Type', 'cron'), ('Email_Cron_Interval', '1'), ('Email_Cron_Lastcheck', '1216322510'), ('Email_Address_Fullname', 'Customer Support'), ('Frontend_TicketTime', '1'), ('Frontend_TicketCode', '1'), ('Frontend_TicketSubject', '1'), ('Frontend_StaffFullname', '1'), ('Frontend_CustomerFullname', '1'), ('Frontend_TicketPriority', '1'), ('Frontend_TicketStatus', '1'), ('Backend_TicketTime', '1'), ('Backend_TicketCode', '1'), ('Backend_TicketSubject', '1'), ('Backend_StaffFullname', '1'), ('Backend_CustomerFullname', '1'), ('Backend_TicketPriority', '1'), ('Backend_TicketStatus', '1'), ('Date_Format', 'd/m/Y'), ('Date_Format_JS', 'dd/mm/yyyy'), ('License_Code', ''), ('Autoclose_Cron_Interval', '120'), ('Autoclose_Cron_Lastcheck', '1216320710'), ('Autoclose_Interval', '1'), ('Autoclose_Email_Interval', '3'), ('Email_Server_Protocol', '/pop3'), ('Email_Server_Security', '/ssl'), ('Email_Accept_New_Tickets', 'no'), ('Email_Reply_Above', '____________________________________________________________'), ('RStickets_Link', '1'), ('RStickets_Show_Menu', '1'), ('Captcha_Enabled','1'), ('Captcha_Characters','5'), ('Captcha_Dots','1'), ('Captcha_Lines','1'), ('Captcha_Case_Sensitive','1'), ('Email_Default_Department','0'), ('Date_Timezone',''), ('RStickets_Add_Tickets','yes'), ('RStickets_MySQL_UTF8','1'), ('RStickets_Custom_User_Link',''), ('Staff_Can_Add_Tickets','all'), ('Captcha_Enabled_For','unregistered,users,staff,');
SQL =
INSERT INTO `jos_rstickets_settings`
(`setting`, `value`)
VALUES
('Email_Server', 'pop.email.com'),
('Email_Server_Port', '995'),
('Email_Address', '
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
'),
('Email_Address_Account', '
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
'),
('Email_Address_Password', 'yourpassword'),
('Email_Cron_Type', 'cron'),
('Email_Cron_Interval', '1'),
('Email_Cron_Lastcheck', '1216322510'),
('Email_Address_Fullname', 'Customer Support'),
('Frontend_TicketTime', '1'),
('Frontend_TicketCode', '1'),
('Frontend_TicketSubject', '1'),
('Frontend_StaffFullname', '1'),
('Frontend_CustomerFullname', '1'),
('Frontend_TicketPriority', '1'),
('Frontend_TicketStatus', '1'),
('Backend_TicketTime', '1'),
('Backend_TicketCode', '1'),
('Backend_TicketSubject', '1'),
('Backend_StaffFullname', '1'),
('Backend_CustomerFullname', '1'),
('Backend_TicketPriority', '1'),
('Backend_TicketStatus', '1'),
('Date_Format', 'd/m/Y'),
('Date_Format_JS', 'dd/mm/yyyy'),
('License_Code', ''),
('Autoclose_Cron_Interval', '120'),
('Autoclose_Cron_Lastcheck', '1216320710'),
('Autoclose_Interval', '1'),
('Autoclose_Email_Interval', '3'),
('Email_Server_Protocol', '/pop3'),
('Email_Server_Security', '/ssl'),
('Email_Accept_New_Tickets', 'no'),
('Email_Reply_Above', '____________________________________________________________'),
('RStickets_Link', '1'),
('RStickets_Show_Menu', '1'),
('Captcha_Enabled','1'),
('Captcha_Characters','5'),
('Captcha_Dots','1'),
('Captcha_Lines','1'),
('Captcha_Case_Sensitive','1'),
('Email_Default_Department','0'),
('Date_Timezone',''),
('RStickets_Add_Tickets','yes'),
('RStickets_MySQL_UTF8','1'),
('RStickets_Custom_User_Link',''),
('Staff_Can_Add_Tickets','all'),
('Captcha_Enabled_For','unregistered,users,staff,');It was not possible to delete the selected file.: 'uninstall.rstickets.php'
It was not possible to delete the selected file.: 'install.rstickets.php'
