MySQL database maintenance

[stuuu]

Yeah everything is fine from what I can see. I might give an optimize a go then Thanks!...

[stuuu]

Hi all,

I've ran a successful vBulletin forum for almost 10 years now and I was wondering what admins do regarding their MySQL database when at this sort of age. We've recently hit 1,000,000...

[stuuu]

Thanks, I've sent them an email.

Any others?...

[stuuu]

Is there such a thing as managed vBulletin web hosting? Where the hosting company handles updates and patches for the server AND vBulletin.

If so, can anyone recommend some to me? I run a...

[stuuu]

We migrated our web site to a Windows 2003 server a few months back, everything has been fine, and pretty much still is!

However we are getting some complaints that when uses are browsing,...

[stuuu]

Interesting I'll see if I can find some information!...

[stuuu]

Thanks Colin, works great!

What's that query doing in the WHERE section, I've not seen a query like that before?...

[stuuu]

Is there any way to find out how many users are subscribed to the "admin emails"? I've had a look through the VB Admin CP but can't find a way to do it? Maybe I need an SQL query?
...

[stuuu]

Thanks for your reply jason, I'll give these a go ...

[stuuu]

I thought it was obvious, but I'll re-quote just for you.



Also as my second post states, the index fix couldn't even complete without an error.

Thank you in ad...

[stuuu]

Anyone? :/

[stuuu]

If it helps, I've just tried fixing the indexes and got this message.

Database error in vBulletin 3.6.5:

Invalid SQL:
ALTER TABLE postindex ADD UNIQUE KEY wordid (wordid,

...

[stuuu]

Hi there, I moved our vB install to a new server about 3 weeks ago with no problems at all. The new server is running PHP5 and MySQL5, today some problems started, and this seems to be the problem:...

[stuuu]

When I went from RC4 to Final I overwrote all the older files with the new.

This problem was there for RC4 aswell, only during the past few days when the attachmentviews problem arose....

[stuuu]

Hi Guys,

Been using vB3 for a while now, had RC4 in up until today when I upgraded to the Final.

Before I made the upgrade I had been getting some errors from vBulletin reference...

[stuuu]

One of my users PM'd me with this problem and I am unsure of how to fix it for him. I have asked him to clear his cookies and relogin, but that did not fix the problem. Here is his message:
...

[stuuu]

No :\ Sorry, that was an old email address from a while back. I have changed it to my current email address, can you resend to the new address please?

Sorry again, and thanks Freddie ...

[stuuu]

I thought it might be the phpAdsNew script running, but it's not

Anyone?