SimplePortal

Support => English Support => Topic started by: tattooedpierre on September 05, 2009, 05:47:34 AM

Title: Unknown column 'id_block' in 'field list'
Post by: tattooedpierre on September 05, 2009, 05:47:34 AM

I am getting the above when trying to install SP 2.3 via the package manager. All tests are successful but installation fails.

In the code; the line is:

Code: [Select]

SELECT id_block
FROM {db_prefix}sp_blocks
LIMIT 1',
.. but in the DB there is no id_block column. This was supposed to be an upgrade from the previous version but it all went wrong and I just reinstalled anew and changed my Settings.php to look at the old DB (i then ran the upgrade.php for SMF 2.0RC1.2 SQL changes..).

Should I just drop the SP-xxx columns? I think this is probably the issue.

Title: Re: Unknown column 'id_block' in 'field list'
Post by: Nathaniel on September 05, 2009, 09:21:10 AM

Which version/s of SP did you use before?

Have you just upgraded from SMF 1.1.x?

Title: Re: Unknown column 'id_block' in 'field list'
Post by: tattooedpierre on September 05, 2009, 10:34:00 AM

Quote from: Nathaniel on September 05, 2009, 09:21:10 AM

Which version/s of SP did you use before?

Have you just upgraded from SMF 1.1.x?

Sorry I was on SMF 2.0 RC1. On reinstall though, i grabbed 2.0RC1.2. Then I upgraded the DB via upgrade.php. For SP I used 2.2.2 (iirc) previously.

Title: Re: Unknown column 'id_block' in 'field list'
Post by: Nathaniel on September 05, 2009, 07:21:35 PM

The SMF upgrade process may have done something odd to the 'sp_%' tables, if you have backups, then restoring those specific tables (and then installing SimplePortal) is probably the easiest way to go.

Title: Re: Unknown column 'id_block' in 'field list'
Post by: tattooedpierre on September 07, 2009, 05:19:34 AM

Quote from: Nathaniel on September 05, 2009, 07:21:35 PM

The SMF upgrade process may have done something odd to the 'sp_%' tables, if you have backups, then restoring those specific tables (and then installing SimplePortal) is probably the easiest way to go.

I didnt want to restore from backup since I had reinstalled SMF entirely; but I do think I know what the problem is. When I install via package manager, even though its says installed and shows the completed message (redirect now etc).. When you actually look in the Sources/ dir none of the .php files have been amended.. so to me this seems a permission issue?

EDIT: This is def. an issue writing to the files. I tried to install Aeva as well and it also failed in much the same way (claims its fine but no Sources/ modifications made).

Title: Re: Unknown column 'id_block' in 'field list'
Post by: Nathaniel on September 07, 2009, 05:25:05 PM

It could be a file permissions issue, below is a list of the files that SimplePortal will need chmoded to 0777.

Sources/
Themes/
index.php
SSI.php

Title: Re: Unknown column 'id_block' in 'field list'
Post by: tattooedpierre on September 09, 2009, 06:50:07 AM

Quote from: Nathaniel on September 07, 2009, 05:25:05 PM

It could be a file permissions issue, below is a list of the files that SimplePortal will need chmoded to 0777.

Sources/
Themes/
index.php
SSI.php

Thank you so much for posting this! It must have been the SSI or index file as I had chmod'd the others before to no effect! Works perfectly now. :D