Print Page - Database Error

Title: Database Error
Post by: john421 on March 13, 2006, 11:09:59 PM

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

Title: Re: Database Error
Post by: IchBin on March 14, 2006, 03:56:21 PM

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.

Title: Re: Database Error
Post by: john421 on March 19, 2006, 05:26:58 PM

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.

Title: Re: Database Error
Post by: john421 on March 19, 2006, 05:30:35 PM

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

Title: Re: Database Error
Post by: IchBin on March 19, 2006, 05:31:34 PM

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.

Title: Re: Database Error
Post by: john421 on March 19, 2006, 05:41:03 PM

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

Title: Re: Database Error
Post by: john421 on March 19, 2006, 05:47:40 PM

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

Title: Re: Database Error
Post by: john421 on March 19, 2006, 05:56:18 PM

I think it might have to do with avatars?

Title: Re: Database Error
Post by: john421 on March 19, 2006, 06:23:11 PM

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.

TinyPortal

Development => Support => Installation => Topic started by: john421 on March 13, 2006, 11:09:59 PM