Colocar Resposta 
 
Avaliação do Tópico:
  • 0 votos - 0 Média
  • 1
  • 2
  • 3
  • 4
  • 5
MyBB SQL Error
28-07-2014, 23:43
Mensagem: #1
MyBB SQL Error
Enquanto estava a tentar publicar uma resposta, apanhei um erro que poderá ser relevante para o funcionamento geral da board.


Citar:MyBB SQL Error

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    1366 - Incorrect integer value: 'perm' for column 'lifted' at row 1
Query:
    INSERT INTO mybb_banned (`uid`,`admin`,`gid`,`oldgroup`,`dateline`,`bantime`,`lifted`,`reason`,`oldaddit​ionalgroups`) VALUES ('18153','0','7','2','1406586345','perm','perm','Automatically banned by the Akismet system for spamming.','')

Ocorreu quando publiquei este post.

Twitter Facebook Youtube

Procura-se...

Rede WirelessPT
Visitar Website de este utilizador Procurar todas as mensagens deste utilizador
Citar esta mensagem numa resposta
14-12-2017, 14:39
Mensagem: #2
RE: MyBB SQL Error
$ sql = "INSERT INTO NEWSLETTER (name, email) 
VALUES 
('$ _POST [name]', '$ _ POST [email]') "; 

This is only IF your table is named: NEWSLETTER named professional assignment writers
and your fields in your NEWSLETTER table are name, and email. The id should auto increment, setup as an identity, so you do not need to add that manually. name, and email. The id should auto increment, setup as an identity, so you do not need to add that manually. 

[color=#26282a][size=small]IMPORTANT NOTE: I would HIGHLY stress you to sanitize your data. (Make sure it is safe from SQL injection) -> http://en.wikipedia.org/wiki/SQL_injecti...ze][/color]
Procurar todas as mensagens deste utilizador
Citar esta mensagem numa resposta
14-12-2017, 14:40
Mensagem: #3
RE: MyBB SQL Error
$sql="INSERT INTO NEWSLETTER (name,email) 
VALUES 
('$_POST[name]','$_POST[email]')"; 

This is only IF your table is named : NEWSLETTER 
and your fields in your NEWSLETTER table are name, and email. The id should auto increment, setup as an identity, so you don't need to add that manually. professional assignment writers

[color=#26282a][size=small]IMPORTANT NOTE: I would HIGHLY stress that you sanitize your data. (Make sure it is safe from SQL injection) -> http://en.wikipedia.org/wiki/SQL_injecti...ze][/color]
Procurar todas as mensagens deste utilizador
Citar esta mensagem numa resposta
Colocar Resposta 


Saltar Fórum:


Utilizadores a ver este tópico: 1 Visitante(s)