MySQL 5 compatibility.

[dasnk]

Hello there, I'm using MySQL 5, I'm not sure if TP is meant to be compatible or not, But i have an error, So here I am.

TinyPortal v.0.75
SMF 1.1 RC1

The install went fine. I clicked on "Edit blocks", then "Add left block"... then got this error message:

Field 'visible' doesn't have a default value
File: C:\WWW\smf\Sources\TPortalAdmin.php
Line: 119

I'm assuming it's a mysql 5 compatibilty issue... (I have searched this site for "mysql 5" and the error text and found no relevant posts).

[Ray]

I run ver MySQL 5.0.3-beta-nt
PHP Version 5.0.5
Windows 2003 Server

Powered by SMF 1.1 RC1.
TinyPortal v.0.75 by Bloc
Amber design by Bloc

and have been runing it on this for a while now and do not have problems. Well but the ones I make

[dasnk]

Well i dunno what to do now, If it works for you on a pretty much identical set up it should be working for me, Hmm. 

[Ray]

is their any tp files that have 0bits in them?? and I guess it worked ok with just the forum installed?

[dasnk]

There's no 0 bits... Yeah it worked fine with just the forum.

I'll do a complete re-install and see how it goes (It's only a test environment).

Edit:

Well the re-install did not fix it.... here's my installation steps... (After I deleted all database and files)

Install SMF 1.1
Download the MySQL5 patch, install that.
Go to package manager install TP.
Realise it has the 0 bytes problem, Download the files and fix it.

All seems ok..

Then going to add a block gets the same database error...

The problem with inserts seems to point at some MySQL 5 issue, I guess it could be some configuration setting in MySQL. Though I see your version of MySQL5 is slightly older, mine is 5.0.16...

[dasnk]

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. 

[bloc]

Ah..MyIsam.

I thought that was enabled by default..but maybe not.