Members: 16,996
Threads: 38,862
Posts: 159,462
Online: 54

Newest Member: Kl_broka@rediffmail.com


Odoo.tv - Outdoor Television


Sedo - Domains kaufen und verkaufen das Projekt mambers.com steht zum Verkauf Besucherstatistiken von mambers.com etracker® Web-Controlling statt Logfile-Analyse
Old 21.10.2004, 12:59   #1 (permalink)
Junior Mamber
 
Pitufo's Avatar
 
Join Date: Jul 2004
Posts: 29
Pitufo is on a distinguished road
Send a message via AIM to Pitufo Send a message via Yahoo to Pitufo
Default MOSHost

I tried installing MOSHost adn got this
Code:
SQL Error DB function failed with error number 1064
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 ';ALTER TABLE `mos_session` ADD `domain` LONGTEXT;DROP TABLE IF SQL=ALTER TABLE `mos_session` ADD `order` LONGTEXT;ALTER TABLE `mos_session` ADD `domain` LONGTEXT;DROP TABLE IF EXISTS `mos_moshost_accounts`CREATE TABLE `mos_moshost_accounts` ( `user` int(11) NOT NULL default '0', `domain` int(11) NOT NULL default '0', `active` tinyint(4) NOT NULL default '0', KEY `domain` (`domain`), KEY `user` (`user`) ) TYPE=MyISAM COMMENT='web hosting account information'; DROP TABLE IF EXISTS `mos_moshost_binterval`CREATE TABLE `mos_moshost_binterval` ( `id` int(11) NOT NULL auto_increment, `name` varchar(25) NOT NULL default '', `evaluate` varchar(25) NOT NULL default '', `active` tinyint(4) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='billing intervals'; DROP TABLE IF EXISTS `mos_moshost_domains`CREATE TABLE `mos_moshost_domains` ( `id` int(11) NOT NULL auto_increment, `customer` int(11) NOT NULL default '0', `domain` varchar(50) NOT NULL default 'domain.com', `creationDate` int(11) NOT NULL default '0', `package` int(11) default NULL, `billingDate` int(20) default NULL, `billingInterval` int(4) default '1', `billingRate` float default NULL, `contactEmail` varchar(50) NOT NULL default 'user@domain.com', `options` text, `active` tinyint(4) NOT NULL default '0', `overdue` tinyint(4) NOT NULL default '0', PRIMARY KEY (`id`), KEY `domain` (`domain`), KEY `customer` (`customer`) ) TYPE=MyISAM COMMENT='web hosting account information'; DROP TABLE IF EXISTS `mos_moshost_config`CREATE TABLE `mos_moshost_config` ( `id` tinyint(4) NOT NULL auto_increment, `cpanelKey` longtext NOT NULL, `sslServer` varchar(50) NOT NULL default '', `domainRegistrar` int(11) NOT NULL default '0', `active` tinyint(4) NOT NULL default '0', `report` tinyint(4) NOT NULL default '0', `reportEmail` varchar(50) NOT NULL default '', `sync` tinyint(4) NOT NULL default '0', `process` tinyint(4) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='MOSHost Configuration Table'; INSERT INTO `mos_moshost_config` ( `id` , `cpanelKey` , `sslServer` , `domainRegistrar` , `active` , `report` , `reportEmail` , `sync` , `process` ) VALUES ('', '', '', '0', '0', '0', '', '0', '0')DROP TABLE IF EXISTS `mos_moshost_invoices`CREATE TABLE `mos_moshost_invoices` ( `id` int(11) NOT NULL auto_increment, `domain` int(11) NOT NULL default '0', `dueDate` int(20) NOT NULL default '0', `amountDue` float NOT NULL default '0', `paid` tinyint(4) NOT NULL default '0', PRIMARY KEY (`id`), KEY `domain` (`domain`) ) TYPE=MyISAM COMMENT='mosHost billing invoices'; DROP TABLE IF EXISTS `mos_moshost_options`CREATE TABLE `mos_moshost_options` ( `id` int(11) NOT NULL auto_increment, `name` varchar(20) NOT NULL default '', `price` float NOT NULL default '0', `active` tinyint(4) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='package options'; DROP TABLE IF EXISTS `mos_moshost_packages`CREATE TABLE `mos_moshost_packages` ( `id` int(11) NOT NULL auto_increment, `name` varchar(15) NOT NULL default '', `space` varchar(50) default NULL, `bandwidth` varchar(50) default NULL, `active` tinyint(4) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='hosting packages'; DROP TABLE IF EXISTS `mos_moshost_rate`CREATE TABLE `mos_moshost_rate` ( `id` int(11) NOT NULL auto_increment, `package` tinyint(4) NOT NULL default '0', `interval` tinyint(4) NOT NULL default '0', `rate` float NOT NULL default '0', PRIMARY KEY (`id`), KEY `package` (`package`,`interval`) ) TYPE=MyISAM COMMENT='moshost hosting rates';
SQL =

