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

Recent

Welcome to TinyPortal. Please login or sign up.

Members
  • Total Members: 3,963
  • Latest: BiZaJe
Stats
  • Total Posts: 195,917
  • Total Topics: 21,308
  • Online today: 629
  • Online ever: 8,223 (February 19, 2025, 04:35:35 AM)
Users Online
  • Users: 0
  • Guests: 466
  • Total: 466

[bugtracker] Articles table, new vs upgrade, conflicting types for illustration field

Started by Resourcez, May 08, 2008, 11:34:28 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Resourcez

In a new install, the articles table illustration field is created as type "TEXT" (line 609).
`illustration` TEXT NOT NULL,

However, if your existing tp articles table is updated,  the illustration field is created as type "INT" (line 567).
mysql_query("ALTER TABLE `{$tp_prefix}articles` ADD `illustration` int NOT NULL")


This website is proudly hosted on Crocweb Cloud Website Hosting.