Continuously syntax error when editing views

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
pasavino
Posts: 3
Joined: Tue 26 Jun 2018 14:30

Continuously syntax error when editing views

Post by pasavino » Tue 26 Jun 2018 14:39

hi,

This query has no errors, but I can not save the view because it continuously tells me that there is an syntax error.
This happens even in version 8, if I try my query in a new tab it works without problems

Can you verify the error for the next updates?

Code: Select all

SELECT
  sucursales.idsucursal AS idsucursal,
  sucursales_mails_templates.idtemplate AS idtemplate,
  sucursales_mails_templates.tipo AS tipo,
  sucursales_mails_templates.diaenvio AS diaenvio
FROM sucursales
  INNER JOIN sucursales_mails_templates
    ON sucursales.idsucursal = sucursales_mails_templates.idsucursal
  WHERE DAY(CURDATE())=sucursales_mails_templates.diaenvio;

alexa
Devart Team
Posts: 2718
Joined: Fri 24 Jun 2011 14:17

Re: Continuously syntax error when editing views

Post by alexa » Wed 27 Jun 2018 10:56

Could you please provide us the version of the MySQL server and the CREATE definition of the view?

You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .

pasavino
Posts: 3
Joined: Tue 26 Jun 2018 14:30

Re: Continuously syntax error when editing views

Post by pasavino » Thu 05 Jul 2018 02:06

MySql version 5.5.46-0+deb7u1

View ( The view was modified, but the error continues )

Code: Select all

CREATE
DEFINER = 'myuser'@'%'
VIEW rocknlearn.vs_control_crones
AS
SELECT
  `sucursales_mails_templates`.`idsucursal` AS `idsucursal`,
  `sucursales_mails_templates`.`idtemplate` AS `idtemplate`,
  `sucursales_mails_templates`.`tipo` AS `tipo`,
  `sucursales`.`nombre` AS `sede`
FROM (`sucursales_mails_templates`
  JOIN `sucursales`
    ON ((`sucursales_mails_templates`.`idsucursal` = `sucursales`.`idsucursal`)))
WHERE ((`sucursales_mails_templates`.`activo` = 1)
AND (`sucursales_mails_templates`.`diaenvio` = DAYOFMONTH(CURDATE())));

alexa
Devart Team
Posts: 2718
Joined: Fri 24 Jun 2011 14:17

Re: Continuously syntax error when editing views

Post by alexa » Fri 06 Jul 2018 08:28

Thank you for the reply.

Could you please also provide us a screenshot of the error?

pasavino
Posts: 3
Joined: Tue 26 Jun 2018 14:30

Re: Continuously syntax error when editing views

Post by pasavino » Mon 16 Jul 2018 02:16

Errors continue, the query in a new tab works, but when I want to save the view it gives error

I can not attach the image.

this query is fine, has no errors

Code: Select all

SELECT
  cinta_llenado.codbarras AS codbarras,
  cinta_llenado.numlote AS numlote,
  stock.nombre AS nombre,
  cinta_llenado.fecha AS fecha,
  COUNT(cinta_llenado.codbarras) AS cnt
FROM cinta_llenado
  INNER JOIN stock
    ON cinta_llenado.codbarras = stock.codbarras
GROUP BY cinta_llenado.codbarras,
         cinta_llenado.numlote,
         stock.nombre,
         cinta_llenado.fecha
ORDER BY cinta_llenado.fecha DESC

alexa
Devart Team
Posts: 2718
Joined: Fri 24 Jun 2011 14:17

Re: Continuously syntax error when editing views

Post by alexa » Wed 18 Jul 2018 09:47

Thank you for the reply.

Could you please perform the following:
1. Select 'Tools -> Options...' from the main menu. The 'Options' window opens.
2. Navigate to the 'Environment -> Output' branch.
3. Select the 'Write queries sent by the program to the SQL Log' and 'Log application errors' options.
4. Unselect the 'Delete application log after closing' option. Click 'OK'.
5. Reproduce the issue and send us the *.log file with the latest date from the directory:

Code: Select all

%SystemDrive%\Users\%UserName%\AppData\Roaming\Devart\dbForge Studio for MySQL\

Post Reply