Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
fallo al actualizar Pandora 7.0 NG
#11
(05-17-2019, 11:48 AM)Jramongv Wrote:
(05-17-2019, 11:37 AM)eduardo.corral Wrote:
(05-17-2019, 09:22 AM)Jramongv Wrote:
(05-17-2019, 08:07 AM)eduardo.corral Wrote:
(05-17-2019, 07:40 AM)Jramongv Wrote: Hola de nuevo, he actualizado hasta el 7.0 NG 734 y he aplicado los XX.sql de forma consecutiva hasta el 27.sql

Lo estoy hacieendo con cat 27.sql | mysql -u root -p pandora

En el 27.sql me da el error:
ERROR 1146 (42S02) at line 14: Table 'pandora.tuser_task' doesn't exist

Buenos días, Jramongv

Es importante tener en cuenta que el mejor proceso es instalar los MR con "source" y no con "cat". Ejecutando "cat" existe el problema de que si se encuentra un fallo en un punto intermedio de la aplicación de los MR, habría que borrar todos hasta ese punto para corregir el error, así es muy peligroso arrastrar fallos con ese comando. 

Respecto al php, basta con hacer una instalación normal. Tendrá en cuenta que tienes una versión anterior y actualizará a la 7.2 sin problema ninguno. Pero es vital actualizar el php antes de seguir con el resto de cambios. 

Un cordial saludo, 

Eduardo.
Hola Eduardo,

Ejecutando con source me pasa esto:

mysql> source /var/www/html/pandora_console/extras/mr/27.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1091 (42000): Can't DROP 'output'; check that column/key exists
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_normal'
ERROR 1060 (42S21): Duplicate column name 'ff_warning'
ERROR 1060 (42S21): Duplicate column name 'ff_critical'
ERROR 1146 (42S02): Table 'pandora.tuser_task' doesn't exist
Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.54 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.21 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.17 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.16 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 5 rows affected (0.16 sec)
Records: 5  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)


Ahora no sé si tendría que repetir todos los sql de nuevo con source..... ¿me podrías indicar?

(05-17-2019, 09:22 AM)Jramongv Wrote:
(05-17-2019, 08:07 AM)eduardo.corral Wrote: Buenos días, Jramongv

Es importante tener en cuenta que el mejor proceso es instalar los MR con "source" y no con "cat". Ejecutando "cat" existe el problema de que si se encuentra un fallo en un punto intermedio de la aplicación de los MR, habría que borrar todos hasta ese punto para corregir el error, así es muy peligroso arrastrar fallos con ese comando. 

Respecto al php, basta con hacer una instalación normal. Tendrá en cuenta que tienes una versión anterior y actualizará a la 7.2 sin problema ninguno. Pero es vital actualizar el php antes de seguir con el resto de cambios. 

Un cordial saludo, 

Eduardo.
Hola Eduardo,

Ejecutando con source me pasa esto:

mysql> source /var/www/html/pandora_console/extras/mr/27.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1091 (42000): Can't DROP 'output'; check that column/key exists
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_normal'
ERROR 1060 (42S21): Duplicate column name 'ff_warning'
ERROR 1060 (42S21): Duplicate column name 'ff_critical'
ERROR 1146 (42S02): Table 'pandora.tuser_task' doesn't exist
Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.54 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.21 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.17 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.16 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 5 rows affected (0.16 sec)
Records: 5  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)


Ahora no sé si tendría que repetir todos los sql de nuevo con source..... ¿me podrías indicar?

Desde el 6.sql hasta el 27.sql los he hecho todos con el cat XX.sql | mysql -u root -p pandora,

pero en ninguno me ha dado error excepto en el 27.sql, ahora haciendo el 27 con source me da lo de antes.

Buenos días, Jramongv

Mientras la ejecución devuelva el valor "Query OK" todo está correcto. ¿Aplicando el 27 con "source" qué es lo que te da exactamente? ¿El valor "Query OK" o el fallo del post previo?

Un saludo, 

Eduardo.

Hola Eduardo, la salida es esta:  (primero da un OK, después error y después OK)

mysql> source /var/www/html/pandora_console/extras/mr/27.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1091 (42000): Can't DROP 'output'; check that column/key exists
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_normal'
ERROR 1060 (42S21): Duplicate column name 'ff_warning'
ERROR 1060 (42S21): Duplicate column name 'ff_critical'
ERROR 1146 (42S02): Table 'pandora.tuser_task' doesn't exist
Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.54 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.21 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.17 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.16 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 5 rows affected (0.16 sec)
Records: 5  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

