I would suggest to change your SQL to
INSERT INTO visitorslog
(VisitorName, HostName, DateVisit, VisitType, TimeIn, TimeOut)
SELECT VisitorName, HostName, DateVisit, VisitType, TimeIn, TimeOut
FROM pvmsvisitor WHERE LogID = 1"
Like Richard mentioned in his comment there are two missing fields and additional the
VALUES
are not needed.