Link to my site: http://www.epu-wow.com
SMF version: 1.1.8
TP version: 1.0.3 Beta 3
Theme name and version: Urban by Dzinerstudio
Mods installed:
1. Pretty URLs Extras 0.9 [ Uninstall ] [ List Files ] [ Delete ]
2. Move Old Topics 1.0 [ Uninstall ] [ List Files ] [ Delete ]
3. Separate Sticky and Normal Topic 1.0 [ Uninstall ] [ List Files ] [ Delete ]
4. Advanced Contact Form 1.1 [ Uninstall ] [ List Files ] [ Delete ]
5. SMF Gallery Pro 1.4.5 [ Uninstall ] [ List Files ] [ Delete ]
6. MCLegendII.2 3.0 [ Uninstall ] [ List Files ] [ Delete ]
7. TinyPortal 1.075 [ Uninstall ] [ List Files ] [ Delete ]
8. Regular smileys to dark background smiley set 1.0 [ Uninstall ] [ List Files ] [ Delete ]
9. BBC Blizzard Quote Tag 1.0.3 [ Uninstall ] [ List Files ] [ Delete ]
10. SMF 1.0.15 / 1.1.7 Update 1.0 [ List Files ] [ Delete ]
11. SMF 1.0.14 / 1.1.6 Update 1.0 [ List Files ] [ Delete ]
12. Aeva ~ Auto-Embed Video & Audio 5.2.56 [ List Files ] [ Delete ]
13. Internal_Links_Use_Same_Window 1.2 [ Uninstall ] [ List Files ] [ Delete ]
14. Googlebot & Spiders Mod 2.0.4 [ Uninstall ] [ List Files ] [ Delete ]
15. [HTML] Permission Mod 1.01 [ Uninstall ] [ List Files ] [ Delete ]
16. No Spam by Guests! 0.2 [ Uninstall ] [ List Files ] [ Delete ]
17. Perfect Smiley Set 1.0 [ Uninstall ] [ List Files ] [ Delete ]
18. TinyPortal 1.063 [ List Files ] [ Delete ]
19. vBulletin Style Meta Tags 1.1 [ Uninstall ] [ List Files ] [ Delete ]
20. Visual Verification Options 0.5.2 [ Uninstall ] [ List Files ] [ Delete ]
21. RSS Feed Icon 1.1 [ Uninstall ] [ List Files ] [ Delete ]
22. Aeva ~ Auto-Embed Video & Audio 6.2.75 [ Uninstall ] [ List Files ] [ Delete ]
23. SMF 1.0.13 / 1.1.5 / 2.0 b3.1 Update 1.0 [ List Files ] [ Delete ]
24. SMF 1.0.16 / 1.1.8 Update 1.0 [ Uninstall ] [ List Files ] [ Delete ]
25. Regular smileys to dark background smiley set 1.0 [ Uninstall ] [ List Files ] [ Delete ]
26. SMF Media Gallery 1.5.5 [ Uninstall ] [ List Files ] [ Delete ]
27. User Control Panel By Alan S 2.0 [ Apply Mod ] [ List Files ] [ Delete ]
28. Highslide Image Viewer 1.0 [ Uninstall ] [ List Files ] [ Delete ]
29. Pretty URLs 0.9.1 [ Uninstall ] [ List Files ] [ Delete ]
30. SMF Secure Login 1.0.4a [ Uninstall ] [ List Files ] [ Delete ]
31. Spoiler Tag 0.6 [ Uninstall ] [ List Files ] [ Delete ]
32. reCAPTCHA for SMF 0.9.5.3 [ Uninstall ] [ List Files ] [ Delete ]
33. AjaxChat Integration 3.0 [ Apply Mod ] [ List Files ] [ Delete ]
34. Hide Info Center From Guests 1.0 [ Uninstall ] [ List Files ] [ Delete ]
Related Error messages: No error messages
I'm gonna refresh the files of my SMF installation so i will uninstall most of the mods and re-install only the ones needed.
Problem with TP installation which i wanna avoid is the Article length, currently my article is set for Longtext and i have many articles that exceed the default length which is set to Tinytext or text, i dont remember which one is it exactly.
So in the case which i dont change it in the sql installation of TP to longtext most of my articles will get limited to the default char length.
Question is what do i have to change and where to have the installation not change to default length and keep it as Longtext.
In the tp_install.php file you can find the section where the articles table is created. There's a big if statement that verifies all the columns in the table. The else statement creates the table.
else{
// attempt to create it then
$rq4=mysql_query("CREATE TABLE IF NOT EXISTS `{$tp_prefix}articles` (
`id` int(11) NOT NULL auto_increment,
`date` int(11) NOT NULL default '0',
`body` longtext NULL,
`intro` text NULL,
`useintro` tinyint(4) NOT NULL default '1',
`category` smallint(6) NOT NULL default '0',
`frontpage` tinyint(4) NOT NULL default '1',
`subject` text NULL,
`authorID` int(11) NOT NULL default '0',
`author` text NULL,
`frame` tinytext NULL,
`approved` tinyint default '1' NOT NULL,
`off` tinyint default '0' NOT NULL,
`options` text NULL,
`parse` tinyint default '0' NOT NULL,
`comments` tinyint default '0' NOT NULL,
`comments_var` text NULL,
`views` int default '0' NOT NULL,
`rating` text NULL,
`voters` text NULL,
`ID_THEME` smallint(6) default '0' NOT NULL,
`shortname` tinytext NULL,
`sticky` TINYINT default '0' NOT NULL ,
`fileimport` TEXT NULL,
`topic` INT default '0' NOT NULL,
`locked` TINYINT default '0' NOT NULL,
`illustration` TEXT NULL,
`headers` TEXT NULL,
`type` TINYTEXT NULL,
`global_tag` TEXT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2;");
$render .='<span>Articles table created.</span><br />';
You can change the body part of the article to be anything you want. However, TP 1 has changed it to use longtext already.
Im gonna try and save the code of the articles just in case because im certainly sure that i had to do it manually when i installed Beta 3, changing to Longtext that is.
Thanks for the reply tho ::)
That's probably a good idea. All backups are a good idea. I think, though, that, if the table already exists, the whole table creation thing is skipped, so nothing would change.