Find Jobs
Hire Freelancers

Modify MySQL Trigger for Insert

$10-50 CAD

Completed
Posted almost 3 years ago

$10-50 CAD

Paid on delivery
Modify MySQL Trigger to fix the insert statement old and new values into event_log_track (Event Log Track is a Drupal module. Drupal version is 8. Must be able to complete the work in 1-2 days max. Must be able to work upon award. Note the MySQL trigger is developed it just needs a fix to the insert statement, the update statement is working and has been tested. So just the Insert section to fix. SQL Trigger: BEGIN IF ([login to view URL] <> [login to view URL]) THEN IF [login to view URL] <> [login to view URL] THEN if [login to view URL] <> [login to view URL] then INSERT INTO bitnami_drupal8.event_log_track (type,operation,path,ref_numeric,ref_char,description,attribute,value, old_value,uid,ip,created) VALUES (‘user’,’update’,‘user/487/edit’,’487’,’staff’,’staff’, ‘Field1’,‘1’,‘2’,’487’,’0.0.0.0’,UNIX_TIMESTAMP(NOW())); end if; /*Muniaddr1 --- [login to view URL],[login to view URL]*/ UPDATE bitnami_drupal8.user__field_field1, (SELECT DISTINCT etm.entity_id, [login to view URL] AS targetValue FROM [login to view URL] t1 INNER JOIN bitnami_drupal8.entity_to_locationID etm ON [login to view URL] = [login to view URL] INNER JOIN bitnami_drupal8.user__field_field1 t2 ON etm.entity_id = t2.entity_id) tbl SET bitnami_drupal8.user__field_addr1.field_field1_value = [login to view URL] WHERE bitnami_drupal8.user__field_addr1.entity_id = tbl.entity_id; END SQL, PHP, and Drupal knowledge are required. Must be able to complete the work in 1-2 days max. Must be able to work upon award. Must note what and where changes to SQL, Drupal, or Drupal modules are.
Project ID: 30680652

About the project

5 proposals
Remote project
Active 3 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi I have extensive SQL development experience . I can do this query for you today. Please view samples of code and documents that I have created available on [login to view URL] . Client comments: Feefo Star Ratings: [login to view URL] I look forward to your soonest reply. Kind regards Sarah
$30 CAD in 1 day
5.0 (2 reviews)
2.7
2.7
5 freelancers are bidding on average $40 CAD for this job
User Avatar
Hello i can Modify MySQL Trigger for Drupal Event Log message me i am ready to start from now.
$100 CAD in 2 days
4.8 (353 reviews)
7.4
7.4
User Avatar
......................................................................................................................................................................................................
$20 CAD in 1 day
5.0 (1 review)
0.0
0.0
User Avatar
Hi Can you please share the Full task list?? I'm a senior front and back end developer with 5+ years of experience in (PHP , CSS , HTML, and Drupal primarily). I specialize in creating custom web projects and RESTful APIs with Drupalframework. Looking forward to your positive response. Thanks and Regards Sahlini
$20 CAD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
BRAMPTON, Canada
5.0
10
Payment method verified
Member since Jul 13, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.