TinyPortal

Development => Support => Topic started by: clothahump on October 26, 2009, 09:36:14 PM

Title: Unable to access Admin
Post by: clothahump on October 26, 2009, 09:36:14 PM
Thought it better I start a new thread.

Link to my site: http://www.tropicalfishforums.co.uk
SMF version: SMF ver. 1.1.10
TP version: TP ver. v1.0 beta 4
Theme name and version: Siradisi
Browser Name and Version: Firefox latest
Mods installed: SMF Media Gallery 2.0, Redimensionner les images
Related Error messages: None

When I try to access the admin panel I am prompted for password, when filled in I click to enter and it refreshes to same page, only way around the problem is to log out and back in, it will then allow me access for about 30 minutes then does the same again.
Should I uninstall TP and my custom theme and start again?
Title: Re: Unable to access Admin
Post by: G6Cad on October 26, 2009, 10:25:16 PM
I think that would be the best yes
Start with the big upgrade over at SMF forums, when everything works there, then add your mods, and after that, your custom themes.

Login issues are not really our department as it's SMF function.
Title: Re: Unable to access Admin
Post by: IchBin on October 26, 2009, 11:27:48 PM
Make sure your login problem is gone when you reinstall SMF. Don't install TP until you can verify that your problem has went away.
Title: Re: Unable to access Admin
Post by: clothahump on October 26, 2009, 11:32:25 PM
I have only just installed SMF 1.1.10 but the admin panel stated I had old files so I needed to do the large upgrade, this failed with error and now I am unable to get into admin to turn forums back on.

This query:

   ALTER TABLE smf_smileys
   ORDER BY LENGTH(code) DESC;

Caused the 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 'LENGTH(code) DESC' at line 2

Tried the fix at SMF but still no joy, I give up.
Title: Re: Unable to access Admin
Post by: bloc on October 27, 2009, 07:51:44 AM
The fix..was that to change the "upgrade.php" file where "ORDER BY LENGTH(code) DESC" was changed to "ORDER BY code DESC"?

If so, it should work.
Title: Re: Unable to access Admin
Post by: clothahump on October 27, 2009, 07:54:57 AM
Yep, did that Bloc and it worked, admin still says files are out of date/wrong versions but it all seems to be working so best left alone.
Title: Re: Unable to access Admin
Post by: clothahump on October 27, 2009, 05:02:07 PM
Before I begin un-installing stuff one question, should the link in the menu link to the original admin or should it point at tp admin???
Title: Re: Unable to access Admin
Post by: ZarPrime on October 27, 2009, 05:04:22 PM
To the main SMF Admin.  The TP functions are inside the main admin section for SMF 1.x..  BTW, that will change when TP for SMF 2 is available but I don't want to confuse you.

ZarPrime
Title: Re: Unable to access Admin
Post by: Zetan on October 27, 2009, 05:05:04 PM
There is only one Admin link. You access TP's admin pages via SMF's admin.
Title: Re: Unable to access Admin
Post by: clothahump on October 27, 2009, 05:09:52 PM
Thanks guys, back to the drawing board then.
Title: Re: Unable to access Admin
Post by: ZarPrime on October 27, 2009, 05:13:05 PM
The link for the Admin tab should go to ...
http://www.YourSite.com/index.php?action=admin

ZP
Title: Re: Unable to access Admin
Post by: clothahump on October 27, 2009, 05:16:37 PM
Yep, it does, this has obviously not happened before so must be something I have done in one of the files but which one and where?
Title: Re: Unable to access Admin
Post by: G6Cad on October 27, 2009, 05:22:58 PM
1. download the BIG upgrade package for SMF 1.1.0
2. Upload and replace ALL files from the EXTRACTED package
3. Refresh your page and you have the forum base done.

Then follow these links ( still on DEFAULT SMF CORE theme )

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)

