Zikula Community

• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: May 14, 2007
  • Posts: 15

  Posted: Aug 04, 2005 - 03:47 PM

  Hey guys im getting this error when i go to intilize the module. can someone give me some advice on how to fix it..
  
  CREATETABLEFAILED Error: Table 'nuke_membersonline_groups' already exists

  • 
  •  
• **unknown user**
  
  

  • Rank: Freshman
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 78

  Posted: Aug 04, 2005 - 03:51 PM

  Well, that means that particular table in the database already exists.
  Could another module you have installed have created it and is using it?

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: May 14, 2007
  • Posts: 15

  Posted: Aug 08, 2005 - 10:32 AM

  so how would i fix this error?

  • 
  •  
• **unknown user**
  
  

  • Rank: Freshman
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 78

  Posted: Aug 08, 2005 - 11:25 AM

  Log into your database via a database editor (i.e. phpMyAdmin), go into your PostNuke database, and scroll until you find the table called "nuke_membersonline_groups"...
  
  Does it exist? It probably does, as the error above suggests.
  
  Then click on "Browse" to see what data is in the table...Is it empty? It may or may not be.
  
  Now, open up a text editor, and open the file on your harddrive called "install.php" in the module directory that you're trying to initialize...Scroll through that file until you find something that looks like this...
  
  

  Code

  "CREATE TABLE  ".$mon_prefix."_membersonline_groups  (
       root_id  int(5) unsigned NOT NULL auto_increment,
       papa_id  int(5) unsigned NOT NULL default '0',
       cat_name  varchar(50) NOT NULL,
       cat_desc  varchar(50) NOT NULL,
       cat_add_date  int(11) NOT NULL default '0',
       cat_img  text NOT NULL,
       nbads  int(11) NOT NULL default '0',
       lang  varchar(5) NOT NULL default '0',
      PRIMARY KEY  ( root_id )

  
  
  root_id, papa_id, etc...Will all be different, but there will be a create table block similar to the above. Compare the list of fields in install.php with the field names in the table in phpMyAdmin...If they are identical...Identical...Then you can probably delete the table in phpMyAdmin and initialize the module with no problems. :)
  
  Now, be careful you only delete the nuke_membersonline_groups table, not the entire database!!! Probably wouldn't be a bad idea to back up your database before doing any of this, too.

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: May 14, 2007
  • Posts: 15

  Posted: Aug 08, 2005 - 11:31 AM

  thanks ill give it a whirl...

  • 
  •  
•  
•  

Users on-line

• roccoluigi,
• slam

This list is based on users active over the last 60 minutes.