News: When asking for support, it helps us and you, if you read the Posting Guidelines

Login  |  Register
HTML5 Icon HTML5 Icon
TP on Social Media
Welcome, Guest. Please login or register.
Did you miss your activation email?

October 16, 2019, 08:27:25 PM

Login with username, password and session length

Recent

Members
  • Total Members: 3756
  • Latest: Ocean
Stats
  • Total Posts: 189087
  • Total Topics: 20763
  • Online Today: 58
  • Online Ever: 629
  • (November 08, 2018, 01:36:54 PM)
Users Online
Users: 0
Guests: 47
Total: 47

Author Topic: Articles being Chopped  (Read 10581 times)

0 Members and 1 Guest are viewing this topic.

Offline clothahump

  • Beta Tester
  • *
  • Posts: 110
Articles being Chopped
« on: February 14, 2011, 01:27:59 PM »
Link to my site: http://www.tropicalfishforums.co.uk
SMF version: SMF ver. RC5
TP version: TP ver. TinyPortal10RC1
Default Forum Language: English
Theme name and version: Default
Browser Name and Version: Firefox?
Mods installed: Not Applicable
Related Error messages: None

When adding large articles they end up getting chopped, how do I increase word count?

Offline IchBin™

  • Developer
  • *
  • Posts: 16228
    • My Website
Re: Articles being Chopped
« Reply #1 on: February 14, 2011, 05:30:45 PM »
How many characters is it allowing? You can see this in any good text editor like notepad++. TP's current table should allow over a million characters which I believe is a field type text in the database. If your upgrade didn't go properly you still might be on the old version of the table that only allowed about 65K of text.

Offline clothahump

  • Beta Tester
  • *
  • Posts: 110
Re: Articles being Chopped
« Reply #2 on: February 15, 2011, 02:12:12 AM »
40,646 according to notepad ++

Offline agent47

  • Full Member
  • ***
  • Posts: 103
Re: Articles being Chopped
« Reply #3 on: February 15, 2011, 03:41:03 AM »
I hate to go off topic but I have to ask how did you manage to make your forums quite popular. I see you have a reasonable amount of users online. Some tips on how you did this would be real nice :)

Offline clothahump

  • Beta Tester
  • *
  • Posts: 110
Re: Articles being Chopped
« Reply #4 on: February 15, 2011, 04:38:24 AM »
Quite simple, provide something which is required, be friendly and kick out any idiots that appear as soon as possible.

Offline IchBin™

  • Developer
  • *
  • Posts: 16228
    • My Website
Re: Articles being Chopped
« Reply #5 on: February 15, 2011, 11:47:19 AM »
You're going to have to look at the smf_tp_articles table in your database. Look at the body row of that table and see what the column "type" is. If it is text, edit the row and change it to longtext.

Offline clothahump

  • Beta Tester
  • *
  • Posts: 110
Re: Articles being Chopped
« Reply #6 on: February 15, 2011, 12:15:47 PM »
That did it IchBin, http://www.tropicalfishforums.co.uk/index.php?page=diyco2

One more problem.
I would like to change the order of the articles in the Article Block, I have saved it time and time again but no go.

Offline IchBin™

  • Developer
  • *
  • Posts: 16228
    • My Website
Re: Articles being Chopped
« Reply #7 on: February 15, 2011, 02:07:58 PM »
What type of article block?

Offline clothahump

  • Beta Tester
  • *
  • Posts: 110
Re: Articles being Chopped
« Reply #8 on: February 15, 2011, 02:12:26 PM »
Articles in a category.

Offline IchBin™

  • Developer
  • *
  • Posts: 16228
    • My Website
Re: Articles being Chopped
« Reply #9 on: February 16, 2011, 03:59:02 PM »
In TPortal.php find this line on about #2149
Code: [Select]
AND art.approved=1", __FILE__, __LINE__);

Change to this:
Code: [Select]
AND art.approved=1 ORDER BY art.date", __FILE__, __LINE__);

That will order them by date.