collapse

* Simple Portal Archived Forum

This is an Archive Forum.

The content in this forum may be out-of-date or have been superseded by newer information, and links in forum pages to other sites may not work.
This forum contains archives for future reference.

Visit our thread at Simple Machines Forum for current support.

SMF 2.1 users: EhPortal is a ported version of Simple Portal specifically designed for the SMF 2.1 branch.
Please visit web-develop.ca to download EhPortal and for its support.

* User Info

 
 
Welcome, Guest. Please login or register.

* Who's Online

  • Dot Guests: 297
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.

* Shoutbox

Refresh History
  • Shoutbox is not for support!
  • {OCS}MasterSeal: Yup, Still adore SP
    April 21, 2019, 07:08:06 PM
  • {OCS}MasterSeal: STILL love SP :)
    November 24, 2018, 05:05:50 AM
  • ♦ Ninja ZX-10RR ♦: <3 aegersz
    September 13, 2018, 03:36:09 PM
  • aegersz: I STILL <3 LOVE SimplePortal
    September 13, 2018, 07:11:39 AM
  • aegersz: o LOVE you guys - Simple Portal rocks !
    May 09, 2018, 05:18:59 AM
  • Chen Zhen: our apologies for the site being down.. please read server issues topic
    March 22, 2018, 05:32:38 AM
  • {OCS}MasterSeal: LOL PLEASE forget I just posted that. I found the answer in my own dang post back in 2015. lol sorry!
    July 04, 2017, 10:47:55 PM
  • {OCS}MasterSeal: I know this SB isnt' for support, but I just have a general question. Who would I contact to find out where SP stores its block info? Is it DB driven or files? I searched the site but came up with nothing. probably my fault any insight is appreciated.
    July 04, 2017, 10:43:36 PM
  • ♦ Ninja ZX-10RR ♦: Excuse me but what does Simpleportal have to deal with that?
    February 05, 2017, 08:21:14 PM
  • WhiteEagle: of course IMHO that site appears to be dead :(
    February 04, 2017, 01:08:05 PM
  • WhiteEagle: If I can get that, then I'll use it for that site...
    February 04, 2017, 01:07:35 PM
  • WhiteEagle: decided to not use SMF for any projects, unless I can get a copy of the premium version of the fanfiction archive plugin
    February 04, 2017, 01:06:54 PM
  • expertdecisions: cloudflare
    January 28, 2017, 08:01:47 AM
  • aegersz: SM release 2.0.13 !
    January 12, 2017, 06:00:13 AM
  • raffo: Tks Emanuele, even if I didn't understand the fix :D
    November 07, 2016, 02:01:20 AM
  • emanuele: [link]
    November 01, 2016, 12:43:50 PM
  • emanuele: raffo: the English support board is a good place. ;)
    November 01, 2016, 12:43:38 PM
  • raffo: Where can I find the fix for the shoutbox?
    November 01, 2016, 05:06:09 AM
  • {OCS}MasterSeal: To the SP team, I make a point to come here and thank you as much as possible for your work.  so again, THANK YOU!
    October 28, 2016, 10:38:05 AM
  • emanuele: That's indeed funny, the limit is present only in the patch and not the full install.
    October 22, 2016, 06:14:58 PM

* Recent Posts

Adding Forums Button to Nav bar by jirapon
[August 01, 2019, 09:07:12 AM]


Re: Board Icons by ♦ Ninja ZX-10RR ♦
[July 30, 2019, 04:03:41 PM]


MOVED: Czech translation???? by ♦ Ninja ZX-10RR ♦
[July 30, 2019, 03:04:51 PM]


Board Icons by jirapon
[July 30, 2019, 07:28:44 AM]


Re: Thankyou Simpleportal, by ♦ Ninja ZX-10RR ♦
[July 29, 2019, 09:41:29 AM]

If you're interested in helping other members with support requests, consider joining the Community Support Helpers group.

Author Topic: database error while installing simpleportal  (Read 5505 times)

0 Members and 1 Guest are viewing this topic.

Offline googlemuscle

  • Newbie
  • Posts: 4
  • SMF Version: 2 RC4
  • SP Version: 2.3.5
