how to start from scratch ???

[GateKeper]

Please advise....

we have a site, and we have a lot of hacks, and lots of stuff we have done, but we would like to start from scratch, with no hacks, no 3rd party anything, just a fresh clean board, but we would like to maintain our members, our posts, files, discussions and so on

How do we go about doing this ? without losing any members, posts, files, and so on

We want a fresh start, just the basic board as though we never added a single anything related to hacks, be it donate, be it the arcade, be it stats, and so on, not even our logo

just a plain, start from zero board, but with our members and their posts and files, PM's and so on

Is there an easy way to do this, please point me to the area that this is documented....

I would like to delete all the stuff we have, as we are finding the board running very slow, and we are getting many errors

for example ones like this

-----------------------------------------
Database error in vBulletin 3.7.2:

Invalid SQL:
SELECT threadid FROM thread
WHERE threadid IN (17689,29324,25447,16192,9975,14172,10765,10626,93 35,9989,9210,7052)
AND forumid IN ();

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 ')' at line 3
Error Number : 1064
Request Date : Tuesday, September 16th 2008 @ 01:48:54 PM
Error Date : Tuesday, September 16th 2008 @ 01:48:54 PM
Script : http://www.xxxxxxxxxxxxx.com/search.php
Referrer :
IP Address : 00000000000
Username : Unregistered
Classname : vB_Database
MySQL Version :


------------------------------------------------
Database error in vBulletin 3.7.2:

Invalid SQL:
SELECT threadid FROM thread
WHERE threadid IN (19596,5947,8121,804,32417,32322,32265,32156,32108 ,32054,21169,31519,17689,31056,31544,14058,30643,3 0655,30289,30465,30274,30154,30062,30027,29966,299 05,29904,29829,29828,29753,29752,29227,29097,29096 ,29063,28155,28477,28244,27621,27436,27317,26918,2 6929,26651,25836,26393,26300,26137,25714,25529,256 66,25665,25664,25425,25424,25423,25383,25335,25158 ,25157,25156,24992,24965,24964,24963,12291,24837,2 4248,24305,23990,23855,23854,23853,23852,23851,238 50,23801,23610,23635,23636,23634,19538,23219,23048 ,22720,22789,22196,22190,22075,21651,21649,15676,2 1481,21449,21331,21297,21172,20813,20508,20691,204 63,20328,20268,19682,19681,19385,19374,19395,19362 ,19338,19208,19180,19179,19147,19146,19104,19103,1 9022,18654,18316,18040,18044,17984,17888,19537,178 51,17742,17693,12917,17606,16992,16776,16772,16650 ,16602,16302,16240,16064,16061,15889,15701,15654,1 5611,15592,14397,15478,15328,15432,15260,15257,140 70,15094,14954,14831,14834,14271,14463,14392,14390 ,14221,14312,10435,13518,1603,13720,12902,12918,13 361,13229,13193,12942,12964,12834,7616,12754,12591 ,12590,2684,12371,12481,12424,12351,12272,12260,12 170,12159,12120,11992,11827,11362,11280,10893,1065 2,10699,10625,10585,10377,10083,10047,10045,10007, 9972,9655,9790,9789,9777,9746,9676,9675,8915,7321, 7797,7762,7550,7191,7161,6085,6084,5481,5383,4793, 3975,3528,3338,3101,8125,1488,8126,1477,1398,323,3 13,265,575,220,168,157,37,32264,31905,31619,24529, 26254,26064,25930,23088,22904,11036,22189,21811,21 769,21752,21562,21558,21514,21500,21335,21209,2044 2,20167,19889,19700,19427,19100,19123,18851,18807, 17444,16603,17043,16393,15393,15131,21645,11475,11 408,11191,9397,7999,7862,6813,2531,4467,2533,2437, 1650,1483,1400,1389,1277,1264,1002,32415,32344,322 68,31891,31739,31269,31409,31360,30697,29324,28622 ,29865,29215,26880,28327,28411,28115,28114,27167,2 6113,25600,25137,24562,23794,24190,2398,15753,2393 1,22752,22955,22579,21134,22364,21624,20595,21604, 21648,21448,20992,21133,21136,20928,20991,19991,19 467,19101,15011,17664,16936,16739,17202,16802,9975 ,15803,15720,15612,15456,13247,14281,14296,14191,1 4069,13565,13326,13236,12973,13082,12438,12354,122 01,12241,12203,12232,10626,9335,9260,9210,9273,516 3,5950,5636,4865,4693,4431,4363,3306,3021,3025,286 8,1628,1503,1257,1251,1250,944,929,799,353,347,279 ,257)
AND forumid IN ();

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 ')' at line 3
Error Number : 1064
Request Date : Monday, September 15th 2008 @ 08:48:49 PM
Error Date : Monday, September 15th 2008 @ 08:48:49 PM
Script : http://www.xxxxxxxxxxxxxx.com/search.php
Referrer :
IP Address : 00000000000000
Username : Unregistered
Classname : vB_Database
MySQL Version :
---------------------------------------------------

