Welcome Guest 

Show/Hide Header

Welcome Guest, posting in this forum requires registration.
Pages: [1]
Author Topic: exiting due to MySQL error
vbbek
Newbie
Posts: 2
Post exiting due to MySQL error
on: October 29, 2014, 20:01

Здравствуйте, сегодня пропала вся статистика по трейдам на 3 сайтах, находящихся на одном сервере. Везде нули. на домашней странице exiting due to MySQL error!

В логах :
ERROR - 2014-10-29 10:30:36 --> Database Error! Message: <b>MySQL Query fail:</b> create temporary table inlogs_temp engine=MEMORY select * from inlogs MySQL Error: Can't find file: 'inlogs' (errno: 2)

Не подскажете где искать проблему ?
Спасибо.
admin
Administrator
Posts: 130
Post Re: exiting due to MySQL error
on: October 30, 2014, 11:42

Видимо было аварийное завершение работы сервера из-за чего сломалась таблица inlogs. Причем совсем. Ее можно восстановить таким запросом в локальной базе:
DROP TABLE INLOGS;
CREATE TABLE IF NOT EXISTS `inlogs` (
`timestamp` int(10) unsigned NOT NULL DEFAULT '0',
`ip` bigint(20) NOT NULL DEFAULT '0',
`trade_id` smallint(5) unsigned NOT NULL DEFAULT '0',
`special` enum('noref','notrade','filtered','normal','se','feeder','bots') NOT NULL DEFAULT 'normal',
`referer` varchar(255) NOT NULL,
`refdomain` varchar(100) NOT NULL,
`useragent` varchar(255) NOT NULL,
`browser` varchar(20) NOT NULL,
`os` varchar(25) NOT NULL,
`is_proxy` tinyint(1) unsigned NOT NULL DEFAULT '0',
`country` char(2) NOT NULL DEFAULT '',
`is_unique` tinyint(1) unsigned NOT NULL DEFAULT '1',
`is_bounced` tinyint(1) unsigned NOT NULL,
`is_monthly_unique` tinyint(1) unsigned NOT NULL DEFAULT '1',
`weight` decimal(5,2) NOT NULL DEFAULT '1.00',
`query` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
vbbek
Newbie
Posts: 2
Post Re: exiting due to MySQL error
on: October 31, 2014, 15:06

Спасибо, помогло.
Pery1941
Newbie
Posts: 2
Post Re: exiting due to MySQL error
on: May 22, 2020, 17:47

Hi, I was facing the same error myself and was looking online for a solution when I landed here. By the way, I needed some help with research paper editing and proofreading as I am writing a research paper for my college. I would appreciate the help from you guys.
Pages: [1]
Mingle Forum by cartpauj
Version: 1.0.33.3 ; Page loaded in: 0.023 seconds.