I get an error when sending a personal message

[Shambles]

TABLE I remove personal message
I installed it again from someone else
may be a problem

May I suggest OP checks the structure of his "reinstalled" personal_messages table.

Should resemble:




If field id_pm_head is being reported as missing, maybe the "installed it again" didn't quite go to plan.

[Kindred]

ah hah....


and now we get to the actual issue. 
Turns out, the section IS part of the standard SMF and you apparently deleted the database table smf_personal_messages

Why did you do such a thing?

run this in your myphpadmin

Code Select Expand


DROP TABLE `smf_personal_messages`;
CREATE TABLE IF NOT EXISTS `smf_personal_messages` (
  `id_pm` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_pm_head` int(10) unsigned NOT NULL DEFAULT '0',
  `id_member_from` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `deleted_by_sender` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `from_name` varchar(255) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `msgtime` int(10) unsigned NOT NULL DEFAULT '0',
  `subject` varchar(255) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `body` text COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`id_pm`),
  KEY `ID_MEMBER` (`id_member_from`,`deleted_by_sender`),
  KEY `msgtime` (`msgtime`),
  KEY `id_pm_head` (`id_pm_head`)
);

note: this will delete any personal messages that were stored on your system

[akaewn]

ah hah....


and now we get to the actual issue. 
Turns out, the section IS part of the standard SMF and you apparently deleted the database table smf_personal_messages

Why did you do such a thing?

run this in your myphpadmin

Code Select Expand


DROP TABLE `smf_personal_messages`;
CREATE TABLE IF NOT EXISTS `smf_personal_messages` (
  `id_pm` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_pm_head` int(10) unsigned NOT NULL DEFAULT '0',
  `id_member_from` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `deleted_by_sender` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `from_name` varchar(255) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `msgtime` int(10) unsigned NOT NULL DEFAULT '0',
  `subject` varchar(255) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `body` text COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`id_pm`),
  KEY `ID_MEMBER` (`id_member_from`,`deleted_by_sender`),
  KEY `msgtime` (`msgtime`),
  KEY `id_pm_head` (`id_pm_head`)
);

note: this will delete any personal messages that were stored on your system

thanks.
solved.
I accidentally deleted it

[akaewn]

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation 'ifnull'
Dosya: /home/efsanewe/public_html/Sources/PersonalMessage.php
Satır: 1695

A new error
Reply button and gives an error ..

[Kindred]

oops....   my code added a table with the latin collation.

you probably need to switch that out to whatever your database is...

[akaewn]

So is there anything I can do about it?

[Kindred]

yes. use your phpmyadmin and change the collations...   or edit the code that I gave to to match your database's actual collations instead of latin...  and re-run it.

[akaewn]

yes. use your phpmyadmin and change the collations...   or edit the code that I gave to to match your database's actual collations instead of latin...  and re-run it.

thanks.