View Full Version : database error please help
i got this error on newreply.php
Database error in vBulletin :
Invalid SQL:
SELECT title, data
FROM datastore
WHERE title IN ('options', 'cron', 'forumcache', 'usergroupcache', 'stylecache', 'smiliecache', 'bbcodecache', 'attachmentcache')
mysql error: Table 'ohtwadi_xvb.datastore' doesn't exist
mysql error number: 1146
and on http://www.oh-twadi.com/forum/forumdisplay.php?f=12
Paul M
09-11-2005, 12:50 PM
Looks like you have deleted the datastore table - restore it from a backup.
seriously dont no when i last bked up
must have been time ago :(
erm would my host hav bkup?
do u meen install bkup of the whole forum?
i dont have any bkups
amykhar
09-11-2005, 01:04 PM
How are we supposed to know if you host has backups? Ask your host ;)
Seriously, don't delete ANYTHING from the database unless you know what you are doing.
i deleted wrong 1
i fortit said dstore
from the alice bot hack
my host doesnt have any bkups
so now what can i do
cant i just use this,i installed a vb forum just now same version as mine,cant i use this sql to doit or....
-- phpMyAdmin SQL Dump
-- version 2.6.1-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Sep 11, 2005 at 03:10 PM
-- Server version: 4.0.24
-- PHP Version: 4.3.11
--
-- Database: `ohtwadi_test`
--
-- --------------------------------------------------------
--
-- Table structure for table `datastore`
--
CREATE TABLE `datastore` (
`title` varchar(15) NOT NULL default '',
`data` mediumtext NOT NULL,
PRIMARY KEY (`title`)
) TYPE=MyISAM;
--
-- Dumping data for table `datastore`
--
INSERT INTO `datastore` VALUES ('wol_spiders', 'a:4:{s:10:"spiderdesc";s:64:"Google\nLycos\nAsk Jeeves\nAltavista\nAlltheWeb\nInktomi\nTurnitin.co m";s:13:"spiderstrings";s:76:"googlebot\nlycos\nask jeeves\nscooter\nfast-webcrawler\nslurp@inktomi\nturnitinbot";s:12:"spiderstring";s:76:"googlebot|lycos|ask jeeves|scooter|fast-webcrawler|slurp@inktomi|turnitinbot";s:11:"spiderarray";a:7:{s:9:"googlebot";s:6:"Google";s:5:"lycos";s:5:"Lycos";s:10:"ask jeeves";s:10:"Ask Jeeves";s:7:"scooter";s:9:"Altavista";s:15:"fast-webcrawler";s:9:"AllTheWeb";s:13:"slurp@inktomi";s:7:"Inktomi";s:11:"turnitinbot";s:12:"Turnitin.com";}}');
INSERT INTO `datastore` VALUES ('attachmentcache', 'a:12:{s:10:"extensions";s:44:"bmp doc gif jpe jpeg jpg pdf png psd txt zip";s:3:"bmp";a:6:{s:9:"extension";s:3:"bmp";s:4:"size";i:40000;s:6:"height";i:768;s:5:"width";i:1024;s:7:"enabled";i:1;s:7:"display";i:0;}s:3:"doc";a:6:{s:9:"extension";s:3:"doc";s:4:"size";i:40000;s:6:"height";i:0;s:5:"width";i:0;s:7:"enabled";i:1;s:7:"display";i:0;}s:3:"gif";a:6:{s:9:"extension";s:3:"gif";s:4:"size";i:40000;s:6:"height";i:768;s:5:"width";i:1024;s:7:"enabled";i:1;s:7:"display";i:0;}s:3:"jpe";a:6:{s:9:"extension";s:3:"jpe";s:4:"size";i:40000;s:6:"height";i:768;s:5:"width";i:1024;s:7:"enabled";i:1;s:7:"display";i:0;}s:4:"jpeg";a:6:{s:9:"extension";s:4:"jpeg";s:4:"size";i:40000;s:6:"height";i:768;s:5:"width";i:1024;s:7:"enabled";i:1;s:7:"display";i:0;}s:3:"jpg";a:6:{s:9:"extension";s:3:"jpg";s:4:"size";i:40000;s:6:"height";i:768;s:5:"width";i:1024;s:7:"enabled";i:1;s:7:"display";i:0;}s:3:"pdf";a:6:{s:9:"extension";s:3:"pdf";s:4:"size";i:40000;s:6:"height";i:0;s:5:"width";i:0;s:7:"enabled";i:1;s:7:"display";i:0;}s:3:"png";a:6:{s:9:"extension";s:3:"png";s:4:"size";i:40000;s:6:"height";i:768;s:5:"width";i:1024;s:7:"enabled";i:1;s:7:"display";i:0;}s:3:"psd";a:6:{s:9:"extension";s:3:"psd";s:4:"size";i:40000;s:6:"height";i:0;s:5:"width";i:0;s:7:"enabled";i:1;s:7:"display";i:0;}s:3:"txt";a:6:{s:9:"extension";s:3:"txt";s:4:"size";i:40000;s:6:"height";i:0;s:5:"width";i:0;s:7:"enabled";i:1;s:7:"display";i:2;}s:3:"zip";a:6:{s:9:"extension";s:3:"zip";s:4:"size";i:40000;s:6:"height";i:0;s:5:"width";i:0;s:7:"enabled";i:1;s:7:"display";i:0;}}');
INSERT INTO `datastore` VALUES ('stylecache', 'a:1:{i:-1;a:1:{i:1;a:1:{i:0;a:5:{s:7:"styleid";s:1:"1";s:5:"title";s:13:"Default Style";s:8:"parentid";s:2:"-1";s:12:"displayorder";s:1:"1";s:10:"userselect";s:1:"1";}}}}');
INSERT INTO `datastore` VALUES ('options', 'a:268:{s:15:"templateversion";s:5:"3.0.7";s:10:"attachfile";s:1:"0";s:10:"attachpath";s:34:"/path/to/your/attachment/directory";s:13:"usefileavatar";s:0:"";s:10:"avatarpath";s:15:"./customavatars";s:9:"avatarurl";s:13:"customavatars";s:10:"divnotpara";s:1:"1";s:21:"usebbcodeparserecurse";s:1:"2";s:14:"fulltextsearch";s:1:"0";s:8:"bbactive";s:1:"1";s:14:"bbclosedreason";s:124:"<p>Sorry, the board is unavailable at the moment while we are testing some functionality.</p>\n<p>We will be back soon...</p>";s:7:"bbtitle";s:6:"Forums";s:5:"bburl";s:33:"http://www.oh-twadi.com/testforum";s:9:"hometitle";s:0:"";s:7:"homeurl";s:23:"http://www.oh-twadi.com";s:13:"contactuslink";s:15:"sendmessage.php";s:16:"contactusoptions";s:34:"Site Feedback\nRegistration Problem";s:14:"webmasteremail";s:22:"webmaster@oh-twadi.com";s:10:"privacyurl";s:0:"";s:13:"copyrighttext";s:0:"";s:11:"companyname";s:0:"";s:9:"faxnumber";s:0:"";s:7:"address";s:0:"";s:8:"keywords";s:53:"vbulletin,forum,bbs,discussion,jelsoft,bulletin board";s:11:"description";s:111:"This is a discussion forum powered by vBulletin. To find out about vBulletin, go to http://www.vbulletin.com/ .";s:12:"useforumjump";s:1:"1";s:12:"pagenavpages";s:1:"3";s:12:"enableaccess";s:1:"1";s:11:"showimicons";s:1:"1";s:15:"addtemplatename";s:0:"";s:15:"usestrikesystem";s:1:"1";s:8:"yestoday";s:1:"1";s:10:"timeoffset";s:1:"0";s:8:"dstonoff";s:1:"0";s:10:"dateformat";s:5:"m-d-Y";s:10:"timeformat";s:5:"h:i A";s:20:"registereddateformat";s:3:"M Y";s:10:"calformat1";s:6:"F j, Y";s:10:"calformat2";s:3:"F j";s:13:"logdateformat";s:11:"H:i, jS M Y";s:13:"cookietimeout";s:3:"900";s:10:"cookiepath";s:1:"/";s:12:"cookiedomain";s:0:"";s:10:"gzipoutput";s:1:"1";s:9:"gziplevel";s:1:"1";s:10:"addheaders";s:0:"";s:14:"nocacheheaders";s:1:"0";s:17:"useheaderredirect";s:1:"1";s:12:"allowphpinfo";s:1:"0";s:11:"cachemaxage";s:1:"0";s:15:"threadviewslive";s:0:"";s:19:"attachmentviewslive";s:0:"";s:12:"emailsendnum";s:2:"10";s:12:"sessionlimit";s:1:"0";s:9:"loadlimit";s:1:"0";s:19:"allowimgsizefailure";s:0:"";s:9:"gdversion";s:1:"0";s:10:"safeupload";s:0:"";s:7:"tmppath";s:4:"/tmp";s:12:"usemailqueue";s:1:"1";s:13:"needfromemail";s:1:"0";s:13:"copypostindex";s:1:"1";s:10:"languageid";s:1:"1";s:7:"styleid";s:1:"1";s:17:"allowchangestyles";s:1:"1";s:11:"cleargifurl";s:9:"clear.gif";s:14:"storecssasfile";s:1:"0";s:9:"usepopups";s:1:"1";s:13:"legacypostbit";s:1:"0";s:11:"enableemail";s:1:"1";s:13:"displayemails";s:1:"1";s:11:"secureemail";s:0:"";s:14:"emailfloodtime";s:2:"60";s:12:"enablecensor";s:1:"1";s:10:"censorchar";s:1:"*";s:11:"censorwords";s:0:"";s:15:"blankasciistrip";s:7:"160 173";s:17:"allowregistration";s:1:"1";s:8:"usecoppa";s:0:"";s:18:"moderatenewmembers";s:0:"";s:13:"regimagecheck";s:1:"1";s:11:"welcomemail";s:1:"1";s:12:"newuseremail";s:0:"";s:14:"allowmultiregs";s:0:"";s:11:"verifyemail";s:0:"";s:18:"requireuniqueemail";s:1:"1";s:13:"minuserlength";s:1:"3";s:13:"maxuserlength";s:2:"25";s:16:"illegalusernames";s:0:"";s:11:"usereferrer";s:1:"1";s:17:"defaultregoptions";s:7:"4686473";s:10:"ctMaxChars";s:2:"25";s:13:"ctCensorWords";s:38:"admin forum moderator vbulletin leader";s:11:"ctCensorMod";s:1:"1";s:15:"allowsignatures";s:1:"1";s:6:"sigmax";s:3:"500";s:11:"allowbbcode";s:1:"1";s:12:"allowsmilies";s:1:"1";s:16:"allowbbimagecode";s:0:"";s:9:"allowhtml";s:0:"";s:10:"ignoremods";s:1:"0";s:13:"avatarenabled";s:1:"1";s:14:"numavatarswide";s:1:"5";s:17:"numavatarsperpage";s:2:"10";s:17:"profilepicenabled";s:1:"1";s:16:"reputationenable";s:0:"";s:17:"reputationdefault";s:2:"10";s:19:"reputationundefined";s:16:"is off the scale";s:13:"showuserrates";s:1:"5";s:10:"adminpower";s:2:"10";s:7:"rdpower";s:3:"365";s:7:"pcpower";s:4:"1000";s:7:"kppower";s:3:"100";s:17:"minreputationpost";s:2:"50";s:18:"minreputationcount";s:2:"10";s:19:"maxreputationperday";s:2:"10";s:16:"reputationrepeat";s:2:"20";s:13:"unallowvbcode";s:1:"1";s:14:"unallowsmilies";s:1:"1";s:10:"unallowimg";s:1:"1";s:11:"unallowhtml";s:0:"";s:16:"enablememberlist";s:1:"1";s:15:"memberlistposts";s:1:"0";s:16:"memberlistfields";s:3:"216";s:17:"memberlistperpage";s:2:"30";s:22:"usememberlistadvsearch";s:1:"1";s:15:"profilelastpost";s:1:"0";s:13:"enablebanning";s:1:"1";s:5:"banip";s:0:"";s:8:"banemail";s:0:"";s:20:"allowkeepbannedemail";s:1:"1";s:12:"globalignore";s:0:"";s:14:"allowedbbcodes";s:4:"1023";s:12:"codemaxlines";s:2:"30";s:10:"quickreply";s:0:"";s:15:"quickreplyclick";s:1:"1";s:12:"postminchars";s:2:"10";s:16:"ignorequotechars";s:1:"1";s:10:"quotetitle";s:1:"0";s:12:"postmaxchars";s:5:"10000";s:9:"maximages";s:1:"4";s:12:"stopshouting";s:1:"1";s:11:"allowdynimg";s:0:"";s:14:"floodchecktime";s:2:"30";s:20:"editthreadtitlelimit";s:1:"5";s:14:"addpolltimeout";s:1:"0";s:13:"edittimelimit";s:1:"0";s:14:"noeditedbytime";s:1:"2";s:5:"logip";s:1:"1";s:18:"allowvbcodebuttons";s:1:"2";s:22:"wysiwyg_show_smiliebox";s:1:"0";s:7:"smtotal";s:2:"15";s:9:"smcolumns";s:1:"3";s:15:"wysiwyg_smtotal";s:2:"15";s:14:"syscolorpicker";s:1:"0";s:16:"attachtotalspace";s:1:"0";s:11:"attachlimit";s:1:"5";s:14:"attachboxcount";s:1:"1";s:14:"allowattachdel";s:1:"1";s:20:"allowclosedattachdel";s:1:"0";s:15:"allowduplicates";s:1:"1";s:18:"viewattachedimages";s:1:"1";s:12:"attachthumbs";s:1:"0";s:16:"attachthumbssize";s:3:"100";s:9:"attachrow";s:1:"5";s:8:"thumbpng";s:1:"1";s:14:"maxpolloptions";s:2:"10";s:13:"maxpolllength";s:3:"100";s:14:"updatelastpost";s:0:"";s:9:"showvotes";s:1:"1";s:10:"votechange";s:0:"";s:14:"enablesearches";s:1:"1";s:15:"searchfloodtime";s:1:"0";s:15:"minsearchlength";s:1:"4";s:15:"maxsearchlength";s:2:"20";s:9:"goodwords";s:14:"vb vbb php sql";s:13:"searchperpage";s:2:"25";s:10:"maxresults";s:3:"500";s:14:"allowwildcards";s:1:"1";s:19:"similarthreadsearch";s:1:"0";s:22:"similarthreadthreshold";s:3:"3.5";s:15:"multimatchscore";s:2:"15";s:9:"datescore";s:2:"15";s:16:"threadtitlescore";s:1:"5";s:14:"posttitlescore";s:1:"5";s:10:"replyscore";s:4:"0.10";s:9:"replyfunc";s:4:"none";s:9:"viewscore";s:4:"0.01";s:8:"viewfunc";s:4:"none";s:9:"ratescore";s:3:"0.5";s:8:"ratefunc";s:4:"none";s:9:"forumhome";s:5:"index";s:15:"displayloggedin";s:1:"1";s:13:"showbirthdays";s:1:"1";s:15:"birthdaydatecut";s:1:"0";s:10:"showevents";s:1:"1";s:12:"showholidays";s:1:"1";s:13:"showeventtype";s:1:"0";s:14:"forumhomedepth";s:1:"2";s:17:"forumdisplaydepth";s:1:"2";s:13:"subforumdepth";s:1:"0";s:20:"showforumdescription";s:1:"1";s:17:"hideprivateforums";s:1:"1";s:9:"showlocks";s:0:"";s:15:"lastthreadchars";s:2:"30";s:19:"showmoderatorcolumn";s:0:"";s:14:"showforumusers";s:0:"";s:10:"maxthreads";s:2:"20";s:12:"showstickies";s:1:"1";s:8:"showdots";s:1:"1";s:13:"usehotthreads";s:1:"1";s:14:"hotnumberviews";s:3:"150";s:14:"hotnumberposts";s:2:"15";s:11:"linktopages";s:1:"1";s:12:"maxmultipage";s:1:"3";s:13:"threadpreview";s:3:"300";s:11:"oneannounce";s:1:"1";s:15:"showthreadusers";s:0:"";s:8:"maxposts";s:2:"10";s:12:"usermaxposts";s:13:"5,10,20,30,40";s:11:"showdeficon";s:22:"images/icons/icon1.gif";s:8:"wordwrap";s:2:"50";s:11:"threadvoted";s:0:"";s:16:"threadsubscribed";s:1:"1";s:18:"showsimilarthreads";s:1:"1";s:12:"postelements";s:1:"0";s:17:"allowthreadedmode";s:1:"1";s:12:"threadedmode";s:0:"";s:18:"threaded_listdepth";s:1:"5";s:17:"threaded_maxcache";s:2:"40";s:9:"enablepms";s:1:"1";s:10:"checknewpm";s:1:"1";s:10:"pmmaxchars";s:4:"5000";s:11:"pmfloodtime";s:2:"60";s:9:"pmperpage";s:2:"50";s:12:"pmmaxperpage";s:3:"100";s:14:"privallowicons";s:1:"1";s:15:"privallowbbcode";s:1:"1";s:16:"privallowsmilies";s:1:"1";s:20:"privallowbbimagecode";s:1:"1";s:13:"privallowhtml";s:0:"";s:9:"WOLenable";s:1:"1";s:10:"WOLrefresh";s:2:"60";s:9:"WOLguests";s:1:"1";s:10:"WOLresolve";s:0:"";s:13:"enablespiders";s:1:"0";s:13:"spiderstrings";s:117:"googlebot\nmediapartners-google\nlycos\nask jeeves\nscooter\nfast-webcrawler\nslurp@inktomi\nturnitinbot\nyahoo! slurp\nmsnbot";s:10:"spiderdesc";s:103:"Google\nMediapartners Adsense\nLycos\nAsk Jeeves\nAltavista\nAlltheWeb\nInktomi\nTurnitin.co m\nYahoo\nMSN Search";s:14:"archiveenabled";s:1:"1";s:22:"archive_threadsperpage";s:3:"250";s:20:"archive_postsperpage";s:3:"250";s:13:"cpstylefolder";s:19:"vBulletin_3_Default";s:19:"timeoutcontrolpanel";s:1:"0";s:15:"adminquickstats";s:1:"0";s:18:"cp_collapse_forums";s:1:"0";s:18:"cp_usereditcolumns";s:1:"2";s:10:"externaljs";s:0:"";s:11:"externalrss";s:0:"";s:11:"externalxml";s:0:"";s:16:"errorlogdatabase";s:0:"";s:16:"errorlogsecurity";s:0:"";s:15:"errorlogmaxsize";s:7:"1048576";s:17:"disableerroremail";s:1:"0";s:19:"subscriptionmethods";s:1:"0";s:7:"ppemail";s:0:"";s:8:"ncxemail";s:0:"";s:15:"worldpay_instid";s:0:"";s:17:"authorize_loginid";s:0:"";}');
INSERT INTO `datastore` VALUES ('smiliecache', 'a:11:{i:1;a:6:{s:8:"smilieid";s:1:"1";s:5:"title";s:5:"Smile";s:10:"smilietext";s:2:":)";s:10:"smiliepath";s:24:"images/smilies/smile.gif";s:15:"imagecategoryid";s:1:"1";s:12:"displayorder";s:1:"1";}i:2;a:6:{s:8:"smilieid";s:1:"2";s:5:"title";s:13:"Embarrassment";s:10:"smilietext";s:2:":o";s:10:"smiliepath";s:26:"images/smilies/redface.gif";s:15:"imagecategoryid";s:1:"1";s:12:"displayorder";s:1:"1";}i:3;a:6:{s:8:"smilieid";s:1:"3";s:5:"title";s:8:"Big Grin";s:10:"smilietext";s:2:":D";s:10:"smiliepath";s:26:"images/smilies/biggrin.gif";s:15:"imagecategoryid";s:1:"1";s:12:"displayorder";s:1:"1";}i:4;a:6:{s:8:"smilieid";s:1:"4";s:5:"title";s:4:"Wink";s:10:"smilietext";s:2:";)";s:10:"smiliepath";s:23:"images/smilies/wink.gif";s:15:"imagecategoryid";s:1:"1";s:12:"displayorder";s:1:"1";}i:5;a:6:{s:8:"smilieid";s:1:"5";s:5:"title";s:16:"Stick Out Tongue";s:10:"smilietext";s:2:":p";s:10:"smiliepath";s:25:"images/smilies/tongue.gif";s:15:"imagecategoryid";s:1:"1";s:12:"displayorder";s:1:"1";}i:8;a:6:{s:8:"smilieid";s:1:"8";s:5:"title";s:3:"Mad";s:10:"smilietext";s:5:":mad:";s:10:"smiliepath";s:22:"images/smilies/mad.gif";s:15:"imagecategoryid";s:1:"1";s:12:"displayorder";s:1:"1";}i:10;a:6:{s:8:"smilieid";s:2:"10";s:5:"title";s:8:"Confused";s:10:"smilietext";s:10:":confused:";s:10:"smiliepath";s:27:"images/smilies/confused.gif";s:15:"imagecategoryid";s:1:"1";s:12:"displayorder";s:1:"1";}i:11;a:6:{s:8:"smilieid";s:2:"11";s:5:"title";s:5:"Frown";s:10:"smilietext";s:2:":(";s:10:"smiliepath";s:24:"images/smilies/frown.gif";s:15:"imagecategoryid";s:1:"1";s:12:"displayorder";s:1:"1";}i:7;a:6:{s:8:"smilieid";s:1:"7";s:5:"title";s:21:"Roll Eyes (Sarcastic)";s:10:"smilietext";s:10:":rolleyes:";s:10:"smiliepath";s:27:"images/smilies/rolleyes.gif";s:15:"imagecategoryid";s:1:"1";s:12:"displayorder";s:1:"3";}i:6;a:6:{s:8:"smilieid";s:1:"6";s:5:"title";s:4:"Cool";s:10:"smilietext";s:6:":cool:";s:10:"smiliepath";s:23:"images/smilies/cool.gif";s:15:"imagecategoryid";s:1:"1";s:12:"displayorder";s:1:"5";}i:9;a:6:{s:8:"smilieid";s:1:"9";s:5:"title";s:4:"EEK!";s:10:"smilietext";s:5:":eek:";s:10:"smiliepath";s:22:"images/smilies/eek.gif";s:15:"imagecategoryid";s:1:"1";s:12:"displayorder";s:1:"7";}}');
INSERT INTO `datastore` VALUES ('iconcache', 'a:14:{i:1;a:5:{s:6:"iconid";s:1:"1";s:5:"title";s:4:"Post";s:8:"iconpath";s:22:"images/icons/icon1.gif";s:15:"imagecategoryid";s:1:"2";s:12:"displayorder";s:1:"1";}i:2;a:5:{s:6:"iconid";s:1:"2";s:5:"title";s:5:"Arrow";s:8:"iconpath";s:22:"images/icons/icon2.gif";s:15:"imagecategoryid";s:1:"2";s:12:"displayorder";s:1:"1";}i:3;a:5:{s:6:"iconid";s:1:"3";s:5:"title";s:9:"Lightbulb";s:8:"iconpath";s:22:"images/icons/icon3.gif";s:15:"imagecategoryid";s:1:"2";s:12:"displayorder";s:1:"1";}i:4;a:5:{s:6:"iconid";s:1:"4";s:5:"title";s:11:"Exclamation";s:8:"iconpath";s:22:"images/icons/icon4.gif";s:15:"imagecategoryid";s:1:"2";s:12:"displayorder";s:1:"1";}i:5;a:5:{s:6:"iconid";s:1:"5";s:5:"title";s:8:"Question";s:8:"iconpath";s:22:"images/icons/icon5.gif";s:15:"imagecategoryid";s:1:"2";s:12:"displayorder";s:1:"1";}i:6;a:5:{s:6:"iconid";s:1:"6";s:5:"title";s:4:"Cool";s:8:"iconpath";s:22:"images/icons/icon6.gif";s:15:"imagecategoryid";s:1:"2";s:12:"displayorder";s:1:"1";}i:7;a:5:{s:6:"iconid";s:1:"7";s:5:"title";s:5:"Smile";s:8:"iconpath";s:22:"images/icons/icon7.gif";s:15:"imagecategoryid";s:1:"2";s:12:"displayorder";s:1:"1";}i:8;a:5:{s:6:"iconid";s:1:"8";s:5:"title";s:5:"Angry";s:8:"iconpath";s:22:"images/icons/icon8.gif";s:15:"imagecategoryid";s:1:"2";s:12:"displayorder";s:1:"1";}i:9;a:5:{s:6:"iconid";s:1:"9";s:5:"title";s:7:"Unhappy";s:8:"iconpath";s:22:"images/icons/icon9.gif";s:15:"imagecategoryid";s:1:"2";s:12:"displayorder";s:1:"1";}i:10;a:5:{s:6:"iconid";s:2:"10";s:5:"title";s:7:"Talking";s:8:"iconpath";s:23:"images/icons/icon10.gif";s:15:"imagecategoryid";s:1:"2";s:12:"displayorder";s:1:"1";}i:11;a:5:{s:6:"iconid";s:2:"11";s:5:"title";s:8:"Red face";s:8:"iconpath";s:23:"images/icons/icon11.gif";s:15:"imagecategoryid";s:1:"2";s:12:"displayorder";s:1:"1";}i:12;a:5:{s:6:"iconid";s:2:"12";s:5:"title";s:4:"Wink";s:8:"iconpath";s:23:"images/icons/icon12.gif";s:15:"imagecategoryid";s:1:"2";s:12:"displayorder";s:1:"1";}i:13;a:5:{s:6:"iconid";s:2:"13";s:5:"title";s:11:"Thumbs down";s:8:"iconpath";s:23:"images/icons/icon13.gif";s:15:"imagecategoryid";s:1:"2";s:12:"displayorder";s:1:"1";}i:14;a:5:{s:6:"iconid";s:2:"14";s:5:"title";s:9:"Thumbs up";s:8:"iconpath";s:23:"images/icons/icon14.gif";s:15:"imagecategoryid";s:1:"2";s:12:"displayorder";s:1:"1";}}');
INSERT INTO `datastore` VALUES ('bbcodecache', 'a:0:{}');
INSERT INTO `datastore` VALUES ('userstats', 'a:3:{s:13:"numbermembers";s:1:"1";s:11:"newusername";s:4:"test";s:9:"newuserid";s:1:"1";}');
INSERT INTO `datastore` VALUES ('usergroupcache', 'a:8:{i:4;a:27:{s:11:"usergroupid";s:1:"4";s:5:"title";s:33:"(COPPA) Users Awaiting Moderation";s:11:"description";s:0:"";s:9:"usertitle";s:0:"";s:15:"passwordexpires";s:1:"0";s:15:"passwordhistory";s:1:"0";s:7:"pmquota";s:2:"50";s:9:"pmsendmax";s:1:"0";s:12:"pmforwardmax";s:1:"0";s:7:"opentag";s:0:"";s:8:"closetag";s:0:"";s:11:"canoverride";s:1:"0";s:13:"ispublicgroup";s:1:"0";s:16:"forumpermissions";s:2:"15";s:13:"pmpermissions";s:1:"0";s:19:"calendarpermissions";s:1:"0";s:14:"wolpermissions";s:1:"0";s:16:"adminpermissions";s:1:"0";s:18:"genericpermissions";s:1:"3";s:14:"genericoptions";s:2:"16";s:11:"attachlimit";s:1:"0";s:14:"avatarmaxwidth";i:-1;s:15:"avatarmaxheight";i:-1;s:13:"avatarmaxsize";i:-1;s:18:"profilepicmaxwidth";i:-1;s:19:"profilepicmaxheight";i:-1;s:17:"profilepicmaxsize";i:-1;}i:6;a:27:{s:11:"usergroupid";s:1:"6";s:5:"title";s:14:"Administrators";s:11:"description";s:0:"";s:9:"usertitle";s:13:"Administrator";s:15:"passwordexpires";s:3:"180";s:15:"passwordhistory";s:3:"360";s:7:"pmquota";s:2:"50";s:9:"pmsendmax";s:1:"5";s:12:"pmforwardmax";s:1:"5";s:7:"opentag";s:0:"";s:8:"closetag";s:0:"";s:11:"canoverride";s:1:"0";s:13:"ispublicgroup";s:1:"0";s:16:"forumpermissions";s:6:"393215";s:13:"pmpermissions";s:1:"3";s:19:"calendarpermissions";s:2:"31";s:14:"wolpermissions";s:2:"31";s:16:"adminpermissions";s:1:"3";s:18:"genericpermissions";s:7:"8388543";s:14:"genericoptions";s:2:"31";s:11:"attachlimit";s:1:"0";s:14:"avatarmaxwidth";s:2:"80";s:15:"avatarmaxheight";s:2:"80";s:13:"avatarmaxsize";s:5:"20000";s:18:"profilepicmaxwidth";s:3:"100";s:19:"profilepicmaxheight";s:3:"100";s:17:"profilepicmaxsize";s:5:"65535";}i:8;a:27:{s:11:"usergroupid";s:1:"8";s:5:"title";s:12:"Banned Users";s:11:"description";s:0:"";s:9:"usertitle";s:6:"Banned";s:15:"passwordexpires";s:1:"0";s:15:"passwordhistory";s:1:"0";s:7:"pmquota";s:1:"0";s:9:"pmsendmax";s:1:"0";s:12:"pmforwardmax";s:1:"0";s:7:"opentag";s:0:"";s:8:"closetag";s:0:"";s:11:"canoverride";s:1:"0";s:13:"ispublicgroup";s:1:"0";s:16:"forumpermissions";s:1:"0";s:13:"pmpermissions";s:1:"0";s:19:"calendarpermissions";s:1:"0";s:14:"wolpermissions";s:1:"0";s:16:"adminpermissions";s:1:"0";s:18:"genericpermissions";s:1:"0";s:14:"genericoptions";s:2:"32";s:11:"attachlimit";s:1:"0";s:14:"avatarmaxwidth";i:-1;s:15:"avatarmaxheight";i:-1;s:13:"avatarmaxsize";i:-1;s:18:"profilepicmaxwidth";i:-1;s:19:"profilepicmaxheight";i:-1;s:17:"profilepicmaxsize";i:-1;}i:7;a:27:{s:11:"usergroupid";s:1:"7";s:5:"title";s:10:"Moderators";s:11:"description";s:0:"";s:9:"usertitle";s:9:"Moderator";s:15:"passwordexpires";s:1:"0";s:15:"passwordhistory";s:1:"0";s:7:"pmquota";s:2:"50";s:9:"pmsendmax";s:1:"5";s:12:"pmforwardmax";s:1:"5";s:7:"opentag";s:0:"";s:8:"closetag";s:0:"";s:11:"canoverride";s:1:"0";s:13:"ispublicgroup";s:1:"0";s:16:"forumpermissions";s:6:"127487";s:13:"pmpermissions";s:1:"1";s:19:"calendarpermissions";s:2:"31";s:14:"wolpermissions";s:1:"3";s:16:"adminpermissions";s:1:"0";s:18:"genericpermissions";s:7:"2629263";s:14:"genericoptions";s:2:"22";s:11:"attachlimit";s:1:"0";s:14:"avatarmaxwidth";s:2:"80";s:15:"avatarmaxheight";s:2:"80";s:13:"avatarmaxsize";s:5:"20000";s:18:"profilepicmaxwidth";s:3:"100";s:19:"profilepicmaxheight";s:3:"100";s:17:"profilepicmaxsize";s:5:"65535";}i:2;a:27:{s:11:"usergroupid";s:1:"2";s:5:"title";s:16:"Registered Users";s:11:"description";s:0:"";s:9:"usertitle";s:0:"";s:15:"passwordexpires";s:1:"0";s:15:"passwordhistory";s:1:"0";s:7:"pmquota";s:2:"50";s:9:"pmsendmax";s:1:"5";s:12:"pmforwardmax";s:1:"5";s:7:"opentag";s:0:"";s:8:"closetag";s:0:"";s:11:"canoverride";s:1:"0";s:13:"ispublicgroup";s:1:"0";s:16:"forumpermissions";s:6:"127487";s:13:"pmpermissions";s:1:"3";s:19:"calendarpermissions";s:2:"19";s:14:"wolpermissions";s:1:"1";s:16:"adminpermissions";s:1:"0";s:18:"genericpermissions";s:7:"2626759";s:14:"genericoptions";s:2:"30";s:11:"attachlimit";s:1:"0";s:14:"avatarmaxwidth";i:-1;s:15:"avatarmaxheight";i:-1;s:13:"avatarmaxsize";i:-1;s:18:"profilepicmaxwidth";s:3:"100";s:19:"profilepicmaxheight";s:3:"100";s:17:"profilepicmaxsize";s:5:"65535";}i:5;a:27:{s:11:"usergroupid";s:1:"5";s:5:"title";s:16:"Super Moderators";s:11:"description";s:0:"";s:9:"usertitle";s:15:"Super Moderator";s:15:"passwordexpires";s:1:"0";s:15:"passwordhistory";s:1:"0";s:7:"pmquota";s:2:"50";s:9:"pmsendmax";s:1:"0";s:12:"pmforwardmax";s:1:"0";s:7:"opentag";s:0:"";s:8:"closetag";s:0:"";s:11:"canoverride";s:1:"0";s:13:"ispublicgroup";s:1:"0";s:16:"forumpermissions";s:6:"393215";s:13:"pmpermissions";s:1:"3";s:19:"calendarpermissions";s:2:"31";s:14:"wolpermissions";s:2:"15";s:16:"adminpermissions";s:1:"1";s:18:"genericpermissions";s:7:"7298415";s:14:"genericoptions";s:2:"31";s:11:"attachlimit";s:1:"0";s:14:"avatarmaxwidth";i:-1;s:15:"avatarmaxheight";i:-1;s:13:"avatarmaxsize";i:-1;s:18:"profilepicmaxwidth";i:-1;s:19:"profilepicmaxheight";i:-1;s:17:"profilepicmaxsize";i:-1;}i:1;a:27:{s:11:"usergroupid";s:1:"1";s:5:"title";s:28:"Unregistered / Not Logged In";s:11:"description";s:0:"";s:9:"usertitle";s:5:"Guest";s:15:"passwordexpires";s:1:"0";s:15:"passwordhistory";s:1:"0";s:7:"pmquota";s:2:"50";s:9:"pmsendmax";s:1:"0";s:12:"pmforwardmax";s:1:"0";s:7:"opentag";s:0:"";s:8:"closetag";s:0:"";s:11:"canoverride";s:1:"0";s:13:"ispublicgroup";s:1:"0";s:16:"forumpermissions";s:4:"4103";s:13:"pmpermissions";s:1:"0";s:19:"calendarpermissions";s:1:"0";s:14:"wolpermissions";s:1:"1";s:16:"adminpermissions";s:1:"0";s:18:"genericpermissions";s:1:"1";s:14:"genericoptions";s:1:"8";s:11:"attachlimit";s:1:"0";s:14:"avatarmaxwidth";i:-1;s:15:"avatarmaxheight";i:-1;s:13:"avatarmaxsize";i:-1;s:18:"profilepicmaxwidth";i:-1;s:19:"profilepicmaxheight";i:-1;s:17:"profilepicmaxsize";i:-1;}i:3;a:27:{s:11:"usergroupid";s:1:"3";s:5:"title";s:33:"Users Awaiting Email Confirmation";s:11:"description";s:0:"";s:9:"usertitle";s:0:"";s:15:"passwordexpires";s:1:"0";s:15:"passwordhistory";s:1:"0";s:7:"pmquota";s:2:"50";s:9:"pmsendmax";s:1:"0";s:12:"pmforwardmax";s:1:"0";s:7:"opentag";s:0:"";s:8:"closetag";s:0:"";s:11:"canoverride";s:1:"0";s:13:"ispublicgroup";s:1:"0";s:16:"forumpermissions";s:4:"4111";s:13:"pmpermissions";s:1:"0";s:19:"calendarpermissions";s:1:"0";s:14:"wolpermissions";s:1:"0";s:16:"adminpermissions";s:1:"0";s:18:"genericpermissions";s:4:"1031";s:14:"genericoptions";s:2:"24";s:11:"attachlimit";s:1:"0";s:14:"avatarmaxwidth";i:-1;s:15:"avatarmaxheight";i:-1;s:13:"avatarmaxsize";i:-1;s:18:"profilepicmaxwidth";i:-1;s:19:"profilepicmaxheight";i:-1;s:17:"profilepicmaxsize";i:-1;}}');
INSERT INTO `datastore` VALUES ('forumcache', 'a:2:{i:1;a:16:{s:7:"forumid";s:1:"1";s:7:"styleid";s:1:"0";s:5:"title";s:13:"Main Category";s:11:"description";s:25:"Main Category Description";s:7:"options";s:5:"86017";s:12:"displayorder";s:1:"1";s:9:"daysprune";s:1:"0";s:12:"newpostemail";s:0:"";s:14:"newthreademail";s:0:"";s:8:"parentid";s:2:"-1";s:10:"parentlist";s:4:"1,-1";s:8:"password";s:0:"";s:4:"link";s:0:"";s:9:"childlist";s:6:"1,2,-1";s:5:"depth";i:0;s:11:"permissions";a:8:{i:4;s:2:"15";i:6;s:6:"393215";i:8;s:1:"0";i:7;s:6:"127487";i:2;s:6:"127487";i:5;s:6:"393215";i:1;s:4:"4103";i:3;s:4:"4111";}}i:2;a:16:{s:7:"forumid";s:1:"2";s:7:"styleid";s:1:"0";s:5:"title";s:10:"Main Forum";s:11:"description";s:22:"Main Forum Description";s:7:"options";s:5:"89799";s:12:"displayorder";s:1:"1";s:9:"daysprune";s:2:"30";s:12:"newpostemail";s:0:"";s:14:"newthreademail";s:0:"";s:8:"parentid";s:1:"1";s:10:"parentlist";s:6:"2,1,-1";s:8:"password";s:0:"";s:4:"link";s:0:"";s:9:"childlist";s:4:"2,-1";s:5:"depth";i:1;s:11:"permissions";a:8:{i:4;s:2:"15";i:6;s:6:"393215";i:8;s:1:"0";i:7;s:6:"127487";i:2;s:6:"127487";i:5;s:6:"393215";i:1;s:4:"4103";i:3;s:4:"4111";}}}');
INSERT INTO `datastore` VALUES ('cron', '1053271600');
INSERT INTO `datastore` VALUES ('birthdaycache', 'a:4:{s:4:"day1";s:10:"2005-09-11";s:4:"day2";s:10:"2005-09-12";s:6:"users1";N;s:6:"users2";N;}');
INSERT INTO `datastore` VALUES ('eventcache', 'a:1:{s:4:"date";s:9:"9-12-2005";}');
INSERT INTO `datastore` VALUES ('maxloggedin', 'a:2:{s:9:"maxonline";i:0;s:13:"maxonlinedate";i:1126441895;}');
amykhar
09-11-2005, 01:12 PM
The easiest thing for you to do would be to install a test board. Go to phpmyadmin, and backup the structure of the datastore table. Restore it to your live forum.
And don't ever delete a table again even if the hack instructions tell you to. You just don't have the knowledge to do that safely.
ok i fixed most of it,thanx
but now i notice my member stats says i have 1 member except theres loads
it just doesnt show it on forum stats
www.oh-twadi.com/forum see bottom
Paul M
09-11-2005, 01:45 PM
That's because those stats are stored in the datastore, so you have lost them.
amykhar
09-11-2005, 03:53 PM
It should fix itself when a new member registers though. The cache is probably going to be wonky until it is refreshed with new data as the data comes in.
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.