phpBB2 by Przemo

[evilmc]

Kod:

Could not update private message read status for user DEBUG MODE SQL Error : 1690 BIGINT UNSIGNED value is out of range in '(`forum_table`.`phpbb_users`.`user_unread_privmsg` - 1)' UPDATE phpbb_users SET user_unread_privmsg = user_unread_privmsg - 1 WHERE user_id = 3 Line : 339 File : privmsg.php

When I send message with MASS PW, I have this problem. How to fix this problem?

EDIT:

I use this and now works!

Kod:

UPDATE phpbb_users SET user_unread_privmsg = 1 WHERE user_id = 3

[Gadatliwa Kasia]

[NineX]

Try:

privmsg.php

Kod:

FIND:         switch ($privmsg['privmsgs_type'])         {             case PRIVMSGS_NEW_MAIL:                 $sql = "user_new_privmsg = user_new_privmsg - 1";                 break;             case PRIVMSGS_UNREAD_MAIL:                 $sql = "user_unread_privmsg = user_unread_privmsg - 1";                 break;         }         $sql = "UPDATE " . USERS_TABLE . "             SET $sql             WHERE user_id = " . $userdata['user_id'];         if ( !$db->sql_query($sql) )         {             message_die(GENERAL_ERROR, 'Could not update private message read status for user', '', __LINE__, __FILE__, $sql);         } REPLACE WITH:         switch ($privmsg['privmsgs_type'])         {             case PRIVMSGS_NEW_MAIL:                 $sql   = "user_new_privmsg = user_new_privmsg - 1";                 $value = $userdata['user_new_privmsg'];                 break;             case PRIVMSGS_UNREAD_MAIL:                 $sql   = "user_unread_privmsg = user_unread_privmsg - 1";                 $value = $userdata['user_unread_privmsg'];                 break;         }         if( ($value-1) >= 0 )         {             $sql = "UPDATE " . USERS_TABLE . "             SET $sql             WHERE user_id = " . $userdata['user_id'];             if ( !$db->sql_query($sql) )             {                 message_die(GENERAL_ERROR, 'Could not update private message read status for user', '', __LINE__, __FILE__, $sql);             }         }

[evilmc]

I have again this problem, I can delete any message from PM:

Kod:

Could not update user pm counters DEBUG MODE SQL Error : 1690 BIGINT UNSIGNED value is out of range in '(`forum`.`phpbb_users`.`user_unread_privmsg` - 1)' UPDATE phpbb_users SET user_unread_privmsg = user_unread_privmsg - 1 WHERE user_id IN (2) Line : 967 File : privmsg.php If you can not fix this problem, you can find help, or ask question at: http://www.przemo.org/phpBB2/

How to fix this problem?

[Woytec]

In the same way you described in your first post.

[evilmc]

I have again problem with messages:

Kod:

Could not insert private message sent text DEBUG MODE SQL Error : 1062 Duplicate entry '0' for key 'PRIMARY' INSERT INTO phpbb_privmsgs_text (privmsgs_text_id, privmsgs_bbcode_uid, privmsgs_text) VALUES (-2006897927, '5b3c32077f', '[center:5b3c32077f][img:5b3c32077f]http://i.imgur.com/XmgxDRU.png[/img:5b3c32077f][/center:5b3c32077f] Kolege... samo još 5 dana do završetka akcije prodaje Football Managera 2015 na 3 rate, a još 45 mesta za akcijsku cenu od samo 3000 dinara! Nemojte propustiti mogućnost da već sada obezbedite svoj primerak originala FM 15 po najboljim uslovima i najjeftinijoj ceni na svetu. Mogućnost kupovine na čitavom regionu Balkana - Srbiji, Bosni i Hercegovini, Crnoj Gori, Hrvatskoj, Makedoniji putem uplate na žiro račun, paypalla, skrilla i dr. Mogućnost kupovine iz inostranstva. Izaberite DVD ili Steam kod Football Manager 2015 i sa datumom izlaska igre uživajte u svojim karijerama. Sve informacije, prijave, uvid u načine plaćanja i rokovima - posetite Serbian FM i [URL=http://serbian-fm.net/cost-before-ordering-prodaja-football-manager-2015-vt11388.htm]OVU TEMU ![/URL] Igra nikad ne prestaje....ostani na poslu! Vaš Serbian FM') Line : 421 File : privmsg.php If you can not fix this problem, you can find help, or ask question at: http://www.przemo.org/phpBB2/

[Woytec]

Kod:

ALTER TABLE `phpbb_privmsgs_text` CHANGE `privmsgs_text_id` `privmsgs_text_id` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0'; ALTER TABLE `phpbb_privmsgs` CHANGE `privmsgs_id` `privmsgs_id` INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT;

[evilmc]

And this is error, when I create new PM and send:

Kod:

Could not insert/update private message sent text. DEBUG MODE INSERT INTO phpbb_privmsgs (privmsgs_type, privmsgs_subject, privmsgs_from_userid, privmsgs_to_userid, privmsgs_date, privmsgs_ip, privmsgs_enable_html, privmsgs_enable_bbcode, privmsgs_enable_smilies, privmsgs_attach_sig) VALUES (1, 'zz', 3, 5482, 1397512441, 'b295354d', 0, 1, 1, 1) Line : 1493 File : privmsg.php If you can not fix this problem, you can find help, or ask question at: http://www.przemo.org/phpBB2/ phpBB modified by Przemo :: Download www.przemo.org

[ Added: 15-04-2014, 15:25 ]
Pls, help!

[Woytec]

Enter in phpmyadmin and show error message

Kod:

INSERT INTO phpbb_privmsgs (privmsgs_type, privmsgs_subject, privmsgs_from_userid, privmsgs_to_userid, privmsgs_date, privmsgs_ip, privmsgs_enable_html, privmsgs_enable_bbcode, privmsgs_enable_smilies, privmsgs_attach_sig) VALUES (1, 'zz', 3, 5482, 1397512441, 'b295354d', 0, 1, 1, 1)

[evilmc]

I add this line on phpmyadmin and don't show any errors:



And can't open any private message on forum:



[ Added: 18-04-2014, 03:13 ]
pls, help me

[Matteo]

Do u still see error from this post?

[evilmc]

Matteo, I don't understand, what error?

[Woytec]

This (identical):

[evilmc]

Guys, I do not understand you, what should I do with this line(error)?

I put this error on phpmyadmin, but nothing happens:

[Woytec]

Send PM again

[Gadatliwa Kasia]

[evilmc]

Woytec, again not works!

We have installed Mass PW mod on forum, maybe this cause problem?