Error updating MySQL with composite keys

I have the following table in Mysql
insert the description of the image here

I've tried every means to perform an SQL update, but each time it returns the same error below.

Can not Add or Update Child Line: Foreign Key Constraint Fails

This is the SQL update

UPDATE ACDM_TREI_RLZD_ALU_EXCC SET EST_EXCC = 'OK' WHERE CD_ALU = 1 ANDTS_RLZC_TREI = 2019-02-16 & # 39; ANDNR_EXCC = 1

This is the table on which it depends
insert the description of the image here

An idea of ​​what I might miss?

My server returns 404 error for accented files – Ubuntu 16.04

When I try to extract files with an accent or even open them, the server returns a 404 error:
www.pennacorp.com.br/B2B%20-%20Conex%C3%B5es%20com%20filial.pdf

But the file exists inside the server, I can see it via ftp:
Sample Image – B2B – Connections


MORE INFO

I have two Ubuntu servers with different versions:

  • In ubuntu 16.04, it returns to me the 404 error
  • In Ubuntu 14.04, the link opens normally:
    www.pennatec.com.br/B2B%20-%20Conex%C3%B5es%20com%20filial.pdf

Error over a table serving Azure

At the moment, there is a tabla al servicio, este cae and genera el siguiente error:

Thu. Feb. 14 2019 23:52:07 GMT + 0000 (Coordinated Universal Time): The application has generated an uncaught exception and is complete:
Error: Invalid metadata file "ejemplo.json": Invalid road metadata for the road. / #.; & # 39; undelete & # 39; is not an http method or a table operation supported.
at throwMetadataError (D: home site wwwroot node_modules azure-mobile-services runtime script metadata.js: 73: 15)
on D: home site wwwroot node_modules azure-mobile-services runtime script metadata.js: 109: 21
to the function..each..forEach (D: home site wwwroot node_modules underscore underscore.js: 86: 24)
on D: home site wwwroot node_modules azure-mobile-services runtime script metadata.js: 107: 15
to the function..each..forEach (D: home site wwwroot node_modules underscore underscore.js: 86: 24)
to validateMetadata (D: home site wwwroot node_modules azure-mobile-services runtime script metadata.js: 97: 7)
at new metadata (D: home site wwwroot node_modules azure-mobile-services runtime script metadata.js: 21: 5)
on ScriptLoader._loadScript.fileHelpers.readFileWithRetries.scriptInfo.script (D: home site wwwroot modules_node azure-mobile-services runtime script scriptloader.js: 189: 45)
at requireWithRetries (D: home site wwwroot node_modules azure-mobile-services runtime filehelpers.js: 77: 13)
on Object.exports.requireWithRetries (D: home site wwwroot node_modules azure-mobile-services runtime filehelpers.js: 101: 5)

theming – The Installes Jquery Color Picker Module now installs an error

I have installed the Jquery Color Picker module and I now get this error. Can someone help? I am a newb ….

