looking for manual install for tp 1 beta 5

[ZarPrime]

 

OK, do you want the newest version then?  If so, uninstall the one you have and download this one and install it instead --> http://www.tinyportal.net/index.php?action=tpmod;dl=item1331

ZarPrime

[stog]

ok guess what error i got?

Code Select Expand

Database Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IFNULL(mem.realName,art.author) as realName FROM smf_tp_articles AS art
LEFT ' at line 2
File: /home/pinegr05/public_html/Sources/TPortal.php
Line: 2115

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.11, while your database is at version 1.1.2. The above error might possibly go away if you execute the latest version of upgrade.php.


been searching and find - this has been covered b4 but of course i ain't found it yet

grr

[ZarPrime]

OK, you should still be able to get to your Admin area unless you have blocks set to show in the Admin section.  If you can get there, go to the Blocks section and turn off all the blocks that are html and javascript blocks.  See if that fixes the issue.  LMK.

ZarPrime

[stog]

ok
i got into admin then searched - found the "missing" comma! put it in - all well for a while then -- same problem again - so uninstalled /re -installed -- read some more - i had given an uncategorised article a cateogory -- eeek

now i am locked out of admin

index.php?action=admin;noblocks

isn't wotrking

late here sry :"

but thx for your help

[stog]

ok added the comma to tportal again, and have got into admin, but home page still errors

am starting to turn off html js blocks - but still same error on homepage

Code Select Expand

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IFNULL(mem.realName,art.author) as realName FROM smf_tp_articles AS art
LEFT J' at line 2
File: /home/**********/fibsboard.com/user/htdocs/Sources/TPortal.php
Line: 1847

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.11, while your database is at version 1.1.2. The above error might possibly go away if you execute the latest version of upgrade.php.

[ZarPrime]

There are actually 2 lines that are missing the comma at the end of the line.  Lines 2148 and 1841 in the TPortal.php file both need the comma at the end of the line.  Have a look at this bug report --> http://www.tinyportal.net/index.php?action=bugtracker;sa=bug560

I should have remembered this.  It's only an issue with SMF 1.1.11 installs, not SMF 2.0 RC3 installs.

ZarPrime

[ZarPrime]

Also, I meant to ask you something else.  Since you are using SMF 1.1.11, did you set your Forum to the default SMF theme (theme=1) before doing the install?  That would also help to eliminate errors.

ZarPrime

[stog]

ok great that has got me my home page back

cheers

[stog]

yes but when it got frantic later on i may have 'faulted'! i got more tabs and windows open than when my cat walks on the keyboard!

[ZarPrime]

 :laugh: That's funny.  I know the feeling.  There are many times when I have 30 or 40 tabs open myself.

OK, if you've got the FP back, clear out your error log and then start turning the html and javascript blocks back on one at a time and see what happens.  Also, take it out of Maintenance Mode if you had it set on and give it a test run.  I'll stay on tonight as long as you are still working on it.

ZarPrime