| View previous topic :: View next topic |
| Author |
Message |
cvandijk
Joined: 21 Jul 2016
Posts: 3589
Location: Netherlands
|
 Posted: Thu Jul 15, 2021 7:45 am Post subject: Error: Could not update private message read status for user |
 |
|
I try to read a private message, but I can't open it. I receive the following error:
| Code: | SQL Error : 1690 BIGINT UNSIGNED value is out of range in '(`cw_bbforum`.`phpbb_users`.`user_unread_privmsg` - 1)'
UPDATE phpbb_users SET user_unread_privmsg = user_unread_privmsg - 1 WHERE user_id = XXX
Line : 274
File : privmsg.php |
Strange thing is that I already read the message, but the forum think it's new. |
|
| Back to top |
|
 |
Marcin
Joined: 02 Jan 2005
Posts: 8519
Location: Poland
|
| Posted: Thu Jul 15, 2021 8:22 am Post subject: |
|
|
I got same error when trying to remove message in outbox :
| Code: | SQL Error : 1690 BIGINT UNSIGNED value is out of range in '(`cw_bbforum`.`phpbb_users`.`user_unread_privmsg` - 1)'
UPDATE phpbb_users SET user_unread_privmsg = user_unread_privmsg - 1 WHERE user_id IN (5744)
Line : 830
File : privmsg.php |
_________________
Visit ABC CPU - Virtual CPU Museum. |
|
| Back to top |
|
|
gshv
Joined: 01 Feb 2003
Posts: 7898
Location: Fairfax, VA USA
|
| Posted: Thu Jul 15, 2021 3:59 pm Post subject: |
|
|
I can reset that 'user_unread_privmsg' counter in the database, maybe it will fix the problem. Please let me know if you want me to do it.
Gennadiy |
|
| Back to top |
|
|
cvandijk
Joined: 21 Jul 2016
Posts: 3589
Location: Netherlands
|
| Posted: Thu Jul 15, 2021 4:05 pm Post subject: |
|
|
| Please reset it for me, I think you need to change it to 1 because the update query tries to subtract 1, and a unsigned bigint can't be negative. |
|
| Back to top |
|
|
Marcin
Joined: 02 Jan 2005
Posts: 8519
Location: Poland
|
| Posted: Thu Jul 15, 2021 4:05 pm Post subject: |
|
|
It will remove all undelivered messages in all accounts ? If that can be done to specific accounts then I would like to do it.
_________________
Visit ABC CPU - Virtual CPU Museum. |
|
| Back to top |
|
|
gshv
Joined: 01 Feb 2003
Posts: 7898
Location: Fairfax, VA USA
|
| Posted: Sat Jul 17, 2021 11:51 pm Post subject: |
|
|
| Marcin wrote: | | It will remove all undelivered messages in all accounts ? If that can be done to specific accounts then I would like to do it. |
No, it will not remove undelivered messages. It will only set the number of unread messages for your account to the actual number of unread messages. Right now this number is incorrect, it's too large, but I think I can fix it. As a matter of fact I just changed it for your account. Please see if you can remove the private message now.
Gennadiy |
|
| Back to top |
|
|
gshv
Joined: 01 Feb 2003
Posts: 7898
Location: Fairfax, VA USA
|
| Posted: Sun Jul 18, 2021 12:00 am Post subject: |
|
|
cvandijk, I've made a similar change to your account. Please see if you can open the unread message right now.
Gennadiy |
|
| Back to top |
|
|
cvandijk
Joined: 21 Jul 2016
Posts: 3589
Location: Netherlands
|
| Posted: Sun Jul 18, 2021 2:57 am Post subject: |
|
|
| gshv wrote: | cvandijk, I've made a similar change to your account. Please see if you can open the unread message right now.
Gennadiy |
It works, thanks for fixing. |
|
| Back to top |
|
|
Marcin
Joined: 02 Jan 2005
Posts: 8519
Location: Poland
|
| Posted: Mon Jul 19, 2021 3:23 am Post subject: |
|
|
| gshv wrote: | As a matter of fact I just changed it for your account. Please see if you can remove the private message now.
Gennadiy |
Sorry but it doesn't work for me :
| Code: | Could not update user pm counters
DEBUG MODE
SQL Error : 1690 BIGINT UNSIGNED value is out of range in '(`cw_bbforum`.`phpbb_users`.`user_unread_privmsg` - 1)'
UPDATE phpbb_users SET user_unread_privmsg = user_unread_privmsg - 1 WHERE user_id IN (5744)
Line : 830
File : privmsg.php |
_________________
Visit ABC CPU - Virtual CPU Museum.
Last edited by Marcin on Mon Jul 19, 2021 1:56 pm; edited 1 time in total |
|
| Back to top |
|
|
debs3759
Joined: 18 Jan 2006
Posts: 9477
Location: Northampton, Divided Kingdom
|
| Posted: Mon Jul 19, 2021 12:31 pm Post subject: |
|
|
| Marcin wrote: | | gshv wrote: | As a matter of fact I just changed it for your account. Please see if you can remove the private message now.
Gennadiy |
Sorry but id doesn't work for me :
| Code: | Could not update user pm counters
DEBUG MODE
SQL Error : 1690 BIGINT UNSIGNED value is out of range in '(`cw_bbforum`.`phpbb_users`.`user_unread_privmsg` - 1)'
UPDATE phpbb_users SET user_unread_privmsg = user_unread_privmsg - 1 WHERE user_id IN (5744)
Line : 830
File : privmsg.php |
|
I have the same error when trying to delete a 2 year old message in my outbox. Only difference is the user ID
_________________
My graphics card database can be found at http://www.gpuzoo.com.
I can resist anything except temptation.
Debs |
|
| Back to top |
|
|
gshv
Joined: 01 Feb 2003
Posts: 7898
Location: Fairfax, VA USA
|
| Posted: Mon Jul 19, 2021 10:52 pm Post subject: |
|
|
| debs3759 wrote: | | Marcin wrote: |
Sorry but id doesn't work for me :
| Code: | Could not update user pm counters
DEBUG MODE
SQL Error : 1690 BIGINT UNSIGNED value is out of range in '(`cw_bbforum`.`phpbb_users`.`user_unread_privmsg` - 1)'
UPDATE phpbb_users SET user_unread_privmsg = user_unread_privmsg - 1 WHERE user_id IN (5744)
Line : 830
File : privmsg.php |
|
I have the same error when trying to delete a 2 year old message in my outbox. Only difference is the user ID |
Please see if it works now.
Gennadiy |
|
| Back to top |
|
|
gshv
Joined: 01 Feb 2003
Posts: 7898
Location: Fairfax, VA USA
|
| Posted: Mon Jul 19, 2021 10:57 pm Post subject: |
|
|
| Marcin wrote: |
Sorry but it doesn't work for me :
| Code: | Could not update user pm counters
DEBUG MODE
SQL Error : 1690 BIGINT UNSIGNED value is out of range in '(`cw_bbforum`.`phpbb_users`.`user_unread_privmsg` - 1)'
UPDATE phpbb_users SET user_unread_privmsg = user_unread_privmsg - 1 WHERE user_id IN (5744)
Line : 830
File : privmsg.php |
|
I haven't noticed that this error is for different forum account. I corrected the number of new messages and the number of unread messages for that account. Please see if you can remove the message now.
Gennadiy |
|
| Back to top |
|
|
debs3759
Joined: 18 Jan 2006
Posts: 9477
Location: Northampton, Divided Kingdom
|
| Posted: Mon Jul 19, 2021 11:49 pm Post subject: |
|
|
| gshv wrote: | | debs3759 wrote: | | Marcin wrote: |
Sorry but id doesn't work for me :
| Code: | Could not update user pm counters
DEBUG MODE
SQL Error : 1690 BIGINT UNSIGNED value is out of range in '(`cw_bbforum`.`phpbb_users`.`user_unread_privmsg` - 1)'
UPDATE phpbb_users SET user_unread_privmsg = user_unread_privmsg - 1 WHERE user_id IN (5744)
Line : 830
File : privmsg.php |
|
I have the same error when trying to delete a 2 year old message in my outbox. Only difference is the user ID |
Please see if it works now.
Gennadiy |
| Code: |
Could not update user pm counters
DEBUG MODE
SQL Error : 1690 BIGINT UNSIGNED value is out of range in '(`cw_bbforum`.`phpbb_users`.`user_unread_privmsg` - 1)'
UPDATE phpbb_users SET user_unread_privmsg = user_unread_privmsg - 1 WHERE user_id IN (5938)
Line : 830
File : privmsg.php
|
Still getting the same error.
_________________
My graphics card database can be found at http://www.gpuzoo.com.
I can resist anything except temptation.
Debs |
|
| Back to top |
|
|
Marcin
Joined: 02 Jan 2005
Posts: 8519
Location: Poland
|
| Posted: Tue Jul 20, 2021 2:29 am Post subject: |
|
|
| gshv wrote: | I haven't noticed that this error is for different forum account. I corrected the number of new messages and the number of unread messages for that account. Please see if you can remove the message now.
Gennadiy |
Now it works !  Thank you.
_________________
Visit ABC CPU - Virtual CPU Museum. |
|
| Back to top |
|
|
gshv
Joined: 01 Feb 2003
Posts: 7898
Location: Fairfax, VA USA
|
| Posted: Tue Jul 20, 2021 10:39 pm Post subject: |
|
|
| debs3759 wrote: |
| Code: |
Could not update user pm counters
DEBUG MODE
SQL Error : 1690 BIGINT UNSIGNED value is out of range in '(`cw_bbforum`.`phpbb_users`.`user_unread_privmsg` - 1)'
UPDATE phpbb_users SET user_unread_privmsg = user_unread_privmsg - 1 WHERE user_id IN (5938)
Line : 830
File : privmsg.php
|
Still getting the same error. |
Oh, I see, I fixed your account, but the error was for different forum account. I fixed that account too. Please check if you still get the same error.
Gennadiy |
|
| Back to top |
|
|
|
![[ Hidden ]](https://cdn.cpu-world.com/forum/templates/CPUWorld/images/lang_english/icon_email.gif "[ Hidden ]"){kind=icon}
