Please help us to make AbanteCart Ideal Open Source Ecommerce Solution for everyone.

Support AbanteCart eCommerce

Author Topic: Got SQL error in remote server...  (Read 8748 times)

Offline tajrean

  • Newbie
  • *
  • Posts: 21
  • Karma: +2/-0
    • View Profile
Got SQL error in remote server...
« 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.
« Last Edit: January 15, 2019, 10:36:46 PM by tajrean »

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5774
  • Karma: +274/-2
    • View Profile
Re: Got SQL error in remote server...
« Reply #1 on: January 16, 2019, 01:00:05 AM »

Offline tajrean

  • Newbie
  • *
  • Posts: 21
  • Karma: +2/-0
    • View Profile
Re: Got SQL error in remote server...
« Reply #2 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?
« Last Edit: January 16, 2019, 07:04:54 AM by tajrean »

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5774
  • Karma: +274/-2
    • View Profile
Re: Got SQL error in remote server...
« Reply #3 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

Offline tajrean

  • Newbie
  • *
  • Posts: 21
  • Karma: +2/-0
    • View Profile
Re: Got SQL error in remote server...
« Reply #4 on: January 18, 2019, 01:38:29 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.

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5774
  • Karma: +274/-2
    • View Profile
Re: Got SQL error in remote server...
« Reply #5 on: January 18, 2019, 01:48:31 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

 

Powered by SMFPacks Social Login Mod