TinyPortal

Development => Support => Installation => Topic started by: Some_Person on March 10, 2006, 10:49:35 PM

Title: Errors
Post by: Some_Person on March 10, 2006, 10:49:35 PM
I get many errors like this one in TP 0.86. I use SMF 1.1 RC1.

Field 'value4' doesn't have a default value
File: C:\Program Files\Apache Group\Apache2\html\Sources\TPortalAdmin.php
Line: 321
Title: Re: Errors
Post by: G6Cad on March 11, 2006, 08:55:08 AM
If you upgrade to 1.1RC2 you should get rid of most of the errors you get.
Title: Re: Errors
Post by: TwinsX2Dad on March 13, 2006, 05:51:40 AM
Why is it every site has Some Person running around complaining?   ;D

Quote from: g6cad on March 11, 2006, 08:55:08 AM
If you upgrade to 1.1RC2 you should get rid of most of the errors you get.

True, but some others will appear. Its all free, release candidate software. Smile and be happy, while trying to work through the bugs. Until we get a full version of 1.1, I have something which might help you......

(https://www.tinyportal.net/proxy.php?request=http%3A%2F%2Fwww.killsbugsdead.com%2Fi%2Fraid_home_peglar_24.jpg&hash=057b557b8572a65fc8f195dcd4b6b7fac850ec57)
Title: Re: Errors
Post by: Some_Person on March 13, 2006, 06:49:47 AM
Upgraded to RC2, same problem.
Title: Re: Errors
Post by: TwinsX2Dad on March 13, 2006, 01:40:58 PM
Okay - what is showing in line 321 of yout TPortalAdmin.php file?
Title: Re: Errors
Post by: IchBin on March 13, 2006, 02:35:21 PM
Value4 seems to be some type of database error or something. I would run the install.php file from the manual install and see if that fills in the missing field.
Title: Re: Errors
Post by: Some_Person on March 13, 2006, 05:24:51 PM
Manual install gives the same problem. Attached is my TPortalAdmin.php. And, by the way, that error is a sample error; I get many others in the same file. Below is another one.

Field 'visible' doesn't have a default value
File: C:\Program Files\Apache Group\Apache2\html\Sources\TPortalAdmin.php
Line: 143


[attachment deleted by admin]
Title: Re: Errors
Post by: IchBin on March 13, 2006, 10:00:19 PM
You tired updating all the files and you still get these errors?
Title: Re: Errors
Post by: Some_Person on March 14, 2006, 06:49:17 AM
Yes
Title: Re: Errors
Post by: TwinsX2Dad on March 14, 2006, 06:58:40 AM
Both of the lines the error is reporting (143 & 321) contain a reference to

$tp_prefix

I have to think that at least one file was corrupted on upload.
Title: Re: Errors
Post by: Some_Person on March 14, 2006, 04:23:38 PM
But, to upload files I just copy them to the html directory in the Apache folder. How could files get corrupted?
Title: Re: Errors
Post by: IchBin on March 14, 2006, 04:44:59 PM
They can get corrupted in the download if the connection loses some packets. It's just something to help narrow down your problem.
Title: Re: Errors
Post by: Some_Person on March 14, 2006, 07:19:49 PM
Redownloaded, same problem.
Title: Re: Errors
Post by: IchBin on March 14, 2006, 07:21:47 PM
Also, have you uploaded the updated TP 0.86 files?

http://www.tinyportal.net/smf/index.php?action=tpmod;dl=item111

If this doesn't help I'm fresh out of ideas bud.
Title: Re: Errors
Post by: Some_Person on March 15, 2006, 06:50:17 AM
I uploaded those, same problem.
Title: Re: Errors
Post by: IchBin on March 15, 2006, 03:01:11 PM
Try this file and see if it fixes your problem.

[attachment deleted by admin]
Title: Re: Errors
Post by: Some_Person on March 15, 2006, 06:11:41 PM
Nope. It didn't.
Title: Re: Errors
Post by: TwinsX2Dad on March 15, 2006, 06:59:41 PM
Quote from: IchBinâââ,¬Å¾Ã,¢ on March 15, 2006, 03:01:11 PM
Try this file and see if it fixes your problem.

You didn't offer him that file? You just offered this file? You know you should always offer this file along with that file! Then, if those don't work, you still have the other file!   ;D




SP, is this error only appearing in your log or is it also causing a problem on your board? Many of us have been regularly deleting errors waiting for the gold releases of SMF.

Actually, in my case, all my errors would go away if I got rid of that stupid SMF Arcade, but........
Title: Re: Errors
Post by: Some_Person on March 15, 2006, 07:48:10 PM
I can't use TinyPortal because of those errors. And yes, I do see them.
Title: Re: Errors
Post by: john421 on March 19, 2006, 06:15:52 PM

I got the same problem.

http://www.tinyportal.net/smf/index.php?topic=3335.new#new
Title: Re: Errors
Post by: john421 on March 19, 2006, 06:23:30 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. 
Title: Re: Errors
Post by: Some_Person on April 02, 2006, 07:22:32 AM
Thanks john421. That fixed the problem!