ALTER TABLE `mos_session` ADD `order` LONGTEXT;ALTER TABLE `mos_session` ADD `domain` LONGTEXT;DROP TABLE IF EXISTS `mos_moshost_accounts`CREATE TABLE `mos_moshost_accounts` (
								`user` int(11) NOT NULL default '0',
								`domain` int(11) NOT NULL default '0',
								`active` tinyint(4) NOT NULL default '0',
								KEY `domain` (`domain`),
								KEY `user` (`user`)
								) TYPE=MyISAM COMMENT='web hosting account information';
                        DROP TABLE IF EXISTS `mos_moshost_binterval`CREATE TABLE `mos_moshost_binterval` (
								`id` int(11) NOT NULL auto_increment,
								`name` varchar(25) NOT NULL default '',
								`evaluate` varchar(25) NOT NULL default '',
								`active` tinyint(4) NOT NULL default '0',
								PRIMARY KEY  (`id`)
								) TYPE=MyISAM COMMENT='billing intervals';
                        DROP TABLE IF EXISTS `mos_moshost_domains`CREATE TABLE `mos_moshost_domains` (
								`id` int(11) NOT NULL auto_increment,
								`customer` int(11) NOT NULL default '0',
								`domain` varchar(50) NOT NULL default 'domain.com',
								`creationDate` int(11) NOT NULL default '0',
								`package` int(11) default NULL,
								`billingDate` int(20) default NULL,
								`billingInterval` int(4) default '1',
								`billingRate` float default NULL,
								`contactEmail` varchar(50) NOT NULL default 'user@domain.com',
								`options` text,
								`active` tinyint(4) NOT NULL default '0',
								`overdue` tinyint(4) NOT NULL default '0',
								PRIMARY KEY  (`id`),
								KEY `domain` (`domain`),
								KEY `customer` (`customer`)
								) TYPE=MyISAM COMMENT='web hosting account information';
                        DROP TABLE IF EXISTS `mos_moshost_config`CREATE TABLE `mos_moshost_config` (
							  `id` tinyint(4) NOT NULL auto_increment,
							  `cpanelKey` longtext NOT NULL,
							  `sslServer` varchar(50) NOT NULL default '',
							  `domainRegistrar` int(11) NOT NULL default '0',
							  `active` tinyint(4) NOT NULL default '0',
							  `report` tinyint(4) NOT NULL default '0',
							  `reportEmail` varchar(50) NOT NULL default '',
							  `sync` tinyint(4) NOT NULL default '0',
							  `process` tinyint(4) NOT NULL default '0',
							  PRIMARY KEY  (`id`)
							) TYPE=MyISAM COMMENT='MOSHost Configuration Table';
                        INSERT INTO `mos_moshost_config` ( `id` , `cpanelKey` , `sslServer` , `domainRegistrar` , `active` , `report` , `reportEmail` , `sync` , `process` ) VALUES ('', '', '', '0', '0', '0', '', '0', '0')DROP TABLE IF EXISTS `mos_moshost_invoices`CREATE TABLE `mos_moshost_invoices` (
								`id` int(11) NOT NULL auto_increment,
								`domain` int(11) NOT NULL default '0',
								`dueDate` int(20) NOT NULL default '0',
								`amountDue` float NOT NULL default '0',
								`paid` tinyint(4) NOT NULL default '0',
								PRIMARY KEY  (`id`),
								KEY `domain` (`domain`)
								) TYPE=MyISAM COMMENT='mosHost billing invoices';
                        DROP TABLE IF EXISTS `mos_moshost_options`CREATE TABLE `mos_moshost_options` (
								`id` int(11) NOT NULL auto_increment,
								`name` varchar(20) NOT NULL default '',
								`price` float NOT NULL default '0',
								`active` tinyint(4) NOT NULL default '0',
								PRIMARY KEY  (`id`)
								) TYPE=MyISAM COMMENT='package options';
                        DROP TABLE IF EXISTS `mos_moshost_packages`CREATE TABLE `mos_moshost_packages` (
								`id` int(11) NOT NULL auto_increment,
								`name` varchar(15) NOT NULL default '',
								`space` varchar(50) default NULL,
								`bandwidth` varchar(50) default NULL,
								`active` tinyint(4) NOT NULL default '0',
								PRIMARY KEY  (`id`)
								) TYPE=MyISAM COMMENT='hosting packages';
                        DROP TABLE IF EXISTS `mos_moshost_rate`CREATE TABLE `mos_moshost_rate` (
								`id` int(11) NOT NULL auto_increment,
								`package` tinyint(4) NOT NULL default '0',
								`interval` tinyint(4) NOT NULL default '0',
								`rate` float NOT NULL default '0',
								PRIMARY KEY  (`id`),
								KEY `package` (`package`,`interval`)
								) TYPE=MyISAM COMMENT='moshost hosting rates';
__________________
I was here!!!
www.Latiraza.net/http://www.latinraza.net
Pitufo is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
Old 26.10.2004, 03:21   #2 (permalink)
Baby Mamber
 
Join Date: Oct 2004
Posts: 6
Wickedinterface is on a distinguished road
Default Re: MOSHost

I to get the same error and would like to know how to fix this
Wickedinterface is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Moshost dmj Komponenten 0 27.07.2004 01:39
MosHost 0.9 HerrDoktor Komponenten 4 03.05.2004 19:23
MOShost??? Pippolo Componenti 0 19.04.2004 10:20


All times are GMT +2. The time now is 20:08.

Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.1.0
A vBSkinworks Design
© Copyright 2004-2008 by Arthur Konze Webdesign.