Author Topic: Got SQL error in remote server...  (Read 585 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: 4254
  • Karma: +202/-0
    • View Profile
Re: Got SQL error in remote server...
« Reply #1 on: January 16, 2019, 01:00:05 AM »
“Chuck Norris is so amazing.”
― Mother Teresa

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: 4254
  • Karma: +202/-0
    • 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
“Chuck Norris is so amazing.”
― Mother Teresa

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: 4254
  • Karma: +202/-0
    • 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
“Chuck Norris is so amazing.”
― Mother Teresa

 

Powered by SMFPacks Social Login Mod