TP-Docs
HTML5 Icon HTML5 Icon HTML5 Icon
TP on Social Media

Recent

Welcome to TinyPortal. Please login or sign up.

March 28, 2024, 09:13:38 AM

Login with username, password and session length
Members
Stats
  • Total Posts: 195,104
  • Total Topics: 21,212
  • Online today: 212
  • Online ever: 3,540 (September 03, 2022, 01:38:54 AM)
Users Online
  • Users: 0
  • Guests: 119
  • Total: 119

Install keeps failing on tp_upgrade.php

Started by webby, August 25, 2012, 10:53:31 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

webby

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

QuoteInvalid 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

Quote from: ladrius on October 08, 2012, 08:20:28 PM
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! :D

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.
QuoteBLOB/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.