Database Error

[john421]

Help can't add any blocks or New category
New install


Database Error
Field 'visible' doesn't have a default value
File: C:\Apache\Apache2\htdocs\forum\Sources\TPortalAdmin.php
Line: 143 



http://localhost/forum/index.php?action=tpadmin;sa=settings 
8: Undefined index: theme_version
File: C:\Apache\Apache2\htdocs\forum\Sources\TPortalAdmin.php
Line: 62


Using

SMF 1.0.6.
TinyPortal v0.8.6
Mysql  5.0
Apache 2.0
PHP 5

[IchBin]

Seems some TP files may be incomplete or corrupted. That would be my only guess at this time. Try uploading the TP files manually from the "Files Only" package in the downloads.

[john421]

Do I need to un zip them?
When I try it with package manager I get this:
An Error Has Occurred!
The package you tried to upload either is not a valid package or has become corrupted. 

[john421]

When I unpack the files and use the manual_tp_install.php I get this:

Warning: require(Settings.php) [function.require]: failed to open stream: No such file or directory in C:\Apache\Apache2\htdocs\forums\filesonly\manual_tp_install.php on line 5

Fatal error: require() [function.require]: Failed opening required 'Settings.php' (include_path='.;C:\php5\pear') in C:\Apache\Apache2\htdocs\forums\filesonly\manual_tp_install.php on line 5

[IchBin]

Yes, with the "Files Only" package you need to unzip, and then upload  or copy them overwritting the files.

Run the install file in the root of your forum and see if that helps.

[john421]

Ok that installed

Install / Upgrade TinyPortal v0.8.6beta
Upshrink table exists
Settings table exists
Reset theme changer
Updated version to 086
Blocks table exists
Variables table exists
Articles table exists
Dlmanager table exists
TinyPortalÂÃ,´s table structure is now installed/updated.

--------------------------------------------------------------------------------
Thank you for trying out TinyPortal.

But I still get the same error

Field 'visible' doesn't have a default value
File: C:\Apache\Apache2\htdocs\forums\Sources\TPortalAdmin.php
Line: 143

[john421]

Is there a way to check value4 ? What is it?

[john421]

I think it might have to do with avatars?

[john421]

This might help others but not me....


http://www.tinyportal.net/smf/index.php?topic=1586.msg12947#msg12947

Ok I fixed it... Here's what I did..

Downlaod the MySQL Administrator tool from MySQL.com.
Connect to SQL sever with it..
Go to StartUp Variables -> General Parameters -> Set Default Storage to MyIsam
then go to Advanced -> Check use ANSI SQL

Restart the MySQL Server, Works.