database error while installing simpleportal
« on: December 03, 2012, 11:07:35 AM »
Ok I intalled today simpleportal 2.3.5
I removed it because I saw an other portal mod so I installed that one.
Because I didnt liked it I removed and tried to install simpleportal 2.3.5 again but now its giving me this error:
Duplicate key name 'state'
File: /usr/export/www/hosting/haxhome/public_html/smf/Sources/Subs-Db-mysql.php
Line: 419

So I cant install simpleportal anymore.
Im using smf 2.0 and before I deleted simpleportal it was working good!

Any solutions for this?

Thnx in advance
« Last Edit: December 04, 2012, 09:30:17 AM by googlemuscle »

Offline Deezel

  • Jr. Member
  • **
  • Posts: 54
  • Gender: Male
  • It Is What It Is
    • Owner/Admin
  • SMF Version: 2.0.4
  • SP Version: 2.3.5
Re: database error while installing simpleportal
« Reply #1 on: December 06, 2012, 10:33:40 AM »
Did you uninstall and delete the old files?

Offline oNLy1

  • Jr. Member
  • **
  • Posts: 53
  • SMF Version: 2.0.2
  • SP Version: 2.3.5
Re: database error while installing simpleportal
« Reply #2 on: December 12, 2012, 07:09:12 AM »
there is a check box at the Uninstall Mod page

[ ] Remove all data associated with this modification

...you may want to re-install the other portal, then uninstall and drop the tables

Offline googlemuscle

  • Newbie
  • Posts: 4
  • SMF Version: 2 RC4
  • SP Version: 2.3.5
Re: database error while installing simpleportal
« Reply #3 on: December 12, 2012, 11:19:17 AM »
I deleted it this way: I go to packages>browse packages> delete.
I dont know if that is the right way?
and I dont see that check box?

Offline phantomm

  • Translator
  • *
  • Posts: 406
  • Gender: Male
  • Smile, tomorrow will be worse...
    • Polish ElkArte community
  • SMF Version: None
  • Elkarte Version: 1.0.5
Re: database error while installing simpleportal
« Reply #4 on: December 13, 2012, 12:09:56 PM »
just to be clear, you removed SimplePortal by clicking at Delete button or Uninstall?


Offline googlemuscle

  • Newbie
  • Posts: 4
  • SMF Version: 2 RC4
  • SP Version: 2.3.5
Re: database error while installing simpleportal
« Reply #5 on: December 13, 2012, 01:24:09 PM »
yes I did:)

Offline phantomm

  • Translator
  • *
  • Posts: 406
  • Gender: Male
  • Smile, tomorrow will be worse...
    • Polish ElkArte community
  • SMF Version: None
  • Elkarte Version: 1.0.5
Re: database error while installing simpleportal
« Reply #6 on: December 13, 2012, 01:35:41 PM »
you did what?

Offline googlemuscle

  • Newbie
  • Posts: 4
  • SMF Version: 2 RC4
  • SP Version: 2.3.5
Re: database error while installing simpleportal
« Reply #7 on: December 13, 2012, 04:50:40 PM »
oh sorry, I did delete ( I dont see uninstall button?)


Offline phantomm

  • Translator
  • *
  • Posts: 406
  • Gender: Male
  • Smile, tomorrow will be worse...
    • Polish ElkArte community
  • SMF Version: None
  • Elkarte Version: 1.0.5
Re: database error while installing simpleportal
« Reply #8 on: December 14, 2012, 02:43:54 AM »
Then I guess you did not uninstalled mod correctly.
Try to uninstall it manually. Make changes backwards:
http://custom.simplemachines.org/mods/index.php?action=parse;mod=1104;attach=200154;smf_version=2.0.2

Remember to backup all edited files.

Offline andy

  • On Leave
  • *
  • Posts: 861
  • Gender: Male
    • Outdoor Club Japan (OCJ) アウトドア・クラブ・ジャパン
  • SMF Version: 2.0.15
  • SP Version: 2.3.7
  • Elkarte Version: None
Re: database error while installing simpleportal
« Reply #9 on: December 14, 2012, 06:03:51 AM »
It would be easier just to replace the files with the ones before mod install - kept in the zips  in the  backup folder of packages - wouldnt it?

Doing it manually would be hard for some people. And for me, I prefer just putting in clean SMF files using the large upgrade package and reinstalling mods - very quick, even with 20-30 mods.


Everyone is a volunteer here so please try and make a small donation to keep the Simple Portal website running