modules won't install :: Archived

gyrantol · Newbie Offline Joined: Mar 30, 2007 Posts: 16

when I am trying to install modules such as coppermine I am getting the following message

Quote::

includes/db/db.php
CMS Warning line 75: On /admin.php?op=modules&install=coppermine While executing query "CREATE TABLE nuke_cpg_albums ( aid int(11) NOT NULL auto_increment, title varchar(255) NOT NULL default '', description text NOT NULL, visibility int(11) NOT NULL default '0', uploads enum('YES','NO') NOT NULL default 'NO', comments enum('YES','NO') NOT NULL default 'YES', votes enum('YES','NO') NOT NULL default 'YES', pos int(11) NOT NULL default '0', category int(11) NOT NULL default '0', pic_count int(11) NOT NULL default '0', thumb int(11) NOT NULL default '0', last_addition INT NOT NULL default '0', stat_uptodate enum('YES','NO') NOT NULL default 'NO', PRIMARY KEY (aid), KEY alb_category (category)) TYPE=MyISAM DEFAULT CHARSET=utf8" the following error occured: Table 'nuke_cpg_albums' already exists In: /homepages/6/d155126608/htdocs/forum/includes/classes/installer.php on line: 61

I am running a 9.1.2.1 (phpnuke 8 upgrade), mysql 5, 1 & 1 webhosts php 4.4.4

sarah · Debugger Offline Joined: Mar 25, 2005 Posts: 2130

How did you try to install the Photo Gallery? It's installed by default, with no option to uninstall it. The db error is telling you it can't add the coppermine tables because they already exist, which they should.

gyrantol · Newbie Offline Joined: Mar 30, 2007 Posts: 16

when I look under modules it is showing coppermine the only option there is install I can't edit it

gyrantol · Newbie Offline Joined: Mar 30, 2007 Posts: 16

nor can I activate it

NanoCaiordo · Posted: Fri Apr 13, 2007 9:56 am Post subject: Re: modules won't install

try to run the following query from phpmyadmin or similar and post the results here please

Code::

select mid, active from nuke_modules where title='coppermine'

gyrantol · Newbie Offline Joined: Mar 30, 2007 Posts: 16

I have reverted back to phpnuke for now so that my users can use the site (they were kicking off lol) I will try the to upgrade it again tonight if I get the same error I will do as you ask...

I wondered if 1 & 1 set their mysql 5 servers in strict mode but I don't know how to check or ammend if needs be

Phoenix · Posted: Fri Apr 13, 2007 8:27 pm Post subject: Re: modules won't install

NanoCaiordo wrote:

try to run the following query from phpmyadmin or similar and post the results here please

Code::

select mid, active from nuke_modules where title='coppermine'

Aside from that, empty your website cache folder and let things regenerate.

gyrantol · Newbie Offline Joined: Mar 30, 2007 Posts: 16

ok,

I have tried again today and I ran the install on version 9.0.6.1 before upgrading it to 9.1.2.1. It seems to be all fine now... but I did get an error message about a duplicate column whilst installing WoWRosterDF but that has installed on 9.1.2.1 so I don't know why it errored.

Thanks for all your advice

gyrantol · Newbie Offline Joined: Mar 30, 2007 Posts: 16

in reference to my previous post I have just had the same results installing Shoutblock 3... comes up with the following error

Quote::

CMS Warning line 75: On /admin.php?op=modules&install=Shoutblock While executing query "ALTER TABLE nuke_admins ADD radminshoutblock TINYINT(1) NOT NULL DEFAULT '0'" the following error occured: Duplicate column name 'radminshoutblock' In: /homepages/6/d155126608/htdocs/forum/admin/modules/modules.php on line: 262

but the strange thing is it installs anyway

gyrantol · Newbie Offline Joined: Mar 30, 2007 Posts: 16

I am trying to install Forums Pro and I am getting a similar error message, but this time it will not install