Hey everyone, i really need help fast! Ok so i was adding a new RSS feed too my forum (forums on 1.1.11) and then when the page refreshed it gives me an error that says this:
An Error Has Occurred!
Board structure corrupt: unable to find parent board
Now my whole board is down and i can't access the admin panel or anything! I have too get my site back up asap, ok so i seen somewhere i need to use something called "PhpMyAdmin". My hosting service is GoDaddy so i went and signed in there and went too the hosting dashboard then MySQL then it allows me too sign into PhpMyAdmin BUT when i try too sign in i get an error
1045 access denied for user 'root@localhost' using password yes
I am putting in the correct name and password but it will not let me in. I have to get my forums back up and running fast! Please someone help me!
Thanks very much in advance if anyone will help me out!
What's your forum url?
www.An0nymousHelper.com/forums
Your whole forum seems messed up even the theme.
Board structure corrupt:
Your files or a database has been corrupted trying asking your web hosting for a backup.
I made a backup of the forum but how do i restore it (noob here) Um i did go through go daddy and there was a restore point on there from yesterday so i restored it but still nothing changed :(
Have you made any edits to a file / added new modifications etc?
Is your host GoDaddy? You should contact them saying you cannot access your forum board.
Yes i am with godaddy, and no i have not installed any new mods, like i did a few hours ago but they worked fine. It was just when i entered a new RSS feed. :(
Well to be honest your best bet is contacting your host tell them if there's a backup database on your hosting account ;).
Quote from: Ashley S on January 01, 2011, 08:21:06 PM
Well to be honest your best bet is contacting your host tell them if there's a backup database on your hosting account ;).
So i just called GoDaddy and they tried a few things but there was not much they could do as i didn't have a back up through go daddy :( It's still not working. I did manage o now get into PhpMyAdmin but i really don't no if there is a way to fix it with that. If there is i would appreciate and help very very much, i really need this forum up.
You can try this
- I broke my forum! What tool should I try? (http://docs.simplemachines.org/index.php?topic=469.0)
Read it though before downloading ;).
Where did you enter the RSS feed. ???
Quote from: Ashley S on January 01, 2011, 08:54:00 PM
You can try this
- I broke my forum! What tool should I try? (http://docs.simplemachines.org/index.php?topic=469.0)
Read it though before downloading ;).
I tried this, but when i go too http://MYSITE.com/forums/repair_settings.php nothing happens. it just says
Not Found
The requested URL /forums/repair_settings.php was not found on this server.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
- I broke my forum! What tool should I try? (http://docs.simplemachines.org/index.php?topic=469.0)
Read it though before downloading ;).
[/quote]
Quote from: Bigguy on January 01, 2011, 08:57:35 PM
Where did you enter the RSS feed. ???
What do you mean by this? I had a mod installed (RSS Feed Poster) and works great i've had for a couple days but i wanted too add a new feed and right after i did that it all went down hill :(
Ok, then maybe the mod author can help out. It seems it is the mod that is causing the problem. repair_settings will not help with this. Plus it must be uploaded before you use it.
The RSS Modification must have a major bug.
Your best bet now is to reply to the Modification topic or PM the owner of the Modification.
Sorry :(.
Quote from: Bigguy on January 01, 2011, 09:04:15 PM
Ok, then maybe the mod author can help out. It seems it is the mod that is causing the problem. repair_settings will not help with this. Plus it must be uploaded before you use it.
Ok ill try and contact them. and yes i had it uploaded before i went too the url ;) still didn't work for some reason...
Quote from: Ashley S on January 01, 2011, 09:06:45 PM
The RSS Modification must have a major bug.
Your best bet now is to reply to the Modification topic or PM the owner of the Modification.
Sorry :(.
ok i will, thank you for your help.
Maybe permissions on the file were wrong.
Hm have a look in your FTP see what permissions the Modification has.
Quote from: Ashley S on January 01, 2011, 09:10:58 PM
Hm have a look in your FTP see what permissions the Modification has.
sorry i'm a bit of a noob, could u please explain how i do this? :) The mod worked fine for a couple days though, it was just adding this last feed :(
See if this helps
How do I chmod? / what is chmod? (http://docs.simplemachines.org/index.php?topic=477.0)
FTP meaning your Control Panel. or Filezilla :).
Look in your folder directory.
/public_html/forums/Packages/
Your RSS Modification should be placed in there have a look at the permissions on the right of the folder ;).
Ok i took a look at it and this is what i got. Are these correct?
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi976.photobucket.com%2Falbums%2Fae241%2FAn0nymousHelper%2FScreenshot2011-01-01at61918PM.png&hash=46a7e614f9eda74d6670857e85b293ae09e88936)
Try making the Modification permission 777 ;)
See how that goes.
There will be different permissions for files then there are for folders. I would ask your host what each should be.
Quote from: Ashley S on January 01, 2011, 09:24:09 PM
Try making the Modification permission 777 ;)
See how that goes.
didn't work :(
Hm i have no clue then aha :P.
Like Bigguy said ask your host what the permissions should be for that modification ;).
Not for that modification just ask what the permissions are supposed to be for files and folders.
ok, so i guess there is no way for me just to restore it then? I have a restore point that i made (about 10 days ago) it's .sql one that i got not from GoDaddy but from the admin panel on smf. If i go through PhpMyAdmin i get an error every time i try and import it :( I just need this forum up very fast.
Have you read this:
How do I restore a database backup? (http://docs.simplemachines.org/index.php?topic=490.0)
Yes thats what i am doing any i get an error :(
The error i get is this Error: 1062 I looked it up and means
Error: 1062 SQLSTATE: 23000 (ER_DUP_ENTRY)
Message: Duplicate entry '%s' for key %d
Your entering a duplicated entry code you sure your doing right??
Is that the whole error message you get.
Hmm i think i'm doing it correct i read that post with the tutorial, You just sign into the Phpmyadmin and then click on your database then click Import and select the .sql file correct? I did see part saying to create a new database but thats just if you dont have one already right? (i obviously have one)
anyways here a pic
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi976.photobucket.com%2Falbums%2Fae241%2FAn0nymousHelper%2FScreenshot2011-01-01at63923PM.png&hash=dfd7c2acf7484ff528ac470ff48256a58456cf5d)
Should i delete the database that the forum is on right now and create a new one with the same name then import the .sql backup into it? Or will i loose everything?
If you create a new database then drop all the tables in it then import your old database that should work or you could delete the smf_log_search_subjects from the .sql file and try uploading it again. I do it that way when I get an error like that. You would need a program that will open .sql files. Something like php designer or notepad ++ would work.
If you delete entries from the .sql file make sure you keep a copy of the original .sql backup file so you have it if it does not work. :)
Im not sure how to "drop all the tables in the new data base lol, so i think ill try and delete the smf_log_search_subjects from the .sql file and see if i can figure that out ;) wish me luck lol
Good luck. It's not that hard and as far as I know that part is really not needed in the backup anyway. The forum should still function fine for you. :)
Quote from: Bigguy on January 01, 2011, 10:18:32 PM
If you delete entries from the .sql file make sure you keep a copy of the original .sql backup file so you have it if it does not work. :)
oh 1 thing i have a backup from about 10 days ago so it wont have all the newest thing but its ok as long as i get the forums up. That back up is a Complete back up, i have another backup from earlier on today but its not the full complete backup. Like when in the admin panel if you go to ( i forget what the full thing is called as i cant look back, im doing this from memory) but you go to where you can click Backup there is a checkbox that says something and then "the important stuff" the backup that i have from earlier on today has just that one and the backup from about 10 days ago has all check boxes checked off and it has Complete in the file name. I hope you understand what i'm trying to say lol i no i say it in sort of a confusing way, sorry :)
Yup I understand confusion, lol ;)
So do i use the full (older) backup or the newer not full back up? lol so confused...
Do they both produce errors ??? If so I guess it really doesn't matter if your going to alter the .sql file.
Yeah both have errors, I opened both of them and went Find and then smf_log_search_subjects only 1 of them have that line though (the newer one) so heres where i am a little confused on what to do. It has 3 of though's lines i just don't no what to delete lol.. I'm very close to finishing this though so if you could help me out here i would appreciate it very much :)
Can you upload that file and I will check things out for you. :) You may have to zip it up.
Yes, do you have aim or msn so we can talk (much easier that the forum lol) or even better if u feel like helping out do you have TeamViewer? Basically it runs my desktop on urs so you can do it and i can watch what ur doing so that i no for future reference :) if not ill just upload it for you
I don't have team viewer no. Pretty much all I am going to do is look for the duplicate entry you posted above and remove it. Then I will upload it for you to try.
ok, here ya go :) (i made it into a .zip)
Ok, try this
:(
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi976.photobucket.com%2Falbums%2Fae241%2FAn0nymousHelper%2FScreenshot2011-01-01at75651PM.png&hash=be02c9fd2e540fe285774167d18010e140953eb9)
Try this
Just about the same :(
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi976.photobucket.com%2Falbums%2Fae241%2FAn0nymousHelper%2Fn.png&hash=46f538198100f5b236d1bf0606885b96b26adbee)
Ok, think I got it right this time. Try this
:(
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi976.photobucket.com%2Falbums%2Fae241%2FAn0nymousHelper%2FScreenshot2011-01-01at81237PM.png&hash=f2650f6e2b0a318672a0648296b93cfd274c322a)
Been awhile since I had to do this, lol. Ok try this:
lol :(
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi976.photobucket.com%2Falbums%2Fae241%2FAn0nymousHelper%2FScreenshot2011-01-01at81850PM.png&hash=debac02e94b4075b50456068641dded721fceb84)
OK, well you only had two attachments so they are gone now as well as the error we started to deal with. Lets give this another shot. Try this:
Hopefully the last one
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi976.photobucket.com%2Falbums%2Fae241%2FAn0nymousHelper%2FScreenshot2011-01-01at82354PM.png&hash=f18234761b7244db1998e9c3cde211abbc4bca5d)
Not exactly sure why there would be an error there but ok...try this then. If this persists then there is something else going on that I am missing. Try this:
Hmm :(
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi976.photobucket.com%2Falbums%2Fae241%2FAn0nymousHelper%2FScreenshot2011-01-01at83047PM.png&hash=f9f500c59a7c1c847b220037eb83933be0838ce3)
See if this works
damn :( I wonder whats up with it..
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi976.photobucket.com%2Falbums%2Fae241%2FAn0nymousHelper%2FScreenshot2011-01-01at84200PM.png&hash=6761c913ed8ec0ab25aa34465c0de20dc250045d)
lol, are we having fun yet. This has to be it....I hope.
omg lol we have to be close!
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi976.photobucket.com%2Falbums%2Fae241%2FAn0nymousHelper%2FScreenshot2011-01-01at84939PM.png&hash=6ee7b204a26033bbef2d5554dec5fccf3f20a319)
Well, this one has to work or error somewhere else cause I can't see anything else to change in that part of the file. It can't be duplicated anywhere else.
wow what could this be! :(
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi976.photobucket.com%2Falbums%2Fae241%2FAn0nymousHelper%2FScreenshot2011-01-01at85902PM.png&hash=0b0152e46cd4979461391a37609a82803d4a8596)
k, try this damn it, lol.
just wow.... lol
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi976.photobucket.com%2Falbums%2Fae241%2FAn0nymousHelper%2FScreenshot2011-01-01at90559PM.png&hash=77560028a0f4417bc51d52a7bbf664b23524beeb)
just to clarify, i go into PhpMyAdmin, click on my database, click upload and then select the file right?
Holy crap I have never had this much problem before. This is not working. I will try once more here, hold on. Yes that is right.... is there already a database or info in the database you are trying to upload to. ???
Yes there is... is that good or bad? should i delete the old database?
ok, before i continue. This is right, right?
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi976.photobucket.com%2Falbums%2Fae241%2FAn0nymousHelper%2FScreenshot2011-01-01at91638PM.png&hash=dac0eb6208efd72d81a0ae5d29950c3bf48d2781)
Yes that is right. We have a backup of it so no worries. This is probably the reason it was showing duplicate entries because it was trying to import a backup of the same thing so it was saying that it found duplicate content.
omg! lol... Should i maybe try one of the first ones you sent now that i have dropped tables?
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi976.photobucket.com%2Falbums%2Fae241%2FAn0nymousHelper%2FScreenshot2011-01-01at92033PM.png&hash=2454eb3e35a2c259d5ae8b5f1df7c288c9ee957f)
Yes drop all tables again and try one of the first ones we did. I was going to suggest that but wanted to see how far we got.
hmm thats the first one you send :(
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi976.photobucket.com%2Falbums%2Fae241%2FAn0nymousHelper%2FScreenshot2011-01-01at92408PM.png&hash=def799aaea39ee423db85cd1409863c25959b455)
Ok, can you send me your cpanel login details and I will check things out. Something is not right here or I am forgetting something. I should still have the original file you sent me I think.
Don't post it here, just PM me.
This problem is solved after much playing around. The problem was the RSS feed poster mod. What I had to do was edit the index.php file that is in the root of the SMF install. I had to remove code from that file that the mod had placed there. This is what I took out:
// RSS Feed Poster run fake cron job
if (!empty($modSettings['rss_fakecron']))
{
if (empty($modSettings['rss_lastcron']) || $modSettings['rss_lastcron'] + (1 * 60) > time())
{
require_once($sourcedir . '/Subs-RSS.php');
UpdateRSSFeedBots();
updateSettings(array('rss_lastcron' => time()));
}
}
I made a backup of the file I edited and left it in the root of your SMF install. Right now your RSS feed poster mod will not work. If you try to uninstall it and it errors on the index.php file this is fine as there are no edits in there from the mod anymore.
I can not reply to your PM cause I guess I have hit the hourly limit. The button I pushed I guess sent a request to godaddy to revive the database. I had to wait til they or the server itself did that. So I guess yeah the backup that was there worked fine. Then I edited the file and viola. :)
Quote from: Bigguy on January 02, 2011, 01:25:59 AM
I can not reply to your PM cause I guess I have hit the hourly limit. The button I pushed I guess sent a request to godaddy to revive the database. I had to wait til they or the server itself did that. So I guess yeah the backup that was there worked fine. Then I edited the file and viola. :)
Thanks you so much again! Wow you helped out so much! Thanks!!!!!
Not a problem. I'm glad it's up and running and that I could finally be of some use to you, lol.