Installation problems

[rentaserv]

When im running the installation i get a whole load of errors about the script inserting the tables to the db what can couse this thanks

 

all users and pass's have been checked and double checked

[joe123]

what is the exact error you receive? , this way someone could help you better

[rentaserv]

ERROR: CREATE TABLE `tblaccounts` ( `id` int(1) unsigned zerofill NOT NULL auto_increment, `userid` int(10) unsigned zerofill NOT NULL default \'0000000000\', `gateway` text NOT NULL, `date` datetime default NULL, `description` text NOT NULL, `amountin` decimal(10,2) NOT NULL default \'0.00\', `fees` decimal(10,2) NOT NULL default \'0.00\', `amountout` decimal(10,2) NOT NULL default \'0.00\', `transid` text NOT NULL, `invoiceid` int(1) NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM Failed - Please contact WHMCS Support with this error message

ERROR: CREATE TABLE `tblactivitylog` ( `id` int(1) unsigned zerofill NOT NULL auto_increment, `date` datetime NOT NULL default \'0000-00-00 00:00:00\', `description` text NOT NULL, `user` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM Failed - Please contact WHMCS Support with this error message

ERROR: CREATE TABLE `tbladdons` ( `id` int(1) unsigned zerofill NOT NULL auto_increment, `packages` text NOT NULL, `name` text NOT NULL, `description` text NOT NULL, `recurring` decimal(10,2) NOT NULL default \'0.00\', `setupfee` decimal(10,2) NOT NULL default \'0.00\', `billingcycle` text NOT NULL, `showorder` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM Failed - Please contact WHMCS Support with this error message

ERROR: CREATE TABLE `tbladminlog` ( `id` int(10) unsigned zerofill NOT NULL auto_increment, `adminusername` text NOT NULL, `logintime` datetime NOT NULL default \'0000-00-00 00:00:00\', `logouttime` datetime NOT NULL default \'0000-00-00 00:00:00\', `ipaddress` text NOT NULL, `sessionid` text NOT NULL, `lastvisit` datetime NOT NULL default \'0000-00-00 00:00:00\', PRIMARY KEY (`id`) ) TYPE=MyISAM Failed - Please contact WHMCS Support with this error message

ERROR: CREATE TABLE `tbladmins` ( `id` int(1) unsigned zerofill NOT NULL auto_increment, `username` text NOT NULL, `password` varchar(32) NOT NULL default \'\', `firstname` text NOT NULL, `lastname` text NOT NULL, `email` text NOT NULL, `userlevel` text NOT NULL, `signature` text NOT NULL, `notes` text NOT NULL, `loginattempts` int(1) NOT NULL, `supportdepts` text NOT NULL, `ticketnotifications` varchar(2) NOT NULL, `ordernotifications` varchar(2) NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM Failed - Please contact WHMCS Support with this error message

ERROR: CREATE TABLE `tblaffiliates` ( `id` int(3) unsigned zerofill NOT NULL auto_increment, `date` date default NULL, `clientid` int(10) unsigned zerofill NOT NULL default \'0000000000\', `visitors` int(1) NOT NULL, `paytype` text NOT NULL, `payamount` decimal(10,2) NOT NULL, `balance` decimal(10,2) NOT NULL default \'0.00\', `withdrawn` decimal(10,2) NOT NULL default \'0.00\', PRIMARY KEY (`id`) ) TYPE=MyISAM Failed - Please contact WHMCS Support with this error message

ERROR: CREATE TABLE `tblaffiliatesaccounts` ( `id` int(1) unsigned zerofill NOT NULL auto_increment, `affiliateid` text NOT NULL, `domain` text NOT NULL, `package` text NOT NULL, `billingcycle` text NOT NULL, `regdate` date default NULL, `amount` decimal(10,2) NOT NULL default \'0.00\', `commission` decimal(10,2) NOT NULL, `lastpaid` date NOT NULL default \'0000-00-00\', `relid` int(10) unsigned zerofill NOT NULL default \'0000000000\', PRIMARY KEY (`id`) ) TYPE=MyISAM Failed - Please contact WHMCS Support with this error message

ERROR: CREATE TABLE `tblcancelrequests` ( `id` int(10) unsigned zerofill NOT NULL auto_increment, `date` datetime NOT NULL default \'0000-00-00 00:00:00\', `relid` int(10) unsigned zerofill NOT NULL default \'0000000000\', `reason` text NOT NULL, `type` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM Failed - Please contact WHMCS Support with this error message

ERROR: CREATE TABLE `tblclients` ( `id` int(10) unsigned zerofill NOT NULL auto_increment, `firstname` text NOT NULL, `lastname` text NOT NULL, `companyname` text NOT NULL, `email` text NOT NULL, `address1` text NOT NULL, `address2` text NOT NULL, `city` text NOT NULL, `state` text NOT NULL, `postcode` text NOT NULL, `country` text NOT NULL, `phonenumber` text NOT NULL, `password` text NOT NULL, `credit` decimal(10,2) NOT NULL, `taxexempt` text NOT NULL, `datecreated` date NOT NULL, `notes` text NOT NULL, `cardtype` varchar(255) NOT NULL default \'\', `cardnum` blob NOT NULL, `startdate` blob NOT NULL, `expdate` blob NOT NULL, `issuenumber` blob NOT NULL, `lastlogin` datetime default NULL, `ip` text NOT NULL, `host` text NOT NULL, `status` text NOT NULL, `language` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM Failed - Please contact WHMCS Support with this error message

ERROR: CREATE TABLE `tblcustomfields` ( `id` int(1) unsigned zerofill NOT NULL auto_increment, `type` text NOT NULL, `relid` int(10) unsigned zerofill NOT NULL default \'0000000000\', `num` text NOT NULL, `fieldname` text NOT NULL, `fieldtype` text NOT NULL, `fieldoptions` text NOT NULL, `adminonly` text NOT NULL, `required` text NOT NULL, `showorder` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM Failed - Please contact WHMCS Support with this error message

ERROR: CREATE TABLE `tbldomainpricing` ( `id` int(1) unsigned zerofill NOT NULL auto_increment, `extension` text NOT NULL, `registrationperiod` int(1) NOT NULL default \'0\', `register` decimal(10,2) NOT NULL default \'0.00\', `transfer` decimal(10,2) NOT NULL, `renew` decimal(10,2) NOT NULL, `autoreg` text NOT NULL, `order` int(1) NOT NULL default \'0\', PRIMARY KEY (`id`) ) TYPE=MyISAM Failed - Please contact WHMCS Support with this error message

ERROR: CREATE TABLE `tbldomains` ( `id` int(10) unsigned zerofill NOT NULL auto_increment, `userid` int(10) unsigned zerofill NOT NULL default \'0000000000\', `orderid` int(1) NOT NULL, `registrationdate` date NOT NULL, `domain` text NOT NULL, `firstpaymentamount` decimal(10,2) NOT NULL default \'0.00\', `recurringamount` decimal(10,2) NOT NULL, `registrar` text NOT NULL, `registrationperiod` int(1) NOT NULL default \'1\', `expirydate` date default NULL, `subscriptionid` text NOT NULL, `status` text NOT NULL, `nextduedate` date NOT NULL default \'0000-00-00\', `nextinvoicedate` date NOT NULL, `additionalnotes` text NOT NULL, `paymentmethod` text NOT NULL, `urlforwarding` text NOT NULL, `emailforwarding` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM Failed - Please contact WHMCS Support with this error message

ERROR: CREATE TABLE `tbldownloadcats` ( `id` int(1) unsigned zerofill NOT NULL auto_increment, `parentid` int(1) NOT NULL default \'0\', `name` text NOT NULL, `description` text NOT NULL, `hidden` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM Failed - Please contact WHMCS Support with this error message

ERROR: CREATE TABLE `tbldownloads` ( `id` int(1) unsigned zerofill NOT NULL auto_increment, `type` text NOT NULL, `category` text NOT NULL, `title` text NOT NULL, `description` text NOT NULL, `downloads` int(1) NOT NULL default \'0\', `location` text NOT NULL, `clientsonly` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM Failed - Please contact WHMCS Support with this error message

ERROR: CREATE TABLE `tblemails` ( `id` int(1) unsigned zerofill NOT NULL auto_increment, `userid` int(10) unsigned zerofill NOT NULL default \'0000000000\', `subject` text NOT NULL, `message` text NOT NULL, `date` datetime default NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM Failed - Please contact WHMCS Support with this error message

ERROR: CREATE TABLE `tblgatewaylog` ( `id` int(10) unsigned zerofill NOT NULL auto_increment, `date` datetime NOT NULL default \'0000-00-00 00:00:00\', `gateway` text NOT NULL, `data` text NOT NULL, `result` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM Failed - Please contact WHMCS Support with this error message

ERROR: CREATE TABLE `tblhosting` ( `id` int(10) unsigned zerofill NOT NULL auto_increment, `userid` int(10) unsigned zerofill NOT NULL default \'0000000000\', `orderid` int(1) NOT NULL, `regdate` date NOT NULL, `domain` text NOT NULL, `server` text NOT NULL, `paymentmethod` text NOT NULL, `firstpaymentamount` decimal(10,2) NOT NULL default \'0.00\', `amount` decimal(10,2) NOT NULL default \'0.00\', `billingcycle` text NOT NULL, `nextduedate` date default NULL, `nextinvoicedate` date NOT NULL, `domainstatus` text NOT NULL, `username` text NOT NULL, `password` text NOT NULL, `notes` text NOT NULL, `subscriptionid` text NOT NULL, `packageid` int(10) unsigned zerofill NOT NULL default \'0000000000\', `overideautosuspend` text NOT NULL, `dedicatedip` text NOT NULL, `assignedips` text NOT NULL, `rootpassword` text NOT NULL, `ns1` text NOT NULL, `ns2` text NOT NULL, `diskusage` int(10) NOT NULL default \'0\', `disklimit` int(10) NOT NULL default \'0\', `bwusage` int(10) NOT NULL default \'0\', `bwlimit` int(10) NOT NULL default \'0\', `lastupdate` datetime NOT NULL default \'0000-00-00 00:00:00\', PRIMARY KEY (`id`) ) TYPE=MyISAM Failed - Please contact WHMCS Support with this error message

 

 

and the above carrys on for about another 200lines

 

the db is empty so its not that

[rentaserv]

i ahve mysql 5 installed btw with php 4.4.7

[Adam]

Hey,

 

Open up a ticket with WHMCS Staff,

http://support.whmcs.com/submitticket.php

 

From,

Adam

[webtrix]

I'm using MySQL 4.1.18 and getting the following errors during install! Please Help!

 

Errors Occured

 

Please open a ticket with the debug information below for support

 

File: install.sql

Line 1 - 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 '\'0000000000\', `gateway` text NOT NULL, `date` datetime default NULL, `descript' at line 1

Line 2 - 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 '\'0000-00-00 00:00:00\', `description` text NOT NULL, `user` text NOT NULL, PRIM' at line 1

Rest of Code Removed...

[CenCal]

My PHP version is - 5.2.6

 

MySQL version is - 4.1.22-standard

 

Just wondering is this a bug that's gone unfixed for almost a year?

 

 

 

Errors Occured

 

Please open a ticket with the debug information below for support

 

File: install.sql

Line 1 - 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 '0000000000'', `gateway` text NOT NULL, `date` datetime default NULL, `descriptio' at line 1

Line 2 - 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 '0000-00-00 00:00:00'', `description` text NOT NULL, `user` text NOT NULL, PRIMAR' at line 1

Line 3 - 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 '0.00'', `setupfee` decimal(10,2) NOT NULL default ''0.00'', `billingcycle` text ' at line 1

Line 4 - 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 '0000-00-00 00:00:00'', `logouttime` datetime NOT NULL default ''0000-00-00 00:00' at line 1

Line 6 - 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 '0000000000'', `visitors` int(1) NOT NULL, `paytype` text NOT NULL, `payamount` d' at line 1

Line 7 - 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 '0.00'', `commission` decimal(10,2) NOT NULL, `lastpaid` date NOT NULL default ''' at line 1

Line 14 - 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 '0000-00-00 00:00:00'', `relid` int(10) unsigned zerofill NOT NULL default ''0000' at line 1

Line 18 - 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 '0000000000'', `num` text NOT NULL, `fieldname` text NOT NULL, `fieldtype` text N' at line 1

Line 20 - 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 '0'', `register` decimal(10,2) NOT NULL default ''0.00'', `transfer` decimal(10,2' at line 1

Line 21 - 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 '0000000000'', `orderid` int(1) NOT NULL, `registrationdate` date NOT NULL, `doma' at line 1

Line 23 - 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 '0'', `name` text NOT NULL, `description` text NOT NULL, `hidden` text NOT NULL, ' at line 1

Line 24 - 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 '0'', `location` text NOT NULL, `clientsonly` text NOT NULL, PRIMARY KEY (`id`) ' at line 1

Line 25 - 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 '0000000000'', `subject` text NOT NULL, `message` text NOT NULL, `date` datetime ' at line 1

Line 28 - 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 '0000-00-00 00:00:00'', `gateway` text NOT NULL, `data` text NOT NULL, `result` t' at line 1

Line 29 - 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 '0000000000'', `orderid` int(1) NOT NULL, `regdate` date NOT NULL, `domain` text ' at line 1

Line 30 - 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 '0000000000'', `name` text NOT NULL, `setupfee` decimal(10,2) NOT NULL default ''' at line 1

Line 31 - 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 '0000000000'', `configid` int(10) unsigned zerofill NOT NULL default ''0000000000' at line 1

Line 32 - 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 '0000000000'', `type` text NOT NULL, `relid` int(10) unsigned zerofill NOT NULL d' at line 1

Line 33 - 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 '0000-00-00 00:00:00'', `userid` int(10) unsigned zerofill NOT NULL default ''000' at line 1

Line 34 - 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 '0'', `useful` int(1) NOT NULL default ''0'', `votes` int(1) NOT NULL default ''0' at line 1

Line 35 - 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 '0'', `name` text NOT NULL, `description` text NOT NULL, `hidden` text NOT NULL, ' at line 1

Line 37 - 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 '0'', `notes` text NOT NULL, `description` text NOT NULL, `order` int(1) NOT NULL' at line 1

Line 38 - 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 '0000000000'', `optionname` text NOT NULL, `optiontype` text NOT NULL, `order` in' at line 1

Line 39 - 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 '0000000000'', `optionname` text NOT NULL, `price` decimal(10,2) NOT NULL default' at line 1

Line 40 - 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 '0'', PRIMARY KEY (`id`) ) TYPE=MyISAM' at line 1

Line 41 - 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 '0'', `name` text NOT NULL, `description` text NOT NULL, `hidden` text NOT NULL, ' at line 1

Line 42 - 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 '0.00'', `expirationdate` date default NULL, `packages` text NOT NULL, `addons` t' at line 1

Line 45 - 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 '0.00'', `noc` text NOT NULL, `statusaddress` text NOT NULL, `primarynameserver` ' at line 1

Line 51 - 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 '0000-00-00 00:00:00'', `message` text NOT NULL, `ticketid` int(10) unsigned zero' at line 1

Line 55 - 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 '0'', `did` int(3) unsigned zerofill NOT NULL default ''000'', `userid` int(10) u' at line 1

Line 56 - 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 'sender'',''subject'',''phrase'') NOT NULL, `content` text NOT NULL, PRIMARY KEY ' at line 1

Line 58 - 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 'Pending'',''Completed'') NOT NULL default ''Pending'', `paid` enum(''Y'',''N'') ' at line 1

Line 60 - 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 'Language'', ''English'')' at line 1

Line 61 - 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 'CompanyName'', ''Company Name'')' at line 1

Line 62 - 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 'Email'', ''changeme@changeme.com'')' at line 1

Line 63 - 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 'Domain'', ''http://www.yourdomain.com/'')' at line 1

Line 64 - 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 'LogoURL'', '''')' at line 1

Line 65 - 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 'SystemURL'', ''http://www.yourdomain.com/whmcs/'')' at line 1

Line 66 - 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 'SystemSSLURL'', '''')' at line 1

Line 67 - 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 'Currency'', ''USD'')' at line 1

Line 68 - 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 'CurrencySymbol'', ''$'')' at line 1

Line 69 - 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 'AutoSuspension'', ''on'')' at line 1

Line 70 - 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 'AutoSuspensionDays'', ''5'')' at line 1

Line 71 - 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 'CreateInvoiceDaysBefore'', ''14'')' at line 1

Line 72 - 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 'AffiliateEnabled'', '''')' at line 1

Line 73 - 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 'AffiliateEarningPercent'', ''0'')' at line 1

Line 74 - 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 'AffiliateBonusDeposit'', ''0.00'')' at line 1

Line 75 - 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 'AffiliatePayout'', ''0.00'')' at line 1

Line 76 - 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 'AffiliateLinks'', '''')' at line 1

Line 77 - 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 'ActivityLimit'', ''1000'')' at line 1

Line 78 - 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 'DateFormat'', ''DD/MM/YYYY'')' at line 1

Line 79 - 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 'PreSalesQuestions'', ''on'')' at line 1

Line 80 - 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 'Template'', ''portal'')' at line 1

Line 81 - 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 'AllowRegister'', ''on'')' at line 1

Line 82 - 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 'AllowTransfer'', ''on'')' at line 1

Line 83 - 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 'AllowOwnDomain'', ''on'')' at line 1

Line 84 - 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 'EnableTOSAccept'', '''')' at line 1

Line 85 - 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 'TermsOfService'', '''')' at line 1

Line 86 - 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 'AllowLanguageChange'', ''on'')' at line 1

Line 87 - 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 'Version'', '''')' at line 1

Line 88 - 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 'AllowCustomerChangeInvoiceGateway'', ''on'')' at line 1

Line 89 - 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 'DefaultNameserver1'', ''ns1.yourdomain.com'')' at line 1

Line 90 - 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 'DefaultNameserver2'', ''ns2.yourdomain.com'')' at line 1

Line 91 - 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 'SendInvoiceReminderDays'', ''7'')' at line 1

Line 92 - 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 'SendReminder'', ''on'')' at line 1

Line 93 - 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 'NumRecordstoDisplay'', ''50'')' at line 1

Line 94 - 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 'BCCMessages'', '''')' at line 1

Line 95 - 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 'MailType'', ''mail'')' at line 1

Line 96 - 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 'SMTPHost'', '''')' at line 1

Line 97 - 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 'SMTPUsername'', '''')' at line 1

Line 98 - 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 'SMTPPassword'', '''')' at line 1

Line 99 - 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 'SMTPPort'', ''25'')' at line 1

Line 100 - 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 'ShowCancellationButton'', ''on'')' at line 1

Line 101 - 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 'UpdateStatsAuto'', ''on'')' at line 1

Line 102 - 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 'InvoicePayTo'', ''Address goes here...'')' at line 1

Line 103 - 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 'SendAffiliateReportMonthly'', ''on'')' at line 1

Line 104 - 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 'InvalidLoginBanLength'', ''15'')' at line 1

Line 105 - 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 'Signature'', ''Signature goes here...'')' at line 1

Line 106 - 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 'DomainOnlyOrderEnabled'', ''on'')' at line 1

Line 107 - 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 'TicketBannedAddresses'', '''')' at line 1

Line 108 - 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 'SendEmailNotificationonUserDetailsChange'', ''on'')' at line 1

Line 109 - 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 'TicketAllowedFileTypes'', ''.jpg,.gif,.jpeg,.png'')' at line 1

Line 110 - 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 'CloseInactiveTickets'', ''0'')' at line 1

Line 111 - 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 'InvoiceLateFeeAmount'', ''10.00'')' at line 1

Line 112 - 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 'AutoTermination'', '''')' at line 1

Line 113 - 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 'AutoTerminationDays'', ''30'')' at line 1

Line 114 - 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 'RegistrarAdminFirstName'', '''')' at line 1

Line 115 - 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 'RegistrarAdminLastName'', '''')' at line 1

Line 116 - 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 'RegistrarAdminCompanyName'', '''')' at line 1

Line 117 - 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 'RegistrarAdminAddress1'', '''')' at line 1

Line 118 - 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 'RegistrarAdminAddress2'', '''')' at line 1

Line 119 - 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 'RegistrarAdminCity'', '''')' at line 1

Line 120 - 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 'RegistrarAdminStateProvince'', '''')' at line 1

 

 

 

 

And another 100 or so errors

[chickendippers]

Have you done as the error message suggests and opened a support ticket?

[CenCal]

Yes of course, however I have yet to receive a reply. So I thought I would try the forums.

 

Have you done as the error message suggests and opened a support ticket?

[chickendippers]

OK, just checking

[txkhomes]

Did you make the database, assign a user full rights, ??

[CenCal]

Yes, I'm not that stupid

 

Did you make the database, assign a user full rights, ??

[txkhomes]

no, not meaning that but I have ran thru 6 installation this past week and I have no ran into any problems other than missing a few steps ....

[phenglai]

Check the mode of your database. Make sure its not in strict mode. I had an issue with the installation when installing on a MySQL server that was set in strict mode. Turn it off, install, reset and you sould be fine.