Hello There, Guest! Register

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
There were 14 errors while executing the SQL!
04-04-2015, 01:36 PM,
#1
There were 14 errors while executing the SQL!
Hey guy!

I have a error after install:

[i]SQL Queries (Broke):
--

--



INSERT INTO `tht_acpnav` (`id`, `visual`, `icon`, `link`) VALUES

(1, 'Home', 'house.png', 'home'),

(2, 'General Settings', 'cog.png', 'settings'),

(3, 'Servers', 'server.png', 'servers'),

(4, 'Packages', 'package_green.png', 'packages'),

(5, 'Staff Accounts', 'user_gray.png', 'staff'),

(6, 'Subdomains', 'link.png', 'sub'),

(7, 'Clients', 'group.png', 'users'),

(8, 'Change Password', 'shield.png', 'pass'),

(9, 'Server Status', 'computer.png', 'status'),

(10, 'Mail Center', 'email_open.png', 'email'),

(12, 'Client Importer', 'user_orange.png', 'import'),

(13, 'Tickets', 'page_white_text.png', 'tickets'),

(14, 'Knowledge Base', 'folder.png', 'kb'),

(15, 'Look & Feel', 'rainbow.png', 'lof'),

(19, 'Invoice Management', 'script.png', 'invoices'),

(20, 'Logs', 'report.png', 'logs')

--

--



INSERT INTO `tht_clientnav` (`id`, `visual`, `icon`, `link`) VALUES

(1, 'Home', 'house.png', 'home'),

(3, 'Announcements', 'bell.png', 'notices'),

(4, 'View Package', 'package.png', 'view'),

(5, 'Edit Details', 'user_edit.png', 'details'),

(2, 'Delete Account', 'cross.png', 'delete'),

(7, 'Invoices', 'script.png', 'invoices'),

(8, 'Tickets', 'page_white_text.png', 'tickets')

--

--



INSERT INTO `tht_config` (`name`, `value`) VALUES

('url', 'http://thehostingtool.com/'),

('vname', '1.2.6'),

('vcode', '1010206'),

('whm-ssl', '1'),

('paypalemail', 'your@email.com'),

('default', 'order'),

('theme', 'Reloaded2'),

('name', 'TheHostingTool'),

('tos', '<p><span style="font-weight: bold;"><span style="color: #333333; font-family: Tahoma; font-size: 11px; font-weight: normal;"><span style="color: #ff0000;">The following content is prohibited on our servers:</span><ol><li><strong>Illegal use</strong></li><li><strong>Threatening Material</strong></li><li><strong>Fraudulent Content</strong></li><li><strong>Forgery or Impersonation</strong></li><li><strong>Unsolicited Content</strong></li><li><strong>Copyright Infringements</strong></li><li><strong>Collection of Private Date (Unless DPA Registered)</strong></li><li><strong>Viruses</strong></li><li><strong>IRC Networks (Including all IRC Material)</strong></li><li><strong>Peer to Peer software&nbsp;<br /></strong></li><li><strong>Any Adult Content</strong></li><li><strong>Non-english Content</strong></li></ol></span></span></p>'),

('multiple', '1'),

('general', '1'),

('message', '<p>Signups are currently disabled. Contact your host for more information.</p>'),

('delacc', '1'),

('cenabled', '1'),

('cmessage', '<p>Client area isn''t enabled. Sorry, contact your host for more details.</p>'),

('emailmethod', 'php'),

('emailfrom', 'TheHostingTool <email@thehostingtool.com>'),

('smtp_host', 'localhost'),

('smtp_user', 'user'),

('smtp_password', 'password'),

('show_version_id', '1'),

('show_acp_menu', '0'),

('show_page_gentime', '1'),

('alerts', '<p>&nbsp;</p><p><em></em></p>'),

('p2hcheck', ''),

('show_footer', '0'),

('senabled', '1'),

('smessage', '<p>Support area isn''t enabled. Sorry, contact your host for more details.</p>'),

('terminationdays', '14'),

('suspensiondays', '14'),

('tldonly', '0'),

('currency', 'USD'),

('ui-theme', 'cupertino')

--

--



INSERT INTO `tht_navbar` (`id`, `icon`, `visual`, `link`, `order`) VALUES

