vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)
-   -   database error please help (https://vborg.vbsupport.ru/showthread.php?t=96047)

Thug 09-11-2005 11:05 AM

database error please help
 
i got this error on newreply.php

PHP Code:

Database error in vBulletin :

Invalid SQL
                
SELECT titledata
                FROM datastore
                WHERE title IN 
('options''cron''forumcache''usergroupcache''stylecache''smiliecache''bbcodecache''attachmentcache')
            
mysql errorTable '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.

Thug 09-11-2005 12:52 PM

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.

Thug 09-11-2005 01:06 PM

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....

PHP Code:

-- phpMyAdmin SQL Dump
-- version 2.6.1-pl2
-- http://www.phpmyadmin.net
-- 
-- 
Hostlocalhost
-- Generation TimeSep 112005 at 03:10 PM
-- Server version4.0.24
-- PHP Version4.3.11
-- 
-- 
Database: `ohtwadi_test`
-- 

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

-- 
-- 
Table structure for table `datastore`
-- 

CREATE TABLE `datastore` (
  `
titlevarchar(15NOT NULL default '',
  `
datamediumtext NOT NULL,
  
PRIMARY KEY  (`title`)
TYPE=MyISAM;

-- 
-- 
Dumping data for table `datastore`
-- 

INSERT INTO `datastoreVALUES ('wol_spiders''a:4:{s:10:"spiderdesc";s:64:"Google\nLycos\nAsk Jeeves\nAltavista\nAlltheWeb\nInktomi\nTurnitin.com";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 `datastoreVALUES ('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 `datastoreVALUES ('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 `datastoreVALUES ('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.com\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 `datastoreVALUES ('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 `datastoreVALUES ('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 `datastoreVALUES ('bbcodecache''a:0:{}');
INSERT INTO `datastoreVALUES ('userstats''a:3:{s:13:"numbermembers";s:1:"1";s:11:"newusername";s:4:"test";s:9:"newuserid";s:1:"1";}');
INSERT INTO `datastoreVALUES ('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 `datastoreVALUES ('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 `datastoreVALUES ('cron''1053271600');
INSERT INTO `datastoreVALUES ('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 `datastoreVALUES ('eventcache''a:1:{s:4:"date";s:9:"9-12-2005";}');
INSERT INTO `datastoreVALUES ('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.

Thug 09-11-2005 01:18 PM

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.


All times are GMT. The time now is 07:30 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01306 seconds
  • Memory Usage 1,877KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (9)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete