please help 8 years efforts are lost hostgator deleted webfiles have db backup

Started by yourdailysaver, May 03, 2015, 12:07:15 AM

Previous topic - Next topic

yourdailysaver

Hello Seniors,

i have my forum running at www.indian-femdom.com before 3 days hostgator has deleted all my webfiles. total of 40 sites lost but only this site uses smf.

i have db's left in there so i downloaded backup
i have changed my host installed db there and from script install i have installed smf 2.0 same version i was using in my forum. and later i changed settings.php with my db settings where i installed backup from my old hostgator backup.

now its showing database error. please help friends. its really my 8 years effort. cant afford to loose it. please.

Kindred

Well, from the error, it would seem that you don't have the correct database connection information in your settings.php file
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

yourdailysaver


Night09


Shambles

Quote from: yourdailysaver
... hostgator has deleted all my webfiles

Tell Hostgator to repair what they did.

Kindred

well, fairly obviously, it is NOT correct -- otherwise your system would be connecting the forum without an error...
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

margarett

Run repair_settings and make sure that all settings are correct.
What is repair_settings.php?

If you have a backup of the database, don't worry you won't loose your content.
I would start by picking a decent host first. Was there a reason for them loosing all your sites? :o

I checked your site, you need to run repair_settings and change everyone to use default theme. You have a default theme confifured whose files are not present anymore, so your layout is messed.
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

yourdailysaver

Quote from: margarett on May 03, 2015, 08:37:43 PM
Run repair_settings and make sure that all settings are correct.
What is repair_settings.php?

If you have a backup of the database, don't worry you won't loose your content.
I would start by picking a decent host first. Was there a reason for them loosing all your sites? :o

I checked your site, you need to run repair_settings and change everyone to use default theme. You have a default theme confifured whose files are not present anymore, so your layout is messed.

thank you all for replies . margarett i tried your steps and got below errors after changing settings in repair_settings.php

Notice: Undefined index: database_error in /home/asutoshdesai/public_html/indian-femdom.com/Sources/Subs-Db-mysql.php on line 594

Fatal error: Call to undefined function allowedTo() in /home/asutoshdesai/public_html/indian-femdom.com/Sources/Subs-Db-mysql.php on line 595

which two lines are as below,

$context['error_title'] = $txt['database_error'];
   if (allowedTo('admin_forum'))

margarett

I'm not sure. Mixed files, maybe...

I can check that for you (later) if you PM me login details to your host's control panel. I need to check both files and database in order to understand what's happening...

Isn't this an option?
Quote from: Shambles on May 03, 2015, 07:51:02 AM
Quote from: yourdailysaver
... hostgator has deleted all my webfiles
Tell Hostgator to repair what they did.
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

yourdailysaver

Quote from: margarett on May 04, 2015, 05:23:51 AM
I'm not sure. Mixed files, maybe...

I can check that for you (later) if you PM me login details to your host's control panel. I need to check both files and database in order to understand what's happening...

Isn't this an option?
Quote from: Shambles on May 03, 2015, 07:51:02 AM
Quote from: yourdailysaver
... hostgator has deleted all my webfiles
Tell Hostgator to repair what they did.

sir they are such a loosers. deleted my 30 sites. and when i created tickets they are not even replying to it from last 3 days. i have changed to godaddy already. i send you id password in pm for my domain but the process of domain transfer is under process i guess so i think i will send you once its completed. so you can work on it. thanks for your time sir.

a10

Quotei have changed to godaddy already
Out of the ashes and into the fire ?  ;)
2.0.19, php 8.0.23, MariaDB 10.5.15. Mods: Contact Page, Like Posts, Responsive Curve, Search Focus Dropdown, Add Join Date to Post.

Vince S

For these cheapies in my experience it is daylight to second place after SiteGround.

10 years ago SiteGround were great, and they keep building substantial improvements of stuff I didn't even know I wanted with every passing year. I have considered lots of alternates over the years but always gone with SiteGround. This was originally an experimental use of a cheap non-Australian based host for a social website, but that has gone so well that when the last serious website I have expires it is going over to SiteGround too.

marg edit: referral removed
Try figuring out where all this is going to keep coming from: Millionaire Baby? Or just pass me a beer and we'll sort it, thank you.....

Steve

@ yourdailysaver - If you are wanting to switch hosts, this is a good place to start looking:

