Hey Guys/Gals !

[DieselMinded]

Im running my first Vbulletin Site

www.dieselbombers.com

And Im wondering what sort of maintenace i should be doing , The database is backed up 1 per day by the host what should I be doing to keep it healthy

Ive clicked around in the Admin CP Maintenace but im unsure whaty to do in there Can someone plese help ?

And why do i get Database Error Emails Everyday?

DM

[Marco van Herwaarden]

There is no real maintenance you should do on a regular basis.

To give an answer to your DB-Error question, please post the full error you get.

[DieselMinded]

Thanks That puts me at eaze !

Heres some errors... I saved all 100 of them so far ill post a few random ones...

Database error in vBulletin 3.6.5:

Invalid SQL:

UPDATE vbdatastore SET
data = data - 3,
data = IF(data < 0, 0, data)
WHERE title = 'mailqueue';

MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Date : Monday, March 26th 2007 @ 10:52:49 PM
Script : http://www.dieselbombers.com/index.php
Referrer : http://www.dieselbombers.com/showthread.php?t=731
IP Address : 69.26.10.6
Username : power95
Classname : vb_database

Database error in vBulletin 3.6.5:

Invalid SQL:

## GET LATEST THREADS ##
SELECT thread.*,thread.iconid AS threadiconid , post.pagetext AS preview
FROM vbthread AS thread
LEFT JOIN vbdeletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
LEFT JOIN vbpost AS post ON(post.postid = thread.firstpostid)
WHERE open <> 10
AND forumid NOT IN (0Bad Lands,99Bad Lands,23Bad Lands,116Bad Lands,118Bad Lands,98Bad Lands,90Bad Lands,91Bad Lands,92Bad Lands,75)
AND thread.visible = '1'
AND deletionlog.primaryid IS NULL
ORDER BY lastpost
DESC LIMIT 10;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Lands,99Bad Lands,23Bad Lands,116Bad Lands,118Bad Lands,98Bad Lands,90Bad Lands,' at line 7
Error Number : 1064
Date : Thursday, March 22nd 2007 @ 06:22:13 PM
Script : http://dieselbombers.com/
Referrer :
IP Address : 70.236.32.28
Username : redneckbuckeye
Classname : vb_database

Database error in vBulletin 3.6.5:

Invalid SQL:

UPDATE vbdatastore SET
data = data - 3,
data = IF(data < 0, 0, data)
WHERE title = 'mailqueue';

MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Date : Sunday, March 18th 2007 @ 06:21:25 PM
Script : http://www.dieselbombers.com/showthr...=2349#post2349
Referrer : http://www.dieselbombers.com/newrepl...postreply&t=87
IP Address : 216.223.173.45
Username : StrokerSmoker
Classname : vb_database

Aslo While i have someone talking to me ...

Ive tried like heck to get this running and it must not be cabatable with other mods i have ..

http://www.vbulletinusers.com/showthread.php?p=88

Man did i have things messed up LOL

Is there some other way to do this ?

My site is

www.dieselbombers.com its less than 2 weeks old and over 400 members WOOT !

Thanks Very Much for any help at all I have 7/8 or so hacks ive installed from here

DM

[Marco van Herwaarden]

MySQL Error : Lost connection to MySQL server during query

The most common reasons for the MySQL server has gone away error are:

1. Is that the server timed out and closed the connection. By default, the server closes the connection after 8 hours or 28800 seconds if nothing has happened. You can change the time limit by setting the wait_timeout variable when you start mysqld via your server's /etc/my.cnf as well.

2. Another common reason to receive the MySQL server has gone away error is because you have issued a ``close'' on your MySQL connection and then tried to run a query on the closed connection. You can check that the MySQL hasn't died by executing mysqladmin version and examining the uptime.

i.e. to check mysql uptime, in shell as root user type:

mysqladmin -u root -p version

3. You can also get these errors if you send a query to the server that is incorrect or too large. If mysqld gets a packet that is too large or out of order, it assumes that something has gone wrong with the client and closes the connection. If you need big queries (for example, if you are working with big BLOB columns), you can increase the query limit by starting mysqld with the -O max_allowed_packet=# option (default 1M) or via max_allowed_packet variable in your /etc/my.cnf file and restarting mysql after you edited your /etc/my.cnf file. The extra memory is allocated on demand, so mysqld will use more memory only when you issue a big query or when mysqld must return a big result row

4. Or simply your host restarted MySQL. I'd contact your web host and ask him to look into this.

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Lands,99Bad Lands,23Bad Lands,116Bad Lands,118Bad Lands,98Bad Lands,90Bad Lands,' at line 7

This is probably caused by a modification you have installed.

To troubleshoot this, please remove any hacks and disable your plugins, then see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

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.

[DieselMinded]

Well I dont understand most of that stuff LOL

As for the bad lands one Them are the forum Numbers and i had to Put them in the exclude of the show new posts hack in like 4 diffrent places before them threads wouldnt show

Any clue on adding More Latest posts options in a Nav Bar drop down?

DM