View Full Version : Mysql error
February 23rd, 2006, 11:23 AM
I installed the gallery yesterday and shared the vB database using pp_ tables
After noticing a few tables were "in use" but empty in phpymyadmin I ran a vB 'Repair and Optimise' and it's showing this error
pp_admlog Check Error: File './watw_forums/pp_admlog.MYD' not found (Errcode: 2)
Could you let me know what I need to do to fix it
February 23rd, 2006, 11:31 AM
Sometimes a few times cleans up table crashes.
try and run again.
February 23rd, 2006, 11:34 AM
I've tried it 5/6 times but still no change
February 23rd, 2006, 12:35 PM
Looks to me like the table is corrupt or does not exist
REPAIR TABLE pp_admlog
February 23rd, 2006, 12:42 PM
I've tried repair table and it throws up this error:
watw_forums.pp_admlog repair error File './watw_forums/pp_admlog.MYD' not found (Errc...
phpmyadmin records are showing the table "in use" rather than giving kb info
Also getting the same sort of error with vb_usernote (for vBulletin) and vb_adv_setting (for vba cmps)
February 23rd, 2006, 12:45 PM
I can not comment on vbulletin but obviously you have some issues with your mysql.
Try dropping the admlog table and recreate it
CREATE TABLE pp_admlog (id int(10) NOT NULL auto_increment,adminuser varchar(50) NOT NULL default '',description varchar(255) NOT NULL default '',datestamp int(20) NOT NULL default '0',ip varchar(35) NOT NULL default '',PRIMARY KEY (id)) TYPE=MyISAM
February 23rd, 2006, 12:51 PM
That looks like it's fixed it, thanks
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.