Hosts, Hosting and Commercial Services

And did you do as margarett suggested?

QuoteI can check that for you (later) if you PM me login details to your host's control panel. I need to check both files and database in order to understand what's happening.

DO NOT pm me for support!

yourdailysaver

Quote from: margarett on May 04, 2015, 05:23:51 AM
I'm not sure. Mixed files, maybe...

I can check that for you (later) if you PM me login details to your host's control panel. I need to check both files and database in order to understand what's happening...

Isn't this an option?
Quote from: Shambles on May 03, 2015, 07:51:02 AM
Quote from: yourdailysaver
... hostgator has deleted all my webfiles
Tell Hostgator to repair what they did.
i tell you what i have done,

i have installed same version of smf on my new server,
and importing my db backup in same db new smf has
i am getting below error while restoring my old db backup to my new db,

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 48
STR: ><
SQL:

<!-- PMA-SQL-ERROR -->
    <div class="error"><h1>Error</h1>
<p><strong>SQL query:</strong>
<a href="db_sql.php?sql_query=SHOW+TABLE+STATUS+FROM+%60asutosh_india%60+WHERE+Name+%3D+%27smf_bfalog_spider_stats%27&amp;show_query=1&amp;db=asutosh_india&amp;token=519dce4cd2cbf1643ecdd97015a3789a"><span class="nowrap"><img src="themes/dot.gif" title="Edit" alt="Edit" class="icon ic_b_edit" /> Edit</span></a>    </p>
<p>
<code class="sql"><pre>
SHOW TABLE STATUS FROM `asutosh_india` WHERE Name = 'smf_bfalog_spider_stats'
</pre></code>
</p>
<p>
    <strong>MySQL said: </strong><a href="./url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.5%2Fen%2Ferror-messages-server.html" target="mysql_doc"><img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help" /></a>
</p>
<code>
#2006 - MySQL server has gone away
</code><br />
</div>

SQL query:

<!-- PMA-SQL-ERROR --> <div class="error"><h1>Error</h1> <p><strong>SQL query:</strong> <a href="db_sql.php?sql_query=SHOW+TABLE+STATUS+FROM+%60asutosh_india%60+WHERE+Name+%3D+%27smf_bfalog_spider_stats%27&amp;show_query=1&amp;db=asutosh_india&amp;token=519dce4cd2cbf1643ecdd97015a3789a"><span class="nowrap"><img src="themes/dot.gif" title="Edit" alt="Edit" class="icon ic_b_edit" /> Edit</span></a> </p> <p> <code class="sql"><pre> SHOW TABLE STATUS FROM `asutosh_india` WHERE Name = 'smf_bfalog_spider_stats' </pre></code> </p> <p> <strong>MySQL said: </strong><a href="./url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.5%2Fen%2Ferror-messages-server.html" target="mysql_doc"><img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help" /></a> </p> <code> #2006 - MySQL server has gone away </code><br /> </div>

MySQL said: Documentation

#1064 - 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 '<!-- PMA-SQL-ERROR -->
    <div class="error"><h1>Error</h1>
<p><strong>SQL quer' at line 1

Kindred

First... How did you make the SQL backup?
Second, did you empty the error log and drop the search index (full or custom) before running your backup?
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

yourdailysaver

Quote from: Kindred on May 07, 2015, 01:26:31 AM
First... How did you make the SQL backup?
Second, did you empty the error log and drop the search index (full or custom) before running your backup?

i have exported backup in sql file before few days i lost my forum. and i dont know how to empty and drop search index sir. i am not that techy. can you please elaborate if possible ?

Kindred

You can drop the search index from the smf admin search index page...
You can empty the error log from the error log page...


But HOW did you create the backup? Did you use phpmyadmin? Your host control panel? Smf admin?
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Steve

Wait a second. Quick question (not trying to hijack thread) ... is this necessary before doing backups or is this for the OP's situation?

Quote from: Kindred on May 07, 2015, 01:26:31 AMSecond, did you empty the error log and drop the search index (full or custom) before running your backup?
DO NOT pm me for support!

Illori

if they are using the admin backup that can help to get a clean dump. if the dump they have is too large those tables being reduced in size will let the dump be smaller and upload possible.

yourdailysaver

i dont know whats going on here. can anybody have reply for my me ? my site is down how can i log into admin

Advertisement: