Hi everyone, after installing TP I can no longer access my SMF site. I have listed out steps I have taken installing smf and TP below and also info on my setup environment .
-Installed SMF without any problems.
-Downloaded TP to my pc
-Uploaded TP to server using SMF admin panel /packages
-Applied MOD and saw that all tests are successful
-TP Install stated that it installed successfuly
-Clicked Home to test if TP installed correctly but I got a blank page. Tried all other links but nothing is accessable.
-Checked the files to see if TP applied changes stated in Manual install doc and confirmed all the changes have been applied.
-Also checked the database and saw TP related entries there.
I have tried above steps twice but the result is same. I checked the forums here, read TP docs/faq but nothing I found to indicate what the problem is.
Could you please help me out what I am missing here...Thanks in advance...
My setup environment:
-------------------------------------------------
SMF version: 1.1.5
TP version: TP 1.0.5 Beta1
Theme name and version: SMF Default Theme - Core
Mods installed: NONE
Related Error messages: Site is completely inaccessable.
PHP version: 4.3.8
MySQL version: 3.23.58
Server version: Apache/1.3.31 (Unix) mod_python/2.7.10 Python/2.2.2 mod_webapp/1.2.0-dev mod_perl/1.29 mod_throttle/3.1.2 PHP/4.3.8 FrontPage/5.0.2.2510 mod_ssl/2.8.18 OpenSSL/0.9.7d
GD version: bundled (2.0.23 compatible)
Can you give URL for site, see what happens form another PC etc.
when you say "blank page" are you seeing anything at all? any error messages etc
cheers
Thanks grabman, there are no error messages. It is completely blank. I will pm you the url....
If you post URL here, others can see it and offer ideas as well.
I looked at site, from PM, didn't show for me either although I do notice that you have a phpBB site running on root URL. Have you made sure that isn't masking new site? Do they have separate DB's etc?
Can you still log in as admin? maybe try and then check error logs etc.
Grab
thanks for the advice grab. Sorry for not posting the url as I am little paranoid during the installation time while running a phpbb board nearby ;). Typical noob I am...aint I?
I have also tried from another pc with different IP to access the site anticipating browser cache problems but it is still the same. So I believe this confirms that the problem is with the site.
Phpbb board has never been an issue because I was able to install and run several forums including the current smf board on seperate directories and databases. This problem only happens right after installing TP on a brand new smf board without any mods or changes in settings . If I restore the files TP has backed up during the installation via ftp, smf then works just fine.
Under these circumstances, only logical conclusion is that the problem is TP related. I am completely clueless at this point and would appreciate all the help I can get.
PS: I can't login via admin as site doesn't show up at all...
You need to first get SMF working again, then check the error log to possibly see where its being halted. The quickest way to do that is to upload the upgrade package of SMF 1.1.5 and overwrite files. It will wipe TP modifications, but not the TP data. Then you can access the errorlog.
thanks bloc, I will do as you suggested. btw, is there anyway I can access the log via ftp?
I accessed smf admin panel after restoring the files that tp backed up during installation.
There are several hundreds pages of following error in smf forum error logs:
http://www.xxxx.com/smf/index.php?action=admin
Database Error: Table 'smftest.smf_tp_modules' doesn't exist
File: /usr/local/psa/home/vhosts/xxxxx.com/httpdocs/smf/Sources/TPSubs.php
Line: 168
I have no idea what these errors mean but I checked out database and could not found aabove table in the database. There are only six tables created by TP and they are:
smf_tp_articles
smf_tp_blocks
smf_tp_data
smf_tp_dlmanager
smf_tp_settings
smf_tp_variables
The error means you probably installed TP manualluy, and didnt run the database setup through the browser.
If you did the install through the package manager, you must have had som error as it halted on the db upgrade process.
Now when you have done the replacement of the SMF files, try and install TP again and see if it works better, if not, you will have to install manually.
This will guide you.
How do I manually install TinyPortal (http://docs.tinyportal.co.uk/index.php?topic=29)
Modification Instructions (http://docs.tinyportal.co.uk/index.php?topic=140)
thanks G6, I installed TP using smf package installer but installer did not give me any errors. In fact, it stated that TP installed successfully at the end of installation. I will try to re-install it as you suggested or go for manual install and let you know the results...
Thanks again...
I deleted previous setup of smf including the database. Downloaded a new set of smf and TP packages to eliminate the possibility of previous set being bad. Smf and TP (through package manager) installation went fine without any errors. (TP Install log below)
Checked out the database and confirmed that all the TP related tables are created except "Modules Table" (note that TP installation log states that it created "modules table")
Unfortunately manual installation has the same problem. When I run manual_tp_install.php, install log also states that it created the "Modules Table" but it is missing from the database.
Any ideas why TP fails to complete database update and misses out "Modules Table"? Thanks...
Install/Upgrade v1.0.5 beta 1©2004-2008
--------------------------------------------------------------------------------
Upshrink table created
Settings table created
Settings table updated
Added 108 new setting(s)
Blocks table created.
some sample values were added to the blocks table
Variables table created.
some sample values were added to the variables table
Articles table created.
DL manager table created
Modules table created
TinyPortal´s table structure is now installed/updated.
--------------------------------------------------------------------------------
Thank you for trying out TinyPortal!
made following change in manual_tp_install.php - line 756 (tp_install.php - line 742)
old
) ENGINE=MyISAM;
new
) TYPE = MYISAM;
I run the sql command to create the table manually and it worked. I can now see TP installed correctly, though I have no idea if this change I made is right or wrong.
It is indeed a difference there, as different versions of MySQL can't read one of those words. I'll will be changing that so it works everywhere.
Thanks Bloc. Btw, TinyPortal is awesome. I appreciate your hard work.
cheers!
:) And thanks for pointing out the error there, I see its only apparant in modules table creation, but nonetheless very important. Fixed for TP 1.0.5 beta2