"subtype" has no default value error message (SMF 1.1.3, TP 0983)

[splattercaster]

The TP links are on the admin page but when I click them I get a blank page returned.

[G6Cad]

Read the sticky topic in the install board "missing admin text" or what it was named.

[splattercaster]

Yeh, I already checked that. I tried using utf8 language files and saw the TP admin links disappear, when I selected English again they returned. This doesn't affect the blank white page problem when I select a TP admin link.

If anyone needs access to the site let me know.

Oh and btw the link on your site for TP English-UTF8 is 0kb
http://www.tinyportal.net/index.php?action=tpmod;dl=item802

[IchBin]

Thanks for the heads up. I've PM'd the user about the UTF8 english files.

[splattercaster]

I tried accessing my TP admin using IE (I usually use FF) and I could see the error message..

PHP Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 1572864 bytes) in C:\*****\Sources\Load.php(1735) : eval()'d code on line 1224

I am attempting to adjust the php ini file now to increases the memory allocation, I'll let you know if it fixes the error, and if I still have the article problem.

Thanks,
Tim

[splattercaster]

OK the memory increase to 16M fixed the blank screen error.

The article problem still remains.

If I try and add a new category the site doesn't return an error but just says 'waiting for www.......' constantly and doesn't time out.

If I try and add an article in no category I get this error:

Incorrect integer value: '' for column 'category' at row 1
File: C:\*****\Sources\TPortalAdmin.php
Line: 463

If I try and add an article to a category that is already there (default from installation) they work fine.

I'm 50% further forward now (I couldn't add articles before) but it's not perfect. Any ideas what could be wrong?

Thanks,
Tim

[G6Cad]

Just to narrow out the language issue, can you set the db and the forum and tp to use iso instead of utf8 and see if it helps.
Convert the db through your admin SMF admin panel and then set the forum to use the english and not english utf8 in admin/settings

[splattercaster]

Sorry, I can't find those options.
The only language options I can see are:

Convert HTML-entities to UTF-8 characters (in Forum Maintenance - General Maintenance)

and

Default Forum Language (Server Settings - Core Configuration)

Do you have a link to instructions for this procedure or can you explain..

Thanks.

[G6Cad]

I think we have found the error, if your administration says you can convert the forum to uft8 it means the forum is running non utf when your db asks for utf8.
So please click the option about convert the forum to utf8 and see if things starts to work ok.

[splattercaster]

OK, I chose 'Convert HTML-entities to UTF-8 characters'
This option has always been there, I have clicked it a few times in the past, and it always remains after using it.

Now when I add an category it doesn't hang but I get the error  message:

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

and if I try adding an article as before I get same error.

By the way, in MySQL it says MySQL charset:  UTF-8 Unicode (utf8)
and the Collation for all tables is  latin1_swedish_ci
is this correct/normal ?

Thanks for reading my posts.