Joomla webhosting component for VHCS2

[Zothos]

bene, if you are interested, lets get this thing running with ispcp

i have send you a pm.

[Zothos]

just noticed, it offers built in support for ispCP. So we only have to get all functions to work.

[sunebeermann]

I just tried to install this plugin and i get alot of errors while trying to load the sample data.

Not able to load sampledata
Errors:
Duplicate entry \'1\' for key 1 SQL=INSERT INTO `jos_wh_featurecat` VALUES (1, \'Basic Features\', 1);

Duplicate entry \'2\' for key 1 SQL=INSERT INTO `jos_wh_featurecat` VALUES (2, \'Domains\', 2);

Duplicate entry \'3\' for key 1 SQL=INSERT INTO `jos_wh_featurecat` VALUES (3, \'Professional Features\', 3);

Duplicate entry \'4\' for key 1 SQL=INSERT INTO `jos_wh_featurecat` VALUES (4, \'Extras\', 4);

Duplicate entry \'5\' for key 1 SQL=INSERT INTO `jos_wh_featurecat` VALUES (5, \'Price and Payment\', 5);

Duplicate entry \'1\' for key 1 SQL=INSERT INTO `jos_wh_features` VALUES (1, 1, 1, \'Webspace\', \'Webspace\', \'[webspace-mb] MB (about [webspace-gb] GB)\', 2);

Duplicate entry \'2\' for key 1 SQL=INSERT INTO `jos_wh_features` VALUES (2, 1, 1, \'Traffic / Month\', \'Traffic / Month\', \'[traffic-mb] MB (about [traffic-gb] GB)\', 3);

Duplicate entry \'3\' for key 1 SQL=INSERT INTO `jos_wh_features` VALUES (3, 1, 1, \'Email-Accounts\', \'Email-Accounts\', \'[mailaccounts]\', 1);

Duplicate entry \'4\' for key 1 SQL=INSERT INTO `jos_wh_features` VALUES (4, 1, 1, \'Email-Aliases\', \'Email-Aliases)\', \'[mailaccounts]\', 4);

Duplicate entry \'5\' for key 1 SQL=INSERT INTO `jos_wh_features` VALUES (5, 1, 1, \'Spamfilter\', \'Spamfilter\', \'Yes\', 5);

Duplicate entry \'6\' for key 1 SQL=INSERT INTO `jos_wh_features` VALUES (6, 1, 1, \'Autoresponder\', \'Autoresponder\', \'[mailaccounts]\', 6);

Duplicate entry \'7\' for key 1 SQL=INSERT INTO `jos_wh_features` VALUES (7, 1, 2, \'Domains\', \'Domains\', \'[domains] ([tlds])\', 7);

Duplicate entry \'8\' for key 1 SQL=INSERT INTO `jos_wh_features` VALUES (8, 0, 2, \'No Domain\', \'Domains\', \'0 (only one subdomain)\', 22);

Duplicate entry \'9\' for key 1 SQL=INSERT INTO `jos_wh_features` VALUES (9, 1, 2, \'Subdomains\', \'Subdomains (yxz.yourdomain.tld)\', \'[subdomains]\', 8);

Duplicate entry \'10\' for key 1 SQL=INSERT INTO `jos_wh_features` VALUES (10, 1, 2, \'Wildcard-Subdomains\', \'Wildcard-Subdomains (*.yourdomain.tld)\', \'Yes\', 10);

Duplicate entry \'11\' for key 1 SQL=INSERT INTO `jos_wh_features` VALUES (11, 1, 2, \'Additional Domains\', \'Additional Domains\', \'Yes, see domain prices\', 9);

Duplicate entry \'12\' for key 1 SQL=INSERT INTO `jos_wh_features` VALUES (12, 1, 3, \'PHP\', \'PHP\', \'[php]\', 12);

Duplicate entry \'13\' for key 1 SQL=INSERT INTO `jos_wh_features` VALUES (13, 1, 3, \'CGI/Perl\', \'CGI/Perl\', \'[cgi-perl]\', 11);

Duplicate entry \'14\' for key 1 SQL=INSERT INTO `jos_wh_features` VALUES (14, 1, 3, \'MySQL-Databases\', \'MySQL-Databases\', \'[dbaccounts]\', 13);

Duplicate entry \'15\' for key 1 SQL=INSERT INTO `jos_wh_features` VALUES (15, 1, 3, \'MySQL-User\', \'MySQL-User\', \'[dbusers]\', 14);

Duplicate entry \'17\' for key 1 SQL=INSERT INTO `jos_wh_features` VALUES (17, 0, 3, \'Own error pages\', \'Own error pages\', \'Yes\', 15);

Duplicate entry \'19\' for key 1 SQL=INSERT INTO `jos_wh_features` VALUES (19, 1, 4, \'Web-FTP & Web-Mail\', \'Web-FTP & Web-Mail\', \'Yes\', 16);

