Questions tagged as 'mysql'

Tagged questions
3
answers

Update Syntax Error

Good morning, I'm trying to make an "Update" to two tables in my database but doing so marks me an error and I'm not able to find the error, as far as I understand the syntax of my query is fine. But even so phpmyadmin throws me the error that s...
asked by 09.10.2017 / 19:09
0
answers

# 1227 - Access denied; Do you need (at least one of) SUPER privileges for this operation in 10hosting?

I have a problem in my database that I went up to a free hosting, the problem is that when I want to integrate my task planners to run they do not let me install them and they do not even let me activate the planner I do not know what happens I...
asked by 06.10.2017 / 01:11
0
answers

Save SQL array using Symfony2 and Doctrine

I have an array type column like this in an entity: @ORM\Column(name="acompanantes", type="array") public fuction setAcompanantes(array $acompanantes) { $this->acompanantes = $acompanantes; return $this; } public fuction getAcompan...
asked by 06.10.2017 / 13:11
0
answers

Nodejs and MySQL: LOAD DATA INFILE sends error "No such file or directory"

I want to do a LOAD FILE from Mysql from Nodejs but I get an error { Error: EE_STAT: Can't get stat of '/var/www/node/importacion/api/csv_files/bulk_for_mysql_410201713121.txt' (Errcode: 2 "No such file or directory") My script is as follow...
asked by 04.10.2017 / 18:57
1
answer

Error when modifying a PHP and MYSQLI image

I have this code but I'm getting this error ... <?php session_start(); $conexion = mysqli_connect("localhost","root","", "trigoyponque2017"); /* $ruta = $_FILES['foto1']['tmp_name']; $destino = "../productos/".$_FILES['foto1']['na...
asked by 04.10.2017 / 20:07
0
answers

Web slows down due to table with thousands of records

Good afternoon, I find myself doing a library with PHP, MySQL and JS for a family member. When he asked me, he told me that he did not want to see the results paged, but all on the same page. The problem comes when I load thousands of records in...
asked by 16.10.2017 / 16:13
1
answer

Replace an old image with php and MySqli

Good evening! I know how to add an image and save it in my Mysql DB, but at the time of doing the UPDATE the image does not replace it. <?php session_start(); $conexion = mysqli_connect("localhost", "root", "", "trigoyponque2017"); $i...
asked by 25.10.2017 / 04:35
2
answers

Date by rank

How can I make a query of dates by rank if the date is 2017-09-04 - 2017-10-03 ----- > This is how the daterangepicker throws it at me. and since I do not have them separated I can not do a BETWEEN.     
asked by 03.10.2017 / 21:36
1
answer

add a select to a modal

I've attached the modal in case somebody can help me thk is in the priority modal ?php if (isset($con)) { ?> <div class="modal fade" id="myModal20" tabindex="-1" role="dialog" aria-labelledby="myModalLabel"> <div class=...
asked by 03.10.2017 / 20:21
1
answer

problems showing the null of a tables

Dear, CREATE TABLE 'preguntas' ( 'id_pregunta' int(11) NOT NULL, 'nombre' varchar(200) COLLATE utf8_spanish_ci NOT NULL, 'id_dimension_p' int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;...
asked by 03.10.2017 / 19:18