"subtype" has no default value error message (SMF 1.1.3, TP 0983)

[Wivelrod]

Hi,

I've just done a clean install of SMF 1.1.3 and the latest version of TP (TP_0983.zip), and I am getting the following error when I try to do certain tasks with articles:

Field 'subtype' doesn't have a default value
File: G:\websites\order-of-the-rose\htdocs\forum\Sources\TPortalAdmin.php
Line: 404

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.3, while your database is at version 1.1.2. The above error might possibly go away if you execute the latest version of upgrade.php.

I found the following post: http://www.tinyportal.net/index.php?topic=15119.0 -which seems to be similar to the issue I have. So I uploaded and ran "manual_tp_install.php" from the download page, yet the problem remains.

BTW, this is my first experience with php and mySQL, so if someone is able to help, please ensure the instructions are clear

Thanks in advance

[G6Cad]

The error tells you the error and what you need to do.
You need to update your DB with the SMF big upgrade package.
Download, take out the 2 sql files and the upgrade.php and upload them to where you have the forum installed, then point the browser to the upgrade.php and it will fix the error you have, then do the same for TP

[Wivelrod]

Why would I have to "upgrade" when its a clean install of SMF with the latest release - is this a bug in deployment?

[G6Cad]

You have to ask that on SMF, but we have seen it a coupple of times now, and to fix it, you have to do the steps i said.
Could be that the SQL and PHP have diffrent settings that doesent apply correct during the install, but when you upgrade the tables again they get red correct.
SMF have the answers, or they should be able to give you more information though.

[Wivelrod]

okey dokey, will do it in the morning. thanks for the help

[Wivelrod]

Unfortunately this did not work.

Update.php, upgrade_1-1.sql and upgrade_1-0.sql were copied into my /forum folder and run. No errors were reported.

I now get:

Field 'subtype' doesn't have a default value
File: G:\websites\order-of-the-rose\htdocs\forum\Sources\TPortalAdmin.php
Line: 404

The hint about database version has been removed by running update, but the error remains.

I can cross post this on the SMF forum too, but there is nothing wrong with the actual functionality of the forum itself. This is only happening using TP functions, such as modifying the demo article or adding new articles and categories.

[G6Cad]

Did you update the TP database tables to ?

Code Select Expand

then point the browser to the upgrade.php and it will fix the error you have, [b]then do the same for TP[/b]

[Wivelrod]

I've rerun manual_tp_install.php.

"    * Upshrink table exists
    * Settings table exists
          o Updated version to 098
    * Blocks table exists
          o Changed pos in blocks table
          o Changed pos in blocks table
    * Variables table exists
          o Changed value5 in variables table
    * Articles table exists
          o Updated body in articles table
    * DL manager table exists
    * Shoutbox table exists

TinyPortalÃ,´s table structure is now installed/updated."

No change in error message when adding a new article category .

[Wivelrod]

Could this be a mySQL version issue?

I have a second site I was using to test SMF originally hosted on another ISP. I've installed TP there and it seems to work ok, I can create new categories.

On the newer site the problem remains. I've completely uninstalled and deleted the TP package and reinstalled it.

[Wivelrod]

Version Information:
Forum version: SMF 1.1.3 (more detailed)
Current SMF version: SMF 1.1.3
PHP version: 5.2.0
MySQL version: 5.0.27-community-nt
Server version: Microsoft-IIS/6.0
GD version: bundled (2.0.28 compatible)