having a few slight issues with installing tp on my forum... i've searched through many threads on here and worked through a fair few issues... but im stuck on a couple that i'll go into more detail about below... i've upgraded my SMF database about 5 times... worked through the manual TP install about 3 times.. and tried just about everything else i could find on here and the SMF forums...
Link to my site: http://www.souldonsound.com/forum
SMF version: SMF 1.1.11
TP version: TP 1.4beta
Theme name and version: Default (testing), custom (eventually)
Browser Name and Version: firefox 3.0.15
Mods installed: heavily modded.. about 25 or so.. cant access admin panel to copy the list..
Related Error messages: see below
sorry to be a pain... im sure your all sick of this one by now... i read about 20 other threads that said search for this issue cause its been answered a few times... but i couldnt access past the first page of threads for some reason and couldnt find anything that wasnt shoutbox related... since i dont have a shoutbox yet i dont think thats whats causing the error.. anyway... first one is just the usual unable to load main template.. but i have no idea why this is happening... any idea's would be a great help.. im guessing you'll probably need more info than that to give any solid advice... but i have no idea where to find anymore info about it... hence asking for directions..
An Error Has Occurred!
Unable to load the 'main' template.
2nd error im getting is when trying to access the admin panel... i read in a few threads this is usually an SMF problem, which it could very well be cause it mentions smfmodules.. but the error code also mentions TPSubs.php so i figured i'd try here just incase.. i checked the manual install guide to see if it was something the first install missed but as far as i can see tpsubs.php isnt one of the files on the list..
error
Table 'nurch2_smf1.modules' doesn't exist
File: /home/nurch2/public_html/forum/Sources/TPSubs.php
Line: 108
below i've copied the block of code around line 108 from my tpsubs.php incase that helps..
function TP_addPerms()
{
global $db_prefix, $tp_prefix, $context, $scripturl, $txt, $settings;
$admperms = array('admin_forum', 'manage_permissions', 'moderate_forum', 'manage_membergroups', 'manage_bans', 'send_mail', 'edit_news', 'manage_boards', 'manage_smileys', 'manage_attachments','tp_articles','tp_blocks','tp_dlmanager','tp_settings');
$request = tp_query("SELECT permissions FROM " . $tp_prefix . "modules WHERE active=1", __FILE__, __LINE__);
if(tpdb_num_rows($request)>0)
{
while($row=tpdb_fetch_assoc($request))
{
$perms=explode(",", $row['permissions']);
$setperm=array();
for($a=0 ; $a < sizeof($perms) ; $a++)
{
$pr=explode("|",$perms[$a]);
$setperm[$pr[0]]=$pr[1];
// admin permission?
if($pr[1]==1)
$admperms[]=$pr[0];
unable to load main template - where, when, how does this happen for you. You've given no detail as to what you are doing.
modules' doesn't exist - does a modules table exist in your database?
haha.. sorry.. that may be useful info to include... i've been trying to fix this for about 10 hours now so my brain is kinda fried..
the main template issue is on the home page.. as soon as you open the forum its there... im running the default theme at the moment... but the forum is set to a custom theme and my admin panel is broken since installing tp so i cant change it to default... so if you check the link you'll get the custom theme unfortunately.. im happy to PM you my login details to access the default theme if it helps though..
also the "forum" button isnt showing on the default theme on most pages... it works on some though.. like if i click the admin panel.. i get the modules error.. .but the forum button appears.. but it doesnt show on the home page, profiles, usual forum pages etc..
as for the modules table... i have no idea what that is or where to start looking... i have a fairly strong HTML background but php is all new to me.. only bought this site about 6 months ago... how would i go about finding out if i do or not? and if i dont have em... how would i get em?
Quote from: G6 on September 21, 2009, 07:41:29 PM
If you have a backup of your forum before you installed TP the first time, you can simply add that and then install TP V0983, if not, you have to eather manually remove all the TP code from the files ( source files ) with help of our docs to get a clean SMF source base again, or download the big upgrade package from SMF and replace all your old files with new ones, remember that the last step will remove ALL mods you might have installed.
will this effect any boards, topics, posts or members? i'd be happy to clean out the themes too actually...
if that will give me a clean slate for design/modding.. but keeps all the info.. which files do i need to replace?
this forums been heavily modded for about 5 years now so its riddled with bugs... starting over would be much easier... but theres 5 years worth of info, and 6000 members i wouldnt mind hanging on to if possible..
First off, make sure you have a back-up.
Then using the big upgrade package, overwrite all the existing SMF files, rename the existing web directory, and create a new one containing a fresh copy of the files.
You should now have a nice clean install of the SMF files, and you should have a basic forum working again with no mods.
Once you've done that, then I'd start installing the mods, and finally get your custom themes back working again.
is there another way to backup the database if my admin panel is down? like through phpmyadmin or something? again im not overly familiar with phpmyadmin but i was just reading you can work with that for restoring n such..
phpmyadmin has a size limit on what it can back-up/restore.
Do you have command line (Shell/SSH/Telnet) access?
Most reliable method for doing back-ups/restores is via the command line.
yeah i do... i think... theres 'ssh/shell access' in my cpanel.. which lets me manage keys... i think im gonna have to do some reading to learn what that is though.. haha.. i have no idea what any of that means..
If you have CPanel, you likely have the Backup Wizard. Actually, I prefer just using Backup and selecting a partial MySQL Database backup of the database in question.
ahh excellent... thats a very simple method... thank you..
i'll give all this a try and let ya know how it goes... cheers for all the help yet again!
CPanel is another option.
SSH is the easiest option, but only if you know how to use a command line prompt.
You'll need a telnet client (PuTTy is the most common), and some basic knowledge of command line commands.
If you have a large database, then back-ups via SSH is the best way to go.
yeah its just over a gig... but im not at all familar with command lines or anything so i'll give this a try first..
fingers crossed..
I doubt if cpanel will handle a back-up that big.
The command you'll need for the back-up is mysqldump.
http://articles.sitepoint.com/article/backing-up-mysqldump is as good a guide as any, however I use the shortcut version for the options.
For example -
mysqldump --opt -Q -u myusername -p mydatabasename > directory/whereIwant/myfiletobedumped/mydbdumpfile.sql
By omitting the actual password at the intial command, you'll then be prompted for it, which saves it being visibly displayed on screen.
Also, once you've managed to create the dump file, you'll want to compress it before you try downloading it (gzip or bzip2 if you're on linux)
For a summary of generic command line commands, I find www.computerhope.com/unix.htm a good reference
uniektekniek,
If you want to remove all your Mods, the best way to do it is detailed in this guide written by Lord Anubis ...
http://www.tinyportal.net/index.php?topic=27943.0
This method will remove all of your currently installed Mods, including TinyPortal, and give your Forum a "Fresh Start" so to speak. Before doing this, make sure that you have completed a backup of your database and set your Forum to the default SMF theme. In this case, I would also recommend that you make a backup on your local computer of the contents of your SMF install folder.
Also, you should be able to find out what Mods you currently have installed by downloading and viewing a file called "installed.list" which is located in the /Packages/ folder of your SMF install.
Once you have completed the steps called for in the guide, with your Forum still set to the default SMF theme, begin installing the Mods you want back in one at a time, beginning with TP. Make sure that any old Mods you decide to put back in have been approved for use with SMF 1.1.11.
ZarPrime