Error 1146 - not able to install

  • Posts: 2
  • Thank you received: 0
11 years 5 months ago #141550

-- url of the page with the problem -- : www.bewebbed.biz
-- HikaShop version -- : x.x.x
-- Joomla version -- : 3.2.1
-- PHP version -- : 5.3.3.
-- Browser(s) name and version -- : FF 26.0
-- Error-message(debug-mod must be tuned on) -- : Error_message

Hi, i have tried to install Hikashop many times now, but unfortunately without any luck.
First i installed the .gz file from local pc, and it just tryed to install for a long time before it timed out. Then i tried to install using ftp, unpacking and uploading the files in the .zip to a dir on the server. Same happened then, it timed out.

I noticed the site was very slow so i talked to my host and they say that the server has been very slow today cause of changing customers to another server and therefore the workload has been hard on the server. Now they have moved my site to the new server and i immediately notice that everything works much faster.
So what i did before trying to install was:

DELETE FROM `jos_menu` WHERE link LIKE '%com_hikashop%';
DELETE FROM jos_extensions WHERE element = 'com_hikashop';
DELETE FROM jos_assets WHERE name='com_hikashop';

Then i tried to install from the ftp. It went much faster this time but returned the following message:
Error 1146: xxxx.ys9u3_hikashop_config' doesn't exist SQL=SELECT * FROM ys9u3_hikashop_config

I dont now what to do next, any advise please ?

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

  • Posts: 84142
  • Thank you received: 13647
  • MODERATOR
11 years 5 months ago #141586

hi,

That's because Joomla considers HikaShop already installed and didn't install the SQL file with all the tables in it.
You need to run these queries again in your database, rename the folders components/com_hikashop and administrator/components/com_hikashop via FTP and do an install via FTP again and it should work.

The following user(s) said Thank You: nettemor

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

  • Posts: 2
  • Thank you received: 0
11 years 5 months ago #141594

Perfect, that did the trick! Thank you. Looking forward to check it out :)

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

  • Posts: 4
  • Thank you received: 0
11 years 5 months ago #143465

Dear all, i have tried to install several times using all possible means. Not possible and get the same error

'mydatabase.v7tf5_hikashop_config' doesn't exist SQL=SELECT * FROM v7tf5_hikashop_config


Please be so kind to let me know how i can install it?. Iam quite new in Joomla


thanks a lot

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

  • Posts: 84142
  • Thank you received: 13647
  • MODERATOR
11 years 5 months ago #143480

Then, extract the file back/tables.sql from the install package. Then, open it with notepad++ or another text editor and change all the table prefixes #__ with your table prefix ( it's v7tf5_ in your case) and then import the SQL file in your database via your phpmyadmin.
Once done, run again the installation and it will work.

The following user(s) said Thank You: koke

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

  • Posts: 4
  • Thank you received: 0
11 years 5 months ago #143486

Dear Nicolas..seems there was message before ;-)...I can read teh second part.....I will do it as you say.

I will inform you...thanks a lot

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

  • Posts: 4
  • Thank you received: 0
11 years 5 months ago #143702

Dear Nicolas..ia hve done all again...and i still getting th same message. I checked the tables and prefixes were added....I am blind now.....can you pease give me advices what to do?.


saludos

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

  • Posts: 84142
  • Thank you received: 13647
  • MODERATOR
11 years 5 months ago #143758

It's not possible that you get the same message if you imported the tables with the correct prefix in the database.
Either the tables were not imported in the correct database, or not with the correct prefix.

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

  • Posts: 4
  • Thank you received: 0
11 years 5 months ago #143833

Thank you Nicolas. The problem is that SQL comes with 2 "__" so it was only necessary to add the prefix without "_". Now it is installed. Thanks for your support.


cheers,


koke

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

  • Posts: 12953
  • Thank you received: 1778
11 years 5 months ago #143861

Thanks for your feedback :).

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

Time to create page: 0.113 seconds
Powered by Kunena Forum