Brandon Shuey wrote:
>
> 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
>
Check the logs, see if other queries run OK, see if this one will give
you the same error again.
--
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)
