Topic: Gallery Image Block - SP 2.2 Problem

[Quinn]

In SMF 2.0 RC1

After setting up a random image block for SMF Gallery I get this error when pressing the Create Button:

Field 'content' doesn't have a default value
File: \Inetpub\www\forums\Sources\SPortalAdmin1-1.php
Line: 1029

The preview is exactly what I am looking for but can't add it to the portal.

Also in SMF 1.1.8 I get the same error...

Field 'content' doesn't have a default value
File: \Inetpub\www\forums\Sources\SPortalAdmin1-1.php
Line: 1029

[Nathaniel]

Firstly, your first error message is odd as it occurs in the SPortal1-1.php file which doesn't exists for the SMF 2 version.

I can't replicate this error in either version of SMF, with SimplePortal 2.2. Please make sure that you are using the latest versions of SimplePortal and the Gallery mod (you will need the correct version for your version of SMF for the gallery mod).

I'll need some more information to try and resolve this issue.
Which database type are you using? MySQL/PostGreSQL/SQLite.
Do you get errors with any of the content blocks? Such as the PHP, HTML and BBC blocks.
Do you have any other errors in your forum error log?
Which exact versions of SimplePortal, SMF Gallery and SMF are you running?

[Quinn]

Firstly, your first error message is odd as it occurs in the SPortal1-1.php file which doesn't exists for the SMF 2 version.

I can't replicate this error in either version of SMF, with SimplePortal 2.2. Please make sure that you are using the latest versions of SimplePortal and the Gallery mod (you will need the correct version for your version of SMF for the gallery mod).

I'll need some more information to try and resolve this issue.
Which database type are you using? MySQL/PostGreSQL/SQLite. MySQL
Do you get errors with any of the content blocks? Such as the PHP, HTML and BBC blocks. No
Do you have any other errors in your forum error log? No
Which exact versions of SimplePortal, SMF Gallery and SMF are you running?

SMF Gallery Pro   ...  Your Version: 1.4.5 Latest Version: 1.4.5     
SMF Gallery Pro SSI    1.1
SMF Gallery Pro - Video AddOn    1.1.1

SiNaN did the Sp 2.2 install on my SMF 1.1.8 site last week... the SMF 2.0 RC1 install is recent as well and using the same versions of SMF Gallery &  MySQL

[Eliana Tamerin]

Did you uninstall SP before the upgrade to SMF 2.0 RC1, or did you let the installer try to fix it?

[[SiNaN]]

Run this query from phpMyAdmin and try again:

Code: [Select]

ALTER TABLE smf_sp_blocks
DROP content

[Quinn]

Did you uninstall SP before the upgrade to SMF 2.0 RC1, or did you let the installer try to fix it?

SMF 2.0 Rc1 is a recent install... previous SP was uninstalled as per instructions

[Quinn]

Run this query from phpMyAdmin and try again:

Code: [Select]

ALTER TABLE smf_sp_blocks
DROP content

That returned no errors or anything for SMF 1.1.8 ... and the gallery block preview works now but Add Block hangs, Loading...

for the SMF 2.0 rc1
Error

SQL query:

ALTER TABLE smf2_sp_blocks DROP content

MySQL said: Documentation
#1091 - Can't DROP 'content'; check that column/key exists

SMF 2.0 gallery block preview show the title bar but no (latest or random)  images in the body of the block

[Quinn]

Firstly, your first error message is odd as it occurs in the SPortal1-1.php file which doesn't exists for the SMF 2 version.

I can't replicate this error in either version of SMF, with SimplePortal 2.2. Please make sure that you are using the latest versions of SimplePortal and the Gallery mod (you will need the correct version for your version of SMF for the gallery mod).

I'll need some more information to try and resolve this issue.
Which database type are you using? MySQL/PostGreSQL/SQLite.
Do you get errors with any of the content blocks? Such as the PHP, HTML and BBC blocks.
Do you have any other errors in your forum error log?
Which exact versions of SimplePortal, SMF Gallery and SMF are you running?

In the SMF 1.1.8 Default Theme folder I have these files:

SPortal.template.php
SPortal1-1.template.php
SPortalAdmin.template.php
SPortalAdmin1-1.template.php
SPortalBlocks1-1.template.php

If i rename the 'SPortalBlocks1-1. template.php' to .old the forum does not load... Unable to load the 'SPortalBlocks1-1' template.

In the SMF 2.0 Rc1 Default Theme folder I have these files:

SPortal2.template.php
SPortalAdmin2.template.php
SPortalBlocks2.template.php

[Quinn]

Latest attempt to make the Gallery block work...

Uninstalled SP 2.2 & deleted the SP 2.1.1 package files from SMF 1.1.8 then re-installed SP 2.2.

I can preview the Gallery Block but it still hangs when adding the block.

[[SiNaN]]

Sorry for delayed response Quinn. Can you provide me a database and admin access to your forum?

[Quinn]

Sorry for delayed response Quinn. Can you provide me a database and admin access to your forum?

not a problem SiNaN, thank you...

PM sent

[[SiNaN]]

Solved the issue by dropping 'content' and 'parameters' fields in sp_blocks table, which are no longer used. They are now dropped by default with install scripts and database tools.

[Quinn]

Solved the issue by dropping 'content' and 'parameters' fields in sp_blocks table, which are no longer used. They are now dropped by default with install scripts and database tools.

Thank You SiNaN... for your dedication and to a great product.