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
If you upgrade to 1.1RC2 you should get rid of most of the errors you get.
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)
Upgraded to RC2, same problem.
Okay - what is showing in line 321 of yout TPortalAdmin.php file?
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.
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]
You tired updating all the files and you still get these errors?
Yes
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.
But, to upload files I just copy them to the html directory in the Apache folder. How could files get corrupted?
They can get corrupted in the download if the connection loses some packets. It's just something to help narrow down your problem.
Redownloaded, same problem.
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.
I uploaded those, same problem.
Try this file and see if it fixes your problem.
[attachment deleted by admin]
Nope. It didn't.
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........
I can't use TinyPortal because of those errors. And yes, I do see them.
I got the same problem.
http://www.tinyportal.net/smf/index.php?topic=3335.new#new
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.
Thanks john421. That fixed the problem!