It appears that the __menu table has the administrator routes placed into rows, but they're not visible in the administrator section. There were several hundred (I'm guessing for each failed installation).

After removing these hundreds of rows I was able to complete an installation.

I'm not sure what created the initial failed installation, but it looks like the installer sets itself up to fail if it can't install over existing tables.

I'm glad you managed to sort this out.

Hi,

I didn't read this one before.

I posted my solution here: getk2.org/community/English-K2-Community/195027-Error-1146-upon-installation#195027

Hi,

I encountered similar error

1146 - Table 'DATABASENAME.xphst_k2_comments' doesn't exist SQL=SELECT COUNT(*) FROM xphst_k2_comments WHERE itemID=23 AND published=1

Did both of the remedies suggested and it didn't work.

I checked out the SQL through the cpanel and seems that there is only a table name 'xphst_k2_comments1' , the addition being the 1 as compared to the error message.

I suspect its got to do with that the database was duplicated from a site hosted on another server (though same specs).

Grateful for any advice. Thank you.

The 1 does not belong there.
Try removing 1 to see if that solves the issue.

Thanks for the response Krikor.

I'm new to mySQL.

Do I just need to run the command RENAME TABLE xphst_k2_comments1 TO xphst_k2_comments?

Is there any other dependencies etc I should note?

Best
Larry

This video will help you support.hostgator.com/articles/specialized-help/technical/phpmyadmin/how-to-rename-database-tables-in-phpmyadmin

Thank you. No errors so far! :)

You 're welcome Larry