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:
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:
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.
You must make sure you have all the articles inside categories
Yes I know, I am unable to add any category though as I get the following error:
Field 'subtype' doesn't have a default value
File: ...\SMF\Sources\TPortalAdmin.php
Line: 404
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 :)
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:
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:
Field 'shortname' doesn't have a default value
File: ...\SMF\Sources\TPortalAdmin.php
Line: 463
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
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.
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 ?
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
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.
Upshrink table exists
Settings table exists
Updated version to 098
Blocks table exists
Changed pos in blocks table
Changed pos in blocks table
Variables table exists
Changed value5 in variables table
Articles table exists
Updated body in articles table
DL manager table exists
Shoutbox table exists
UTF-8 setting is found.
Converted articles table for utf-8
Converted settings table for utf-8
Converted blocks table for utf-8
Converted variables table for utf-8
Converted dlmanager table for utf-8
TinyPortal´s table structure is now installed/updated.
I think this it this is okay, correct me if wrong though.
Edit: Reckon it's properly connected to the database?
Seems ok yes.
Do you get this error using the default core theme to ?
Yes, I'm getting the same errors.
Have you got any idea why I'm getting the 500 error when I try to install tinyportal using the packages manager?
File permission issues usually causes 500 server errors.
I think it might be the cause to your error to.
The files cant be read probably.
You need to contact your host and ask them to check this issue for you.
Well, that's the problem. I'm my own host and I've set all permissions open.
Because I was thinking, if we could solve this 500 error I could uninstall Tinyportal and install it the normal way via the packages manager.
Dunno what server software your using, but i think you could google on your 500 internal server errros and find some solution on the web server sites.
Hmm, really annoying :p
Anyway, I'll figure something out eventually. Thanks for the help, I'll post again if I've fixed it somehow.
Okay, so I've found the problem after editing the TTL.
After enabling error reports (wasn't too happy to do this for security reasons) to show up, I found out that it was as easy as pie. The server simply didn't have enough memory left...
Ah well, thanks for the efford you've put into this. Finally a support team that accually thinks with you.
Im glad you found out the cause, and for posting up for others to read.
More memory on the server ? Memory allocation or the overall installed memory inside the serverbox ?
If it's allocation, you should be able to set that to a higher value in the php.ini file
Even though the initial problem with the manual install has not been solved, I should have this portal up soon.
Also, yes I've set the value high enough but it doesn't help if there's no more memory to allocate :)
Okay, I was finally able to install the portal using the package manager on a fresh forum.
I thought this would fix the problem because I still might have dome something wrong during the manual install.
Now the initial problem, explained in the first post, happens again.
Still the same database errors while it has full permissions, enough memory ect.
QuoteOkay, I was finally able to install the portal using the package manager on a fresh forum.
I need to know *exactly* what steps you went through in order to be able to figure out where the problem is. Also, I need to know *exactly* what mods were installed in the database you are trying to upload.
In the meantime, here's something that may or may not apply to your situation... From what you have said, you have installed TP1.05 on your "live" site. And you want to import the database from the live site into a test site which has TP.98 on it. This will not work.
Go into phpMyAdmin and install the database from your live site into another database. Delete all of the tables that TP uses. If you used the default naming convention, they should start with
smf_tp_. You might want to copy text or code that you already have in blocks or articles and paste them into a text editor to use later, but you will not be able to use the tables from 1.05 with a .98 installation. It will not work.
Now export this new database into an sql file.
Install (once more!) SMF. Import the new database that you just created. Test. If it works (it should), install TP. Test. Install other mods. Test. Test. Test. Create new articles and blocks, using the code you saved before you deleted the TP tables from the other database. Test.
At this point you can delete that other temporary database that you created, as well as the sql file. You won't need them again.
Then again, maybe I'm completely misunderstanding what is going on. If so, I need every detail of what's going on. As Denzel Washington's character said in
Philadelphia, "Explain it to me like I was a three-year-old." ;)
Okay, hey.
You did misunderstood me completely :p . Thanks for the efford you've put into posting this up thought.
As I saw the problem again after a succesfull install using the packages manager, I decided to create a fresh forum, fresh database ect. so there where no other mods/themes/templates or anything else present when this problem happened again.
To recreate this problem simply install a TP0.98 on a SMF 1.1.5 board using the packages manager. Then try to add a category I get the following error:
Field 'subtype' doesn't have a default value
File: ...\SMF115a\Sources\TPortalAdmin.php
Line: 404
When I try to add an article to one of the existing (demo) categories:
Field 'shortname' doesn't have a default value
File: ...\SMF115a\Sources\TPortalAdmin.php
Line: 463
Though the downloads settings and blocks manager are working perfectly fine at every aspect.
I've been having exact same errors on the TP1.05 version I have installed on my other test board.
What is your server software spec ? What have you installed to run your own host ?
This has something to do with your MySQL version. I'm not sure what, but I'm pretty sure thats what the cause is.
Quote from: G6 on June 28, 2008, 10:18:44 PM
What is your server software spec ? What have you installed to run your own host ?
Prepair for a huge list if I was ever going to post all that here.
To IchBin, reckon installing MySQL 5.0 or 5.1 on another (virtual) server and directing another fresh forum plus TP to that would solve the problem?
You could try that. Although, not knowing what is causing the problem it could be a simple configuration problem.