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

[cupandacu]

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

[Damian Culotta]

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';

[cupandacu]

Hi

Thanks so much for the feedback.

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

[Damian Culotta]

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.