Theme Problem

[riverscorpion]

Hello.

So I downloaded a theme layout called Curv RC5 New Generation5 a few months ago. Earlier tonight, I was in my admin area and testing out different themes, so I decided to select on Curv RC. After I selected it, I logged off, and then went to sign back in, but the main page gave me no way  to sign in.

Now I know of no way to log in through that home page. Either there has to be a way for me to log in so I can change the theme or there has to be a way for me to change the theme from my FTP.

What can I do?

[riverscorpion]

Also, here's a link to my forum.

www.stackemup.net

[ziycon]

I would say go to http://www.stackemup.net/index.php?action=login but there seems to be an issue with the theme, you may need to contact the creator of the theme to get help.

Koodi [Valitse] Laajenna

<b>Fatal error</b>:  Call to undefined function JavaScriptEscape() in <b>D:\Hosting\7404858\html\Sources\Load.php(1733) : eval()'d code</b> on line <b>282</b><br />

[riverscorpion]

That's it? There's no way for me to change the theme through FTP? There's got to be

.

[ziycon]

You can try running the below SQL, if you still have the default theme available then it will set it as the default theme.  Clear out your cache after running it.

Koodi [Valitse] Laajenna

UPDATE smf_settings SET value=1 WHERE variable='theme_default';

[river scorpion]

Thanks. I appreciate it.

I'm not sure if there is a thread on this site already for running SQLs. So I will ask some questions here.

Am I going through MySQL or SQL server or even something else? If I click on either one, there is one other database set up in MySQL but nothing set up in SQL server. So I'm guessing it's MySQL?

Am I creating a new database or restoring/backing up the database that is already there?

If create, when I click on create new database, am I putting that code into the part that says description?

[ziycon]

You need to log into your existing database that contains your forum, there is no need to create any new databases. Is there any option call phpmyadmin on you admin interface when you login?

[river scorpion]

Yup...Phpmyadmin is there.

[river scorpion]

Select DATABASES  -> SQL -> RUN SQL Query on Server comes up -> Enter "UPDATE smf_settings SET value=1 WHERE variable='theme_default'"  -> HIT GO?

[river scorpion]

If you can't solve it or answer my questions,  just say so! Just please direct me to the person above you...with more experience and knowledge. No passing the buck over to the theme developer. Unacceptable.

RIVER

[mashby]

Do you remember which version of SMF you have? Based on where you posted this topic, can I assume it's 1.1.14? I'm guessing you installed a theme for 2.0 RC5 which would indeed cause you problems. ziycon's suggestion is rather good:

UPDATE smf_settings SET value=1 WHERE variable='theme_default';

Considering this isn't working:
http://www.stackemup.net/index.php?theme=1

[Illori]

or use repair_settings.php and just use the part to reset the themes to default which does not require access to phpmyadmin. What is repair_settings.php?

[river scorpion]

Do you remember which version of SMF you have? Based on where you posted this topic, can I assume it's 1.1.14?

Actually it's 1.1.13. Does that make a difference?

I tried ziycon's suggestion and nothing happened.

[mashby]

Shouldn't make any difference, no. Try what Illori suggested next regarding repair_settings.
What is repair_settings.php?

[river scorpion]

or use repair_settings.php and just use the part to reset the themes to default which does not require access to phpmyadmin. What is repair_settings.php?

I went into it. recommended settings is what I did. Then I saved. there was this message:

"Some settings are not being shown because the MySQL connection information is incorrect."

wtf. I guess that means my SQL server information is wrong. Because I had changed that to the recommended, localhost. The other information is right.

Ideas?

[river scorpion]

Update:  Got and entered name for SQL Server.

Page was reloaded. Message came up on the new page. It said "Settings Repairs Tool" with a link for this forum. The rest was blank.

Still can't connect! SMF is unable to connect with the database. So we have to figure out a way to link the two up.

[river scorpion]

Shouldn't make any difference, no.

