- Posts: 2
- Thank you received: 0
Error 1146 - not able to install
12 years 8 months ago #141550
by nettemor
Error 1146 - not able to install was created by nettemor
-- 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 ?
-- 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.
12 years 8 months ago #141586
by nicolas
Replied by nicolas on topic Error 1146 - not able to install
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.
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.
12 years 8 months ago #141594
by nettemor
Replied by nettemor on topic Error 1146 - not able to install
Perfect, that did the trick! Thank you. Looking forward to check it out
Please Log in or Create an account to join the conversation.
12 years 7 months ago #143465
by koke
Replied by koke on topic Error 1146 - not able to install
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
'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.
12 years 7 months ago #143480
by nicolas
Replied by nicolas on topic Error 1146 - not able to install
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.
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.
12 years 7 months ago #143486
by koke
Replied by koke on topic Error 1146 - not able to install
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
I will inform you...thanks a lot
Please Log in or Create an account to join the conversation.
12 years 7 months ago #143702
by koke
Replied by koke on topic Error 1146 - not able to install
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
saludos
Please Log in or Create an account to join the conversation.
12 years 7 months ago #143758
by nicolas
Replied by nicolas on topic Error 1146 - not able to install
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.
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.
12 years 7 months ago #143833
by koke
Replied by koke on topic Error 1146 - not able to install
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
cheers,
koke
Please Log in or Create an account to join the conversation.
Less
More
- Posts: 12953
- Thank you received: 1778
12 years 7 months ago #143861
by Mohamed Thelji
Replied by Mohamed Thelji on topic Error 1146 - not able to install
Thanks for your feedback
.
Please Log in or Create an account to join the conversation.
Time to create page: 0.232 seconds