Add Category

[bloc]

Yes, its def. MySQL5 or PHP5 trouble. I will work out a fix for you on that pending newer versions of TP.

[ViperX]

Excellent,
Thank You!

[tcwright]

I'm receiving a similar error:

Field 'subtype' doesn't have a default value
File: [...]\Sources\TPortalAdmin.php
Line: 434

I've been searching high and low for a resolution of this issue.  I'm getting the same error except different line number (434 instead of 404).  I first received this error when upgrading from SMF 1.1.1 to 1.1.3 and from TP 0.9.7 to 0.9.8.  Below the error message was a database error indicating that I was using the database from SMF 1.1.2 and to perform a manual update to 1.1.3 to fix the problem, which I did - the database error went away but I'm still receiving the subtype error.

I then performed a fresh install reverting back to SMF 1.1.2 w/ TP 0.9.8 and still have the same issue.

I've also followed all of the recommendations from other posts (i.e. performing a manual database install, repairing the database, etc.) with no luck.  When I go in and edit the tp_variables table I see subtype, value7 and value8, and the default value is blank.  I was thinking I can go in and manually edit the default value but I'm not sure what the default value should be.

These were all fresh installs, mind you...  I'm on a Windows 2003 Server machine w/ MySQL 5.0.27-community, and PHP 5.2.0.

Any help would be appreciated.

Regards,
Tom

[ViperX]

Hi Tom,
I was also having issue as you are. Bloc mention that he thought it was a PHP or  Mysql 5.X issue, but did not mention any details. My live site is on a linux box with older versions and did not have the trouble. I was able to get past those erros in my testing by changing the appropriate TP_???  tables so that they were NOT set to "NOT NULL", which allows NULL entries.
Since there are not that many TP tables perhaps Bloc could just post the correct setting for the tables(if that is the issue). I have no idea if this could cause any other ramifications but give it a shot...

Best Regards,
John   

[tcwright]

Thanks John, I'll do that and let you know if it works or not.

[tcwright]

Hey John,

I upgraded from MySQL 5.0.27 to 5.0.45 and upgraded PHP from 5.2 to 5.3, which seemed to fix the issue, just in case this issue comes up again.  I haven't performed any extensive testing, but the Add Catagory issue is resolved.

Thanks,
Tom