Website Down ::> Accidentally dropped visitor_log and visitor_log_info tables in Database Admin
Getting this error in the logs:
2015-04-13T06:22:52+00:00 ERR (3): Warning: PDO::__construct() [pdo.--construct]: [2002] Connection refused (trying to connect via tcp://mysqlv112:3306) in /data/14/1/150/111/1313763/user/1407123/htdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php on line 129
Can I just create the table in the Database Admin to resolve this issue? What fields are in the tables for visitor_log and visitor_log_info? Please help!
Is this what I add to the log_visitor table?
database zend-framework
edited yesterday
Glorfindel
2211412
asked Apr 14 '15 at 6:15
dylanspeetz
84
add a comment |
Getting this error in the logs:
2015-04-13T06:22:52+00:00 ERR (3): Warning: PDO::__construct() [pdo.--construct]: [2002] Connection refused (trying to connect via tcp://mysqlv112:3306) in /data/14/1/150/111/1313763/user/1407123/htdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php on line 129
Can I just create the table in the Database Admin to resolve this issue? What fields are in the tables for visitor_log and visitor_log_info? Please help!
Is this what I add to the log_visitor table?
database zend-framework
edited yesterday
Glorfindel
2211412
asked Apr 14 '15 at 6:15
dylanspeetz
84
in table magento is save customer url ,customer visited url list
– Amit Bera♦
Apr 14 '15 at 6:18
is this for the table visitor_log?
– dylanspeetz
Apr 14 '15 at 6:24
That error says MySQL is down. First start it back up.
– Melvyn
Apr 14 '15 at 6:29
How do I start up MySQL? Sorry I am a noob web developer
– dylanspeetz
Apr 14 '15 at 6:37
On the server commandline try eitherservice mysqld restartor check the/etc/init.d/directory for a MySQL startup script
– Sander Mangel♦
Apr 14 '15 at 6:39
add a comment |
Getting this error in the logs:
2015-04-13T06:22:52+00:00 ERR (3): Warning: PDO::__construct() [pdo.--construct]: [2002] Connection refused (trying to connect via tcp://mysqlv112:3306) in /data/14/1/150/111/1313763/user/1407123/htdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php on line 129
Can I just create the table in the Database Admin to resolve this issue? What fields are in the tables for visitor_log and visitor_log_info? Please help!
Is this what I add to the log_visitor table?
database zend-framework
edited yesterday
Glorfindel
2211412
asked Apr 14 '15 at 6:15
dylanspeetz
84
Getting this error in the logs:
2015-04-13T06:22:52+00:00 ERR (3): Warning: PDO::__construct() [pdo.--construct]: [2002] Connection refused (trying to connect via tcp://mysqlv112:3306) in /data/14/1/150/111/1313763/user/1407123/htdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php on line 129
Can I just create the table in the Database Admin to resolve this issue? What fields are in the tables for visitor_log and visitor_log_info? Please help!
Is this what I add to the log_visitor table?
database zend-framework
database zend-framework
edited yesterday
Glorfindel
2211412
asked Apr 14 '15 at 6:15
dylanspeetz
84
edited yesterday
Glorfindel
2211412
asked Apr 14 '15 at 6:15
dylanspeetz
84
edited yesterday
Glorfindel
2211412
edited yesterday
Glorfindel
2211412
edited yesterday
Glorfindel
2211412
2211412
asked Apr 14 '15 at 6:15
dylanspeetz
84
asked Apr 14 '15 at 6:15
dylanspeetz
84
asked Apr 14 '15 at 6:15
dylanspeetz
84
84
in table magento is save customer url ,customer visited url list
– Amit Bera♦
Apr 14 '15 at 6:18
is this for the table visitor_log?
– dylanspeetz
Apr 14 '15 at 6:24
That error says MySQL is down. First start it back up.
– Melvyn
Apr 14 '15 at 6:29
How do I start up MySQL? Sorry I am a noob web developer
– dylanspeetz
Apr 14 '15 at 6:37
On the server commandline try eitherservice mysqld restartor check the/etc/init.d/directory for a MySQL startup script
– Sander Mangel♦
Apr 14 '15 at 6:39
add a comment |
in table magento is save customer url ,customer visited url list
– Amit Bera♦
Apr 14 '15 at 6:18
is this for the table visitor_log?
– dylanspeetz
Apr 14 '15 at 6:24
That error says MySQL is down. First start it back up.
– Melvyn
Apr 14 '15 at 6:29
How do I start up MySQL? Sorry I am a noob web developer
– dylanspeetz
Apr 14 '15 at 6:37
On the server commandline try eitherservice mysqld restartor check the/etc/init.d/directory for a MySQL startup script
– Sander Mangel♦
Apr 14 '15 at 6:39
in table magento is save customer url ,customer visited url list
– Amit Bera♦
Apr 14 '15 at 6:18
in table magento is save customer url ,customer visited url list
– Amit Bera♦
Apr 14 '15 at 6:18
is this for the table visitor_log?
– dylanspeetz
Apr 14 '15 at 6:24
is this for the table visitor_log?
– dylanspeetz
Apr 14 '15 at 6:24
That error says MySQL is down. First start it back up.
– Melvyn
Apr 14 '15 at 6:29
That error says MySQL is down. First start it back up.
– Melvyn
Apr 14 '15 at 6:29
How do I start up MySQL? Sorry I am a noob web developer
– dylanspeetz
Apr 14 '15 at 6:37
How do I start up MySQL? Sorry I am a noob web developer
– dylanspeetz
Apr 14 '15 at 6:37
On the server commandline try either
service mysqld restart or check the /etc/init.d/ directory for a MySQL startup script– Sander Mangel♦
Apr 14 '15 at 6:39
On the server commandline try either
service mysqld restart or check the /etc/init.d/ directory for a MySQL startup script– Sander Mangel♦
Apr 14 '15 at 6:39
add a comment |
1 Answer
1
active
oldest
votes
The error you're getting thates that PDO can't connect to the MySQL server. Are you sure you've set the right credentials? You can find them in app/etc/local.xml
For the tables, the following query will create the log_visitor and log_visitor_info tables.
CREATE TABLE IF NOT EXISTS `log_visitor` (
`visitor_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Visitor ID',
`session_id` varchar(64) DEFAULT NULL COMMENT 'Session ID',
`first_visit_at` timestamp NULL DEFAULT NULL COMMENT 'First Visit Time',
`last_visit_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Last Visit Time',
`last_url_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Last URL ID',
`store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
PRIMARY KEY (`visitor_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Log Visitors Table' AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `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';
answered Apr 14 '15 at 6:38
Sander Mangel♦
34.7k469136
Awesome! Website is up and running again ~ Thank you very much!
– dylanspeetz
Apr 14 '15 at 6:43
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "479"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f63515%2fwebsite-down-accidentally-dropped-visitor-log-and-visitor-log-info-tables-in%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
The error you're getting thates that PDO can't connect to the MySQL server. Are you sure you've set the right credentials? You can find them in app/etc/local.xml
For the tables, the following query will create the log_visitor and log_visitor_info tables.
CREATE TABLE IF NOT EXISTS `log_visitor` (
`visitor_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Visitor ID',
`session_id` varchar(64) DEFAULT NULL COMMENT 'Session ID',
`first_visit_at` timestamp NULL DEFAULT NULL COMMENT 'First Visit Time',
`last_visit_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Last Visit Time',
`last_url_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Last URL ID',
`store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
PRIMARY KEY (`visitor_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Log Visitors Table' AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `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';
answered Apr 14 '15 at 6:38
Sander Mangel♦
34.7k469136
Awesome! Website is up and running again ~ Thank you very much!
– dylanspeetz
Apr 14 '15 at 6:43
add a comment |
The error you're getting thates that PDO can't connect to the MySQL server. Are you sure you've set the right credentials? You can find them in app/etc/local.xml
For the tables, the following query will create the log_visitor and log_visitor_info tables.
CREATE TABLE IF NOT EXISTS `log_visitor` (
`visitor_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Visitor ID',
`session_id` varchar(64) DEFAULT NULL COMMENT 'Session ID',
`first_visit_at` timestamp NULL DEFAULT NULL COMMENT 'First Visit Time',
`last_visit_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Last Visit Time',
`last_url_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Last URL ID',
`store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
PRIMARY KEY (`visitor_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Log Visitors Table' AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `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';
answered Apr 14 '15 at 6:38
Sander Mangel♦
34.7k469136
Awesome! Website is up and running again ~ Thank you very much!
– dylanspeetz
Apr 14 '15 at 6:43
add a comment |
The error you're getting thates that PDO can't connect to the MySQL server. Are you sure you've set the right credentials? You can find them in app/etc/local.xml
For the tables, the following query will create the log_visitor and log_visitor_info tables.
CREATE TABLE IF NOT EXISTS `log_visitor` (
`visitor_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Visitor ID',
`session_id` varchar(64) DEFAULT NULL COMMENT 'Session ID',
`first_visit_at` timestamp NULL DEFAULT NULL COMMENT 'First Visit Time',
`last_visit_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Last Visit Time',
`last_url_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Last URL ID',
`store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
PRIMARY KEY (`visitor_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Log Visitors Table' AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `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';
answered Apr 14 '15 at 6:38
Sander Mangel♦
34.7k469136
The error you're getting thates that PDO can't connect to the MySQL server. Are you sure you've set the right credentials? You can find them in app/etc/local.xml
For the tables, the following query will create the log_visitor and log_visitor_info tables.
CREATE TABLE IF NOT EXISTS `log_visitor` (
`visitor_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Visitor ID',
`session_id` varchar(64) DEFAULT NULL COMMENT 'Session ID',
`first_visit_at` timestamp NULL DEFAULT NULL COMMENT 'First Visit Time',
`last_visit_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Last Visit Time',
`last_url_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Last URL ID',
`store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
PRIMARY KEY (`visitor_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Log Visitors Table' AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `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';
answered Apr 14 '15 at 6:38
Sander Mangel♦
34.7k469136
answered Apr 14 '15 at 6:38
Sander Mangel♦
34.7k469136
answered Apr 14 '15 at 6:38
Sander Mangel♦
34.7k469136
answered Apr 14 '15 at 6:38
Sander Mangel♦
34.7k469136
34.7k469136
Awesome! Website is up and running again ~ Thank you very much!
– dylanspeetz
Apr 14 '15 at 6:43
add a comment |
Awesome! Website is up and running again ~ Thank you very much!
– dylanspeetz
Apr 14 '15 at 6:43
Awesome! Website is up and running again ~ Thank you very much!
– dylanspeetz
Apr 14 '15 at 6:43
Awesome! Website is up and running again ~ Thank you very much!
– dylanspeetz
Apr 14 '15 at 6:43
add a comment |
Thanks for contributing an answer to Magento Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f63515%2fwebsite-down-accidentally-dropped-visitor-log-and-visitor-log-info-tables-in%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
in table magento is save customer url ,customer visited url list
– Amit Bera♦
Apr 14 '15 at 6:18
is this for the table visitor_log?
– dylanspeetz
Apr 14 '15 at 6:24
That error says MySQL is down. First start it back up.
– Melvyn
Apr 14 '15 at 6:29
How do I start up MySQL? Sorry I am a noob web developer
– dylanspeetz
Apr 14 '15 at 6:37
On the server commandline try either
service mysqld restartor check the/etc/init.d/directory for a MySQL startup script– Sander Mangel♦
Apr 14 '15 at 6:39