SQL Errors

[darkspreader]

I am running SMF 1.1.5 with Tinyportal 1.0.5 beta 1.

I have noticed that I am getting these strange SQL errors when doing some certain things in some TP sections, such as adding a Menu Item. The first time I try adding an item, the page just stays stuck at Loading, and the second time it gives me this error (I also get this same problem when making new articles):

Field 'subtype' doesn't have a default value
File: S:\htdocs\friends_sites\dark\Sources\TPortalAdmin.php
Line: 837

Now the file above is obviously a local directory, but what could be wrong with the php file? I attached it in this post for further inspection.

[G6Cad]

Go through the manuall install instructions and check so everything got added correctly.

The doc section holds the info you need to know

[darkspreader]

Well, I found one thing in the style.css for my theme missing, but that was it.

[G6Cad]

And the DB upgrade ?

You said your theme in use, do you have the same issue in Default Core theme ?

[darkspreader]

I did not have the same issue in the default theme.

And I don't know what to do for the "DB upgrade." I couldn't find a Doc that showed how to.

[G6Cad]

Well, as it works fine in the default theme, my bet is that you have some issues with the theme you use.
Not much we can help you with.
If you take your time and read the posting guide we have in the sticky topic for this support board and fill in the info we need to know, we can see what might be the cause to your issue

[darkspreader]

Link to my site: http://alpha27.randomresources.org/
SMF version: 1.1.5
TP version: 1.0.5 beta 1
Theme name and version: Xbox 360 Elite 1.1
Mods installed:

1.     Color And BgColor BBCode Bar      3.3
2.    Custom Profile Field Mod    3.17
3.    LogModAccountEdits    1.9
4.    Member Color Link    3.0.0
5.    Moderator Activity Report    1.2
6.    Admin Notepad    1.0
7.    Popup PM Message - Uses The Same Window    1.3
8.    Profile User Action    1.1
9.    Remove Quoted Images    1.0
10.    Signature Settings Mod    1.1
11.    SMF Ranks    1.1
12.    Spam Me Not Mod    1.02
13.    TinyPortal    1.052

Related Error messages:

Field 'subtype' doesn't have a default value
File: S:\htdocs\friends_sites\dark\Sources\TPortalAdmin.php
Line: 837

It seems like something isn't getting executed or parsed right on that line in TPortalAdmin.php... I have no knowledge on PHP or MySQL, so it's kind of hard for me to evaluate these problems myself...



Edit: I just tried making a new article while using the Default Core theme, and I got this error:

Field 'shortname' doesn't have a default value
File: S:\htdocs\friends_sites\dark\Sources\TPortalAdmin.php
Line: 867

And the same problem as before for the menu manager. Is it possible that Tinyportal didn't install successfully?

[G6Cad]

Seems like you need to update the DB

download the tp package, extract it and upload all the files manually through FTP, then point your browser to manual_tp_install.php and let it update your db tp tables

[darkspreader]

I am still getting the same errors.

[G6Cad]

Did you ever check the default themes files so the TP ode got added to them as it should ?
Look at my first post but this time check the default theme as it's to that theme TP adds all the code.

If that doesent do it, it must be some of your other mods that auses your issues.