Гость
04 Сен 2012 00:22

I received this error when I try to install cobalt 7

"JInstaller: :Install: Error SQL DB function failed with error number 1146

Table 'master_ekho.nybg_js_res_packs' doesn't exist SQL=ALTER TABLE nybg_js_res_packs ADD COLUMN author_name varchar(100) ;

SQL =

ALTER TABLE #__js_res_packs ADD COLUMN author_name varchar(100) ;

Component Update: SQL error file DB function failed with error number 1146

Table 'master_ekho.nybg_js_res_packs' doesn't exist SQL=ALTER TABLE nybg_js_res_packs ADD COLUMN author_name varchar(100) ;

SQL =

ALTER TABLE #__js_res_packs ADD COLUMN author_name varchar(100) ;

Package Install: There was an error installing an extension: com_cobalt.v.7.8995.zip

How can I fix this???

Последние изменения: 02 Март 2014


Sergey
Total posts: 13,748
04 Сен 2012 01:08

It is an update installation right?

Just run this query to your DB

CREATE TABLE IF NOT EXISTS `#__js_res_packs` (

    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,

    `name` varchar(255) NOT NULL,

    `description` text,

    `key` char(10) NOT NULL,

    `addkey` tinyint(2) NOT NULL DEFAULT '1',

    `add_files` text,

    `ctime` datetime NOT NULL,

    `mtime` datetime NOT NULL,

    `btime` datetime NOT NULL,

    `version` varchar(20) NOT NULL,

    `checked_out` int(11) NOT NULL,

    `checked_out_time` datetime NOT NULL,

    `users` tinyint(3) NOT NULL,

    `user_id` int(11) NOT NULL,

    `author_name` varchar(100),

    `author_email` varchar(100),

    `author_url` text,

    PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

In fact this table is not important for Cobalt operation. Only if you want to create Packs.


Гость
04 Сен 2012 15:58

Ok i have added the query to my DB but the problem still persist.. Am I missing any steps that I should be taking after adding the query and trying to re update/install?


Гость
04 Сен 2012 16:06

Also the cobalt doesn't appear in the component section anymore.


Sergey
Total posts: 13,748
04 Сен 2012 18:16

The error you mentioned could happen only if you update Cobalt from version lower than 7.8860.

Could you prpovide your admin access so I could check it?


Гость
04 Сен 2012 18:37

http://proelite365.com/administrator/

Username: masteruser

Password: 13tmm247


Sergey
Total posts: 13,748
05 Сен 2012 00:41

That is very strange behaviour. After I deleted Cobalt and installed it again it install correctly. now it is there. I will also look further for cases like this to find what can be the reason.


Гость
05 Сен 2012 17:27

Thank you I truly appreciate it. Cobalt is an amazing component. Keep up the amazing work..


Sergey
Total posts: 13,748
05 Сен 2012 19:25

If you like it so much, woul you please add a review on JED?


Гость
06 Сен 2012 11:56

No problem

Работает на Cobalt