Do it in this order and not some other way cause this WILL sort out your issues.
Title: Re: Unable to access Admin
Post by: clothahump on October 27, 2009, 05:26:13 PM
With TP un-installed?
Title: Re: Unable to access Admin
Post by: G6Cad on October 27, 2009, 05:55:01 PM
No, you dont need to uninstall anything as everything will be removed when you replaced the files with new ones
Title: Re: Unable to access Admin
Post by: clothahump on October 27, 2009, 07:31:23 PM
Followed the instructions to the letter and still the same problem, beginning to wish I had not started this transfer to another system. :(
Title: Re: Unable to access Admin
Post by: G6Cad on October 27, 2009, 07:50:56 PM
No, you did NOT follow the instructions to the letter, i STILL see your fish theme as default.

CORE theme ( the blue default theme that ships with SMF package ) is the theme i want to see you use until EVERYTHING is working,.

It's VERY hard to help when you dont listen to what we say
Title: Re: Unable to access Admin
Post by: clothahump on October 27, 2009, 07:53:25 PM
Missed that bit sorry, changed to default now.
Title: Re: Unable to access Admin
Post by: G6Cad on October 27, 2009, 08:01:11 PM
And does the admin work there ?  ( As you replaced all files with new ones it must work )
Title: Re: Unable to access Admin
Post by: Zetan on October 27, 2009, 08:02:08 PM
Quote from: clothahump on October 27, 2009, 07:53:25 PM
Missed that bit sorry, changed to default now.


How? How can you have "missed that bit" when I made a point of it?


We are happy to help, but you need to understand and follow the instructions given.

Title: Re: Unable to access Admin
Post by: clothahump on October 27, 2009, 08:06:10 PM
I do understand but I have a medical condition that affects my concentration at times, admin seems to be working at the moment, will see if it fails and let you know.
Title: Re: Unable to access Admin
Post by: clothahump on October 27, 2009, 08:58:55 PM
Default theme still in use and admin has just failed again.
Title: Re: Unable to access Admin
Post by: G6Cad on October 27, 2009, 09:17:41 PM
You are the only one that can help us help you by telling us what you do WHEN admin fails, it worked and now it doesent, what did you do when it failed ?
Title: Re: Unable to access Admin
Post by: clothahump on October 27, 2009, 09:22:37 PM
That's the problem, I am not sure at all where and when things went wrong, it could have been caused by installing the gallery, editing files to get gallery link in menu etc, the admin log in does not fail immediately, it works for a while and then nothing.

I am wondering if I should remove all files from the server and start again, I could then just connect to the DB once all installed again.
Title: Re: Unable to access Admin
Post by: Zetan on October 27, 2009, 09:43:16 PM
Before the installation of any other themes and mods, after you've installed TP.. does the install of TP function correctly? I ask because we can only support TinyPortal. If the install is failing after you've installed any other mods, you need to seek advice with the author/s of the other mod/s.
Title: Re: Unable to access Admin
Post by: clothahump on October 27, 2009, 09:47:24 PM
No tp does not function correctly, according to the admin panel neither TP or SMF Media Gallery is applied, states in Packages [ Apply Mod ]  [ List Files ]  [ Delete ] for both.
Title: Re: Unable to access Admin
Post by: Zetan on October 27, 2009, 09:56:00 PM
Quote from: clothahump on October 27, 2009, 09:22:37 PM
the admin log in does not fail immediately, it works for a while and then nothing.



I'm not sure where you go from here. We've given you all the advice we can and it shouldn't be this difficult. There are sites with TP installed and one I've seen with 50+ mods running.
Title: Re: Unable to access Admin
Post by: clothahump on October 27, 2009, 10:00:24 PM
I'm not sure either, I can't even Apply TP mod now and it has yet again logged me out.
Title: Re: Unable to access Admin
Post by: Zetan on October 27, 2009, 10:04:49 PM
TP is installed from where I'm sitting:

http://www.tropicalfishforums.co.uk/index.php

Would you PM me a temporary admin account? I'm not going to do anything other than look at the admin panel and settings.
Title: Re: Unable to access Admin
Post by: Zetan on October 27, 2009, 10:32:05 PM
Your TP install appears to be fine from what I've looked at, I've checked with all install standard themes. I've been logged in for 20 minutes and I haven't been logged out once yet. I think I remember you stating you are on a dial-up connection, could possibly be a reason?

Ok, I did make a few changes:

I have enabled Local Storage of cookies, under Server Settings. If this causes any problems, switch it back off. It's just a test and may or may not help.

I've also run through the first 5 SMF Maintenance tasks, under Forum Maintenance.
Title: Re: Unable to access Admin
Post by: clothahump on October 27, 2009, 10:35:22 PM
Thanks Zetan, it can stay like it is for now, I have more important things to do like earn a living. ;)
Title: Re: Unable to access Admin
Post by: Zetan on October 27, 2009, 10:37:55 PM
I would back the site up at this point. I have work in the morning too, but since I don't spend a lot of time here at the mo, I'll stick around while the connection is working.
Title: Re: Unable to access Admin
Post by: clothahump on October 27, 2009, 10:40:19 PM
To download it would take me all day and my ISP cuts me off every 2 hours so impossible I am afraid.
Title: Re: Unable to access Admin
Post by: Zetan on October 27, 2009, 10:42:50 PM
Well, I would go get a free hosting account from somewhere and use it to do server - sever backups. Google's yr mate on how to do something like that.. never done it myself, but I have read a few articles about it.
Title: Re: Unable to access Admin
Post by: Zetan on October 27, 2009, 10:58:25 PM
Just had a quick Googla, you might find this interesting:

