Webmastersite.net
Register Log In

Empty delimiter / Personal link list
dificulties

Comments on Empty delimiter / Personal link list

peumus
Forum Regular

Usergroup: Customer
Joined: Aug 09, 2004
Location: Chile

Total Topics: 172
Total Comments: 462
peumus
Posted Aug 23, 2005 - 11:19 AM:

Hello Paul,

I have some difficulties with 3.16 ver:

a)

At admin panner - > Comom Tasks - > Main
The following error appears on top:

Warning: strstr(): Empty delimiter. in /.../links/templatefunctions.php on line 1130

I was having this error report at ver. 3.14 too.

b)

The personal link lists are not working well.
- For any user:
the following error arises:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /.../linksb/classes/database.php on line 82

also:

This is what the problematic area of the template looks like during parsing:
Line #34: <center><span class="title">Welcome to WSN Links 3.16</span><br>This text is in your wrapper template. Visit your <a href="admin/index.php?context=templates.php">admin panel</a> to edit it.</center>
Line #35: <br>
Line #36: <div class="main">
Line #37:
Line #38: <?php if (95 == ) { ?>
Line #39: <center><div class="suggest"><a href="suggest.php?action=addlink&catid=&isalbum=1">Add Link</a></div></center>

- For admin, the sitemap is not correct, showing the title of one category instead of links collection.

I have uploaded again the entire fields on a links2 folder and runned upgrade, and the same problem arises.

Could you please advise me on the steps to follow in order check were the problem is.

Thanks.
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Aug 23, 2005 - 7:57 PM:

You haven't posted the debug output as the pinned thread instructs for your mysql warning.

I can of course only state that these are not anything which can be reproduced on a normal install, as you can see for yourself by doing a new install.

Since this is apparently about your unspecified customizations rather than a bug report, moved.
peumus
Forum Regular

Usergroup: Customer
Joined: Aug 09, 2004
Location: Chile

Total Topics: 172
Total Comments: 462
peumus
Posted Aug 24, 2005 - 6:10 AM:

My apologies for not reading the instructions for mysql warning before posting.

The debug output for a user request to see it's links list is
(I have deleted the warnings "Cannot modify header information - headers already sent by" as advised on the manual) :

Load time so far: 0.06 seconds.
Performing query: SELECT name,content FROM wsnlinks_settings WHERE id>0 ORDER BY id ASC ;

Number of rows is 251 for Resource id #19

Load time so far: 0.06 seconds.
Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 ORDER BY id DESC LIMIT 0,1;

Load time so far: 0.07 seconds.
Performing query: SELECT name,value FROM wsnlinks_switches WHERE id>0 ;

Number of rows is 23 for Resource id #31

Load time so far: 0.07 seconds.
Performing query: SELECT original,replacement,description,id,sortorder FROM wsnlinks_markup WHERE type='smilie' ORDER BY sortorder ;

Number of rows is 14 for Resource id #32

Load time so far: 0.07 seconds.
Performing query: SELECT COUNT(*) FROM wsnlinks_categories WHERE validated=1 AND hide=0 AND isalbum=0 ;

Load time so far: 0.07 seconds.
Performing query: UPDATE wsnlinks_settings SET content='59' WHERE name='totalsubcats';

Load time so far: 0.07 seconds.
Performing query: 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 FROM wsnlinks_membergroups WHERE id>0 ;

Load time so far: 0.07 seconds.
Performing query: 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,articles,nombre_usuario,empresa,telefono,fax,direccion_empresa,pais,kbalbumid FROM wsnlinks_members WHERE id=15 AND validated=1 ;

Load time so far: 0.08 seconds.
Performing query: SELECT id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,permissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sponsorlinks,testattach,views,orden_dan,customwrap FROM wsnlinks_categories WHERE validated=1 AND hide=0 ;

Number of rows is 59 for Resource id #38

Load time so far: 0.1 seconds.
Performing query: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE;

Load time so far: 0.1 seconds.
Performing query: SELECT id,`to`,subject,message,headers,replacement,mime FROM wsnlinks_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10;

Number of rows is 0 for Resource id #39

Load time so far: 0.1 seconds.
Performing query: UNLOCK TABLES;

Load time so far: 0.1 seconds.
Performing query: SELECT id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,permissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sponsorlinks,testattach,views,orden_dan,customwrap FROM wsnlinks_categories WHERE id=95 ;

Load time so far: 0.1 seconds.
Performing query: SELECT id FROM wsnlinks_categories WHERE parent= AND validated=1 AND isalbum=1 ;

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /.../links/classes/database.php on line 82

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 'AND validated=1 AND isalbum=1' at line 1

Load time so far: 0.1 seconds.
Performing query: SELECT id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,permissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sponsorlinks,testattach,views,orden_dan,customwrap FROM wsnlinks_categories WHERE parent= AND validated=1 AND isalbum=1 ORDER BY orden_dan ASC ;

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 validated=1 AND isalbum=1' at line 1

