Database problems

[Kronos]

Hello, I've just successfully manualy installed tinyportal on my SMF board.
I've seen other people on these boards with the same errors but they never had an answer to their problem.

When I try to add an article category it gives the following error:

Code Select Expand


Field 'subtype' doesn't have a default value
File: ...\SMF\Sources\TPortalAdmin.php
Line: 404
And when I attempt to add an article to one of the allready existing demo categories:

Code Select Expand


Field 'shortname' doesn't have a default value
File: ...\SMF\Sources\TPortalAdmin.php
Line: 463
I haven't encountered any other errors so far but if I do I'll post them.

Thanks in advance.

Also I'd like to tell you that I'm not particulary good with php, this might make it a bit harder.

[G6Cad]

You must make sure you have all the articles inside categories

[Kronos]

Yes I know, I am unable to add any category though as I get the following error:

Code Select Expand

Field 'subtype' doesn't have a default value
File: ...\SMF\Sources\TPortalAdmin.php
Line: 404

[G6Cad]

Dont know the reason to your crossposting....

Manually installed what inside what ?  Posting guidelins holds the facts we need to know to help you, Can you fill them in for us so we can see where to go from here 

[Kronos]

Sorry, I've read the guidelines but did not see this.
I've manually installed the Tinyportal version stated below on the SMF board versoin stated below.
The manual_tp_install.php does not give any errors.

Link to my site: http://www.inter-com.ath.cx/
SMF version: 1.1.5
TP version: v0.9.8
Theme name and version: DarkIce 1.1 by Crip
Mods installed:
Admin notepad v1.0
Remove Message Icons v1.0
Simple Imageshack v2.0.3
WoW-Itemstats v1.25.9.2
Tinyportal v098
Related Error messages:

On creating a new article category:

Code Select Expand

Field 'subtype' doesn't have a default value
File: ...\SMF\Sources\TPortalAdmin.php
Line: 404

On creating a new article in one of the existing demo categories:

Code Select Expand

Field 'shortname' doesn't have a default value
File: ...\SMF\Sources\TPortalAdmin.php
Line: 463

[G6Cad]

Strange that you have that error in TP V098, we have only seen that error reported in the V1.0.5 beta.
Can you make sure you added the correct TP codestrings in to your SMF files ? The strings for V098 are diffrent from V1.0.5

[Kronos]

I've used the following page to edit the codestrings:
http://www.tinyportal.net/index.php?topic=14195

Also, I've double checked the changed I made.
Though It is odd the package wouldn't install via the packages manager, it gave an 500 internal server error even though I gave everything all permissions for the install.

[G6Cad]

Well, the codeedits should be good then.

Permission issues to the files can make a lot of strange things happend.

What TP package did you download and use when you uploaded the files to your forum ?

[Kronos]

When I tried to install via the package manager and had the 500 internal server error I used:
http://www.tinyportal.net/index.php?action=tpmod;dl=item745

After that for the manual install I used:
http://www.tinyportal.net/index.php?action=tpmod;dl=item744

[G6Cad]

Really strange.

Should work if you done everything as the insctructions say.

Try and run the DB install again from the browser and make sure it updates the tables with out errors.