(1, 'cart.png', 'Order Form', 'order', 1),

(2, 'user.png', 'Client Area', 'client', 0),

(3, 'key.png', 'Admin Area', 'admin', 2),

(4, 'report_magnify.png', 'Knowledge Base', 'support', 3)

--

--



INSERT INTO `tht_supportnav` (`id`, `visual`, `icon`, `link`) VALUES

(1, 'Home', 'house.png', 'home'),

(2, 'Tickets', 'page_white_text.png', 'tickets'),

(3, 'Knowledgebase', 'folder_explore.png', 'kb')

--

--



INSERT INTO `tht_templates` (`id`, `name`, `acpvisual`, `subject`, `content`, `description`) VALUES

(1, 'reset', 'Client Reset Password', 'New Password', '<p><span style="font-weight: bold;">Your password has been reset!<br /><span style="font-weight: normal;">New Password: %PASS%<br /><br /><span style="font-weight: bold;"><span style="color: #ff0000;">Notice!<br /><span style="color: #000000;"><span style="font-weight: normal;">If you didn''t use the forgot password feature, we suggest you log into client area with your new password and use a different email.</span></span></span></span></span></span></p>', 'This is the email a user recieves when they reset their password.<br /><br />Template Variables:<br />%PASS% = Their new password'),

(3, 'newacc', 'New Hosting Account', 'Your Hosting Account', '<p><span style="font-weight: bold;">Your account has been created!<br /><span style="font-weight: normal;">Your account has been successfully created and you''re now able to log into your client control panel and your web hosting control panel. Your details are as follows:</span></span></p><p><span style="font-weight: bold;">Username: </span>%USER%<br /><span style="font-weight: bold;">Password: </span>%PASS%<br /><span style="font-weight: bold;">Email: </span>%EMAIL%<br /><span style="font-weight: bold;">Domain/Subdomain: </span>%DOMAIN%<br /><span style="font-weight: bold;">Package: </span>%PACKAGE%</p>', 'This is the email a client gets when they first go though the order form and complete it. This email should contain all their details. They will only receive this email if Email Validation is disabled.<br /><br />Template Variables:<br />%USER% - Client Username<br />%PASS% - Client Password<br />%EMAIL% - Client Email<br />%DOMAIN% - The clients package url<br />%PACKAGE% - The package the client signed up for'),

(4, 'termacc', 'Client Terminated', 'Termination', '<p><span style="font-weight: bold;">Your account has been terminated!<br /><span style="font-weight: normal;">This now means that your client username and password no longer exists. This is the same with your web hosting panel. All your files, databases, records have been removed and aren''t retrievable.<br /><br /><span style="font-weight: bold;">Reason for termination: </span>%REASON%</span></span></p>', 'This is the email the client recives when their account has been terminated by admin or when they manually deleted it in the client control panel.<br /><br />Email Variables:<br />%REASON% - The reason why their account has been terminated'),

(5, 'suspendacc', 'Suspended Account', 'Suspended', '<p><span style="font-weight: bold;">Your Account Has Been Suspended!<br /><span style="font-weight: normal;">This means that your site on control panel is no longer accessable. Your website and all its content still remain intact. Contact your host for further details.</span></span></p>', 'This is the email the client recieves when they''re account has been suspended. '),

(6, 'unsusacc', 'Unsuspended Account', 'Unsuspended', '<p><span style="font-family: ''Times New Roman''; font-size: 16px;"><div style="color: #000000; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; background-image: initial; background-repeat: initial; background-attachment: initial; -webkit-background-clip: initial; -webkit-background-origin: initial; background-color: #ffffff; background-position: initial initial; margin: 8px;"><p><span style="font-weight: bold;">Your Account Has Been Unsuspended!<br /><span style="font-weight: normal;">This means that your site on control panel is now accessable. Your website and all its content still remain intact and can be accessed.</span></span></p></div></span></p>', 'This is the email a client recieves when their account has been unsuspended.'),

