News: TinyPortal Release Schedule. Please read this update for More Info.

Login  |  Register
HTML5 Icon HTML5 Icon HTML5 Icon
TP on Social Media
Welcome, Guest. Please login or register.
Did you miss your activation email?

November 18, 2019, 08:31:43 PM

Login with username, password and session length

Recent

Members
Stats
  • Total Posts: 189259
  • Total Topics: 20772
  • Online Today: 332
  • Online Ever: 629
  • (November 08, 2018, 01:36:54 PM)
Users Online
Users: 0
Guests: 113
Total: 113

Author Topic: Database Error  (Read 3640 times)

0 Members and 1 Guest are viewing this topic.

john421

  • Guest
Database Error
« on: March 13, 2006, 04: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

Offline IchBin™

  • Developer
  • *
  • Posts: 16228
    • My Website
Re: Database Error
« Reply #1 on: March 14, 2006, 08:56:21 AM »
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

  • Guest
Re: Database Error
« Reply #2 on: March 19, 2006, 10:26:58 AM »
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

  • Guest
Re: Database Error
« Reply #3 on: March 19, 2006, 10:30:35 AM »

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

Offline IchBin™

  • Developer
  • *
  • Posts: 16228
    • My Website
Re: Database Error
« Reply #4 on: March 19, 2006, 10:31:34 AM »
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

  • Guest
Re: Database Error
« Reply #5 on: March 19, 2006, 10:41:03 AM »
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

  • Guest
Re: Database Error
« Reply #6 on: March 19, 2006, 10:47:40 AM »

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

john421

  • Guest
Re: Database Error
« Reply #7 on: March 19, 2006, 10:56:18 AM »

 I think it might have to do with avatars?

john421

  • Guest
Re: Database Error
« Reply #8 on: March 19, 2006, 11:23:11 AM »


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.