Going back to that...I noticed there was a little delimiter box in the bottom left hand corner when I ran that query. But I left it blank.

I was thinking that maybe I had to enter something in there to make the query work. Let me know if that's the case.

[ziycon]

If you can't solve it or answer my questions,  just say so! Just please direct me to the person above you...with more experience and knowledge. No passing the buck over to the theme developer. Unacceptable.

RIVER

There's was no need for that reply, I'm not logged on to the net 24/7 and I offer help in my free time.

[river scorpion]

This isn't about you. I'll say it again. If you are not competent enough to assist with my issue...just direct me to somebody more knowledgable than you who can.

IS SMF this underrepresented I've got to wait for somebody to log into this forum on their own free time? Is this the only place on earth that I can go to for SMF technical problems?

[Illori]

river scorpion this forum provides support by VOLUNTEERS so we come here when we want, we also reply when we want. and no there is no other official site you can get support from.

[Tony Reid]

river scorpion - I must say, perhaps its a cross border culture thing - but your posts do come across very rude.

I noticed that your install appears to be very new (based on your previous posts), and so my suggestion to you would be to sign up to charter membership and have an SMF team member install your forum for you.

http://www.simplemachines.org/charter/

[river scorpion]

At this point I have no intent to fork over fifty bucks for a charter membership when I haven't gotten any workable solutions here on this thread.

If you want to sell charter memberships, you gotta prove your abilities first in the public section, no questions asked.

[Illori]

we have told you what to do to fix your issue, you just have not shown us at all that you have even attempted to follow though with those fixes. if you cant do it then the team can do it for you.

[Tony Reid]

I'm not selling charter membership - but I can see that your not technically skilled in being able to perform what's being asked of you.

As Illori has stated, the repair settings file requires you to re-enter the correct settings and then apply.

[river scorpion]

we have told you what to do to fix your issue, you just have not shown us at all that you have even attempted to follow though with those fixes. if you cant do it then the team can do it for you.

I laid my attempts at follow through out for you on my 9th and 10th post down, to which you have never responded. I've given you various information. It's up to you to use your SMF savvy to intuitively deduce the actual problem and provide a remedy (like a doctor) when the online manual isn't adequate.

[Illori]

It's up to you to use your SMF savvy to intuitively deduce the actual problem and provide a remedy (like a doctor) that goes beyond any reference to the online manual.

no it is not my JOB i am not paid to do anything here, so i dont have to try to solve your problems if you can not. and usually referring people to the documentation will help them solve their problems as people know how to read.

[Deaks]

river scorpian, how are you?
I have some simple questions that I would appreciate you answering and thinking about carefully.

1.  Do you have any mods installed?
2.  How many users and posts roughly does your fourm have?
3.  Did you backup your site at anytime?

[river scorpion]

Hello Beard.

Okay.
Yeah, I've got five mods installed:
1. .htaccess
2. index.php
3. installed.list
4. smf patch 1.0.21...
5. smf patch 1..1.14...

I've got 32 members and about a couple hundred posts.

Yup. There is a folder above the five mods called backup. Inside that are .htaccess, index.php, 2011-2-11_before..., and 2011-06-14_before...

[mashby]

Wondering what got you to this point. Your site is rather unresponsive, but some parts are alive. What is the .htaccess mod? Have a link to that on this site? index.php isn't really a mod either. Sure, there are mods that affect that file, but it's usually a more descriptive mod. Nonetheless, this file works:
http://www.stackemup.net/Themes/default/images/on.gif
This doesn't:
http://www.stackemup.net/
Well, it does return this:

Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.

Does your database still exist? Can you contact your host and see if the database server is up?

[Deaks]

mashby, if you read carefully you notice that the site was working fine apart from the issue reported, the connection to database error occured after river scorpian  used repair_settings.php.  The database issue is now fixed and forum is now showing again.

[river scorpion]

Appreciated the responses from people.

As Beard has said, the issue was solved and the website is back up. Thanks again, Beard.