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

Recent

Welcome to TinyPortal. Please login or sign up.

Members
Stats
  • Total Posts: 196,004
  • Total Topics: 21,330
  • Online today: 2,036
  • Online ever: 8,223 (February 19, 2025, 04:35:35 AM)
Users Online
  • Users: 1
  • Guests: 367
  • Total: 368
  • @rjen

[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.