cancel
Showing results for 
Search instead for 
Did you mean: 

I think my website is doomed? Please let me know what you think

I think my website is doomed? Please let me know what you think

Hi all

 

I backed up a large database file through my cPanel. I then deleted it from the server.

Now I am trying to restore the folder file but it doesn't seem to work.

 

After completing the restore, I get this message on my domain:

 

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bikefair_mage7.mage_log_visitor_info' doesn't exist

I think the file is no good because the internet connection I had was not stable.

 

Is there anyway to get my site up and running again without this file? I do not have a back up of the site.

 

Any advice would be much appreciated.

 

Phil

3 REPLIES

Re: I think my website is doomed? Please let me know what you think

Hi @cupandacu,

 

You'll need that table.

You should check on your database if the table is present. If not, maybe this could help you to recreate the table:

 

CREATE TABLE `log_visitor_info` (
  `visitor_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Visitor ID',
  `http_referer` varchar(255) DEFAULT NULL COMMENT 'HTTP Referrer',
  `http_user_agent` varchar(255) DEFAULT NULL COMMENT 'HTTP User-Agent',
  `http_accept_charset` varchar(255) DEFAULT NULL COMMENT 'HTTP Accept-Charset',
  `http_accept_language` varchar(255) DEFAULT NULL COMMENT 'HTTP Accept-Language',
  `server_addr` bigint(20) DEFAULT NULL COMMENT 'Server Address',
  `remote_addr` bigint(20) DEFAULT NULL COMMENT 'Remote Address',
  PRIMARY KEY (`visitor_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Log Visitor Info Table';
--
If you've found one of my answers useful, please give "Kudos" or "Accept as Solution"

Re: I think my website is doomed? Please let me know what you think

Hi

Thanks so much for the feedback.

If I wanted to give this code a try, where can I place it?

Re: I think my website is doomed? Please let me know what you think

You'll need to connect to your database and run that sql script.

If you're not sure what are you doing please get some qualified help. That scripts create the database table you've missed.

 

--
If you've found one of my answers useful, please give "Kudos" or "Accept as Solution"