Yesterday i import a SQL file through PHPMYADMIN in my opencart database, after successful uploaded, when i search the file in the structure tab, i can't found the file. But when i try the search tab then in the table list, i can see the file. Now how can i solve thia issue? The sql file is related with a zipcode/pincode based extension, without the sql file the extension not working. I tried to re import but got error. You can see the sql file in this link:- //-- ADMIN DELETED LINK CONTAINS MALWARE --//
Attachments
error.JPG (553.23 KiB) Viewed 1059 times
You can try running the following SQL on the SQL tab in your database
Then try running your extensions SQL again
Code: Select all
drop table if exists zip_code;
This is not really an OpenCart issue, but a mysql issue.
You should check with your extension developer to see if they can shed any light on it.
Most likely their SQL contains something that is causing the issue
You should check with your extension developer to see if they can shed any light on it.
Most likely their SQL contains something that is causing the issue
SQL file seems fine - I have however deleted your zippy link as it leads to malware / adware from the site linked.
Added the sql to a temp database and it shows without error.
From your screen shot, not all tables are shown on the left panel, you may need to click on the > next arrow at the top of that left column to view the rest of the tables in that list
Added the sql to a temp database and it shows without error.
From your screen shot, not all tables are shown on the left panel, you may need to click on the > next arrow at the top of that left column to view the rest of the tables in that list
Check the attachment for sql file.
Attachments
Hi
If the extension is no longer available, then you should either grab a new extension that is supported or raise a post in the Commercial Support forum for paid assistance
If the extension is no longer available, then you should either grab a new extension that is supported or raise a post in the Commercial Support forum for paid assistance
Who is online
Users browsing this forum: No registered users and 58 guests