HI,
SINCE YESTERDAY I GET A LOT OF SQL-ERROR MESSAGES. FIRST TIME I THOUGHT IT WAS A PROBLEM OF OUR OSCOMMERCE-SHOP. THAN I SAW THAT PHPEE 2.2.5 GIVE ME THE FOLLOWING ERRORMESSAGE AFTER I LOGG IN:
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/tools/public_html/stats/dspLogs.php on line 215
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/tools/public_html/stats/dspLogs.php on line 216
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/tools/public_html/stats/dspLogs.php on line 220
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/tools/public_html/stats/dspLogs.php on line 221
THE SQL-ERRORS ARE THE FOLLOWING:
INSERT INTO PPHL_DB_PREFIX42464_logs (hostname,tld,ip,entryid,path,referer,seareng,agentid,res_w,res_h,colo r,time,t_reload,proxy,proxy_ip,proxy_hostname)
VALUES ('p548ABA8D.dip0.t-ipconnect.de','de','84.138.186.141',34809,34809,'http://www.google.de/search?hl=de&q=cool&btnG=Google-Suche&meta=lr=lang_de','Google',14,1024,768,32,1168600330,1168600330,' ','','')
1016: Can't open file: 'PPHL_DB_PREFIX42464_logs.MYI' (errno: 145)
Jan 12, 01:12:10 PM.
I TRIED TO REPAIR THE TABLE WITH :
"rapair table PPHL_DB_PREFIX42464_logs.MYI"
AND RECEIVED THE MESSAGE:
Table 'PPHL_DB_PREFIX42464_logs.MYI' doesn't exist
CAN SOMEBODY HELP ME? I NEED A TUTORIAL HOW I SHOULD INSTALL THE TABLE AND FIX THE ERROR. IM A BEGINNER AND NOT SO FIT WITH PHP AND SQL. PLEASE HELP ME. (GERMAN REPLY ARE WELCOME)