http://www3.bigupload.com/

Read:
http://www3.bigupload.com/backup.php

Quote
6. Webmasters backup your website automatically  (Ensim compatible or use our custom made backup scripts).

Thing with server to server backups, they are apparently very fast due to the data center connections used.
Title: Re: Unable to access Admin
Post by: mc on October 28, 2009, 12:24:41 PM
Sounds like a cookie issue to me.

I done some work on a SMF forum trying to get a wordpress bridge to work a couple months ago, and it involved changing the cookie settings. Everytime I changed the settings, it wouldn't let me log-out or in, and I had to manually delete the cookies to get things working again.
Title: Re: Unable to access Admin
Post by: Zetan on October 28, 2009, 12:54:32 PM
Quote from: mc on October 28, 2009, 12:24:41 PM
Sounds like a cookie issue to me.

Which is why I turned the Local Cookies on, just to test:

Quote from: Zetan on October 27, 2009, 10:32:05 PM

I have enabled Local Storage of cookies, under Server Settings. If this causes any problems, switch it back off. It's just a test and may or may not help.


Title: Re: Unable to access Admin
Post by: mc on October 28, 2009, 01:08:16 PM
But you'll also likely need to delete the cookie on your computer.

Could it be the OP has something installed on their computer that affects cookies?
Title: Re: Unable to access Admin
Post by: clothahump on October 28, 2009, 07:43:43 PM
As much as I hate it I have been using IE8 and it all works normally, Firefox is causing the Log in problem, anybody else getting this with Firefox?
Title: Re: Unable to access Admin
Post by: G6Cad on October 28, 2009, 07:58:17 PM
Not a single reported problem .

Clear your cache and temp internet files and do a hard refresh ( ctrl + F5 )
Title: Re: Unable to access Admin
Post by: clothahump on October 28, 2009, 08:13:41 PM
Still no good mate, very strange.
One thing that has come from this is the masses of spammers trying to sign up, they just don't give up.
Title: Re: Unable to access Admin
Post by: IchBin on October 29, 2009, 12:30:41 AM
Could also be a add-on or something causing firefox to do this. If disabling your add-ons doesn't help, I would create another profile in FF and try that. If that doesn't fix it, I think you're out of luck. Check to see if you have the same problem in FF on another computer too.
Title: Re: Unable to access Admin
Post by: mc on October 29, 2009, 02:09:34 AM
Quote from: clothahump on October 28, 2009, 08:13:41 PM
One thing that has come from this is the masses of spammers trying to sign up, they just don't give up.

Have you set the verification image to the highest level?
Registration (under Members in admin panel) -> Settings
I find setting the complexity to the highest level removes most spam bot registrations.
Title: Re: Unable to access Admin
Post by: IchBin on October 29, 2009, 01:17:28 PM
That highest level sucks to read some times though. I prefer to keep a medium setting with a couple of other anti-spam mods installed.
Title: Re: Unable to access Admin
Post by: clothahump on December 11, 2009, 05:10:02 PM
Just discovered the fix for my problem purely by chance, a large web forum I visit was hacked and the user names and passwords were posted on the Net for all to see, this prompted me to change my passwords on every site I visit including my own and everything now works, strange but at least we can put this one to bed.