User can't send PMs because of the 60-sec wait...

[kevinmanphp]

Just got a message from one of my top posters stating...

I cannot send any private messages anymore for some reason. Everytime I try to send a private message, I am getting this:

1. This forum requires that you wait 60 seconds between sending private messages. Please try again in 3547418456 seconds.

Any idea how this can be fixed. I tested other accounts and everyone else is Pm'ing without problems. What could be wrong with this one user's account? Thanks.

[Steve Machol]

To troubleshoot this, remove any hacks and disable your plugins, then see if you still have this problem.

If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

Next, create a new style and choose no parent style. This will force it to use the default templates. Finally have him empty his browser cache, close all browser windows then try again. Make sure he changes to the new style and view your forums with it. Does he have the same problem?

If so, this may be due to your language pack. Have himn try the English pack to see if he has the same problem.

[hsm]

I encountered this problem before...

I just changed the PM wait from 0 to 120, today I had a member say the same thing, Please try again in 3147495495 seconds.

He says that is too long to wait

I checked and it seem this user had joined my old board (before the Vb migration). Try going to the users profile, click save, and ask him again. That worked last time.

[Scott MacVicar]

I'll check and see what could cause this, looks like integer overflow

[kevinmanphp]

Hey hsm... thanks for your advice... I certainly will try it and will let you know if it works! Thanks for taking the time to help!

[hsm]

My users are having the same problem now, but if I set the wait period to 0, it goes away.

I think it only effects user who were imported from my old board.

[Scott MacVicar]

Are you using MySQL 5.0 per chance?

[kevinmanphp]

Unfortunately re-saving their profile in admin section did not work. No Scott... I am using 4.1

Will troubleshoot further...

[hsm]

Upon further investigation, this error only seems to hit imported members.

[Scott MacVicar]

Quick check

SELECT * FROM pmtext WHERE dateline > UNIX_TIMESTAMP()

Look for pms in the future, how many does it return and what sort of values.

[hsm]

Im not sure where to run that query...

But as a test, an imported profile from a Yabb board with no private messages had that error too.

[Steve Machol]

Note: You can run queries in the SQL tab in phpMyAdmin, Or to run queries from the Admin CP:

Admin CP -> Maintenance -> Execute SQL Query -> Manual Query

Then enter your query in the Manual Query box and click on 'Continue'.

To run queries you first need to give yourself permission to run queries in the Admin CP. To do this, edit this section of config.php:

// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
// The users specified here will be allowed to run queries from the control panel.
// See the above entries for more information on the format.
// Please note that the ability to run queries is quite powerful. You may wish
// to remove all user IDs from this list for security reasons.
$canrunqueries = 'x';

...with x being your userid number.

[hsm]

Yeah, there are a lot, I got 14,000 of these

http://img212.imageshack.us/img212/8808/phpquery1yj.gif

[Scott MacVicar]

Thats the maximum size of an integer, I'll speak to Jerry about this.

I'm also not sure what an appropriate value to replace this with would be, what would you like all of those orphan pms to be set to?

[Scott MacVicar]

Jerry asked for a ticket to be opened and he'll take a look at the source, it should defalt to the database value which is 0.