Mysql error

StuartDH · February 23rd, 2006, 10: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)
pp_admlog

Could you let me know what I need to do to fix it

Thanks

Stuart

Zachariah · February 23rd, 2006, 10:31 AM

Sometimes a few times cleans up table crashes.
try and run again.

StuartDH · February 23rd, 2006, 10:34 AM

I've tried it 5/6 times but still no change

Chuck S · February 23rd, 2006, 11:35 AM

Looks to me like the table is corrupt or does not exist

REPAIR TABLE pp_admlog

StuartDH · February 23rd, 2006, 11:42 AM

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)

Chuck S · February 23rd, 2006, 11:45 AM

I can not comment on vbulletin but obviously you have some issues with your mysql.

Try dropping the admlog table and recreate it

Code:

Content visible to verified customers only.

StuartDH · February 23rd, 2006, 11:51 AM

That looks like it's fixed it, thanks