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: 367
  • 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

* Team Blog

* 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]
Thanks for having an interest with our portal. If you have any requests for features, have a look at the Feature Requests board.

« previous next »
Pages: [1]   Go Down

Author Topic: Database Error  (Read 5664 times)

0 Members and 1 Guest are viewing this topic.

Offline raasaa

  • Newbie
  • Posts: 4
Database Error
« on: March 01, 2009, 01:50:51 AM »
I was using SimplePortal 2.1 with SMF 1.1.8....and it was working fine. I recently upgraded to SMF 2 Beta. Before upgrading, i uninstalled SimplePortal and all the other mods that i had installed. I did this by using package manager only.

The upgrade went smoothly, i added in a new theme and a few other mods which are working without any issues.

When i try to install SimplePortal 2.1,


I first get this error.
Quote
16.     Execute Modification     ./Themes/default/css/dropmenu.css     Test failed
      1.    Replace    ./Themes/default/css/dropmenu.css    Test failed
I ignored this error and continued with the installation, and ended up getting another error.

Quote
Table 'konohasmf.sp_articles' doesn't exist
File: /home/konoha/konoha/smf/Packages/temp/install2.php
Line: 50

I went into phpmyadmin to check if this table existed, and it exists under the name "konohasmf_sp_articles".
For the second error message, i created a temp folder in the Packages directory and changed the permissions for all files / directories in the packages directory to 777.


Please advise, on how to sort this out and get SP working...
Logged

Offline Nathaniel

  • Comrade
  • *
  • Posts: 5203
  • Gender: Male
    • Verbtest.com
  • SMF Version: 2 RC4
  • SP Version: 2.3.3
Re: Database Error
« Reply #1 on: March 01, 2009, 02:41:04 AM »
You can skip the first error okay.

With the database error. Its an error with SMF 2 RC1, you can avoid it by making a backup of your 'konohasmf_sp_%' tables (there should be 4), deleting them from your SMF database, installing SimplePortal and then restoring the backup of those tables so that you have the data.

If you are going straight from SMF 1.1.8 to SMF 2 RC1 then you will also have to change any columns in those tables which have the prefix 'ID_' to lower case. Do that after the other process.
eg. 'ID_BLOCK' -> 'id_block'.
Logged
SMF Friend (Former Support Specialist) | SimplePortal DeveloperMy SMF Mods | SimplePortal"Quis custodiet ipsos custodes?" - Who will Guard the Guards?Please don't send me ANY support related PMs. I will just delete them.

Offline raasaa

  • Newbie
  • Posts: 4
Re: Database Error
« Reply #2 on: March 02, 2009, 02:08:59 AM »
successfully installed now....thanks a lot for your help

Something weird though....

I did a backup for those 4 tables, as you suggested....but after the installation i see that all the 4 tables are back, and the "ID" prefix has automatically been changed to lower case.....

Do i have to restore the backed up tables.....or do i just keep them in cold storage for now ??
Logged

Offline Nathaniel

  • Comrade
  • *
  • Posts: 5203
  • Gender: Male
    • Verbtest.com
  • SMF Version: 2 RC4
  • SP Version: 2.3.3
Re: Database Error
« Reply #3 on: March 02, 2009, 04:14:41 AM »
Sorry I forgot to mention, delete the 'sp_%' tables that are there before you restore your older tables. ;)
Logged
SMF Friend (Former Support Specialist) | SimplePortal DeveloperMy SMF Mods | SimplePortal"Quis custodiet ipsos custodes?" - Who will Guard the Guards?Please don't send me ANY support related PMs. I will just delete them.

Offline raasaa

  • Newbie
  • Posts: 4
Re: Database Error
« Reply #4 on: March 02, 2009, 06:54:00 AM »
Quote from: LHVWB on March 02, 2009, 04:14:41 AM
Sorry I forgot to mention, delete the 'sp_%' tables that are there before you restore your older tables. ;)
It wont really matter rite...which table i am using....since i am starting the portals from scratch. Its not like i will be losing something by not restoring the older tables ??

Just asking...for future reference sake :D
Logged

Offline crank

  • Semi Newbie
  • *
  • Posts: 10
    • Webmasters Trade
Re: Database Error
« Reply #5 on: March 08, 2009, 10:12:01 AM »
Sorry to hijack this thread but this is relevant.

I followed everything explaind here and it worked great but at the bottom of the portal this is how the license shows up

Powered by SMF 2.0 RC1 | SMF © 2006–2009, Simple Machines LLC
SimplePortal 2.1.1
XHTML RSS WAP2

The thing is that it shows one on top of the other kind of messy. Is this a problem?
Logged

Offline [SiNaN]

  • Mr. SimplePortal
  • Developer
  • *
  • Posts: 6782
  • SMF Version: 2.0.15
  • SP Version: 2.3.7
Re: Database Error
« Reply #6 on: March 08, 2009, 11:37:40 AM »
If you are using default theme, press Ctrl+F5.

If you are using a custom theme, apply the index.css edit in your custom theme's index.css file too.
Logged
And slowly, you come to realize... It's all as it should be...
Pages: [1]   Go Up
« previous next »