SimplePortal

Support => Install and Upgrade => Topic started by: raasaa on March 01, 2009, 01:50:51 AM

Title: Database Error
Post by: raasaa 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...

Title: Re: Database Error
Post by: Nathaniel 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'.

Title: Re: Database Error
Post by: raasaa 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 ??

Title: Re: Database Error
Post by: Nathaniel 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. ;)

Title: Re: Database Error
Post by: raasaa 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

Title: Re: Database Error
Post by: crank 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?

Title: Re: Database Error
Post by: [SiNaN] 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.