AbanteCart Community

eCommerce construction => Installation and Configuration => Fresh Installation => Topic started by: tajrean on January 15, 2019, 09:05:24 PM

Title: Got SQL error in remote server...
Post by: tajrean on January 15, 2019, 09:05:24 PM
I got the following message after uploading abantecart in my remote host.

SQL Error: Table 'epiz_21893854_nos.settings' doesn't exist
Error No: 1146
SQL: SELECT se.* FROM settings se WHERE se.store_id = '0' AND se.`group` NOT IN (SELECT `key` FROM extensions) in /home/vol2_1/epizy.com/epiz_21893854/htdocs/core/database/amysqli.php on line 109

I wanted to create table under my database but the database doesn't show up even if created.

Can anyone help me? WOuld really appreciate it.
Title: Re: Got SQL error in remote server...
Post by: Basara on January 16, 2019, 01:00:05 AM
Hello. If you upload only files this will not work. You have to load database too
https://abantecart.atlassian.net/wiki/spaces/AD/pages/22511620/Changing+Domain+Name#ChangingDomainName-Movetoanotherhosting
Title: Re: Got SQL error in remote server...
Post by: tajrean on January 16, 2019, 06:38:36 AM

Thanks for reply. I read the link and i did as it said. I backed up xyz_settings database and imported it to the remote location but error occurred ( attached the screenshot)
IS there any way to fix this?
Title: Re: Got SQL error in remote server...
Post by: Basara on January 16, 2019, 06:42:22 AM
Hi. Please check your screenshot. You have an error message describe the problem: "access denied". Please ask hosting support to help you configure mysql database user permissions
Title: Re: Got SQL error in remote server...
Post by: tajrean on January 18, 2019, 01:38:29 AM
Quote from: Basara on January 16, 2019, 06:42:22 AM
Hi. Please check your screenshot. You have an error message describe the problem: "access denied". Please ask hosting support to help you configure mysql database user permissions

It would be better if you could write down the process for installing abantecart without using softaculous in remote server.
Title: Re: Got SQL error in remote server...
Post by: Basara on January 18, 2019, 01:48:31 AM
Quote from: tajrean on January 18, 2019, 01:38:29 AM
It would be better if you could write down the process for installing abantecart without using softaculous in remote server.

Hello. You don't need Softaculous to install AbanteCart. Check regular installation manual https://abantecart.atlassian.net/wiki/spaces/AD/pages/4391051/Regular+Installation