Install keeps failing on tp_upgrade.php

[webby]

I've tried every trick I know but install keeps failing with the following message:

Invalid default value for 'bar'
File: /Packages/temp/SMF2/tp_upgrade.php
Line: 324

Help!

[webby]

I solved the problem by deleting all the tp tables in MySQL.

[IchBin™]

Glad you got it sorted. I think it may have something to do with your version of MySQL or something like having it in strict mode. I'll have to do some testing and see if I can replicate the issue though.

[ladrius]

Same error.

Solved it the same way...thanks!

[IchBin™]

Same error.

Solved it the same way...thanks!

Two awesomes in one post.
1. Awesome you fixed it
2. Awesome you found it by searching!

[IchBin™]

Apparently it thinks that TP was trying to set a default value for the illustrator field in the articles table. Even though TP does not try to set any default value that I can see. Not sure what happened there for you. Maybe the table had a default value set before you dropped it somehow. That's about the only thing I can think of.

[Charles Parker]

I just upgraded from 1.17 smf with an old version of TP (can't remember which) however I had teh same issue.

BLOB/TEXT column 'illustration' can't have a default value
Line 324

Looking at the database columns (in the table 'smf_tp_articles') I found that there was a default value set to "0" and it was an int(11) data type

I changed it to a BLOB and removed the default value and set it to NULL

This allowed the installation to continue with no obvious problems.
However...
I would like to know what the correct data type is supposed to be, etc.
It worked - but if its supposed to be an Int(11)
I would like to change it back ASAP
Many thanks!

[IchBin™]

It's supposed to be a text field. Not an int. You just need to remove the default attribute so that it's not trying to set a default value anymore.

[Charles Parker]

Thanks I will change it to a text field, at one point you must have had it as an int(11) because I have never touched it prior. Its just the way I found it.
what is the default length of the text field? btw.

Thank you so much for your efforts, I am one of many who feel smf is not smf without tp
you guys (bloc, etc) are awesome

[IchBin™]

A text field is 65,535 bytes. I've noticed this with a few people. If I get a free moment, I'll have to see how that field is used, and if I need to fix the installer to update that field.