SQL issues

11 years 2 months ago #550 by S Irfan
SQL issues was created by S Irfan
Salam o Aleikum,

MashAllaah, what a nice component you have created, I believe it is going to be the best of its kind inshaAllaah!

I have installed this component so far for about two times after uninstalling it following the first installation just to ensure that I did not do anything wrong but that was not the case I learned. I have duplicate entires of States, Cities, Counties, and whatever else that is a part of those tables and all I do is install the component through Joomla 1.5.13\'s standard installer.

I would greatly appreciate it should you be so kind to help me resolve this issue at your earliest opportunity.

Thank you!

Kindest regards..
11 years 2 months ago #552 by Ahmad
Replied by Ahmad on topic SQL issues
WaSalam,

Thanks for nice comments.

There is two way to remove duplicate entries
1- Delete all data form #__js_job_states, #__js_job_counties & #__js_job_cities tables and run insert addresses query.

2- Uninstall it and delete these tables #__js_job_states_bak, #__js_job_counties_bak & #__js_job_cities_bak and install again.

Please note: Uninstall and install will not removing duplicate entries.

Please write your valuable review JS Jobs and JS Support Ticket at JED.
Time to create page: 0.149 seconds

Please publish modules in offcanvas position.