Can someone in plain ole English, advise on how to go about doing this,,,or if the errors above are not critical, how to resolve them

Our goal is really to start from scratch, and build up on the site once again, with hacks, but probably not as many, only one's we really want to have, and ones that work and not give us problems and or slow us down

we are finding a slow down on the site, yet our specs on our server are as follows

------------------------------------------
Processor Name Intel(R) Core(TM)2 Quad CPU @ 2.40GHz
Vendor ID GenuineIntel
Processor Speed (MHz) 1600.000
Processor Name Intel(R) Core(TM)2 Quad CPU @ 2.40GHz
Vendor ID GenuineIntel
Processor Speed (MHz) 1600.000
Processor Name Intel(R) Core(TM)2 Quad CPU @ 2.40GHz
Vendor ID GenuineIntel
Processor Speed (MHz) 1600.000
Processor Name Intel(R) Core(TM)2 Quad CPU @ 2.40GHz
Vendor ID GenuineIntel
Processor Speed (MHz) 2400.000
Total Memory 3309912 kB
Free Memory 159328 kB
Total Swap Memory 2031608 kB
Free Swap Memory 2031540 kB
System Uptime 49 Days, 14 Hours and 13 Minutes
Apache 2.2.9 Running
DirectAdmin 1.32.2 Running
Exim 4.67 Running
MySQL 5.0.37 Running
Named 9.3.3rc2 Running
ProFTPd 1.3.1 Running
sshd Running
dovecot 1.1.1 Running

------------------------------------------

just to add one more, after we did the upgrade to the latest release

----------------------------------

Database error in vBulletin 3.7.3:

Invalid SQL:
SELECT threadid FROM thread
WHERE threadid IN (32343,29865,15753,22955,9529,9975,15675,15612,136 39,13565,13068,12241,9210,9399,5163,7160,4449,3027 ,3025,1628,1585,1580,1579,257,28448,27436,25600,22 664,16936,16579,13628,1619,4793,3032,3413,3049,164 1,1499,1399,279,26258,26094,25137,23454,23219,2092 8,15720,9272,490,32091,32087,32086,32085,32084,320 81,31847,31846,31845,31844,31843,31842,17689,31398 ,31397,31395,31394,31393,31392,30643,29516,29067,2 7078,27733,27654,26324,25349,24785,24248,23795,241 66,24042,24043,22867,22579,21064,18770,18656,18495 ,12185,16289,16240,15803,15652,13247,14573,15076,1 4498,14766,14011,14281,14296,13618,13402,13437,134 64,13463,13462,13461,13388,13385,13235,13193,12846 ,12750,12438,12255,11634,11457,11374,10377,10364,9 971,9258,9078,5129,7271,6738,6483,5649,6133,6126,6 085,6084,5842,5519,5566,5364,5502,3788,5317,5340,5 359,5357,3199,1708,8125,1488,1389,1257,956,954,931 ,918,830,828,827,591,466,465,441,364,262,577,166,1 63,158,37,32344,31891,27571,29964,25239,23449,2775 7,27439,27167,26471,26128,24040,23069,23021,22866, 22423,20595,21746,21648,21409,21330,20944,19933,19 737,19283,18870,18784,18512,17985,17784,17686,9227 ,16576,16303,15906,15862,15782,15647,15641,15108,1 5037,14829,14222,14131,13722,14129,13882,13445,131 31,13175,12408,12203,11831,10656,10588,7457,6782,6 643,5950,5355,4511,4413,4104,3270,2722,1457,1645,1 557,1278,1274,929,806,485,265,575)
AND forumid IN ();

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 ')' at line 3
Error Number : 1064
Request Date : Thursday, September 18th 2008 @ 08:30:59 PM
Error Date : Thursday, September 18th 2008 @ 08:30:59 PM
Script : http://www.xxxxxxxxxxxxxx.com/search.php?do=process
Referrer : http://www.ftaview.com/showthread.ph...ight=dp34+dish
IP Address : 00000000000000
Username : Unregistered
Classname : vB_Database
MySQL Version
-----------------------------------------------------------------------------
we have over 10 thousand members, and can have anywhere from 20 to 500 members online at any given time, but we find the site to become very slow after 200 members are online and active, it then even becomes difficult to upload files and or download them..


Any and all advice is appreciated...

Thanks

if there is anything else required, please advise and we will be glad to provide the info needed

Cheers