1
m0nty
problem installing ipb module
  • 2003/11/16 14:16

  • m0nty

  • XOOPS is my life!

  • Posts: 3337

  • Since: 2003/10/24


I previously had ipb 1.23 installed, but ran into a few probs unfortunately..

so i uninstalled it..

now the problem is i've recopied all the files from my drive so that all the ipboard files are in there original state..

but when i try to install the module again i get an error message saying:

Installing Message Board

Duplicate column name 'clickable'

Unable to install ipboard. Error(s):

any ideas how to fix this?

2
Jan304
Re: problem installing ipb module
  • 2003/11/16 15:31

  • Jan304

  • Official Support Member

  • Posts: 520

  • Since: 2002/3/31


Run this sql query:
ALTER TABLE smiles
    DROP  clickable
;

ALTER TABLE session
    DROP    member_name 
,
    
DROP    member_id ,
    
DROP    browser ,
    
DROP    login_type ,
    
DROP    location ,
    
DROP    member_group ,
    
DROP    in_forum ,
    
DROP    in_topic ,
    
DROP    INDEX in_topic ,
    
DROP    INDEX in_forum
;

DELETE FROM users WHERE uid='0';

ALTER TABLE users
    DROP   mgroup 
,
    
DROP   ip_address ,
    
DROP   avatar_size ,
    
DROP   title ,
    
DROP   allow_admin_mails ,
    
DROP   email_pm ,
    
DROP   email_full ,
    
DROP   skin ,
    
DROP   warn_level ,
    
DROP   warn_lastwarn ,
    
DROP   language ,
    
DROP   last_post ,
    
DROP   restrict_post ,
    
DROP   view_img ,
    
DROP   view_avs ,
    
DROP   view_pop ,
    
DROP   bday_day ,
    
DROP   bday_month ,
    
DROP   bday_year,
    
DROP   new_msg ,
    
DROP   msg_from_id ,
    
DROP   msg_msg_id ,
    
DROP   msg_total ,
    
DROP   vdirs ,
    
DROP   show_popup ,
    
DROP   misc ,
    
DROP   last_visit,
    
DROP   last_activity ,
    
DROP   dst_in_use ,
    
DROP   view_prefs ,
    
DROP   coppa_user ,
    
DROP   mod_posts ,
    
DROP   auto_track ,
    
DROP   org_perm_id ,
    
DROP   org_supmod ,
    
DROP   integ_msg ,
    
DROP   temp_ban ,
    
DROP   signature ,
    
DROP   INDEX mgroup ,
    
DROP   INDEX bday_day,
    
DROP   INDEX bday_month
;

3
m0nty
Re: problem installing ipb module
  • 2003/12/19 14:29

  • m0nty

  • XOOPS is my life!

  • Posts: 3337

  • Since: 2003/10/24


got this same problem again...

run the query u gave above.. now i get this error >

Installing Message Board

Duplicate entry '0' for key 1

Unable to install ipboard. Error(s):

any ideas?

4
m0nty
Re: problem installing ipb module
  • 2003/12/19 21:24

  • m0nty

  • XOOPS is my life!

  • Posts: 3337

  • Since: 2003/10/24


ok sorted that problem out and IPBM is now installed :)

the next problem is how the hell can i import/convert my standalone IPB 1.2 forum onto XOOPS ipbm 1.23??

i've used koudanshi's converter but everytime i do this, i end up with problems.. the problem being once it's completed i goto the forum index page and all i get is a white page!!


Login

Who's Online

257 user(s) are online (70 user(s) are browsing Support Forums)


Members: 0


Guests: 257


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Jul 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits