MyBB Community Forums

Full Version: mySQL error: 1062 when sending pms
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
me and my users get this

mySQL error: 1062
Duplicate entry '32767' for key 1
Query: INSERT INTO mybb_privatemessages(pmid,uid,toid,fromid,folder,subject,icon,message,dateline,status,includesig,smilieoff,receipt,readtime) VALUES(NULL,'1','1','1','1','222','','ads','1145296431','0','yes','no','1','0');

how to fix ?
Can you run this in phpMyAdmin:

ALTER TABLE `mybb_privatemessages` CHANGE `pmid` `pmid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT 
yeap thanx
I have the same problem with users posting.
Can you please post the full error message?
Well it happened when i switched host. And when i reinstalled the data base from the old site i got the error after posting once. But i lost the Mysql export and the old host is still down. So when i can get the old database and install it i'll get the error for you.