SQL issues

S Irfan
Topic Author
Offline
Fresh Boarder

14 years 8 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..

Ahmad
Offline
Administrator

14 years 8 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.055 seconds