(05-22-2019, 06:55 AM)Jramongv Wrote:
(05-17-2019, 11:48 AM)Jramongv Wrote:
(05-17-2019, 11:37 AM)eduardo.corral Wrote:
(05-17-2019, 09:22 AM)Jramongv Wrote:
(05-17-2019, 08:07 AM)eduardo.corral Wrote: Buenos días, Jramongv

Es importante tener en cuenta que el mejor proceso es instalar los MR con "source" y no con "cat". Ejecutando "cat" existe el problema de que si se encuentra un fallo en un punto intermedio de la aplicación de los MR, habría que borrar todos hasta ese punto para corregir el error, así es muy peligroso arrastrar fallos con ese comando. 

Respecto al php, basta con hacer una instalación normal. Tendrá en cuenta que tienes una versión anterior y actualizará a la 7.2 sin problema ninguno. Pero es vital actualizar el php antes de seguir con el resto de cambios. 

Un cordial saludo, 

Eduardo.
Hola Eduardo,

Ejecutando con source me pasa esto:

mysql> source /var/www/html/pandora_console/extras/mr/27.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1091 (42000): Can't DROP 'output'; check that column/key exists
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_normal'
ERROR 1060 (42S21): Duplicate column name 'ff_warning'
ERROR 1060 (42S21): Duplicate column name 'ff_critical'
ERROR 1146 (42S02): Table 'pandora.tuser_task' doesn't exist
Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.54 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.21 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.17 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.16 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 5 rows affected (0.16 sec)
Records: 5  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)


Ahora no sé si tendría que repetir todos los sql de nuevo con source..... ¿me podrías indicar?

(05-17-2019, 09:22 AM)Jramongv Wrote: Hola Eduardo,

Ejecutando con source me pasa esto:

mysql> source /var/www/html/pandora_console/extras/mr/27.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1091 (42000): Can't DROP 'output'; check that column/key exists
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_normal'
ERROR 1060 (42S21): Duplicate column name 'ff_warning'
ERROR 1060 (42S21): Duplicate column name 'ff_critical'
ERROR 1146 (42S02): Table 'pandora.tuser_task' doesn't exist
Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.54 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.21 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.17 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.16 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 5 rows affected (0.16 sec)
Records: 5  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)


Ahora no sé si tendría que repetir todos los sql de nuevo con source..... ¿me podrías indicar?

Desde el 6.sql hasta el 27.sql los he hecho todos con el cat XX.sql | mysql -u root -p pandora,

pero en ninguno me ha dado error excepto en el 27.sql, ahora haciendo el 27 con source me da lo de antes.

Buenos días, Jramongv

Mientras la ejecución devuelva el valor "Query OK" todo está correcto. ¿Aplicando el 27 con "source" qué es lo que te da exactamente? ¿El valor "Query OK" o el fallo del post previo?

Un saludo, 

Eduardo.

Hola Eduardo, la salida es esta:  (primero da un OK, después error y después OK)

mysql> source /var/www/html/pandora_console/extras/mr/27.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1091 (42000): Can't DROP 'output'; check that column/key exists
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_normal'
ERROR 1060 (42S21): Duplicate column name 'ff_warning'
ERROR 1060 (42S21): Duplicate column name 'ff_critical'
ERROR 1146 (42S02): Table 'pandora.tuser_task' doesn't exist
Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.54 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.21 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.17 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.16 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 5 rows affected (0.16 sec)
Records: 5  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
¿Alguna sugerencia al respecto?. No sé si está todo OK, no creo por los errores que aparecen, ¿debería reinstalar otra vez?
 Reply
Messages In This Thread
fallo al actualizar Pandora 7.0 NG - by Jramongv - 05-13-2019, 10:59 AM
RE: fallo al actualizar Pandora 7.0 NG - by Jramongv - 05-22-2019, 06:55 AM


Users browsing this thread: 1 Guest(s)


(c) 2006-2018 Artica Soluciones Tecnológicas. Contents of this wiki are under Create Common Attribution v3 licence. | pandorafms.com | pandorafms.org

Theme © MyBB Themes