Database Issue

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 --//

Tried logging out of phpmyadmin and back in ?

Still can't solve the problem.

You can try running the following SQL on the SQL tab in your database
Then try running your extensions SQL again

Successfully drop the sql file and successfully reinsert it again but again can't search the file in structure. How can i solve it?

My opencart version is 1.5.6.4

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

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

Check the attachment for sql file.

thank you, problem solved.

I want to add cod payment option with this extension, how can I do that? I mean pincode based cod payment option.

You will need to contact the extension developer regarding this

I got this extension from marketplace of opencart and now its available there, so can't take the help of developer. Please help me in this matter.

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