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):
Quote
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.
Go through the manuall install instructions and check so everything got added correctly.
The doc section holds the info you need to know
Well, I found one thing in the style.css for my theme missing, but that was it.
And the DB upgrade ?
You said your theme in use, do you have the same issue in Default Core theme ?
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.
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
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:
Quote1. 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:QuoteField '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:
QuoteField '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?
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
I am still getting the same errors.
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.
All the files got installed properly.... something is weird...
Edit: Should I try fully uninstalling Tinyportal, then trying a manual install? Also, I have a question. Is it possible to make a mirror of my SMF site, all mods and themes installed, instead of Tinyportal, then just copying the files from the mirror onto the actual site? This way, I could effectively uninstall Tinyportal without having to go through each little piece of coding and removing/replacing it.
Thanks.
I am still having trouble here.
Is it possible that something in line 867 is wrong? This is what's on that line:
VALUES('$artd','$artbb','$arti','$artu','$artc','$artf','$arts','$nameb','$name','$artframe','$artpp','0','$artoptions',0,0,'',0,'','',0,'$artimp')", __FILE__, __LINE__);
The error code says something about field 'shortname' however there is no shortname field in this line...
Search do work ;)
Click me (http://www.tinyportal.net/index.php?topic=22283.msg180642#msg180642)
Thanks! I'll see if this will work.
But man i'll tell you, search engines ALWAYS hate me. ;)
Quote from: darkspreader on June 02, 2008, 10:24:24 PM
Thanks! I'll see if this will work.
But man i'll tell you, search engines ALWAYS hate me. ;)
I think its the other way around. Only, you're not the only one who hates the search. ;)
I used the term "shortname" and the third topic had the answer, not really all that hard to do ;D