Find Jobs
Hire Freelancers

Fix Database Sync on Wordpress DB

$8-15 USD / hour

Stengt
Lagt ut over 2 år siden

$8-15 USD / hour

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.
Prosjekt-ID: 31570191

Om prosjektet

20 forslag
Eksternt prosjekt
Aktiv 2 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
20 freelancers are bidding on average $13 USD/time for this job
Brukeravatar
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 written and worked with numerous ones over the last 10 years). I would need to look through the code to see if there is an issue internally with the existing plugin or with the source DB and whether or not it can be tweaked to work. Also I am based in SA which may help considering it is a South African website.
$12 USD om 5 dager
5,0 (24 omtaler)
5,6
5,6
Brukeravatar
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 Experience is ready to take over your job requirements in a professional manner with a steady eye to responsive and optimised coding patterns. My Motto is simple, it's ORANGE Outstanding Results, Ample kNowledge, Genuine Experience All at a very affordable rate without any compromise to the coding and design quality Please initiate DM to discuss furtherwards Stay safe and blessed Best Wishes your digital friend :)
$8 USD om 40 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
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 before and have expertise with them. - Theme Customization and Development - Plugin Development and Customization - Payment Gateway Integration - Building Theme/Template or site from scratch in WP - Bootstrap, CSS & jQuery for full responsive UI. Please consider me once and initiate a chat for more discussion. Regards, Indrit
$15 USD om 40 dager
0,0 (0 omtaler)
0,0
0,0

Om klienten

CANADAs flagg
Ottawa, Canada
0,0
0
Medlem siden jul. 28, 2021

Klientbekreftelse

Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.