Đã Đóng

Fix Database Sync on Wordpress DB

1. Intro to Project and Error

We have this website LPC.org.za. At the moment we have 2 posts types. Practitioner Listings and Law Firms.

These 2 post types have a relationship where some Practitioner Listings link with Law Firms and vice versa. In other words it makes it easier for people find the Law Firm that a Practitioner belongs to.

Right now there are numerous Law Firms that are linking to the wrong Practitioner.

There is an external database that syncs on a daily basis to the website.

I don’t have access to that Database unfortunately.

That external database is was populates the fiels and content for the Practitioner Listings and Law Firms

The sync runs on a CRON Job and the script is ran with custom built plugin.

I believe there may be an error in the Plugin’s Script or the external database causing these post types to not link properly.

I give far more details below and I also supplied login access to the site so that you can have a look.

2. Login details

I will share login details once the job has been approved.

3. Intro to the Website

We setup custom post types, taxonomies and fields using a plugin called Toolset

We have these 2 post types that are having syncing issues.

Law Firms

(link removed)

And

Practitioner Listings

(link removed)

3.1. Relationships

This posts type create listing on the frontend here

Law Firms: (link removed)

Practitioners: (link removed)

Some of the Law Firms and Practitioners have a relationship. Meaning that certain Law Firms will be linked to a Practitioner and vice versa.

An example will be seen here: (link removed)

Screenshot: (link removed)

3.2. Sync Plugin

The current plugin that controls the script to run the Script and Cron Job is called “LPC Database Sync”

I am not entirely sure how this plugin works, but it is definitely needed to get the Sync to work with the external database.

(link removed)

The sync basically pulls in database from an external database into this one "_sync": (link removed) and the database "_sync" database is an exact replica of the external database. After this the database populates the "wp_posts" and "wp_mostmeta" tables, thuse creating the posts

3.3. Cron Job

The cron job is setup in the Cpanel here under Advance - Cron Jobs: (link removed)

This is required for the Sync to happen every day, right now it's on pause.

3.4 Database where the field pull in from

The sync populates the database table that fall under lpcorg_sync found in our PHPMYADMIN here

(link removed)

4. Error

The error we're getting on this site is that some Practitioners are linking to the incorrect Law Firms and I am not able to see why that is.

Example 1

Prebashnie Moonsamie: (link removed)

Current Associated Firm: Mphela & Associates Attorneys

It's supposed to be: State Attorneys (Pretoria)

(link removed)

Example 2

Jason Dean Jennings: (link removed)

Current Associated Firm: Langenhoven Attorneys Inc

It's supposed to be: Spamer Triebel Inc.

(link removed)

That is basically the error we are getting. I believe it is either the plugin script or the lpcorg_sync database causing these issues.

please write "monkey" to confirm you are not a bot.

Please could you have a look at the site and let me know if this is something that you can fix.

Thank you.

Kĩ năng: MySQL, PHP, Web Hosting, Thử nghiệm trang web

Xem nhiều hơn: fix database problems, fix bad rss wordpress feeds, database hospital management free project adonet, free database anime wordpress, integrating wordpress existing project, fix rss issues wordpress, fix database sql wordpress, wordpress fix database password, fix database error wordpress site, wordpress database sync, wordpress fix database plugin, wordpress database sync plugin, sync wordpress users with external database, www redo project org db

Về Bên Thuê:
( 0 nhận xét ) Ottawa, Canada

ID dự án: #31570191

20 freelancer chào giá trung bình $13/giờ cho công việc này

(55 Nhận xét)
7.6
(331 Nhận xét)
7.3
(462 Nhận xét)
7.3
techplusintl

monkey Hi there, ★★★ Wordpress Themes & Plugins / PHP Expert ★★★ 8+ Years of Experience ★★★ I've read requirements and ready to fix Database Sync on Wordpress DB. Websites we built with Wordpress: ✔ [login to view URL] Thêm