Load time so far: 0.1 seconds.
Performing query: SELECT id FROM wsnlinks_links WHERE catid= AND hide=0 AND validated=1 ;

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 validated=1 AND isalbum=1 ORDER BY orden_dan ASC' at line 1

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /.../links/classes/database.php on line 82

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 'AND hide=0 AND validated=1' at line 1

Load time so far: 0.1 seconds.
Performing query: SELECT id FROM wsnlinks_links WHERE catid= AND validated=1 AND hide=0 AND type='regular' ;

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 hide=0 AND validated=1' at line 1

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /.../links/classes/database.php on line 82

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 'AND validated=1 AND hide=0 AND type='regular'' at line 1

Load time so far: 0.1 seconds.
Performing query: SELECT id FROM wsnlinks_links WHERE catid= AND validated=1 AND hide=0 AND type='recip' ;

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 validated=1 AND hide=0 AND type='regular'' at line 1

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /.../links/classes/database.php on line 82

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 'AND validated=1 AND hide=0 AND type='recip'' at line 1

Load time so far: 0.1 seconds.
Performing query: SELECT id FROM wsnlinks_links WHERE catid= AND validated=1 AND hide=0 AND type='anunciante1' ;

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 validated=1 AND hide=0 AND type='recip'' at line 1

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /.../links/classes/database.php on line 82

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 'AND validated=1 AND hide=0 AND type='anunciante1'' at line 1

Load time so far: 0.1 seconds.
Performing query: SELECT id FROM wsnlinks_links WHERE catid= AND hide=0 AND validated=1 ;

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 validated=1 AND hide=0 AND type='anunciante1'' at line 1

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /.../links/classes/database.php on line 82

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 'AND hide=0 AND validated=1' at line 1

Load time so far: 0.1 seconds.
Performing query: SELECT id FROM wsnlinks_sessions WHERE memberid>0 ;

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 hide=0 AND validated=1' at line 1

Number of rows is 1 for Resource id #43

Load time so far: 0.1 seconds.
Performing query: SELECT id FROM wsnlinks_sessions WHERE memberid=0 ;

Number of rows is 5 for Resource id #44

Load time so far: 0.19 seconds.
Performing query: SELECT id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,permissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sponsorlinks,testattach,views,orden_dan,customwrap FROM wsnlinks_categories WHERE id=95 ;

If you are not the administrator of this site, please report this page to the administrator. If you are the administrator, please pay careful attention: You have a parse error in your template templates/default/albums.tpl (or perhaps in your header or footer) which you need to repair before this page can be displayed correctly. The error is picked up on by php at line 120 of the output.
This is what the problematic area of the template looks like during parsing:
Line #115: </span>
Line #116: </center>
Line #117: <div class="main">
Line #118:
Line #119: <?php if (95 == ) { ?>
Line #120: <center>

Await for your comments.
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Aug 24, 2005 - 8:12 PM:

Performing query: SELECT id FROM wsnlinks_categories WHERE parent= AND validated=1 AND isalbum=1 ;

Looks like it just doesn't have any idea what the category name is when it's checking for subcategories, which implies the album id field isn't set properly.

Are you sure this isn't just the install you were integrating?
peumus
Forum Regular

Usergroup: Customer
Joined: Aug 09, 2004
Location: Chile

Total Topics: 172
Total Comments: 462
peumus
Posted Aug 25, 2005 - 1:11 PM:

Paul,

I was trying to integrate WSN KB into WSN Links. This is the install that manage the members table were I have added the new kbalbumid variable

Today admin personal link list appears as being of other member.
I have deleted that member and added a link at the personal list regardless of the errors that arises.
I have also added links to personal link of other test members.

Now personal link list list seems to be working well for those members, but for admin the title of personal link is replaced by a category name (the category for the first link added). Still checking this.

By the way, I have noticed that when a member ads a link (Edited: a new link) to his personal link list an email is sent to all members (ver. 316 WSN Links and Kb.)
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Aug 26, 2005 - 12:57 PM:

Please restrict yourself to one thread on the one topic, or at least reference the other, so that I don't waste your time and mine telling you things that have nothing to do with integration, given that nothing was said about integration in this thread.

You probably didn't blank out the bad album ids when you fixed the problem of having mixed the KB and Links albumid field. Set your albumid to 0 and let it recreate.
peumus
Forum Regular

Usergroup: Customer
Joined: Aug 09, 2004
Location: Chile

Total Topics: 172
Total Comments: 462
peumus
Posted Aug 27, 2005 - 1:26 AM:

Agree, time is one of the most scarce resources.

Yes, blanking the albumid variable reset to the correct personal category.

After checking a lot, I would say that WSNKb (1.15) has problems to integrated to WSNLinks (3.16) and is altering the personal categories names of it. ( ref. my post on WSNKb support forum ).
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



This thread is closed, so you cannot post a reply.