How Many Tables During Instalation??

[eagle1468]

How Many ***_tp_**** Tables are there supposed to be after installation?

I only have 7 Tables and they are

***_tp_articles
***_tp_blocks
***_tp_data
***_tp_dlmanager
***_tp_settings
***_tp_shoutbox
***_tp_variables

Is there a table(s) missing??

I ask this because I am tying to fix the Error:

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

In TPortalAdmin.php at Line 404 it reads:

Code Select Expand

db_query("INSERT INTO {$tp_prefix}variables (value1,value2,value3,type,value4,value5) VALUES('$catn','$catp','','category','',0)", __FILE__, __LINE__);

Could Someone Please HELP!!!

I had another problem but I fixed it (with Articles)
1. The Error:

Field 'shortname' doesn't have a default value
File: C:\Program Files\*****\Sources\TPortalAdmin.php
Line: 463

I changed the database table to reflect "Null" not "Not Null"

2. Then received error

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

I changed $artc to 0 This fixed all problems with adding articles but I need help with categories now!

Thank you in advance for you Help!!!!

[eagle1468]

   :up: OK I fixed the Category Problem -- with living with 1 option OFF!
For those of you who may want to know!

I modified the Database under ***_tp_variables
I set:
subtype to NULL
Value 7 to NULL
Value 8 to NULL

This allows creation Moving and Deleting to all Categories. The only thing your unable to do is -- in the Add Category page there is only 1 Sub Type and that is NONE no matter how many Categories are on the site.

However, if you want to set SubType for the new category, just go to the Categories page Set as sub-category of: ?

There your all done!!
And Look I fixed my own Problem I'm so proud of myself
Yes, there is probably a neater way to fix this but upgrading DB's sure didn't help!! :coolsmiley:

[darkspreader]

I, too, am receiving these errors, however, to fix the articles problem, where specifically did you set the "database table to Null" instead of Not Null? I was able to change the $artc to 0, but I still need to do that first part, and I don't really know where to do it.

Thanks in advance.

[IchBin]

In his post, he specifically states that its the tp_variables table. And then tells you the 3 columns that you need to change. Take a read again and then look at your table.

[darkspreader]

I understand that part, but I don't get the part in his first post.

I changed the database table to reflect "Null" not "Not Null"

[G6Cad]

Read it a few times more and you will see what he said.

The table at default is "not null", it should be set to NULL

[darkspreader]

What aspect of the table do I change? There is no magic button in phpmyadmin to "change the table to null."

[JPDeni]

Looks to me that you need to change the shortname field in tp_articles.

He said:

Field 'shortname' doesn't have a default value

Actually, I would make sure that all the fields in tp_articles are set to Not Null.

[darkspreader]

Thanks. It makes a lot more sense now.