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.
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
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