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