Duplicate entry \'20\' for key 1 SQL=INSERT INTO `jos_wh_features` VALUES (20, 0, 4, \'Web-FTP\', \'Web-FTP\', \'Yes\', 24);

Duplicate entry \'21\' for key 1 SQL=INSERT INTO `jos_wh_features` VALUES (21, 1, 4, \'Support\', \'Support\', \'Free (Email, Forum, Messenger or Livechat)\', 17);

Duplicate entry \'23\' for key 1 SQL=INSERT INTO `jos_wh_features` VALUES (23, 1, 5, \'Monthly Fee\', \'Monthly Fee\', \'[price]\', 18);

Duplicate entry \'24\' for key 1 SQL=INSERT INTO `jos_wh_features` VALUES (24, 1, 5, \'Billing cycle\', \'Billing cycle\', \'[billing_cycle]\', 19);

Duplicate entry \'25\' for key 1 SQL=INSERT INTO `jos_wh_features` VALUES (25, 1, 5, \'Terms of notice\', \'Terms of Notice\', \'1 month\', 20);

Duplicate entry \'26\' for key 1 SQL=INSERT INTO `jos_wh_features` VALUES (26, 1, 5, \'Yearly Fee\', \'Yearly Fee\', \'[price-x12]\', 21);

Duplicate entry \'27\' for key 1 SQL=INSERT INTO `jos_wh_features` VALUES (27, 1, 5, \'Setup Fee\', \'Setup Fee\', \'[setupfee]\', 23);

Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_wh_plans` VALUES (\'\', 0, \'-1-2-8-11-17-20-21-23-24-25-26-27-\', \'-1-2-8-11-17-\', 0, \'de\', \'9.99\', 1, 7, \'Mini\', \'This plan has only a minimum of features and webspace. It is recommended for a small company homepage or a small portfolio web site without too many requirements.\', \'_no_;_no_;-1;-1;-1;1;-1;-1;512;20;\', 0.66, 6.66, \'$[price] USD\', \'12\');

Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_wh_plans` VALUES (\'\', 0, \'-s-\', \'-3-1-2-4-7-9-13-12-14-\', 1, \'de,com,net\', \'9.99,11.99\', 1, 8, \'Normal\', \'This plan has all features you need for a Web Site. Support for PHP and CGI/Perl and a MySQL database means you can use it for dynamic content like a Content Managment System, Guestbook or Forum.\', \'_yes_;_yes_;5;1;1;1;1;1;1024;100;\', 1.50, 5.00, \'$[price] USD\', \'12\');

Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_wh_plans` VALUES (\'\', 0, \'-s-\', \'-3-1-2-4-7-9-13-12-14-\', 1, \'de,com,net,at,ch,be,org\', \'9.99,11.99\', 1, 9, \'Big\', \'Our bigger hosting plan.\', \'_yes_;_yes_;10;10;10;10;3;3;2048;200;\', 2.50, 5.00, \'$[price] USD\', \'6\');

Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_wh_plans` VALUES (\'\', 0, \'-s-\', \'-3-1-2-4-7-9-13-12-14-21-25-\', 3, \'de, com, net, at, ch, be, org\', \'9.99,11.99\', 1, 10, \'Professional\', \'Our biggest hosting plan, not only for professionals.\', \'_yes_;_yes_;40;40;40;40;4;4;4096;400;\', 4.00, 4.00, \'$[price] USD\', \'1\');


MySQL-Queries:
INSERT INTO `#__wh_featurecat` VALUES (1, 'Basic Features', 1);

INSERT INTO `#__wh_featurecat` VALUES (2, 'Domains', 2);

INSERT INTO `#__wh_featurecat` VALUES (3, 'Professional Features', 3);

INSERT INTO `#__wh_featurecat` VALUES (4, 'Extras', 4);

INSERT INTO `#__wh_featurecat` VALUES (5, 'Price and Payment', 5);

INSERT INTO `#__wh_features` VALUES (1, 1, 1, 'Webspace', 'Webspace', '[webspace-mb] MB (about [webspace-gb] GB)', 2);

INSERT INTO `#__wh_features` VALUES (2, 1, 1, 'Traffic / Month', 'Traffic / Month', '[traffic-mb] MB (about [traffic-gb] GB)', 3);

INSERT INTO `#__wh_features` VALUES (3, 1, 1, 'Email-Accounts', 'Email-Accounts', '[mailaccounts]', 1);

INSERT INTO `#__wh_features` VALUES (4, 1, 1, 'Email-Aliases', 'Email-Aliases)', '[mailaccounts]', 4);

INSERT INTO `#__wh_features` VALUES (5, 1, 1, 'Spamfilter', 'Spamfilter', 'Yes', 5);

INSERT INTO `#__wh_features` VALUES (6, 1, 1, 'Autoresponder', 'Autoresponder', '[mailaccounts]', 6);

INSERT INTO `#__wh_features` VALUES (7, 1, 2, 'Domains', 'Domains', '[domains] ([tlds])', 7);

INSERT INTO `#__wh_features` VALUES (8, 0, 2, 'No Domain', 'Domains', '0 (only one subdomain)', 22);

INSERT INTO `#__wh_features` VALUES (9, 1, 2, 'Subdomains', 'Subdomains (yxz.yourdomain.tld)', '[subdomains]', 8);

INSERT INTO `#__wh_features` VALUES (10, 1, 2, 'Wildcard-Subdomains', 'Wildcard-Subdomains (*.yourdomain.tld)', 'Yes', 10);

INSERT INTO `#__wh_features` VALUES (11, 1, 2, 'Additional Domains', 'Additional Domains', 'Yes, see domain prices', 9);

INSERT INTO `#__wh_features` VALUES (12, 1, 3, 'PHP', 'PHP', '[php]', 12);

INSERT INTO `#__wh_features` VALUES (13, 1, 3, 'CGI/Perl', 'CGI/Perl', '[cgi-perl]', 11);

INSERT INTO `#__wh_features` VALUES (14, 1, 3, 'MySQL-Databases', 'MySQL-Databases', '[dbaccounts]', 13);

INSERT INTO `#__wh_features` VALUES (15, 1, 3, 'MySQL-User', 'MySQL-User', '[dbusers]', 14);

INSERT INTO `#__wh_features` VALUES (17, 0, 3, 'Own error pages', 'Own error pages', 'Yes', 15);

INSERT INTO `#__wh_features` VALUES (19, 1, 4, 'Web-FTP & Web-Mail', 'Web-FTP & Web-Mail', 'Yes', 16);

INSERT INTO `#__wh_features` VALUES (20, 0, 4, 'Web-FTP', 'Web-FTP', 'Yes', 24);

INSERT INTO `#__wh_features` VALUES (21, 1, 4, 'Support', 'Support', 'Free (Email, Forum, Messenger or Livechat)', 17);

INSERT INTO `#__wh_features` VALUES (23, 1, 5, 'Monthly Fee', 'Monthly Fee', '[price]', 18);

INSERT INTO `#__wh_features` VALUES (24, 1, 5, 'Billing cycle', 'Billing cycle', '[billing_cycle]', 19);

INSERT INTO `#__wh_features` VALUES (25, 1, 5, 'Terms of notice', 'Terms of Notice', '1 month', 20);

INSERT INTO `#__wh_features` VALUES (26, 1, 5, 'Yearly Fee', 'Yearly Fee', '[price-x12]', 21);

INSERT INTO `#__wh_features` VALUES (27, 1, 5, 'Setup Fee', 'Setup Fee', '[setupfee]', 23);

INSERT INTO `#__wh_plans` VALUES ('', 0, '-1-2-8-11-17-20-21-23-24-25-26-27-', '-1-2-8-11-17-', 0, 'de', '9.99', 1, 7, 'Mini', 'This plan has only a minimum of features and webspace. It is recommended for a small company homepage or a small portfolio web site without too many requirements.', '_no_;_no_;-1;-1;-1;1;-1;-1;512;20;', 0.66, 6.66, '$[price] USD', '12');

INSERT INTO `#__wh_plans` VALUES ('', 0, '-s-', '-3-1-2-4-7-9-13-12-14-', 1, 'de,com,net', '9.99,11.99', 1, 8, 'Normal', 'This plan has all features you need for a Web Site. Support for PHP and CGI/Perl and a MySQL database means you can use it for dynamic content like a Content Managment System, Guestbook or Forum.', '_yes_;_yes_;5;1;1;1;1;1;1024;100;', 1.50, 5.00, '$[price] USD', '12');

INSERT INTO `#__wh_plans` VALUES ('', 0, '-s-', '-3-1-2-4-7-9-13-12-14-', 1, 'de,com,net,at,ch,be,org', '9.99,11.99', 1, 9, 'Big', 'Our bigger hosting plan.', '_yes_;_yes_;10;10;10;10;3;3;2048;200;', 2.50, 5.00, '$[price] USD', '6');

INSERT INTO `#__wh_plans` VALUES ('', 0, '-s-', '-3-1-2-4-7-9-13-12-14-21-25-', 3, 'de, com, net, at, ch, be, org', '9.99,11.99', 1, 10, 'Professional', 'Our biggest hosting plan, not only for professionals.', '_yes_;_yes_;40;40;40;40;4;4;4096;400;', 4.00, 4.00, '$[price] USD', '1

[BeNe]

Code:

Duplicate entry

Looks like there is already some Data in it

[sunebeermann]

Found the error, hmm
I didnt read all the instructions, i forgot to upgrade the data base, after install, i then uninstalled the component and installed it again running the databa upgrade and everything works great, this is a really need piece of software.

[Z4P]

I had it working with the RC...

[BeNe]

What did you changed exactly ?

[Z4P]

nothing in the code... just selected in the options the ispcp DB.

[adigit]

hi Z4P, is it stable enough?

I just want to test it in my lab pc. hehe...

[Z4P]

Jeay it was stable, tho i just tested it for 1 hour.