Keyword

Error 1146 upon installation

  • Giacomo
  • Giacomo's Avatar Topic Author
  • Offline
  • New Member
More
10 years 3 months ago - 10 years 3 months ago #129201 by Giacomo
Error 1146 upon installation was created by Giacomo
Hello everyone,

I tried installing K2_v2.6.8.zip on Joomla! 3.3.0 but it kept failing with a 1146 error,
stating that the *_k2_* tables did not exist.

Background:

- HTTP server: nginx/1.2.1
- Scripting: PHP 5.4.4-14+deb7u9
- DB: mysql Ver 15.1 Distrib 10.0.11-MariaDB

Given that structure is quite tested and running (we're hosting a hundred other websites)
and the privileges on the DB are ok, I made it work by

- unzipping the source (K2_v2.6.8.zip)
- editing the file "administrator/components/com_k2/install.mysql.sql"
- creating tables by hand (user is the same of "configuration.php")
- commenting the whole file
- zipping back everything
- upload and install

Now it works.
I think the problem was something related to the table names
(e.g.: CREATE TABLE IF NOT EXISTS `#__k2_attachments`)
where the "#_" sign gets replaced.

To cut it short, I don't know which was the exact matter.

Hope someone finds it useful,

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


Powered by Kunena Forum