(7, 'newaccadmin', 'Awaiting Validation', 'Awaiting Admin', '<p><span style="font-weight: bold;">Your account is awaiting admin validation!<br /><span style="font-weight: normal;">Your account has been successfully created but you need to wait for an admin to approve your account! You''re now able to log into your client control panel. Your details are as follows:</span></span></p><p><span style="font-weight: bold;">Username:&nbsp;</span>%USER%<br /><span style="font-weight: bold;">Password:&nbsp;</span>%PASS%<br /><span style="font-weight: bold;">Email:&nbsp;</span>%EMAIL%<br /><span style="font-weight: bold;">Domain/Subdomain:&nbsp;</span>%DOMAIN%<br /><span style="font-weight: bold;">Package:&nbsp;</span>%PACKAGE%</p></div></span></p>', 'This is the email a client gets when they first go though the order form and complete it but are awaiting the admin. This email should contain all their details. This will only be sent if email confirmation is disabled.<br /><br />Template Variables:<br />%USER% - Client Username<br />%PASS% - Client Password<br />%EMAIL% - Client Email<br />%DOMAIN% - The clients package url<br />%PACKAGE% - The package the client signed up for'),

(8, 'adminval', 'Admin - User Needs Validating', 'User Awaiting Validation', '<p><span style="font-weight: bold;">A Client Is Awaiting Admin Validation!<br /><span style="font-weight: normal;">Log into your ACP now to approve or decline that client.</span></span></p>', 'This the email you recieve when a user has signed up to a package requiring admin validation and is awaiting it.'),

(9, 'approvedacc', 'Account Approved', 'Account Approved', '<p><span style="font-weight: bold;">Your account has now been approved!<br /><span style="font-weight: normal;">This means that your account is now active and the details that were sent in your previous email now work. You can proceed to your hosting control panel.</span></span></p>', 'This is the email the client recieves when they''re package has been validated by you.'),

(10, 'declinedacc', 'Declined Account', 'Account Declined', '<p><span style="font-weight: bold;">Your account has been declined!<br /><span style="font-weight: normal;">An admin has declined your account. Your record has been deleted from the database. You may try and signup again.</span></span></p>', 'This is the email recieved when you decline a account that needs admin validation.'),

(11, 'p2hwarning', 'Post 2 Host - Posts Warning', 'Monthly Posts Warning', '<p><strong>You haven''t posted enough!<br /></strong>You have posted a total of %USERPOSTS%. %MONTHLY% is required for your package!</p>', 'This is the email a client recieves on the 20th of the month if they haven''t posted enough posts to keep their account.<br />Template Variables:%USERPOSTS% - The posts the user has done%MONTHLY% - The posts required'),

(12, 'new ticket', 'Admin - New Ticket', 'New Ticket', '<p><strong>A Client has posted a new ticket!<br /></strong>The ticket is awaiting your staff reply, please look at it ASAP. It''s details:<br /><br /><strong>Title:&nbsp;</strong>%TITLE%<br /><strong>Urgency:&nbsp;</strong>%URGENCY%<br /><strong>Content:&nbsp;</strong>%CONTENT%</p>', 'This is the email all staff members recieve when a ticket has been created. This is supposed to alert you to the ticket.<br /><br />Email Variables:<br />%TITLE% - Ticket Title<br />%CONTENT% - Ticket Content<br />%URGENCY% - Ticket Urgency<br />'),

(13, 'new response', 'Admin - New Ticket Response', 'New Ticket Response', '<p><strong>%USER% has replied to the ticket ''%TITLE%'' and now is awaiting your response!<br /></strong>Please look at the ticket ASAP and try to resolve the problem.</p>', 'This email is sent when the CLIENT has replied to a ticket.<br /><br />Ticket Variables:<br />%TITLE% - The response title<br />%CONTENT% - The response<br />%USER% - The user who posted it<br />'),

(14, 'clientresponse', 'New Ticket Response', 'New Ticket Response', '<p><strong>%STAFF% has replied to your ticket!<br /></strong>To view this ticket, please login to your support area and check. The title of his response is: %TITLE%</p>', 'This email is sent to the client when they''re ticket has been replied to by a staff member.<br /><br />Ticket Variables:<br />%TITLE% - Reply Title<br />%CONTENT% - Reply Content<br />%STAFF% - Staff Member'),

