Part of the EllisLab Network
pMachine Pro has been replaced by ExpressionEngine, our full featured web publishing solution. Please consider upgrading.
You can download pMachine Pro here: Download pMachine Pro  |  Download Language Packs
   
 
mysql error, what do I do? 
Posted: 21 April 2006 01:32 PM   [ Ignore ]  
Summer Student
Total Posts:  15
Joined  2002-09-08

my comment form is running this error:

Comment form
MySQL Error: 1016 Can’t open file: ‘pm_security_hashes.MYI’ (errno: 144)
Query: INSERT INTO pm_security_hashes (date, ip_address, hash) VALUES (UNIX_TIMESTAMP(), ‘64.171.121.98’, ‘7c68d99d66df9ba906368386a617aef8’)

MySQL Error: 1016 Can’t open file: ‘pm_security_hashes.MYI’ (errno: 144)
Query: INSERT INTO pm_security_hashes (date, ip_address, hash) VALUES (UNIX_TIMESTAMP(), ‘64.171.121.98’, ‘957580a0e32caac8830a7882ed1de861’)

MySQL Error: 1016 Can’t open file: ‘pm_security_hashes.MYI’ (errno: 144)
Query: INSERT INTO pm_security_hashes (date, ip_address, hash) VALUES (UNIX_TIMESTAMP(), ‘64.171.121.98’, ‘10fcbc7f80812ea1bc758ba5551989de’)

MySQL Error: 1016 Can’t open file: ‘pm_security_hashes.MYI’ (errno: 144)
Query: INSERT INTO pm_security_hashes (date, ip_address, hash) VALUES (UNIX_TIMESTAMP(), ‘64.171.121.98’, ‘63034834d1d4d15bf63e586bba2bf844’)

MySQL Error: 1016 Can’t open file: ‘pm_security_hashes.MYI’ (errno: 144)
Query: INSERT INTO pm_security_hashes (date, ip_address, hash) VALUES (UNIX_TIMESTAMP(), ‘64.171.121.98’, ‘7f978278e97c14f6387dd45a46eeb8e3’)

what do I do?

Profile
 
 
Posted: 21 April 2006 01:46 PM   [ Ignore ]   [ # 1 ]  
Moderator
Avatar
RankRankRankRankRankRankRank
Total Posts:  10150
Joined  2002-04-29

You’ll need to run a repair on the table pm_security_hashes using something like phpMyAdmin. That will fix theproblem.

 Signature 

Quick Reference - EE Trial Options - EE Wiki - Docs for updating a build

Profile
 
 
Posted: 21 April 2006 01:48 PM   [ Ignore ]   [ # 2 ]  
Summer Student
Total Posts:  15
Joined  2002-09-08

hi sue.
thanks, I tried to run a repair but got this error:

#1016 - Can’t open file: ‘pm_security_hashes.MYI’ (errno: 144)

how can I reinstall that?

Profile
 
 
Posted: 22 November 2006 07:27 AM   [ Ignore ]   [ # 3 ]  
Summer Student
Avatar
Total Posts:  1
Joined  2006-11-22

I was getting this same error on my front page. Using phpMyAdmin to repair the table solved the problem. Thanks for the invaluable advice.

Just to clarify for others, the repair path is: phpMyAdmin Home > Databases > pmachine > Check the box beside pm_security_hashes > Repair table [choose this option from the ‘With selected’ drop-down].

Profile
 
 
Posted: 06 June 2007 04:06 AM   [ Ignore ]   [ # 4 ]  
Summer Student
Total Posts:  1
Joined  2007-06-06

Thanks for the update, even I was facing the same problem

 Signature 

Website Design India

Profile
 
 
   
 
 
‹‹ Smf to pMachine Pro Forums      Blank Page ››
Post Marker Legend
New Topic New posts Hot Topic Hot Topic with new posts New Poll New Poll Moved Topic Moved Topic Sticky Topic Sticky topic
Old Topic No new posts Hot Old Topic Hot Topic with no new posts Old Poll Old Poll Closed Topic Closed Topic Announcement Announcements
Theme
Change Theme
Visitor Statistics
The most visitors ever was 233, on December 18, 2007 12:04 AM
Total Registered Members: 58789 Total Logged-in Users: 0
Total Topics: 69485 Total Anonymous Users: 0
Total Replies: 374081 Total Guests: 30
Total Posts: 443566    
Members ( View Memberlist )
Active Members: