SMF 1.1.8
TP 1.0 B3
Modified BlueSkies..
Ok, I am pretty frustrated. :tickedoff: My site www.usscalemasters.org/forums I am building, I can't get *consistent* articles. I have posted a few, in fact one which is similar to the one I am trying to construct now. It is not a difficult article, just HTML. Ok the code is an export from MS Excel, not my favorite way to generate code, but for times sake, the best way...
I have a similar article:
http://usscalemasters.org/forums/index.php/page,9.html (http://usscalemasters.org/forums/index.php/page,9.html)
When I add the new code to another article, it will disappear when I save it. I have looked around and thought I had the general problem fixed since the other article I posted a couple weeks ago worked. I click on the <> code icon, paste this code and save. I have tried to post it complete and removing the everything from the top and bottom only leaving what is between the first and last div statements... Any help would be greatly appreciated. I am almost wondering if I am running into a input text size limit? I can re save the data from excel in small chunks, and a smaller chunk will show up...
Hmmm just found out, there is to much code to post here.. I keep getting a timeout. Ok, so I have created a web page http://usscalemasters.org/forums/index.php/page,18.html (http://usscalemasters.org/forums/index.php/page,18.html) and set up the article as an external page. Not really what I wanted to do, with if that is the only way.. .then I guess that will work..
http://usscalemasters.org/forums/index.php/page,18.html (http://usscalemasters.org/forums/index.php/page,18.html)
So what I am doing wrong? :uglystupid2:
Thanks
Mitch
Are these pages created dynamically (upon each page visit) or is this just a static export from Excel saved to .HTML format?
If it is static, you could use a php article such as:
include('path/to/yourfile.htm');
Assuming you got the relative path correct from your forum directory, the file would load and you could a) bypass the editor and b) update the spreadsheet / save the new HTML file, and it would appear as such on the site, and c) not worry about article size.
No, just static pages....
Thanks I will give that a try....
The "disappear when you save it" problem sounds like the editor issue that Bloc posted a fix for quite some time ago. He attached a .js file that you can replace the existing one with to fix that issue.
http://www.tinyportal.net/index.php/topic,28788.msg229572.html#msg229572
Thanks, and I thought I had already done that. And if I take the sheet and only save a smaller portion of the file, it seems to work... that is what is confusing me...
--Mitch
Ok, I just checked, and yes I have the proper (new) .js file in place.. I thought I had already done that a while back when I was having issues like this before.. Which fixed them until now...
--Mitch
You seem to have the same problem I had using Excel to try making articles. I had to save the Excel sheet, import it into Word then have word convert it into an HTML file. Not the best way of doing things but worked for me at the time.
The site i was working on was for posting gymnastic competition scores, a lengthy process with all of the scores. It seem that an article can only hold so much info doing it that way then would time out. So, I would do it in sections, adding each section while saving until it could not hold any more. You might end up having to create multiple articles for this depending on the amount of info you have to add.
Hmmm, I haven't tried this but you might want to try converting the output to xml and see if it works better that way. Just a thought but it might require further converting and/or editing...if it will work.
If you view your tp_articles table in the database, what type of table is it?
Sorry for the delay. MyISAM is the type...
Just tried again with another article and it did the same thing.. I have it has an HTML include right now.
Another fairly long html export from MS Excell.
http://usscalemasters.org/forums/index.php/page,19.html (http://usscalemasters.org/forums/index.php/page,19.html)
MyISAM is the type...
This is also after upgrading to 1.0 B4.
--Mitch
I think you may have the same issue I had
Apps like excel and word have an auto correct feature that can change some standard ASCII chars to things you don't expect.
Eg. A double quoted string will have the quote chars replaced with something that looks more like 66 and 99 if you get my drift.
I had a non standard apostrophe char which although manger to save to the db when displayed the article was blank.
Alternatively use a freeware HTML designe, or text editor instead of the office apps
I didn't mean engine type. I meant column type. It should say text, or longtext.
Sorry Ich, I am confused, are you talking about the Row_format? which is Dynamic. If not, I'm not sure where to find that. I have looked in phpmyadmin and with the "show table status" --Mitch
OK, maybe I found how, show create table?
smf_tp_articles | CREATE TABLE `smf_tp_articles` (
`id` int(11) NOT NULL auto_increment,
`date` int(11) NOT NULL default '0',
`body` text,
`intro` text,
`useintro` tinyint(4) NOT NULL default '1',
`category` smallint(6) NOT NULL default '0',
`frontpage` tinyint(4) NOT NULL default '1',
`subject` text,
`authorID` int(11) NOT NULL default '0',
`author` text character set latin1 collate latin1_general_ci,
`frame` tinytext character set latin1 collate latin1_general_ci,
`approved` tinyint(4) NOT NULL default '1',
`off` tinyint(4) NOT NULL default '0',
`options` text character set latin1 collate latin1_general_ci,
`parse` tinyint(4) NOT NULL default '0',
`comments` tinyint(4) NOT NULL default '0',
`comments_var` text character set latin1 collate latin1_general_ci,
`views` int(11) NOT NULL default '0',
`rating` text character set latin1 collate latin1_general_ci,
`voters` text character set latin1 collate latin1_general_ci,
`ID_THEME` smallint(6) NOT NULL default '0',
`shortname` tinytext character set latin1 collate latin1_general_ci,
`sticky` tinyint(4) NOT NULL default '0',
`fileimport` text character set latin1 collate latin1_general_ci,
`topic` int(11) NOT NULL default '0',
`locked` tinyint(4) NOT NULL default '0',
`illustration` text character set latin1 collate latin1_general_ci,
`headers` text character set latin1 collate latin1_general_ci,
`type` tinytext character set latin1 collate latin1_general_ci,
`global_tag` text character set latin1 collate latin1_general_ci,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 |
That what you are looking for?
--Mitch
Yes! ok, so you need to actually click on the articles table to view that info. Next you need to edit the "body" column of this table. Change its "type" to longtext instead of text.
A "text" column can only hold 65,535 characters, where as a "longtext" 4,294,967,295 characters.