(15, 'areset', 'Admin Reset Password', 'New ACP Password!', '<p><span style="font-weight: bold;">Your ACP password has been reset!<br /><span style="font-weight: normal;">New Password: %PASS%<br /><br /><span style="font-weight: bold;"><span style="color: #ff0000;">Notice!<br /><span style="color: #000000;"><span style="font-weight: normal;">If you didn''t use the forgot password feature, we suggest you log into admin CP with your new password and use a different email.</span></span></span></span></span></span></p>', 'This is the email an admin recieves when they reset their password.<br /><br />Template Variables:<br />%PASS% = Their new password'),

(16, 'newinvoice', 'New Invoice', 'New Invoice', '<p><strong>You have a new unpaid invoice on your account!<br /></strong>Make sure you log into your client area (%USER%) and pay the invoice.</p><p><strong>Invoice Due: </strong>%DUE%</p>', 'This is the email a client receives when they''ve got a new unpaid invoice. There are certain variables:<br />%USER% - Username<br />%DUE% - The Invoice Due Date'),

(17, 'cancelacc', 'Account Cancelled', 'Cancelled', '<p><span style="font-weight: bold;">Your account has been cancelled!<br /><span style="font-weight: normal;">This now means that your client username and password no longer work and your web hosting package no longer exists. All your files, databases, records have been removed and aren''t retrievable.<br /><br /><span style="font-weight: bold;">Reason for cancellation: </span>%REASON%</span></span></p>', 'This is the email the client recives when their account has been cancelled by admin or when they manually cancel it in the client control panel.<br /><br />Email Variables:<br />%REASON% - The reason why their account has been cancelled'),

(18, 'newaccval', 'New Hosting Account + Email Confirmation', 'Your Hosting Account', '<p><span style="font-weight: bold;">Your account has been created!<br /><span style="font-weight: normal;">Your account has been successfully created and you''re now able to log into your client control panel and your web hosting control panel. Your details are as follows:</span></span></p><p><span style="font-weight: bold;">Username: </span>%USER%<br /><span style="font-weight: bold;">Password: </span>%PASS%<br /><span style="font-weight: bold;">Email: </span>%EMAIL%<br /><span style="font-weight: bold;">Domain/Subdomain: </span>%DOMAIN%<br /><span style="font-weight: bold;">Package: </span>%PACKAGE%<br /><span style="font-weight: bold;">Confirmation Link: </span><a title="Confirmation Link" href="%CONFIRM%">%CONFIRM%</a></p>', 'This is the email a client gets when they first go though the order form and complete it. This email should contain all they''re details. They will only receive this email if Email Validation is enabled.<br /><br />Template Variables:<br />%USER% - Client Username<br />%PASS% - Client Password<br />%EMAIL% - Client Email<br />%DOMAIN% - The clients package url<br />%PACKAGE% - The package the client signed up for<br />%CONFIRM% - The confirmation link')

--

--



INSERT INTO `tht_types` (`id`, `name`, `visual`) VALUES

(1, 'free', 'Free'),

(2, 'p2h', 'Post2Host'),

(3, 'paid', 'Paid')

INSERT INTO `tht_config` (`name`, `value`) VALUES ('timezone', 'UTC')

INSERT INTO `tht_config` (`name`, `value`) VALUES ('wwwsubdomain', 'both')

INSERT INTO `tht_config` (`name`, `value`) VALUES ('emailval', '1')

INSERT INTO `tht_config` (`name` ,`value`) VALUES ('smtp_port', '25'), ('smtp_secure', '0')

ALTER TABLE `tht_users` ADD `emailval` BOOLEAN NOT NULL DEFAULT '0'

ALTER TABLE `tht_users` ADD `confirmcode` VARCHAR(40) NULL DEFAULT NULL, ADD `newemail` VARCHAR(50) NULL DEFAULT NULL

ALTER TABLE `tht_clientnav` ADD `weight` INT NOT NULL
[/i]

Thank for your help and thank exscuseme for my language, I am french
Reply
04-07-2015, 10:33 PM,
#2
RE: There were 14 errors while executing the SQL!
Wipe the database + files. And reupload making sure all files are intact. Try to not use any special characters on any of the fields in the setup. What version of PHP are you running?
Kevin Mark - TheHostingTool Lead Developer
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)