Webmastersite.net
Register Log In

Search fulltext

Title Search fulltext
Description db errrors
Message Text Hi Paul, We are trying to default to fulltext search from the admin under "Search" we select fulltext. Then when trying to search from index page we get db errors. -------------- Query: SELECT `id` FROM dir_categories WHERE validated=1 AND hide=0 AND isalbum=0 ORDER BY id DESC LIMIT 0,1 Number of rows is 1 for Resource id #25 Load time so far: 2.44 seconds. Query: UPDATE dir_settings SET content='5' WHERE name='highestcatindex' Query: SELECT `name`,`value` FROM dir_switches WHERE id>0 Number of rows is 69 for Resource id #26 Query: SHOW COLUMNS FROM dir_links Getting field list for table dir_links: id,title,url,description,rating,votes,validated,catid,sumofv otes,email,time,hits,numcomments,hide,ownerid,voterips,voter ids,lastedit,type,notify,suspect,pendingedit,funds,suspended ,alias,expire,ip,inalbum,typeorder,recipurl,hitsin,recipwith ,hitsinips,hitsoutips,lastcomment,related,inhidden,viewers,t hreadviewers,hitsintemp,hitsouttemp,origtype,importance,pare ntids,timesdead,timesemailed,threadclosed,threadposters,last posterid,lastpostername,ownername,deleted,deletionreason,mov edto,deletedby,timevalidated,filefield,message,sticky,downlo ads,pollid,posticon,savedby,validatedemail,unpaid,recipverif ied,effectivetime,sugcatid,pagerank,wysihtml Query: SHOW COLUMNS FROM dir_categories Getting field list for table dir_categories: id,name,parent,validated,description,time,parentnames,parent ids,numlinks,hide,lastlinktime,custom,lastedit,moderators,he aderinfo,related,numsub,type,permissions,subscribers,subscri ber,mixtypes,isalbum,orderlinks,totalcomments,ulsearchmax,ul searchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sp onsorlinks,views,customwrap,deleted,reqlinks,reqcoms,reqlink sdelay,priority,levelsdeep,lastposterid,lastpostername,lastc ommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidate dlinks,unvalidatedcomments,actaslink,countposts,subcatshtml, linksperpage,wysihtml Query: SHOW COLUMNS FROM dir_members Getting field list for table dir_members: id,name,links,comments,time,usergroup,password,ip,totalhits, totalhitsin,email,validated,template,language,lastattempt,al lowemail,signature,avatarname,stylesheet,allowuseremail,albu mid,failedattempts,totalbytes,funds,notifyoflinks,lastvisit, timezone,rating,pmfolders,notifyofpms,acceptpms,cookiedurati on,banned,location,homepage,occupation,bio,aim,icq,msn,yahoo ,inactive,timeonline,totalpms,buddies,ignored,isonline,accep tims,adminpermissions,referrer,groupreverttime,grouprevertto ,moderationpm,secondarygroups,linksperpage,commentsperpage,s houts,customtitle,shoutban,topicbans,forumbans,visibility,bi rthdate,lastsession,interests,posteditor,forumaccess,pmpopup ,pmnotify,modnotes,guestnotes,salt,lastmodnote,newpms,imflag ,orderalbums,lastguestnote,autosubscribe,notifymethod,showav atars,showsigs,warninglevel,topics,posts,chatcolor,traderrat ing,invitessent,validatedemail,newemail,calsub,macros Query: SHOW COLUMNS FROM dir_membergroups Getting field list for table dir_membergroups: id,title,caneditown,caneditall,canvote,isadmin,canpost,canem ail,validatecats,validatecomments,validatelinks,validateedit s,cansubmitlinks,cansubmitcategories,cansubmitcomments,caned itownlinks,caneditowncategories,caneditowncomments,caneditow nprofile,caneditalllinks,caneditallcategories,caneditallcomm ents,caneditallprofiles,candownloadfiles,canupload,canviewip ,limitlinks,canemailmembers,canusehtml,limitlinksdaily,canal ias,cancopy,candeleteown,candeleteall,candofulledit,candelet ecategories,candeletecomments,candeleteowncategories,candele teowncomments,candeletemembers,candeleteownmembers,canaliasc ategories,canviewpages,caneditvotes,numaliases,canviewvotes, canhideownlinks,canhideowncategories,canhideowncomments,canh idealllinks,canhideallcategories,canhideallcomments,canratec omments,bytespermem,canpm,canim,canharddelete,limitpms,limit pmsdaily,canviewdeleted,cansubmitpolls,candeletepolls,candel eteownpolls,caneditpolls,caneditownpolls,attachperpost,attac hperpm,canviewshouts,caneditshouts,caneditownshouts,candelet eshouts,candeleteownshouts,cansubmitshouts,canpollvote,custo mtitle,canviewinvisible,namestyle,canpmimportant,canviewmodl og,isleader,cansubmitquotes,validatequotes,candeletequotes,c andeleteownquotes,canreport,canusesearch,attachperlink,valid ateattachments,caneditownquotes,caneditallquotes,canviewchat ,caneditownevents,caneditallevents,candeleteownevents,candel eteevents,cansubmitevents,validateevents,bulkpms,issupermod, numinv,allowugspec,validateemails,validatesponsorlinks Query: SHOW COLUMNS FROM dir_email Getting field list for table dir_email: id,to,subject,message,headers,timesent,ip,replacement,mime Query: SHOW COLUMNS FROM dir_sessions Getting field list for table dir_sessions: id,memberid,location,time,ip,browser,starttime,catid,threadi d,areaname,lastsearch,nopermission,inchat,name,isrobot,lastc hat,groupnamestyle,acceptims,visibility Query: SHOW COLUMNS FROM dir_ratings Getting field list for table dir_ratings: id,votevalue,time,memberid,ip,custom,linkid Query: SHOW COLUMNS FROM dir_markup Getting field list for table dir_markup: id,type,original,replacement,description,originalclose,repla cementclose,sortorder Query: SHOW COLUMNS FROM dir_modlog Getting field list for table dir_modlog: id,topicid,postid,type,nature,reason,moderatorid,source,dest ination,time,catid,memberid Query: SHOW COLUMNS FROM dir_crons Getting field list for table dir_crons: id,frequency,nextrun,filename,native Query: SHOW COLUMNS FROM dir_calendar Getting field list for table dir_calendar: id,ownerid,title,description,joined,starttime,endtime,date,r eminded,validated,time Query: SHOW COLUMNS FROM dir_im Getting field list for table dir_im: id,toid,fromid,message,time,isread,timeread,deleted Query: SHOW COLUMNS FROM dir_searches Getting field list for table dir_searches: id,value,memberid,catid,time Query: SHOW COLUMNS FROM dir_comments Getting field list for table dir_comments: id,linkid,postername,message,time,linkname,validated,ip,owne rid,lastedit,type,approved,votes,hide,typeorder,lasteditby,c atid,editreason,preventedit,inhidden,deleted,deletionreason, usernoteon,modnote,filefield,title,deletedby,parentids,disab lesmilies,disablesig,icon,disablewsn,disablehtml,originalmes sage,flagged,wysihtml Query: SHOW COLUMNS FROM dir_pm Getting field list for table dir_pm: id,toid,fromid,timeread,message,subject,time,icon,folderid,d eleted,flag,filefield,important,replyto,replied,sentdeleted, wysihtml Query: SELECT `id`,`type`,`original`,`replacement`,`description`,`original close`,`replacementclose`,`sortorder` FROM dir_markup WHERE type='wsncode' ORDER BY sortorder Number of rows is 22 for Resource id #44 Query: SELECT `original`,`replacement`,`description`,`id`,`sortorder` FROM dir_markup WHERE type='smilie' ORDER BY sortorder Number of rows is 14 for Resource id #45 Query: SHOW COLUMNS FROM dir_attachments Getting field list for table dir_attachments: id,type,objectid,filename,filetitle,filesize,width,height,me mberid,time,deleted,field,downloads,validated,ownerip Query: SELECT `id`,`title`,`caneditown`,`caneditall`,`canvote`,`isadmin`,` canpost`,`canemail`,`validatecats`,`validatecomments`,`valid atelinks`,`validateedits`,`cansubmitlinks`,`cansubmitcategor ies`,`cansubmitcomments`,`caneditownlinks`,`caneditowncatego ries`,`caneditowncomments`,`caneditownprofile`,`caneditallli nks`,`caneditallcategories`,`caneditallcomments`,`caneditall profiles`,`candownloadfiles`,`canupload`,`canviewip`,`limitl inks`,`canemailmembers`,`canusehtml`,`limitlinksdaily`,`cana lias`,`cancopy`,`candeleteown`,`candeleteall`,`candofulledit `,`candeletecategories`,`candeletecomments`,`candeleteowncat egories`,`candeleteowncomments`,`candeletemembers`,`candelet eownmembers`,`canaliascategories`,`canviewpages`,`caneditvot es`,`numaliases`,`canviewvotes`,`canhideownlinks`,`canhideow ncategories`,`canhideowncomments`,`canhidealllinks`,`canhide allcategories`,`canhideallcomments`,`canratecomments`,`bytes permem`,`canpm`,`canim`,`canharddelete`,`limitpms`,`limitpms daily`,`canviewdeleted`,`cansubmitpolls`,`candeletepolls`,`c andeleteownpolls`,`caneditpolls`,`caneditownpolls`,`attachpe rpost`,`attachperpm`,`canviewshouts`,`caneditshouts`,`canedi townshouts`,`candeleteshouts`,`candeleteownshouts`,`cansubmi tshouts`,`canpollvote`,`customtitle`,`canviewinvisible`,`nam estyle`,`canpmimportant`,`canviewmodlog`,`isleader`,`cansubm itquotes`,`validatequotes`,`candeletequotes`,`candeleteownqu otes`,`canreport`,`canusesearch`,`attachperlink`,`validateat tachments`,`caneditownquotes`,`caneditallquotes`,`canviewcha t`,`caneditownevents`,`caneditallevents`,`candeleteownevents `,`candeleteevents`,`cansubmitevents`,`validateevents`,`bulk pms`,`issupermod`,`numinv`,`allowugspec`,`validateemails`,`v alidatesponsorlinks` FROM dir_membergroups WHERE id>0 Query: SELECT `id`,`name`,`links`,`comments`,`time`,`usergroup`,`password` ,`ip`,`totalhits`,`totalhitsin`,`email`,`validated`,`templat e`,`language`,`lastattempt`,`allowemail`,`signature`,`avatar name`,`stylesheet`,`allowuseremail`,`albumid`,`failedattempt s`,`totalbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezon e`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookiedur ation`,`banned`,`location`,`homepage`,`occupation`,`bio`,`ai m`,`icq`,`msn`,`yahoo`,`inactive`,`timeonline`,`totalpms`,`b uddies`,`ignored`,`isonline`,`acceptims`,`adminpermissions`, `referrer`,`groupreverttime`,`grouprevertto`,`moderationpm`, `secondarygroups`,`linksperpage`,`commentsperpage`,`shouts`, `customtitle`,`shoutban`,`topicbans`,`forumbans`,`visibility `,`birthdate`,`lastsession`,`interests`,`posteditor`,`foruma ccess`,`pmpopup`,`pmnotify`,`modnotes`,`guestnotes`,`salt`,` lastmodnote`,`newpms`,`imflag`,`orderalbums`,`lastguestnote` ,`autosubscribe`,`notifymethod`,`showavatars`,`showsigs`,`wa rninglevel`,`topics`,`posts`,`chatcolor`,`traderrating`,`inv itessent`,`validatedemail`,`newemail`,`calsub`,`macros` FROM dir_members WHERE id=2 AND validated=1 Query: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`paren tnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom `,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`t ype`,`permissions`,`subscribers`,`subscriber`,`mixtypes`,`is album`,`orderlinks`,`totalcomments`,`ulsearchmax`,`ulsearchq uery`,`ulsearchadult`,`alias`,`catcols`,`linkcols`,`dmozpath `,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,` reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposter id`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastt hreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomme nts`,`actaslink`,`countposts`,`subcatshtml`,`linksperpage`,` wysihtml` FROM dir_categories WHERE validated=1 AND deleted=0 AND hide=0 Number of rows is 3 for Resource id #54 Query: LOCK TABLES dir_email WRITE, dir_links WRITE, dir_categories WRITE, dir_members WRITE Query: SELECT `id`,`to`,`subject`,`message`,`headers`,`replacement`,`mime` FROM dir_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10 Number of rows is 0 for Resource id #55 Query: UNLOCK TABLES Query: INSERT INTO dir_searches(`value`,`memberid`,`catid`,`time`) VALUES('Blade','2','','116408070 4') Query: SELECT `lastsearch` FROM dir_sessions WHERE ip='68.174.139.173' Number of rows is 1 for Resource id #61 Load time so far: 1.9 seconds. Query: UPDATE dir_sessions SET lastsearch='1164080704' WHERE ip='68.174.139.173' Query: SELECT `id`,`title`,`url`,`description`,`rating`,`votes`,`validated `,`catid`,`sumofvotes`,`email`,`time`,`hits`,`numcomments`,` hide`,`ownerid`,`voterips`,`voterids`,`lastedit`,`type`,`not ify`,`suspect`,`pendingedit`,`funds`,`suspended`,`alias`,`ex pire`,`ip`,`inalbum`,`typeorder`,`recipurl`,`hitsin`,`recipw ith`,`hitsinips`,`hitsoutips`,`lastcomment`,`related`,`inhid den`,`viewers`,`threadviewers`,`hitsintemp`,`hitsouttemp`,`o rigtype`,`importance`,`parentids`,`timesdead`,`timesemailed` ,`threadclosed`,`threadposters`,`lastposterid`,`lastposterna me`,`ownername`,`deleted`,`deletionreason`,`movedto`,`delete dby`,`timevalidated`,`filefield`,`message`,`sticky`,`downloa ds`,`pollid`,`posticon`,`savedby`,`validatedemail`,`unpaid`, `recipverified`,`effectivetime`,`sugcatid`,`pagerank`,`wysih tml` FROM dir_links WHERE (validated=1 AND hide=0 AND inhidden=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((effectivetime < 1164080704) AND ()) ORDER BY rating DESC LIMIT 0,42 Load time so far: 1.91 seconds. 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 ')) ORDER BY rating DESC LIMIT 0,42' at line 1 Query: SELECT COUNT(id) FROM dir_links WHERE (validated=1 AND hide=0 AND inhidden=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((effectivetime < 1164080704) AND ()) Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/admin0/public_html/4/databases/mysql.php on line 22 Count is Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/admin0/public_html/4/databases/mysql.php on line 19 Number of rows is for 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 1 Warning: Cannot modify header information - headers already sent by (output started at /home/admin0/public_html/4/databases/mysql.php:15) in /home/admin0/public_html/4/end.php on line 145 Load time so far: 1.92 seconds. 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 1 Query: SELECT COUNT(id) FROM dir_categories WHERE isalbum=0 AND deleted=0 AND moderators LIKE '%, 2[,]%' Count is 0 Links Directory Options | Private Messages | Members | Calendar | Search | New Links | Logout You have 0 new PMs, 0 total. There are no matches for your search. Try searching for a more general term. Continue Contact the Administration Admin Control Panel | Moderator Control Panel Site Map 34 total queries This page was created in 1.96 seconds Server Status: time since last reboot is 11 days, 19:37, 2 users, load average: 0.03, 0.04, 0.07 Query: SELECT `memberid`,`starttime`,`time` FROM dir_sessions WHERE time < 1164079804 AND memberid > 0 Number of rows is 0 for Resource id #72 Load time so far: 1.97 seconds. Query: DELETE FROM dir_sessions WHERE time < 1164079804 Query: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime` ,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,` inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`accept ims`,`visibility` FROM dir_sessions WHERE memberid=2 Number of rows is 1 for Resource id #73 Load time so far: 1.97 seconds. Query: UPDATE dir_sessions SET id='78' WHERE id=78 Load time so far: 1.97 seconds. Query: UPDATE dir_sessions SET memberid='2' WHERE id=78 Load time so far: 1.97 seconds. Query: UPDATE dir_sessions SET location='http://www.0webmasters.com/4/search.php?&condition=fulltext' WHERE id=78 Load time so far: 1.97 seconds. Query: UPDATE dir_sessions SET time='1164080704' WHERE id=78 Load time so far: 1.97 seconds. Query: UPDATE dir_sessions SET ip='68.174.139.173' WHERE id=78 Load time so far: 1.97 seconds. Query: UPDATE dir_sessions SET browser='Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.8) Gecko/20061025 Firefox/1.5.0.8' WHERE id=78 Load time so far: 1.97 seconds. Query: UPDATE dir_sessions SET starttime='1164079628' WHERE id=78 Load time so far: 1.97 seconds. Query: UPDATE dir_sessions SET catid='' WHERE id=78 Load time so far: 1.97 seconds. Query: UPDATE dir_sessions SET threadid='' WHERE id=78 Load time so far: 1.97 seconds. Query: UPDATE dir_sessions SET areaname='Search' WHERE id=78 Load time so far: 1.97 seconds. Query: UPDATE dir_sessions SET lastsearch='1164080704' WHERE id=78 Load time so far: 1.97 seconds. Query: UPDATE dir_sessions SET nopermission='0' WHERE id=78 Load time so far: 1.97 seconds. Query: UPDATE dir_sessions SET inchat='0' WHERE id=78 Load time so far: 1.97 seconds. Query: UPDATE dir_sessions SET name='adminpy' WHERE id=78 Load time so far: 1.97 seconds. Query: UPDATE dir_sessions SET isrobot='0' WHERE id=78 Load time so far: 1.97 seconds. Query: UPDATE dir_sessions SET lastchat='0' WHERE id=78 Load time so far: 1.97 seconds. Query: UPDATE dir_sessions SET groupnamestyle='admincolor' WHERE id=78 Load time so far: 1.97 seconds. Query: UPDATE dir_sessions SET acceptims='all' WHERE id=78 Load time so far: 1.97 seconds. Query: UPDATE dir_sessions SET visibility='everyone' WHERE id=78 closing database connection ---------------------- Thanks, rw
Rating
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5
0/5 based on 0 votes.
Ownership rw
Views 487 views. Averaging 0 views per day.
Similar Topics
Submission Date Nov 20, 2006 - 8:09 PM