$25 USD / giờ
(244 Nhận xét)
7.8
devstart1234

monkey Hi, We are a team and have checked your requirement "Fix Database Sync on Wordpress DB". We are ready to sign NDA, If required. > Wordpress skills includes: - Wordpress Installation and Configuration - Wordp Thêm

$8 USD / giờ
(302 Nhận xét)
7.5
smilemittal181

"monkey" Hello, I can easily fix Database Sync on Wordpress DB. I am a senior WordPress developer with over 7+ years of experience in website designing, development and customisation. I have built and customized 500+ w Thêm

$10 USD / giờ
(195 Nhận xét)
7.3
maxpl

Hi, Hope you are fine. I am an experienced web and mobile app developer. I have 8+ years of experience in webdesign/development and Mobile Deve Thêm

$15 USD / giờ
(33 Nhận xét)
6.8
kuldeepak05

"monkey" ******* Professional WordPress/Database expert here ******* Hello, How have you been? Just checked your specification. I am ready to fix the issues being faced and can assure to deliver quality work with f Thêm

$12 USD / giờ
(57 Nhận xét)
6.5
vishalpardhi27

I CAN START WORK ON IT IMMEDIATELY. Hi mate, I’d be glad to assist for Fix Database Sync issue an existing site. I have 6+ years experience with web development. Proven experience in MySQL, HTML5, CSS3, JavaScript, Aj Thêm

$12 USD / giờ
(82 Nhận xét)
6.2
FiveExceptions

Hello, Here, we have a team of highly professional developers with expertise in website development using different technologies. Whether it's creating a website from scratch, integrating plugins, APIs, or any other t Thêm

$15 USD / giờ
(20 Nhận xét)
6.3
camper2020

monkey. Hi there, I've read through the specs and had a look at the site. I believe I can assist. I have extensive experience with WordPress development and custom posts, taxonomies, fields and custom plugins (having Thêm

$12 USD / giờ
(24 Nhận xét)
5.6
arnoldb

Hello Sir, I hope you are doing well. I am a full stack developer from Poland with 8 years of experience in mobile app and web technologies. I Thêm

$15 USD / giờ
(14 Nhận xét)
5.6
saaz109

Hi I AM READY TO START NOW I read through the job details carefully and I am absolutely sure that we can do the project very well. In a nutshell, I'm a freelancer with more than 7 years of work experience. Expert i Thêm

$12 USD / giờ
(42 Nhận xét)
5.4
(35 Nhận xét)
4.7
(20 Nhận xét)
3.9
SocialMagnetic7

"monkey" Hello, I have just studied the project description and I can assure you that I will fix the issue. I will complete this project as per your expectations. I guarantee that my work will be 100% professional. I Thêm

$8 USD / giờ
(1 Nhận xét)
1.8
naiklancer

Hello sir! I am available now to discuss the project! I am skillful WordPress Developer and I use WordPress and Adobe Illustrator to craft the designs with skills including Web Hosting, Website Testing, MySQL and PHP Thêm

$20 USD / giờ
(0 Nhận xét)
0.0
enakshibard

WORDPRESS PRO (Perfectionist-Reliable-Original) developer is READY to GET STARTED right now for outstanding outcome services tailored to your needs. Competent Freelance developer with GENUINE Expertise and relevant Ex Thêm

$8 USD / giờ
(0 Nhận xét)
0.0
sneh86

Hello, I build custom themes and plugins for WordPress and WooCommerce, my focus is to build the best, secure, reliable, optimized, and good user experience websites for Informational, Membership, and eCommerce. I ha Thêm

$12 USD / giờ
(0 Nhận xét)
0.0
indritneza1995

Hello, I have reviewed your project details and feel that I can immediately work on your project. I have strong expertise to accomplish this project in the decided time frame. I have developed many WordPress sites b Thêm

$15 USD / giờ
(0 Nhận xét)
0.0