Webmastersite.net
Register Log In
  1. WSN Support Forums
  2. Search
  3. Search Results

305 matching results for "david":

Sort by
Topic Title Author Comment Text Created Forum
custom table search error david I upgraded to 5.0.12. The above search error is gone, but another search in my custom table not working. Could be toplist and NOT search related though.

This is the searchquery:

search.php?action=filter&filled=1&whichtype=links&condition=and&usewrapper=no&kiez=1&custom=yes&TID=listlinksonmembers&helysegcondition=%3D&helysegsearch=budapest


There is an extra information 'KIEZ' that is passed in the search query.

Here is the above custom TID:

<!-- BEGIN SEARCH links RESULTS -->
<!-- BEGIN REGULAR -->
	<tr <? if ({NUMBER} % 2) { ?>class="even"<? } else { ?>class="odd"<? } ?>>
		<td>
			<p><a href="index.php?action=displaycat&catid={LINKCATID}" target="_blank">{LINKCATNAME}</a></p>
		</td>
		<td>
			<p><a href="{TRACKLINKURL}&usewrapper=no&custom=yes&TID=listonelinkonmembers" target="memberlist_listonelink">{LINKHAZSZAM} {LINKCIM}</a></p>
		</td>
		<td>
			<p><!-- BEGIN TOPLIST -->
			<CONFIG>bemutatva,property,999,ascending,tomember={KIEZ} AND property={LINKID},,,0,0,0,0,0,0,,0</CONFIG>
			<img src="{IMAGESURL}/xxx/visitedinperson.gif" alt="" title="" />
			<!-- END TOPLIST --></p>
		</td>
	</tr>
<!-- END REGULAR -->
<!-- END SEARCH links RESULTS -->


Here is the debug info when submitting the search:

Query 6: SELECT `id`,`to`,`subject`,`message`,`headers`,`replacement`,`mime` FROM wsnlinks_email WHERE timesent=0 AND inprogress=0 ORDER BY id ASC LIMIT 0,10

Load time so far: 0.19 seconds.

Number of rows is 0

Creating search with new as new

Query 7: INSERT INTO wsnlinks_searches(`id`,`value`,`memberid`,`catid`,`time`) VALUES('','budapest','1','','1223558818')

Query 8: SELECT `id` FROM wsnlinks_searches ORDER BY id DESC

Load time so far: 0.2 seconds.

Setting cookie with name testcookie, value 83 and expiration time 3447117635

