MySQL errors #1146

[DirtyMonkey]

Can anyone point me in the right direction. I think the tables are corrupt and so won't let me drop them.
How can I delete them?

I get the following errors when trying to access the tables from phpMyAdmin:

#1146 - Table 'smithieuk_.jos_jp_def' doesn't exist
#1146 - Table 'smithieuk_.jos_jp_packvars' doesn't exist

If I try and drop them i get:

#1051 - Unknown table 'jos_jp_def'
#1051 - Unknown table 'jos_jp_packvars'

If I try and reinstall JoomlaPack (which created the tables) i get:

Upload component - Failed

SQL Error DB function failed with error number 1051
Unknown table 'jos_jp_packvars' SQL=DROP TABLE IF EXISTS `jos_jp_packvars`
SQL =
DROP TABLE IF EXISTS `jos_jp_packvars`

 

[tiramisu_]

firstly, try to do it manually from shell,

check where DBs are locates:

cat /etc/psa/psa.cong | grep mysql

check if tables are there;


also pay attention to /var/log/mysqld.log file. It may contain useful instructions and reason of failure.

 

[DirtyMonkey]

Thanks tany, I have deleted the offending tables manually.