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: D:\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: D:\Inetpub\www\forums\Sources\SPortalAdmin1-1.php
Line: 1029
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?
Quote from: LHVWB on April 07, 2009, 11:15:16 PM
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
Did you uninstall SP before the upgrade to SMF 2.0 RC1, or did you let the installer try to fix it?
Run this query from phpMyAdmin and try again:
ALTER TABLE smf_sp_blocks
DROP content
Quote from: Eliana Tamerin on April 13, 2009, 08:47:34 PM
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
Quote from: [SiNaN] on April 14, 2009, 04:38:38 AM
Run this query from phpMyAdmin and try again:
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
Quote from: LHVWB on April 07, 2009, 11:15:16 PM
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
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.
Sorry for delayed response Quinn. Can you provide me a database and admin access to your forum?
Quote from: [SiNaN] on April 25, 2009, 04:48:29 AM
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
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.
Quote from: [SiNaN] on May 01, 2009, 03:26:56 AM
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.