The website has encountered an unexpected error. Please try again later.
Error: The class' Drupal field_group Routing FieldGroupConverter & # 39; was not found in Drupal Component DependencyInjection Container-> createService () (line 258 of core / lib / Drupal / Component / DependencyInjection / Container.php).
Drupal Component DependencyInjection Container-> createService (Array, field_group.param_converter & # 39;) (line: 171)
Drupal Component DependencyInjection Container-> get (# field_group.param_converter # 1) (Line: 480)
Drupal Component DependencyInjection Container-> resolServicesAndParameters (Array) (Line: 319)
Drupal Component DependencyInjection Container-> createService (Array, paramconverter_manager) (line: 171)
Drupal Component DependencyInjection Container-> get (paramconverter_manager, # 1) (Line: 480)
Drupal Component DependencyInjection Container-> resolServicesAndParameters (Array) (Line: 230)
Drupal Component DependencyInjection Container-> createService (Array, route_enhancer.param_conversion) (line: 171)
Drupal Component DependencyInjection Container-> get (route_enhancer.param_conversion, 1) (Line: 480)
Drupal Component DependencyInjection Container-> resolServicesAndParameters (Array) (Line: 319)
Drupal Component DependencyInjection Container-> createService (Array, & # 39; router.no_access_checks & # 39;) (line: 171)
Drupal Component DependencyInjection Container-> get (& # 39; router.no_access_checks & # 39; 1) (Line: 480)
Drupal Component DependencyInjection Container-> resolServicesAndParameters (Array) (Line: 230)
Drupal Component DependencyInjection Container-> createService (Array, Router & # 39;) (Line: 171)
Drupal Component DependencyInjection Container-> get (& # 39; 1) (Line: 480)
Drupal Component DependencyInjection Container-> resolServicesAndParameters (Array) (Line: 230)
Drupal Component DependencyInjection Container-> createService (Array, & rt; router_listener & # 39;) (Line: 171)
Drupal Component DependencyInjection Container-> get (& # 39; router_listener & # 39;) (Line: 71)
Drupal webprofiler EventDispatcher TraceableEventDispatcher-> dispatch (<kernel.request> Object) (Line: 127)
Symfony Component HttpKernel HttpKernel-> handleRaw (Object, 1) (Line: 68)
Symfony Component HttpKernel HttpKernel-> handle (Object, 1, 1) (Line: 57)
Drupal Core StackMiddleware Session-> handle (Object, 1, 1) (Line: 47)
Drupal Core StackMiddleware KernelPreHandle-> handle (Object, 1, 1) (Row: 99)
Drupal page_cache StackMiddleware PageCache-> pass (Object, 1, 1) (Line: 78)
Drupal page_cache StackMiddleware PageCache-> handle (Object, 1, 1) (Line: 47)
Drupal Core StackMiddleware ReverseProxyMiddleware-> handle (Object, 1, 1) (Line: 38)
Drupal webprofiler StackMiddleware WebprofilerMiddleware-> handle (Object, 1, 1) (Line: 52)
Drupal Core StackMiddleware NegotiationMiddleware-> handle (Object, 1, 1) (Line: 23)
Stack StackedHttpKernel-> handle (Object, 1, 1) (Line: 669)
Drupal Core DrupalKernel-> handle (Object) (Line: 19)

python – GIF / PPM Converter in Grayscale Generates "Out of Range Coordinates" Error

My current exercise is to convert a .gif or .ppm file to grayscale. I had the code, and from what I understood, it should work, but I got an error while running the program.

Traceback (most recent call last):
File ".  Greyscale.py", line 54, in 
    main ()
File ".  Greyscale.py", line 43, in the main folder
image2convert = convert (image2convert)
File ".  Greyscale.py", line 29, converted
r, g, b = image2convert.getPixel (pixelx, pixely)
"C:  Python37  lib  site-packages  graphics.py" file, line 933, in getPixel
value = self.img.get (x, y)
File "C:  Python37  lib  tkinter  __ init__.py", line 3581, in get
returns self.tk.call (self.name, get, x, y)
_tkinter.TclError: pyimage1 get: coordinates out of range

Here is my code:

# greyscale.py - Converts an image file to grayscale

since tkinter.filedialog import askopenfilename, askaveasfilename
of graphic import *

def displayimage (imagefile):
#Open image to get width and height
image2convert = Image (Point (0, 0), image file)
imgwidth = image2convert.getWidth ()
imgheight = image2convert.getHeight ()

# Set the size of the window to the size of the image and draw the image on the window.
win = GraphWin ("grayscale converter", imgwidth, imgheight)
image2convert.move (imgwidth / 2, imgheight / 2)
image2convert.draw (win)

returns image2convert, wins

def convert (image2convert):
width = image2convert.getWidth ()
height = image2convert.getHeight ()

#For each row of pixels
for pixelx in the range (width + 1):
#For each column of pixels
for pixely in range (height + 1):
print (pixelx, pixely)
# Get Pixel Color, calculate grayscale, set Pixel on calculated color
r, g, b = image2convert.getPixel (pixelx, pixely)
brightness = int (round (0.299 * r + 0.587 * g + 0.114 * b))
image2convert.setPixel (pixelx, pixely, color_rgb (brightness, brightness, brightness))
#View progress for each line
update (win)
return image2convert

def ():
imagefile = askopenfilename (filetypes =[("GIF-Image", ".gif"), ("PPM-Image", ".ppm")])

image2convert, win = displayimage (imagefile)

#convert after the click
win.getMouse ()
image2convert = convert (image2convert)

#save new image
outFile = askaveasfilename (image2convert)
newImg = image2convert.save (outFile)

#close file and window after click
win.getMouse ()
image2convert.close ()
win.close ()

main ()

Get the pixel takes the x and y coordinates as an argument and generates a list of color values ​​-> [r, g, b]

I really do not see why it does not work, I used print to display the x, y values ​​each time and it seemed ok too:

0 0
0 1
0 2
0 3
0 4
0 5
0 6
0 7
0 8
0 9
0 10
0 11
0 12
0 13
0 14
0 15
0 16
0 17
0 18
0 19
0 20
0 21
0 22
0 23
0 24
0 25
0 26
0 27
0 28
0 29
0 30
....

So, it passes correctly through each pixel of the first loop but fails to get the pixel colors.

Ideas?

woocommerce – error call_user_func_array () – WordPress Development Stack Exchange

I have this message when I try to add a new variant of a product on Woocommerce / WP:

Warning: call_user_func_array () expects parameter 1 to be a valid callback, array must have exactly two members in /home/snap/public_html/wp-includes/class-wp-hook.php on line 288 .

This type of message appears when I log in to my administrator account and other places as well, for two days.

Can someone help me?

Thank you!

ERROR JSON response. For more information on this error, please visit http://datatables.net/tn/1

Click on the "Add to Cart" button for impossible answers, it is impossible to define the name of the person who made a mistake, but it is possible to choose a program program. doy con el chiste (PORQUE EL AOP PORQUE ES LO THAT ME DICE CHROME THAT THE ERROR IS EL EL ARCHIVO FETCH.PHP IN THE LINEA 25), agradeceria su ayuda. The code compartments and animation.

db.sql

-
- Database: `testing`
-

- ------------------------------------------------- --- --------

-
- Table structure for the `tbl_employee` table
-

CREATE TABLE `tbl_employee` (
`id` int (11) NOT NULL,
`name` varchar (50) NOT NULL,
The text `address` is not NULL,
`gender` varchar (10) NOT NULL,
`designation` varchar (100) NOT NULL,
`age` int (11) NOT NULL,
`images` varchar (150) NOT NULL
) ENGINE = MyISAM DEFAULT CHARSET = latin1;

-
- Dumping data for table `tbl_employee`
-

INSERT INTO job_blue (`id`,` name`, `address`,` sex`, `designation`,` age`, `images`) VALUES
(6, "Barbra K. Hurley," 1241 Canis Heights Drive, Los Angeles, CA 90017, "Woman," & # 39; Service Technician & # 39; 39, 26 years old, image_35.jpg & # 39;),
(7, 'Antonio J. Forbes', '403 Snyder Avenue  Charlotte, NC 28208,' Male, 'Faller', 28 years, 'image_36.jpg',
(8, "Charles D. Horst," 1636 Walnut Hill Drive, Cincinnati, OH 45202, "Male," Financial Investigator & # 39; , 29 years old, & # 39;) image_37.jpg,
(174, "Martha B. Tomlinson," 4005 Bird Spring Lane, Houston, TX 77002, "Female," Systems & Programmer ". , 28 years old, 'image_44.jpg',
(162, "Jarrod D. Jones", "3827 Bingamon Road, Garfield Heights, OH 44125", "Man", "Workforce Development Advisor", 24, "image_3.jpg" )
(192, 'Flora Reed', '4000 Hamilton Drive Cambridge, MD 21613', 'Female,' Machine Offbearer ', 27 years old, & # 39; image_41.jpg & # 39;)
(193, "Donna Case", "4781 Apple Lane Peoria, IL 61602", "Female", "Machine Operator", 26, "image_15.jpg"),
(194, "William Lewter," "168 Little Acres Lane Decatur, IL 62526," "Man," "Process Engineer," 25, "image_46.jpg"),
(195, 'Nathaniel Leger', '3200 Harley Brook Lane, Meadville, PA 16335', ​​'Male', 'Nurse', and the 21 years old, & # 39; image_34.jpg & # 39;),
(183, "Steve John," 108, Vile Speaks, CL, "Man," Software Engineer, 29, & & 39, & # 39; # 39; image_47.jpg & # 39;)
(186, "Louis C. Charmis", "1462 Juniper Drive" "Breckenridge, MI 48612", "Man", "Mental Health Advisor", 30, "),
(200, 'June Barnard', '4465 Woodland Terrace Folsom, CA 95630', 'Woman', 'Fishing Boat Operator', 24 years old & # 39;);

-
- Index for empty tables
-

-
- Index for the table `tbl_employee`
-
ALTER TABLE `tbl_employee`
ADD PRIMARY KEY (`id`);

-
- AUTO_INCREMENT for empty tables
-

-
- AUTO_INCREMENT for the table `tbl_employee`
-
ALTER TABLE `tbl_employee`
MODIFY `id`int (11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT = 206;

database_connection.php

index.php


 
  Delete Mysql data with the help of jquery Dialogify with PHP Ajax
  
  
  
    
  
  
  
 
 
  

Delete Mysql data with the help of jquery Dialogify with PHP Ajax


Employee data

first name Sex Designation Age View edit Wipe off

fetch.php

prepare ($ query);
$ statement-> execute ();
$ result = $ statement-> fetchAll ();
$ data = array ();
$ Filter_rows = $ statement-> rowCount ();
foreach ($ result as $ row)
{
$ sub_array = array ();
$ sub_array[] = $ row["name"];
$ sub_array[] = $ row["gender"];
$ sub_array[] = $ row["designation"];
$ sub_array[] = $ row["age"];
$ sub_array[] = & # 39;& # 39 ;;
$ sub_array[] = & # 39;& # 39 ;;
$ sub_array[] = & # 39;& # 39 ;;
$ data[] = $ sub_array;
}

get_total_all_records function ($ connect)
{
$ statement = $ connect-> prepare ("SELECT * FROM tbl_employee");
$ statement-> execute ();
$ result = $ statement-> fetchAll ();
return $ statement-> rowCount ();
}

$ output = array (
"draw" => intval ($ _ POST["draw"])
"recordsTotal" => $ filtered_rows,
"recordsFiltered" => get_total_all_records ($ connect),
"data" => $ data
)
echo json_encode ($ output);
?>

add_data_form.php

<? php

//insert_data.php

include (& # 39; database_connection.php & # 39;);

if (isset ($ _ POST["name"]))
{
$ error = & # 39;
$ success = & # 39;
$ name = & # 39;
$ address = & # 39;
$ designation = & # 39 ;;
$ age = & # 39 ;;
$ images = & # 39;
$ gender = $ _POST["gender"];
if (empty ($ _ POST["name"]))
{
$ error. = & # 39;

The name is required

& # 39 ;; } other { $ name = $ _POST["name"]; } if (empty ($ _ POST["address"])) { $ error. = & # 39;

The address is required

& # 39 ;; } other { $ address = $ _POST["address"]; } if (empty ($ _ POST["designation"])) { $ error. = & # 39;

The designation is required

& # 39 ;; } other { $ designation = $ _POST["designation"]; } if (empty ($ _ POST["age"])) { $ error. = & # 39;

Age is required

& # 39 ;; } other { $ age = $ _POST["age"]; } if (isset ($ _FILES["images"]["name"]) && $ _FILES["images"]["name"] ! = & # 39;) { $ image_name = $ _FILES["images"]["name"]; $ array = explode (".", $ image_name); $ extension = end ($ array); $ temporary_name = $ _FILES["images"]["tmp_name"]; $ allowed_extension = array ("jpg", "png"); if (! in_array ($ extension, $ allowed_extension)) { $ error. = & # 39;

Invalid image

& # 39 ;; } other { $ images = rand (). & # 39;. & # 39; . $ extension; move_uploaded_file ($ temporary_name, "http://es.stackoverflow.com/images/". $ images); } } if ($ error == & # 39;) { $ data = array ( & # 39 ;: name & # 39 ;: => $ name, & # 39 ;: address & # 39; => $ address, & # 39 ;: kind & # 39; => $ kind, & # 39 ;: designation & # 39 ;: => $ designation, & # 39 ;: age & # 39; => $ age, & # 39 ;: images & # 39; => $ images ) $ query = " INSERT IN tbl_employee (name, address, sex, designation, age, images) VALUES (: name, address, sex, designation, age, images) "; $ statement = $ connect-> prepare ($ query); $ statement-> execute ($ data); $ success = "Employee data inserted"; } $ output = array ( & # 39; success & # 39; => $ success, & # 39; error & # 39; => $ error ) echo json_encode ($ output); } ?>

fetch_single_data.php

prepare ($ query);
$ statement-> execute ();
while ($ row = $ statement-> fetch (PDO :: FETCH_ASSOC))
{
$ data[] = $ row;
}
echo json_encode ($ data);
}

?>

edit_data_form.php

update_data.php

<? php

//update_data.php

include (& # 39; database_connection.php & # 39;);

if (isset ($ _ POST["name"]))
{
$ error = & # 39;
$ success = & # 39;
$ name = & # 39;
$ address = & # 39;
$ designation = & # 39 ;;
$ age = & # 39 ;;
$ images = & # 39;
$ gender = $ _POST["gender"];
if (empty ($ _ POST["name"]))
{
$ error. = & # 39;

The name is required

& # 39 ;; } other { $ name = $ _POST["name"]; } if (empty ($ _ POST["address"])) { $ error. = & # 39;

The address is required

& # 39 ;; } other { $ address = $ _POST["address"]; } if (empty ($ _ POST["designation"])) { $ error. = & # 39;

The designation is required

& # 39 ;; } other { $ designation = $ _POST["designation"]; } if (empty ($ _ POST["age"])) { $ error. = & # 39;

Age is required

& # 39 ;; } other { $ age = $ _POST["age"]; } $ images = $ _POST['hidden_images']; if (isset ($ _FILES["images"]["name"]) && $ _FILES["images"]["name"] ! = & # 39;) { $ image_name = $ _FILES["images"]["name"]; $ array = explode (".", $ image_name); $ extension = end ($ array); $ temporary_name = $ _FILES["images"]["tmp_name"]; $ allowed_extension = array ("jpg", "png"); if (! in_array ($ extension, $ allowed_extension)) { $ error. = & # 39;

Invalid image

& # 39 ;; } other { $ images = rand (). & # 39;. & # 39; . $ extension; move_uploaded_file ($ temporary_name, "http://es.stackoverflow.com/images/". $ images); } } if ($ error == & # 39;) { $ data = array ( & # 39 ;: name & # 39 ;: => $ name, & # 39 ;: address & # 39; => $ address, & # 39 ;: kind & # 39; => $ kind, & # 39 ;: designation & # 39 ;: => $ designation, & # 39 ;: age & # 39; => $ age, & # 39 ;: images & # 39; => $ images, & # 39 ;: id & # 39; => $ _POST["id"] ) $ query = " UPDATE tbl_employee SET name =: name, address =: address, kind =: kind, designation =: designation, age =: age, images =: images O id =: id "; $ statement = $ connect-> prepare ($ query); $ statement-> execute ($ data); $ success = "updated employee data"; } $ output = array ( & # 39; success & # 39; => $ success, & # 39; error & # 39; => $ error ) echo json_encode ($ output); } ?>

delete_data.php

prepare ($ query);
$ statement-> execute ();
}

?>

Después coding error errors.
Introduce the description of the pictorial image

there are views of consumption:

Introduce the description of the pictorial image

Immersive images on all themes, information about windows 10 compared to the previous version v3.2.2

dual boot – Noveau and error of severity

When I start the computer and I go to the GRUB menu and I click on E and after linux line add new.modeset = 0 I can sometimes load a login page (if I can not access the login page, I get an error with it again). If I try to connect or type
CTRL + ALT + F2, I receive severity = corrected Fault. What should I do?

I am on Asus F550V and nVidia (I am reading about nVidia related issues but I am unable to find a solution to my problem).

Thank you.

Qhy am I getting an error while filtering subSelect?

select "masters". *, (select avg (rating)
from "comments" where "master_id" = "masters". "id") as rating
of "masters" where note> 3

[42703] ERROR: the "rating" column does not exist

HTTP 500 Error When Deploying Node.JS on Web App

The deployment state was successful, but the site still displays an HTTP 500 error.
I look at the request diagnostic and get the information HTTP 500 error code 1000 error code 1028. I can not find the meaning of the 1000 status code and the code of the error code. 1028 error in Google search. Please help

Request a screenshot of diagnostic screen