Query 9: SELECT `id`,`title`,`url`,`description`,`rating`,`votes`,`validated`,`catid`,`sumofvotes`,`email`,`time`,`hits`,`numcomments`,`hide`,`ownerid`,`voterips`,`voterids`,`lastedit`,`type`,`notify`,`suspect`,`pendingedit`,`funds`,`suspended`,`alias`,`expire`,`ip`,`inalbum`,`typeorder`,`recipurl`,`hitsin`,`recipwith`,`hitsinips`,`hitsoutips`,`lastcomment`,`related`,`inhidden`,`viewers`,`threadviewers`,`hitsintemp`,`hitsouttemp`,`origtype`,`importance`,`parentids`,`timesdead`,`timesemailed`,`threadclosed`,`threadposters`,`lastposterid`,`lastpostername`,`ownername`,`deleted`,`deletionreason`,`movedto`,`deletedby`,`timevalidated`,`filefield`,`message`,`sticky`,`downloads`,`pollid`,`posticon`,`savedby`,`validatedemail`,`unpaid`,`recipverified`,`effectivetime`,`sugcatid`,`pagerank`,`wysihtml`,`movedid`,`unrevised`,`feedurl`,`feedcache`,`feedcachetime`,`tags`,`xmlsource`,`ordercomments`,`lastpadupdate`,`padfile`,`lastmonthlycheck`,`invisibleto`,`profileurl`,`lastprofileurl`,`timesrenewed`,`timedeleted`,`helyseg`,`ar`,`varos`,`epitoanyag`,`alapterulet`,`kertmeret`,`szobaszam`,`felszobaszam`,`erkely`,`futes`,`kilatas`,`tajolas`,`komfort`,`lift`,`emeleten`,`parkolas`,`lakasallapot`,`extrak`,`butorozott`,`szintek`,`kiadoar`,`epitoanyagenglish`,`erkelyenglish`,`futesenglish`,`kilatasenglish`,`tajolasenglish`,`komfortenglish`,`liftenglish`,`parkolasenglish`,`lakasallapotenglish`,`extrakenglish`,`butorozottenglish`,`descriptionenglish`,`kerulet`,`megye`,`eladokiado`,`gepesitett`,`gepesitettenglish`,`cim`,`hazszam`,`adminnotes`,`telek`,`sponsorend`,`address`,`city`,`state`,`country`,`latitude`,`longitude`,`zip`,`kiadoareuro`,`phone`,`kiemelt`,`kertkapcsolat`,`kertkapcsolatenglish`,`helysegszam`,`summary` FROM wsnlinks_links WHERE (validated=1 AND invisibleto NOT LIKE '%|3|%' AND hide=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((effectivetime < 1223558818) AND (helyseg = 'budapest')) ORDER BY typeorder ASC,time DESC LIMIT 0,60

Load time so far: 0.21 seconds.

Load time so far: 0.21 seconds.

Query 10: SELECT COUNT(id) FROM wsnlinks_links WHERE (validated=1 AND invisibleto NOT LIKE '%|3|%' AND hide=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((effectivetime < 1223558818) AND (helyseg = 'budapest'))
Count is 3

Number of rows is 3

Creating link with Array as row

Query 11: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`alias`,`catcols`,`linkcols`,`dmozpath`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`linksperpage`,`wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaultnoaccess`,`lastthreadurl`,`lastposturl`,`nameenglish`,`specialurl`,`invisibleto` FROM wsnlinks_categories WHERE id=63

Load time so far: 0.23 seconds.

Query 12: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`alias`,`catcols`,`linkcols`,`dmozpath`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`linksperpage`,`wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaultnoaccess`,`lastthreadurl`,`lastposturl`,`nameenglish`,`specialurl`,`invisibleto` FROM wsnlinks_categories WHERE id=63

Load time so far: 0.23 seconds.

Creating link with Array as row

Query 13: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`alias`,`catcols`,`linkcols`,`dmozpath`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`linksperpage`,`wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaultnoaccess`,`lastthreadurl`,`lastposturl`,`nameenglish`,`specialurl`,`invisibleto` FROM wsnlinks_categories WHERE id=63

Load time so far: 0.24 seconds.

Query 14: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`alias`,`catcols`,`linkcols`,`dmozpath`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`linksperpage`,`wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaultnoaccess`,`lastthreadurl`,`lastposturl`,`nameenglish`,`specialurl`,`invisibleto` FROM wsnlinks_categories WHERE id=63

Load time so far: 0.24 seconds.

Creating link with Array as row

Query 15: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`alias`,`catcols`,`linkcols`,`dmozpath`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`linksperpage`,`wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaultnoaccess`,`lastthreadurl`,`lastposturl`,`nameenglish`,`specialurl`,`invisibleto` FROM wsnlinks_categories WHERE id=63

Load time so far: 0.24 seconds.

Query 16: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`alias`,`catcols`,`linkcols`,`dmozpath`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`linksperpage`,`wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaultnoaccess`,`lastthreadurl`,`lastposturl`,`nameenglish`,`specialurl`,`invisibleto` FROM wsnlinks_categories WHERE id=63

Load time so far: 0.24 seconds.

Query 17: SELECT `id`,`time`,`lastedit`,`ownerid`,`editedby`,`showdate`,`property`,`tomember` FROM wsnlinks_bemutatva WHERE 1=1 AND (tomember=1 AND property=217) ORDER BY property ASC LIMIT 0,999

Load time so far: 0.25 seconds.

Number of rows is 0

Query 18: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility`,`profileurl` FROM wsnlinks_sessions WHERE memberid=1

Load time so far: 0.28 seconds.

Number of rows is 1

Creating online with Array as row

Load time so far: 0.28 seconds.


The search itself is produced fine, the results are ok. It is the toplist that is generated for each result, that is now broken. In the above debug info, you will see that it has 3 search results, but it generates the toplist for only the last 2 of the results displayed. AND it doesn't just output the IMG that is between the TOPLIST tags, but displays the toplist config for the last 2 search results, next to the image:

bemutatva,property,999,ascending,tomember={KIEZ} AND property=215,,,0,0,0,0,0,0,,0


Thanks
David		 Oct 09, 2008 - 6:40 AM Paid Scripts Support
custom table search error david Yep, it is in the custom folder. Oct 09, 2008 - 4:48 AM Paid Scripts Support
custom table search error david Hi Paul,

Trying to perform a search on the custom table I added. I can add and edit fine, but searching produces an error.

My custom table is 'bemutatva'. I have added an entry to it, with the 'property' value of 213. The property field is an integer field.

When I try this:

search.php?action=filter&filled=1&whichtype=bemutatva&propertycondition=or&propertysearch=213&usewrapper=no


I get the following error:

Query 6: SELECT `id`,`to`,`subject`,`message`,`headers`,`replacement`,`mime` FROM wsnlinks_email WHERE timesent=0 AND inprogress=0 ORDER BY id ASC LIMIT 0,10

Load time so far: 0.07 seconds.

Number of rows is 0

Query 7: SELECT `id`,`time`,`lastedit`,`ownerid`,`editedby`,`showdate`,`property`,`tomember` FROM wsnlinks_bemutatva WHERE () AND (((property = 213))) ORDER BY LIMIT 0,60

Load time so far: 0.08 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 ') AND (((property = 213))) ORDER BY LIMIT 0,60' at line 1

Load time so far: 0.08 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 ') AND (((property = 213))) ORDER BY LIMIT 0,60' at line 1

Query 8: SELECT COUNT(id) FROM wsnlinks_bemutatva WHERE () AND (((property = 213)))

An error occoured at xxx.net/search.php?action=f...tysearch=213&usewrapper=no on 2008-10-08 14:12:21. Please relay this data to support. Error #2: 'mysql_fetch_row(): supplied argument is not a valid MySQL result resource' in /home/xxx/public_html/xxx/databases/mysql.php on line 50. Debug info:
Count is

An error occoured at xxx.net/search.php?action=f...tysearch=213&usewrapper=no on 2008-10-08 14:12:21. Please relay this data to support. Error #2: 'mysql_num_rows(): supplied argument is not a valid MySQL result resource' in /home/xxx/public_html/xxx/databases/mysql.php on line 47. Debug info:

Number of rows is 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 ') AND (((property = 213)))' at line 1

Query 9: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility`,`profileurl` FROM wsnlinks_sessions WHERE memberid=1

Load time so far: 0.09 seconds.

Number of rows is 1

Creating online with Array as row

Load time so far: 0.09 seconds.


Am I missing something, or this is a bug?

Thanks
David		 Oct 08, 2008 - 7:17 AM Paid Scripts Support
Unable to log out - error david same error came up when trying to switch languages. Oct 07, 2008 - 12:52 PM Paid Scripts Support
Unable to log out - error david Hi Paul,

I got the same thing.
I logged into the admin panel to update the 5.0.10, so I was logged in obviously.
Then I tried to log out and this is what I got:

Query 3: SELECT `name`,`value` FROM wsnlinks_switches

Load time so far: 0.05 seconds.

Query 4: SELECT `id`,`title`,`caneditown`,`caneditall`,`canvote`,`isadmin`,`canpost`,`canemail`,`validatecats`,`validatecomments`,`validatelinks`,`validateedits`,`cansubmitlinks`,`cansubmitcategories`,`cansubmitcomments`,`caneditownlinks`,`caneditowncategories`,`caneditowncomments`,`caneditownprofile`,`caneditalllinks`,`caneditallcategories`,`caneditallcomments`,`caneditallprofiles`,`candownloadfiles`,`canupload`,`canviewip`,`limitlinks`,`canemailmembers`,`canusehtml`,`limitlinksdaily`,`canalias`,`cancopy`,`candeleteown`,`candeleteall`,`candofulledit`,`candeletecategories`,`candeletecomments`,`candeleteowncategories`,`candeleteowncomments`,`candeletemembers`,`candeleteownmembers`,`canaliascategories`,`canviewpages`,`caneditvotes`,`numaliases`,`canviewvotes`,`canhideownlinks`,`canhideowncategories`,`canhideowncomments`,`canhidealllinks`,`canhideallcategories`,`canhideallcomments`,`canratecomments`,`bytespermem`,`canpm`,`canim`,`canharddelete`,`limitpms`,`limitpmsdaily`,`canviewdeleted`,`cansubmitpolls`,`candeletepolls`,`candeleteownpolls`,`caneditpolls`,`caneditownpolls`,`attachperpost`,`attachperpm`,`canviewshouts`,`caneditshouts`,`caneditownshouts`,`candeleteshouts`,`candeleteownshouts`,`cansubmitshouts`,`canpollvote`,`customtitle`,`canviewinvisible`,`namestyle`,`canpmimportant`,`canviewmodlog`,`isleader`,`cansubmitquotes`,`validatequotes`,`candeletequotes`,`candeleteownquotes`,`canreport`,`canusesearch`,`attachperlink`,`validateattachments`,`caneditownquotes`,`caneditallquotes`,`canviewchat`,`caneditownevents`,`caneditallevents`,`candeleteownevents`,`candeleteevents`,`cansubmitevents`,`validateevents`,`bulkpms`,`issupermod`,`numinv`,`allowugspec`,`validateemails`,`validatesponsorlinks`,`cansubmittags`,`candeletetags`,`cansubmitfeeds`,`validatefeeds`,`validatefeeditems`,`numaliasestot`,`shoutsperday`,`validatetrader`,`renewdays`,`renewtimes`,`canviewownfulltrc`,`canviewallfulltrc` FROM wsnlinks_membergroups

Load time so far: 0.05 seconds.

Query 5: SELECT `id`,`name`,`links`,`comments`,`time`,`usergroup`,`password`,`ip`,`totalhits`,`totalhitsin`,`email`,`validated`,`template`,`language`,`lastattempt`,`allowemail`,`signature`,`avatarname`,`stylesheet`,`allowuseremail`,`albumid`,`failedattempts`,`totalbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezone`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookieduration`,`banned`,`location`,`homepage`,`occupation`,`bio`,`aim`,`icq`,`msn`,`yahoo`,`inactive`,`timeonline`,`totalpms`,`buddies`,`ignored`,`isonline`,`acceptims`,`adminpermissions`,`referrer`,`groupreverttime`,`grouprevertto`,`moderationpm`,`secondarygroups`,`linksperpage`,`commentsperpage`,`shouts`,`customtitle`,`shoutban`,`topicbans`,`forumbans`,`visibility`,`birthdate`,`lastsession`,`interests`,`posteditor`,`forumaccess`,`pmpopup`,`pmnotify`,`modnotes`,`guestnotes`,`salt`,`lastmodnote`,`newpms`,`imflag`,`orderalbums`,`lastguestnote`,`autosubscribe`,`notifymethod`,`showavatars`,`showsigs`,`warninglevel`,`topics`,`posts`,`chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`calsub`,`macros`,`guestnotify`,`keychecktime`,`notifykeywords`,`autosubscribepost`,`blogrss`,`positivepct`,`notifytrader`,`minar`,`maxar`,`varos`,`epitoanyag`,`minalapterulet`,`maxalapterulet`,`minhelysegszam`,`maxhelysegszam`,`minfelszobaszam`,`maxfelszobaszam`,`erkely`,`futes`,`kilatas`,`tajolas`,`komfort`,`lift`,`minemeleten`,`maxemeleten`,`parkolas`,`lakasallapot`,`extrak`,`butorozott`,`telefon`,`minkiadoar`,`maxkiadoar`,`megye`,`kerulet`,`eladokategoria`,`gepesitett`,`mintelek`,`maxtelek`,`inactiveemail`,`minkiadoareuro`,`maxkiadoareuro`,`kiadokategoria`,`fullname`,`kertkapcsolat` FROM wsnlinks_members WHERE id = '1' AND validated = 1

Load time so far: 0.06 seconds.

Query 6: SELECT `id`,`to`,`subject`,`message`,`headers`,`replacement`,`mime` FROM wsnlinks_email WHERE timesent=0 AND inprogress=0 ORDER BY id ASC LIMIT 0,10

Load time so far: 0.07 seconds.

Number of rows is 0

Parse error: syntax error, unexpected '"', expecting T_STRING or T_VARIABLE or '$' in /home/xxx/public_html/xxx/includes/actions.php on line 81


I didn't get logged out.

Then I tried to log in with a member in another browser (IE6, cleared the cookies), and I got this:

Query 3: SELECT `name`,`value` FROM wsnlinks_switches 

Load time so far: 0.1 seconds.



Query 4: SELECT `id`,`title`,`caneditown`,`caneditall`,`canvote`,`isadmin`,`canpost`,`canemail`,`validatecats`,`validatecomments`,`validatelinks`,`validateedits`,`cansubmitlinks`,`cansubmitcategories`,`cansubmitcomments`,`caneditownlinks`,`caneditowncategories`,`caneditowncomments`,`caneditownprofile`,`caneditalllinks`,`caneditallcategories`,`caneditallcomments`,`caneditallprofiles`,`candownloadfiles`,`canupload`,`canviewip`,`limitlinks`,`canemailmembers`,`canusehtml`,`limitlinksdaily`,`canalias`,`cancopy`,`candeleteown`,`candeleteall`,`candofulledit`,`candeletecategories`,`candeletecomments`,`candeleteowncategories`,`candeleteowncomments`,`candeletemembers`,`candeleteownmembers`,`canaliascategories`,`canviewpages`,`caneditvotes`,`numaliases`,`canviewvotes`,`canhideownlinks`,`canhideowncategories`,`canhideowncomments`,`canhidealllinks`,`canhideallcategories`,`canhideallcomments`,`canratecomments`,`bytespermem`,`canpm`,`canim`,`canharddelete`,`limitpms`,`limitpmsdaily`,`canviewdeleted`,`cansubmitpolls`,`candeletepolls`,`candeleteownpolls`,`caneditpolls`,`caneditownpolls`,`attachperpost`,`attachperpm`,`canviewshouts`,`caneditshouts`,`caneditownshouts`,`candeleteshouts`,`candeleteownshouts`,`cansubmitshouts`,`canpollvote`,`customtitle`,`canviewinvisible`,`namestyle`,`canpmimportant`,`canviewmodlog`,`isleader`,`cansubmitquotes`,`validatequotes`,`candeletequotes`,`candeleteownquotes`,`canreport`,`canusesearch`,`attachperlink`,`validateattachments`,`caneditownquotes`,`caneditallquotes`,`canviewchat`,`caneditownevents`,`caneditallevents`,`candeleteownevents`,`candeleteevents`,`cansubmitevents`,`validateevents`,`bulkpms`,`issupermod`,`numinv`,`allowugspec`,`validateemails`,`validatesponsorlinks`,`cansubmittags`,`candeletetags`,`cansubmitfeeds`,`validatefeeds`,`validatefeeditems`,`numaliasestot`,`shoutsperday`,`validatetrader`,`renewdays`,`renewtimes`,`canviewownfulltrc`,`canviewallfulltrc` FROM wsnlinks_membergroups 

Load time so far: 0.11 seconds.



Query 5: SELECT `id`,`password` FROM wsnlinks_members WHERE name = 'xxx@gmail.com' OR email = 'xxx@gmail.com' 

Load time so far: 0.13 seconds.



Query 6: SELECT `id`,`name`,`links`,`comments`,`time`,`usergroup`,`password`,`ip`,`totalhits`,`totalhitsin`,`email`,`validated`,`template`,`language`,`lastattempt`,`allowemail`,`signature`,`avatarname`,`stylesheet`,`allowuseremail`,`albumid`,`failedattempts`,`totalbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezone`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookieduration`,`banned`,`location`,`homepage`,`occupation`,`bio`,`aim`,`icq`,`msn`,`yahoo`,`inactive`,`timeonline`,`totalpms`,`buddies`,`ignored`,`isonline`,`acceptims`,`adminpermissions`,`referrer`,`groupreverttime`,`grouprevertto`,`moderationpm`,`secondarygroups`,`linksperpage`,`commentsperpage`,`shouts`,`customtitle`,`shoutban`,`topicbans`,`forumbans`,`visibility`,`birthdate`,`lastsession`,`interests`,`posteditor`,`forumaccess`,`pmpopup`,`pmnotify`,`modnotes`,`guestnotes`,`salt`,`lastmodnote`,`newpms`,`imflag`,`orderalbums`,`lastguestnote`,`autosubscribe`,`notifymethod`,`showavatars`,`showsigs`,`warninglevel`,`topics`,`posts`,`chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`calsub`,`macros`,`guestnotify`,`keychecktime`,`notifykeywords`,`autosubscribepost`,`blogrss`,`positivepct`,`notifytrader`,`minar`,`maxar`,`varos`,`epitoanyag`,`minalapterulet`,`maxalapterulet`,`minhelysegszam`,`maxhelysegszam`,`minfelszobaszam`,`maxfelszobaszam`,`erkely`,`futes`,`kilatas`,`tajolas`,`komfort`,`lift`,`minemeleten`,`maxemeleten`,`parkolas`,`lakasallapot`,`extrak`,`butorozott`,`telefon`,`minkiadoar`,`maxkiadoar`,`megye`,`kerulet`,`eladokategoria`,`gepesitett`,`mintelek`,`maxtelek`,`inactiveemail`,`minkiadoareuro`,`maxkiadoareuro`,`kiadokategoria`,`fullname`,`kertkapcsolat` FROM wsnlinks_members WHERE id='32' 

Load time so far: 0.13 seconds.



Number of rows is 1 

Query 7: SELECT `password`,`lastattempt`,`failedattempts` FROM wsnlinks_members WHERE name = 'xxx@gmail.com' OR email = 'xxx@gmail.com' 

Load time so far: 0.13 seconds.



username is xxx@gmail.com for user id number 32
Load time so far: 0.13 seconds.



Query 8: UPDATE wsnlinks_members SET lastattempt='1223405741' WHERE name='xxx@gmail.com'

Setting cookie with name wsnuser, value 32 and expiration time 1254941741

Setting cookie with name wsnpass, value 9dd4e461268c8034f5c856224e155c67a6 and expiration time 1254941741

Query 9: SELECT `id`,`name`,`links`,`comments`,`time`,`usergroup`,`password`,`ip`,`totalhits`,`totalhitsin`,`email`,`validated`,`template`,`language`,`lastattempt`,`allowemail`,`signature`,`avatarname`,`stylesheet`,`allowuseremail`,`albumid`,`failedattempts`,`totalbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezone`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookieduration`,`banned`,`location`,`homepage`,`occupation`,`bio`,`aim`,`icq`,`msn`,`yahoo`,`inactive`,`timeonline`,`totalpms`,`buddies`,`ignored`,`isonline`,`acceptims`,`adminpermissions`,`referrer`,`groupreverttime`,`grouprevertto`,`moderationpm`,`secondarygroups`,`linksperpage`,`commentsperpage`,`shouts`,`customtitle`,`shoutban`,`topicbans`,`forumbans`,`visibility`,`birthdate`,`lastsession`,`interests`,`posteditor`,`forumaccess`,`pmpopup`,`pmnotify`,`modnotes`,`guestnotes`,`salt`,`lastmodnote`,`newpms`,`imflag`,`orderalbums`,`lastguestnote`,`autosubscribe`,`notifymethod`,`showavatars`,`showsigs`,`warninglevel`,`topics`,`posts`,`chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`calsub`,`macros`,`guestnotify`,`keychecktime`,`notifykeywords`,`autosubscribepost`,`blogrss`,`positivepct`,`notifytrader`,`minar`,`maxar`,`varos`,`epitoanyag`,`minalapterulet`,`maxalapterulet`,`minhelysegszam`,`maxhelysegszam`,`minfelszobaszam`,`maxfelszobaszam`,`erkely`,`futes`,`kilatas`,`tajolas`,`komfort`,`lift`,`minemeleten`,`maxemeleten`,`parkolas`,`lakasallapot`,`extrak`,`butorozott`,`telefon`,`minkiadoar`,`maxkiadoar`,`megye`,`kerulet`,`eladokategoria`,`gepesitett`,`mintelek`,`maxtelek`,`inactiveemail`,`minkiadoareuro`,`maxkiadoareuro`,`kiadokategoria`,`fullname`,`kertkapcsolat` FROM wsnlinks_members WHERE id = '32' AND validated = 1 

Load time so far: 0.14 seconds.



Query 10: SELECT `id`,`to`,`subject`,`message`,`headers`,`replacement`,`mime` FROM wsnlinks_email WHERE timesent=0 AND inprogress=0 ORDER BY id ASC LIMIT 0,10

Load time so far: 0.16 seconds.



Number of rows is 0 


Parse error: syntax error, unexpected '"', expecting T_STRING or T_VARIABLE or '$' in /home/xxx/public_html/xxx/includes/actions.php on line 81


But I did get logged in. Tried logging out and got the same logout error that I got with the admin.		 Oct 07, 2008 - 12:06 PM Paid Scripts Support
account verification code error david The login problem is there though. when a person registers and visits the activation url, they don't get logged in automatically. Oct 07, 2008 - 11:47 AM Paid Scripts Support
account verification code error david cool. so each new email gets a different registration code. smiling face

 Oct 07, 2008 - 11:43 AM Paid Scripts Support
debug mode david 2 things:

1. this is the manual for the Debug section:
"Suppress all errors for non-admins - This is the ultimate anti-debug. It prevents all errors, even fatal errors, from being displayed... the page will simply be rendered as far as is possible without php complaining about not being able to do some of the things it was told to do. When logged in as admin you'll still see errors as normal, but this will prevent you from noticing any errors that only show up as a guest."

That doesn't say anything about sending the admin an email about the errors, or showing them somewhere, other than at the exact page you are on as an admin and see the error.

2. what are Strict modes in the debug level?

Thanks
David		 Oct 07, 2008 - 12:43 AM Paid Scripts Support
debug mode david Hmmm... so 'suppression' does that? Cool.

You know why I didn't know this? It's because there is no single, comprehensive place on your site to read up on all the things released in updates. The single line entries in the updates, listing what was included, are good if one of those issues was mine on the forum and I know what it relates to. Otherwise, sometimes it's hard to know what some new things/features are and what they do, and how to use them. smiling face

Thanks
 Oct 07, 2008 - 12:34 AM Paid Scripts Support
cannot alias links david No worries Paul. I saw that you will be releasing a fix for all of these things anyways. smiling face

Thanks		 Oct 06, 2008 - 5:17 AM Paid Scripts Support
custom table actions error david Thanks Paul. smiling face Oct 06, 2008 - 1:58 AM Paid Scripts Support
custom table actions error david Hi Paul,

Added a new custom database table, as per the Tried the Adding Database Table article.

When I try to call any of the actions (add, edit, view), it doesn't seem to call up the custom templates I created for them (called them bemutatva_add.tpl, etc. as per the article instructions).

When calling 'generics.php?action=add&classname=bemutatva' for example, I see this in the top of the debug info:

Load time so far: 0.1 seconds.

Number of rows is 0

Creating bemutatva with blank as blank

Load time so far: 0.11 seconds.

Query 7: SELECT COUNT(id) FROM wsnlinks_sessions WHERE memberid>0
Count is 1


here is my bemutatva.php file (in the includes folder):

<?php

class bemutatva extends generic
{
 
 function __construct($type, $input)
 { // constructor
  global $language; 
  $this->objecttype = 'bemutatva'; 
  $this->objecttable = 'bemutatvatable';
  $this->objectdateformat = $language->dateformat_comments;
  parent::__construct($type, $input);
 }
   
function canview() { return true; } 

}

?>


I have added the general_bemutatva language field with 'bemutatva' as the value.

What could be the problem? If I call the bemutatva_add.tpl as a custom template, like index.pxp?custom=yes&TID=bemutatva_add, then I get to see my form and I can add a new entry just fine...

Thanks
David		 Oct 04, 2008 - 3:45 AM Paid Scripts Support
debug mode david Hi Paul,

When I found the errors in www.webmastersite.net/forum...id=8442&page=last#lastpost, some of the errors came up only because I set the debug info to be shown to the admin, and then while the redirect pages were showing these errors I had to quickly select all the text on the page and copy paste it into a text document, just so I can go through it. I know that I could have set the redirect time to a longer period, but to keep changing that just for these debug seconds, is a hassle.

Also, I have a big site with a ton of queries. so even if I copy the debug info into a text file, it is not possible to find an error. I have to do a text search for the word 'error'. smiling face that's how I found one of the errors in the place where I didn't think I'd have one (the site showed no problems, but the error was present).

So my feature request is: a debug mode that ignores redirects and ALWAYS shows the debug info and IF it finds the word 'error' in the output, it stores that complete DEBUG info somewhere in the admin panel. Or just plain and simple ignore everything and just show the debug info and highlight the word 'error' on it.

Or better yet, it's a mode that if turned on, runs in the background and doesn't show the debug info onscreen, but runs it and stores the debug info IF it finds an error, then notifies you in the admin panel.

Thanks
David		 Oct 03, 2008 - 8:36 AM Paid Scripts Support
account verification code error david smiling face I meant that each member gets the same verification code. I will try to register my test member with a different email and see. smiling face Oct 03, 2008 - 5:49 AM Paid Scripts Support
account verification code error david
Paul wrote:
I presume you're saying every member gets the same verification code. If you just mean that the same member gets the same code on each re-request, then of course that's true.


Yes, that's what I mean. What is true? I don't get it. You mean it's true that the cache could be on even though it is showing off?		 Oct 01, 2008 - 6:53 AM Paid Scripts Support
Narrow results to results containing

Link to these search results