mysql> REPLACE INTO tblVisits (
-> VisitLogID,
-> HostAccount,
-> Style,
-> Format,
-> Source,
-> Category,
-> Server,
-> UserID,
-> RemoteIP,
-> UserAgent,
-> RemoteHost,
-> Referer,
-> Date_Time,
-> ReferralAccount,
-> Summarized)
-> SELECT
-> VisitLogID,
-> IFNULL(a.Account,"Invalid"),
-> IFNULL(st.Style,"Invalid"),
-> Format,
-> Source,
-> IFNULL(c.Category,"Invalid"),
-> IFNULL(s.Server,"Invalid"),
-> UserID,
-> RemoteIP,
-> UserAgent,
-> RemoteHost,
-> Referer,
-> Date_Time,
-> ReferralAccount,
-> '0'
-> FROM (((uplVisits AS v
-> LEFT JOIN tblCategory AS c ON v.Category = c.CategoryAlias)
-> LEFT JOIN tblAccountMap AS a ON v.HostAccount = a.AccountAlias)
-> LEFT JOIN tblStyle AS st ON v.Style = st.Style)
-> LEFT JOIN tblServer AS s ON v.Server = s.Server;
ERROR 2013: Lost connection to MySQL server during query
mysql> Bus Error - core dumped
Brandon Shuey
WebCentric Inc.
(316) 612-8030
brandon@stripped