My errors...

[Sal Collaziano]

Hmm. Okay.. I get a lot like these two:

1. Invalid SQL:
SELECT DISTINCT privatemessage.*, user.username AS tousername, user.emailonpm, user.invisible,
user.lastactivity, icon.iconpath, session.userid AS sessionuserid
FROM privatemessage
LEFT JOIN user ON (user.userid = privatemessage.touserid)
LEFT JOIN icon ON (icon.iconid = privatemessage.iconid)
LEFT JOIN session ON (session.userid = user.userid
AND session.userid <> 0 AND user.invisible = 0 AND session.lastactivity>0)
WHERE fromuserid=2048
AND folderid <> -1
AND receipt > 0

ORDER BY dateline DESC
mysql error: The SELECT would examine too many records and probably take a very long time. Check your WHERE and use SET OPTION SQL_BIG_SELECTS=1 if the SELECT is ok

mysql error number: 1104

Date: Thursday 31st of January 2002 04:31:09 AM
Script: http://www.80sxchange.com/forums/for...php?daysprune=
Referer: http://80sxchange.com/forums/private.php?




and the other popular one:

2. Database error in vBulletin :

Link-ID == false, connect failed
mysql error:

mysql error number:

Date: Wednesday 30th of January 2002 02:26:58 PM
Script: /forums/showthread.php?s=&threadid=7688
Referer: http://www.80sxchange.com/forums/sea...&searchid=6793



Any thoughts?

Thank you!

[George L]

1. upgrade to 2.2.2

2. PHP/MySQL versions ?

3. mysql variables /etc/my.cnf settings

4. mysql extended-status output

5. top stats

6. how many private messages do you have in your database ?

[Sal Collaziano]

Okay. I just upgraded to 2.2.2. - Maybe that will fix the problem. I reset my PMs from 70 for each user to 20. I don't know how to delete their old READ messages for them. Maybe this should be an option.

Other than that.. I don't really understand the rest of your suggestions. I'm not very technical!

Thank you!

[fury]

Do this query to show you how many PM's are in your database: select count(*) from privatemessage;

I'm not exactly sure you may want to try a delete on all read messages, some of your users may be saving their PM's for a reason. (I don't know the query that does this anyway, lol)

[Sal Collaziano]

You might wanna HIT me but.. How do you DO that query?

[fury]

Log into your webhost's preferred method of shell (SSH is used by most), and log into mysql like this, replacing all in italics with its respective parameters (without the <>'s):

mysql -u<mysqlusername> -p<mysqlpassword> <mysqldatabasename>

Perform the queries you want

Then type exit

BTW, I found out what query to do to delete all read messages. You may want to wait for a vBulletin developer to confirm this though, as this is only based on a few glances at the privatemessage table

DELETE FROM privatemessage WHERE messageread="1";

And, as I said, you might want to run this by your users before doing it, as they may want to save some private messages. I think they'll understand, I read over at that board periodically and they're a pretty cool bunch

[Sal Collaziano]

Hey Fury? Bud? I love ya. man (no, I don't want a beer) - but once I read anything about the 'preferred method of shell' I was lost. I'm one of those web people that was about to learn all of this but took a drastic turn. I don't know if my brain can take in all of this kind of thing.

However, I did post a message up to let people know they need to clear out their private messages. Hopefully, this will help. And wait. I didn't know you were a fan of anything 80's. You are?

Thanks.. The people in my community are a pretty cool bunch.

[fury]

Yes, I am a fan of some stuff 80's. After all, I was born in the middle of them

[Sal Collaziano]

Cool. Atleast you have a few memories from the tail end of it. Those were the best years for me - the late 80's... How easy life was back then...