[TP 1.0 Beta 5-1] Editing and saving Articles

[Freddy]

When I used your text file in an HTML article it also cut it short.  Went to look at the HTML again via TP admin and found the end was chopped off.

Do you know anything about the mysql database ?

If you look at the structure of the tp_articles table you will find the field 'body' which holds the data is set to 'text'.  This means it will only accept 65535 characters.

What you could try is changing the 'body' field to 'longtext'.

[Rafferty]

I had a look for this but can't find it.  I found the tp_articles table and the field body however the fields were individually set for each article populated by the html code.

At the risk of appearing rude, and I don't mean to be, TP has really got harder and harder to use over the years I have been using it.  I have been looking at other portals which seem much easier to use.  I have read comments from other TP users at these forums stating the same, that TP is becoming harder to use and their looking for something easier.   

The only issue I have is the article system which is getting almost impossible to use. 

[bloc]

Yes, TP have become more complex over the years, no question of that. I like to think that it is also capable of more things now than before. But if you need just some extra pages in SMF and the occasional block or two along with it, why use something like TP then? I would then rather recommend you to indeed use other solutions.

You may think this is strange - to sort of "drive people away" from TP - but its really very simple: I have a dream about how to expand SMF to a portal/small CMS, and thats what TP is doing. If then 100 or 10.000 people like it, doesn't worry me too much, because I am staying true to that dream. As it happens also many others seem to prefer its increased complexity, including the TP team here(though I can tell you they had a big part of deciding in what has gone into TP and what has not), so I persevere to clean it up and improve it. Because its far from "perfect" in regards to bugs and optimisation lol. But overall I feel its doing its thing.

The only things I am unsatisfied atm with are the lack of good themeing of TP templates + speed and resource use. Its a bit heavy on that.

[ZarPrime]

Rafferty,

Can you look at this page on my test site --> http://talesofthehavenexpanse.com/smf2test/index.php?page=rafferty

I am interested in knowing whether this is what it's supposed to look like, or if something seems to be missing.  I took the code you attached to this post --> http://www.tinyportal.net/index.php?topic=32404.msg260766#msg260766

... and pasted it into an html article.

ZarPrime

[m771401]

ZarPrime,

There seems to be a couple of people having this problem now. I think it's great that it works on your site. I wish it worked on mine but it doesn't.
This topic and the other two probably could be merged now since they are detailing the same problem with the editor/article system not handling special characters.

[NCKerm]

The only things I am unsatisfied atm with are the lack of good themeing of TP templates + speed and resource use. Its a bit heavy on that.

Iââ,¬â,,¢m not going to complain because I already solved my problem, but I decided to tell my story just to let you know. Upgrading from SMF1+TP0.98 to SMF2+TP1 completely killed my server. While before the upgrade I was able to serve up to 1500 users online (according to the ?action=who, timeout=15 mins) before all thing began to slow down, then after upgrade I was barely able to serve 400 users.
First day I spent tweaking apache, nginx, mysql and accelerators. Without result, I still was running out of RAM and CPU. On second day I rent a new server and the problem gone. Now its all running very smooth.. on a hardware that just a week ago I would call complete overkill.
One more time, Iââ,¬â,,¢m not complaining. I know that it is beta and such.

[Rafferty]

Rafferty,

Can you look at this page on my test site --> http://talesofthehavenexpanse.com/smf2test/index.php?page=rafferty

I am interested in knowing whether this is what it's supposed to look like, or if something seems to be missing.  I took the code you attached to this post --> http://www.tinyportal.net/index.php?topic=32404.msg260766#msg260766

... and pasted it into an html article.

ZarPrime

Thanks for your trouble ZarPrime, yes that pretty much how it needs to be with the exception of some of the text format has changed and one missing line, the last line, however it doesnt display like that on mine.  As explained before Im only getting half of the length of the article showing.

To Bloc, yes Bloc and I have appreciated all efforts put into TP by yourself and others and like other users have watched it grow.  I ve enjoyed playing with all the new features and for the most part I love it.  Its a shame I cant say the same for the Article system. It seems to have been plagued with problems for a long time now and for lamen like me, increasingly hard to operate.  I am also very upset at losing our list of deceased Veterans which has been 2 years in the making.  I used an article to produce a Chapel Type theme surrounding the names of our dead comrades, frequently adding to it as another one passes.  As explained previously, I have lost most of that with my last attempted edit using the built in editor.  But we live and learn, after all its a beta and was my risk.  Ill start that again, its very important to us that these patriots be remembered.  Thanks again for all your help guys, just a reminder that we are all real people out here and our forums are very important to us and at times rely on your help.  Keep up the great work.   

[Freddy]

Rafferty...

Do you have any old backups of your database ?  If you have then most of what you lost will be in those.  You just need to use phpmyadmin and find the article in the database.  Copy it out and reuse it again.

[Rafferty]

Thanks for that Freddy, Yes I have kept all backups however Im extremely nervous playing with the databases but I guess its time to start if its going to save me another 2 years.  Fact is Ive left it well alone so far and wouldnt know where to start.  On the odd occasion Ive needed something my host as done it for me. Trouble is, If I restore it and go to edit it again the same thing will happen unless i just use the data to restore the names and find some other way to display it to the guys. 

Off topic slightly, Ive just noticed an error on the bottom of my new articles under the Comments box, as in the attached screen shot. I dion't know what this means. "
Not Defined Yet Not Defined Yet Not Defined Yet Not Defined Yet Not Defined Yet "

[Freddy]

Well it's a little more involved than what I said.  The way I would probably do it is create a new (ie separate) database temporarily and import one of the backups into it.  Then I would track down the article from there.  Then you can just remove the temporary database when you are done.

The 'phpMyAdmin' software takes some figuring out.  If you want to send me the last back up you did (the sql file) then if you gave me an idea of what was in the article then I could probably extract it for you.