[gitec] erro parlamentar

Jos Luiz Lacowicz lacowicz em estadao.com.br
Segunda Agosto 15 01:26:27 BRT 2011


Infelizmente não.

veja que tentei varias vezes antes de startar o sapl e depois

jose em jose:~$ mysql -usapl -psapl
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 96
Server version: 5.1.54-1ubuntu4 (Ubuntu)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

mysql> use interlegis;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> alter parlamentar add column txt_biografia text after ind_ativo;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use
near 'parlamentar add column txt_biografia text after ind_ativo' at line 1
mysql> quit;
Bye
jose em jose:~$ mysql -usapl -psapl
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 97
Server version: 5.1.54-1ubuntu4 (Ubuntu)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

mysql> use interlegis;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> alter parlamentar add column txt_biografia text after ind_ativo;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use
near 'parlamentar add column txt_biografia text after ind_ativo' at line 1
mysql> quit;
Bye
jose em jose:~$ sudo /var/interlegis/SAPL-2.3/instances/sapl23/bin/startsapl.sh
[sudo] password for jose:
Starting SAPL server...
. daemon process started, pid=2084
jose em jose:~$ mysql -usapl -psapl
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 102
Server version: 5.1.54-1ubuntu4 (Ubuntu)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

mysql> use interlegis;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> alter parlamentar add column txt_biografia text after ind_ativo;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use
near 'parlamentar add column txt_biografia text after ind_ativo' at line 1
mysql> quit;
Bye
jose em jose:~$



Em 11 de agosto de 2011 20:26, Leandro Roberto Silva <
leandroroberto.br em gmail.com> escreveu:

> Olá Joe,
>
> parece que funcionou....
>
> Só faltou você digitar a linha que conecta no banco, na sequencia abaixo, o
> passo 2.
>
> Siga então novamente esta sequência:
>
>    1. *mysql -usapl -psapl*
>    2. *
>
>    use interlegis;
>
>    *
>    3. *
>
>    alter parlamentar add column txt_biografia text after ind_ativo;
>
>    *
>    4. *
>
>    quit;
>
>    *
>
> *
> *
> --
> =========================================
> *Leandro Roberto - (64) 8448-7460*
> Tecnólogo em Sistemas de Informação
> *Câmara Municipal de Jataí - (64) 3636-0816*
> Departamento de TIC - Departamento de Documentação Eletrônica
>
>
> --
> Site da Comunidade GITEC:
> http://colab.interlegis.gov.br/wiki
>
> Regras de participação:
> http://colab.interlegis.gov.br/wiki/ComoParticiparComunidade
>
> Para pesquisar o histórico da lista visite:
> http://colab.interlegis.gov.br/wiki/PesquisaListas
>
> Para administrar sua conta visite:
> http://listas.interlegis.gov.br/mailman/listinfo/gitec
>
-------------- Próxima Parte ----------
Um anexo em HTML foi limpo...
URL: http://listas.interlegis.gov.br/pipermail/gitec/attachments/20110815/497e0f62/attachment.htm 


Mais detalhes sobre a lista de discussão GITEC