1. Roy Svendsen
  2. Installation questions
  3. Tuesday, 01 November 2011
  4.  Subscribe via email
HI

Have som problems installing on a Joomla 1.7.2 . I´m getting this error



There was a problem with your installation


jos_comment update :
- update of voting_yes.
- update of voting_no.
- update of parentid.
- update of email.
- update of website.
- update of notify.
- create index contentid.
- update of userid.
- update of component.
- create index com_contentid.
- update of importtable.
- update of importid.
- update of importparentid.
Create jos_comment_setting table.
Install error: DB function failed with error number 1146
Table 'anetteshus.jos_comment' doesn't exist SQL=ALTER TABLE `vpo_comment` ADD `voting_yes` INT(10) NOT NULL default '0' AFTER `published`;
ALTER TABLE `vpo_comment` ADD `voting_yes` INT(10) NOT NULL default '0' AFTER `published`;

Install error: DB function failed with error number 1146
Table 'anetteshus.jos_comment' doesn't exist SQL=ALTER TABLE `vpo_comment` ADD `voting_no` INT(10) NOT NULL default '0' AFTER `voting_yes`;
ALTER TABLE `vpo_comment` ADD `voting_no` INT(10) NOT NULL default '0' AFTER `voting_yes`;

Install error: DB function failed with error number 1146
Table 'anetteshus.jos_comment' doesn't exist SQL=ALTER TABLE `vpo_comment` ADD `parentid` INT(10) NOT NULL default '-1' AFTER `voting_no`;
ALTER TABLE `vpo_comment` ADD `parentid` INT(10) NOT NULL default '-1' AFTER `voting_no`;

Install error: DB function failed with error number 1146
Table 'anetteshus.jos_comment' doesn't exist SQL=ALTER TABLE `vpo_comment` ADD `email` VARCHAR(50) AFTER `name`;
ALTER TABLE `vpo_comment` ADD `email` VARCHAR(50) AFTER `name`;

Install error: DB function failed with error number 1146
Table 'anetteshus.jos_comment' doesn't exist SQL=ALTER TABLE `vpo_comment` ADD `website` VARCHAR(100) AFTER `email`;
ALTER TABLE `vpo_comment` ADD `website` VARCHAR(100) AFTER `email`;

Install error: DB function failed with error number 1146
Table 'anetteshus.jos_comment' doesn't exist SQL=ALTER TABLE `vpo_comment` ADD `notify` TINYINT(1) NOT NULL default '0' AFTER `website`;
ALTER TABLE `vpo_comment` ADD `notify` TINYINT(1) NOT NULL default '0' AFTER `website`;

Install error: DB function failed with error number 1146
Table 'anetteshus.jos_comment' doesn't exist SQL=ALTER TABLE `vpo_comment` ADD INDEX `contentid` ( `contentid` );
ALTER TABLE `vpo_comment` ADD INDEX `contentid` ( `contentid` );

Install error: DB function failed with error number 1146
Table 'anetteshus.jos_comment' doesn't exist SQL=ALTER TABLE `vpo_comment` ADD `userid` INT(11) AFTER `ip`;
ALTER TABLE `vpo_comment` ADD `userid` INT(11) AFTER `ip`;

Install error: DB function failed with error number 1146
Table 'anetteshus.jos_comment' doesn't exist SQL=ALTER TABLE `vpo_comment` ADD `component` VARCHAR(50) NOT NULL default '' AFTER `contentid`;
ALTER TABLE `vpo_comment` ADD `component` VARCHAR(50) NOT NULL default '' AFTER `contentid`;

Install error: DB function failed with error number 1146
Table 'anetteshus.jos_comment' doesn't exist SQL=ALTER TABLE `vpo_comment` ADD INDEX `com_contentid` ( `component`, `contentid` );
ALTER TABLE `vpo_comment` ADD INDEX `com_contentid` ( `component`, `contentid` );

Install error: DB function failed with error number 1146
Table 'anetteshus.jos_comment' doesn't exist SQL=ALTER TABLE `vpo_comment` ADD `importtable` VARCHAR(30) NOT NULL default '' AFTER `parentid`;
ALTER TABLE `vpo_comment` ADD `importtable` VARCHAR(30) NOT NULL default '' AFTER `parentid`;

Install error: DB function failed with error number 1146
Table 'anetteshus.jos_comment' doesn't exist SQL=ALTER TABLE `vpo_comment` ADD `importid` INT(10) NOT NULL default '0' AFTER `importtable`;
ALTER TABLE `vpo_comment` ADD `importid` INT(10) NOT NULL default '0' AFTER `importtable`;

Install error: DB function failed with error number 1146
Table 'anetteshus.jos_comment' doesn't exist SQL=ALTER TABLE `vpo_comment` ADD `importparentid` INT(10) NOT NULL default '-1' AFTER `importid`;
ALTER TABLE `vpo_comment` ADD `importparentid` INT(10) NOT NULL default '-1' AFTER `importid`;


Install 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 'type=MyISAM' at line 7 SQL=CREATE TABLE `vpo_comment_setting` ( `id` INT(11) NOT NULL auto_increment, `set_name` VARCHAR(50) NOT NULL default '', `set_component` VARCHAR(50) NOT NULL default '', `set_sectionid` INT(11) NOT NULL default '0', `params` text NOT NULL, PRIMARY KEY (`id`)) type=MyISAM
CREATE TABLE `vpo_comment_setting` ( `id` INT(11) NOT NULL auto_increment, `set_name` VARCHAR(50) NOT NULL default '', `set_component` VARCHAR(50) NOT NULL default '', `set_sectionid` INT(11) NOT NULL default '0', `params` text NOT NULL, PRIMARY KEY (`id`)) type=MyISAM
Responses (10)


There are %s replies to this question. If you want to see them you need a valid subscription.
If you have a valid subscription, please login now.
Visit store now

Last questions

Hotspots Pro 6.0.13 compatability with Joomla 5.3.
Running Hotspots Pro 6.0.13 on Joomla 4.4.13 and want to upgrade to Joomla 5.3.1...
2 Replies
Posted on Friday, 04 July 2025
some questions on Hotspots
Hi, On Hotspots extension : 1) is it possible to add our own map layer / v...
0 Replies
Posted on Thursday, 03 July 2025
Trying to resize the image in the comments
Hey everyone, Basically I am trying to make the images in the comments smalle...
9 Replies
Posted on Wednesday, 12 August 2009
J5 compatibility for Hotspots
Hi guys, Just started to update my old J3x website. Is there J5 compatibility p...
2 Replies
Posted on Monday, 24 February 2025
  • #Hotspots
  • #hotspots Joomla 5
error message when adding/cofiguring email address
When configuring the email plugin that send a email message to admin when a new ...
0 Replies
Posted on Friday, 09 May 2025