COMMUNITY FORUM

installation error , please help! 1146 - An error

Start
Prev
1
Next
End

Anthony Chu
Topic Author
Offline
New Member

11 years 2 months ago #123921 by Anthony Chu

installation error , please help! 1146 - An error was created by Anthony Chu

1146 - An error has occurred.

Table 's562559db0.cgn5u_k2_categories' doesn't exist SQL=SHOW FULL COLUMNS FROM `cgn5u_k2_categories`

Please how to fix it?

Please Log in or Create an account to join the conversation.

Yiota
Visitor

11 years 2 months ago #123922 by Yiota

Replied by Yiota on topic Re: installation error , please help! 1146 - An error

Try to do this.

In Joomla Admin area go to Extension Manager > Discover (side bar nav)
Click on the "Discover" button at the top.
Find all of the K2 files that weren't installed and select them. Click on "Install" button at the top.
Go back to Extension Manager > Install
Reinstall the K2 SVN version zip file on top of your old installation.

Please Log in or Create an account to join the conversation.

Anthony Chu
Topic Author
Offline
New Member

11 years 2 months ago #123923 by Anthony Chu

Replied by Anthony Chu on topic Re: installation error , please help! 1146 - An error

thanks a lot. It works.

Please Log in or Create an account to join the conversation.

Yiota
Visitor

11 years 2 months ago #123924 by Yiota

Replied by Yiota on topic Re: installation error , please help! 1146 - An error

You are welcome.

Please Log in or Create an account to join the conversation.

Ryan Smith
Offline
New Member

11 years 2 months ago #123925 by Ryan Smith

Replied by Ryan Smith on topic Re: installation error , please help! 1146 - An error

I seem to have the same issue, but following the above doesn't fix my installation problem.

Joomla! 3.2.1
Failed Install: K2 2.6.7 (public) and K2.6.8SVN(git)

This is the first I've run in to this issue, and I use K2 on every client site I work on.

Please Log in or Create an account to join the conversation.

Yiota
Visitor

11 years 2 months ago #123926 by Yiota

Replied by Yiota on topic Re: installation error , please help! 1146 - An error

Did you have an older version of K2 or this is a clean installation in a clean 3.2.1 Joomla! site?
Can you install other extensions?

Please Log in or Create an account to join the conversation.

Ryan Smith
Offline
New Member

11 years 2 months ago - 11 years 2 months ago #123927 by Ryan Smith

Replied by Ryan Smith on topic Re: installation error , please help! 1146 - An error

Good morning Yiota,

It'a a clean installation of 3.2.1 on a new server (same configuration as the rest of my clients' sites).

I tried both the public release of K2 2.6.7 and a pull from Git (2.6.8 ) SVN.

All of the other standard extensions I typically install have installed fine.

I've tried the installation from URL, from the zip package as well. I'm at a loss from what the error could be. I would hate to have to wipe the server and try again, not knowing if the problem will persist.

Please Log in or Create an account to join the conversation.

Yiota
Visitor

11 years 2 months ago #123928 by Yiota

Replied by Yiota on topic Re: installation error , please help! 1146 - An error

When you went to the Extension Manager > Discover page did you get any unistalled items?
Also try to run a Fix to your database in case this helps.

Please Log in or Create an account to join the conversation.

Ryan Smith
Offline
New Member

11 years 2 months ago #123929 by Ryan Smith

Replied by Ryan Smith on topic Re: installation error , please help! 1146 - An error

I've previously completed both operations.

It doesn't appear to have an issue with the database, and there's nothing for the system to discover.

Please Log in or Create an account to join the conversation.

Yiota
Visitor

11 years 2 months ago #123930 by Yiota

Replied by Yiota on topic Re: installation error , please help! 1146 - An error

Check in your site's tmp folder for any remnants of previous uninstalled versions. Search also for any K2 files/folders installed even though you are getting an error.

Please Log in or Create an account to join the conversation.

Ryan Smith
Offline
New Member

11 years 2 months ago #123931 by Ryan Smith

Replied by Ryan Smith on topic Re: installation error , please help! 1146 - An error

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.

Please Log in or Create an account to join the conversation.

Yiota
Visitor

11 years 2 months ago #123932 by Yiota

Replied by Yiota on topic Re: installation error , please help! 1146 - An error

I'm glad you managed to sort this out.

Please Log in or Create an account to join the conversation.

Giacomo
Offline
New Member

10 years 10 months ago #123933 by Giacomo

Replied by Giacomo on topic Re: installation error , please help! 1146 - An error

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

Please Log in or Create an account to join the conversation.

larry
Offline
New Member

10 years 1 month ago #141419 by larry

Replied by larry on topic installation error , please help! 1146 - An error

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.

Please Log in or Create an account to join the conversation.

Krikor Boghossian
Offline
Platinum Member

10 years 1 month ago #141430 by Krikor Boghossian

Replied by Krikor Boghossian on topic installation error , please help! 1146 - An error

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

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.

larry
Offline
New Member

10 years 1 month ago #141496 by larry

Replied by larry on topic installation error , please help! 1146 - An error

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

Please Log in or Create an account to join the conversation.

Krikor Boghossian
Offline
Platinum Member

10 years 1 month ago #141516 by Krikor Boghossian

Replied by Krikor Boghossian on topic installation error , please help! 1146 - An error

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

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.

larry
Offline
New Member

10 years 1 month ago #141555 by larry

Replied by larry on topic installation error , please help! 1146 - An error

Thank you. No errors so far! :)

Please Log in or Create an account to join the conversation.

Krikor Boghossian
Offline
Platinum Member

10 years 1 month ago #141569 by Krikor Boghossian

Replied by Krikor Boghossian on topic installation error , please help! 1146 - An error

You 're welcome Larry

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.

Start
Prev
1
Next
End