orderid: WSN Support

WSN Support » WSN Gallery » orderid » orderid

orderid
Orderids not being created

Version: 2.12
Status: fixed

orderid

dreamweaver
Experienced

Usergroup:
Joined: May 05, 2004
Total Topics: 12
Total Posts: 53

Posted 05/30/05 - 04:06 PM:	#1
After intergrating the comments and the Image Details, orderids are no longer being created. If I change the url to "Link" instead of Comments -- showing the original Image Details template -- then orderids are fine there. I should also add, as you probably know, that after the orderid has a jumpstart -- i.e. I put a 1 in to begin -- it goes on just fine. Edited by dreamweaver on 05/31/05 - 10:54 AM

dreamweaver
Experienced

Usergroup:
Joined: May 05, 2004
Total Topics: 12
Total Posts: 53

Posted 06/02/05 - 11:33 AM:	#2
Hm, it's slightly more serious/problematic than I thought, since sometimes it just bugs up and shows the raw PHP with: Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/dw/public_html/wsngallery/classes/database.php on line 59 Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/dw/public_html/wsngallery/classes/database.php on line 59 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dw/public_html/wsngallery/classes/database.php on line 72 ...at the top.

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 6014

Posted 06/02/05 - 10:23 PM:	#3
Just checked on localhost and {PREVIOUSLINK} and {NEXTLINK} seem to be working there. Perhaps check your template against the default.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

dreamweaver
Experienced

Usergroup:
Joined: May 05, 2004
Total Topics: 12
Total Posts: 53

Posted 06/03/05 - 05:10 PM:	#4
I presume you mean {NEXT} instead; I don't see any {NEXTLINK} in the template default... Can't see any real differences. I did a straight copy and paste; only changing the two a tags to have "comments" instead of "link" (just changed that now; didn't realise before, meh). So, it's: <p align="center"> <IF {PREVIOUSEXISTS}><a href="comments.php?action=detail&catid={IMAGECATID}&orderid={PREVIOUS}">Previous</a></IF> <IF {PREVIOUSEXISTS} and {NEXTEXISTS}> \| </IF> <IF {NEXTEXISTS}><a href="comments.php?action=detail&catid={IMAGECATID}&orderid={NEXT}">Next</a></IF> </p> ...but now always getting: Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/dw/public_html/wsngallery/classes/database.php on line 59 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dw/public_html/wsngallery/classes/database.php on line 72 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dw/public_html/wsngallery/classes/database.php on line 72 Edited by dreamweaver on 06/03/05 - 05:28 PM

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 6014

Posted 06/05/05 - 09:43 AM:	#5
Well that would explain it I guess, try a {NEXTLINK} instead. {NEXT} would, I believe, be a pagination variable for the comments page of a multipage thread.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

dreamweaver
Experienced

Usergroup:
Joined: May 05, 2004
Total Topics: 12
Total Posts: 53

Posted 06/06/05 - 04:54 AM:	#6
Should have mentioned that I already tried that; no luck. With {NEXTLINK} it doesn't stream fo MySQL errors, but the order is certainly mucked, and it seems to always end up -- one way or another -- at orderid=162. I don't see why it would be {NEXTLINK} -- the Image Details in the default template has {NEXT} and it works fine there.

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 6014

Posted 06/13/05 - 10:46 AM:	#7
I don't see why it would be {NEXTLINK} -- the Image Details in the default template has {NEXT} and it works fine there. Because there's no pagination there. {NEXT} is a reserved pagination variable, it messes up any page that already has pagination. Will re-check this later today, anyhow.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 6014

Posted 06/13/05 - 09:03 PM:	#8
Checked again, and it still appears to work perfectly. <p align="center"> <IF {PREVIOUSEXISTS}><a href="link.php?action=detail&catid={IMAGECATID}&orderid={PREVIOUSLINK}">Previous</a></IF> <IF {PREVIOUSEXISTS} and {NEXTEXISTS}> \| </IF> <IF {NEXTEXISTS}><a href="link.php?action=detail&catid={IMAGECATID}&orderid={NEXTLINK}">Next</a></IF> </p>
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

dreamweaver
Experienced

Usergroup:
Joined: May 05, 2004
Total Topics: 12
Total Posts: 53

Posted 06/14/05 - 09:06 AM:	#9
Are you sure you're doing this in the Comments template? Kind of wondering if you are since your URL there has href="link.php and I'd imagine you should have comments.php there instead. As I said, it works perfectly on the link.php, yes.

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 6014

Posted 06/16/05 - 06:00 PM:	#10
I was using the comments tempalte, but as you note my HTML was wrong.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

dreamweaver
Experienced

Usergroup:
Joined: May 05, 2004
Total Topics: 12
Total Posts: 53

Posted 06/17/05 - 02:30 AM:	#11
Sorry to carry on, but do you wanna try putting the comments HTML code in for the Comments template? Since, I just put that HTML in my comments, and because it changes to link, it looks like it works just fine. Change the code to "comments" instead of "link" and then you'll see the problems; since as it is, it just changes to the "link" instead, where the Next/Previous is working just fine. Noticed another couple problems with 0.15: * Cannot view member album; complains that {THISMEMBERCANREMOVE[ (sic) is invalid. Changing it lets you view the images, but then you get the error: Warning: Missing argument 1 for canremove() in /home/dw/public_html/wsngallery/classes/member.php on line 856 ..though the "Templates" section (in admin panel) also has a permanent error on top. Edited by dreamweaver on 06/17/05 - 04:12 PM

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 6014

Posted 06/17/05 - 11:02 PM:	#12
Just wait for 2.16 on the thread's original topic. Noticed another couple problems with 0.15: * Cannot view member album; complains that {THISMEMBERCANREMOVE[ (sic) is invalid. Changing it lets you view the images, but then you get the error: Warning: Missing argument 1 for canremove() in /home/dw/public_html/wsngallery/classes/member.php on line 856 I'm getting an error of the album not getting created if you don't specifically click to create it, and thus becoming a conditional error, but that appears unrelated to what you've posted. So you will have to post a procedure for reproducing. Edit: Ah, 2.12. Well, I remember something of that sort back then. .though the "Templates" section (in admin panel) also has a permanent error on top. Erm, you aren't going to specify what it is? I don't get one. I'm guessing there's just a warning saying you forgot to upload a template. Edited by Paul on 06/17/05 - 11:15 PM
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

dreamweaver
Experienced

Usergroup:
Joined: May 05, 2004
Total Topics: 12
Total Posts: 53

Posted 06/18/05 - 04:52 AM:	#13
So you will have to post a procedure for reproducing. Well, I removed it now since it was simple to do, but it was simply that in the template there was {THISMEMBERCANREMOVE[ instead of {THISMEMBERCANREMOVE}, but not sure if that was simply from the upgrade, since PF doesn't have the prob. Erm, you aren't going to specify what it is? I don't get one. I'm guessing there's just a warning saying you forgot to upload a template. Perhaps. I thought I posted it earlier; nevermind. It's: Warning: filesize(): Stat failed for ../templates/default/badrequest.tpl (errno=2 - No such file or directory) in /home/dw/public_html/wsngallery/admin/templates.php on line 307

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 6014

Posted 06/18/05 - 02:40 PM:	#14
<IF {THISMEMBERCANREMOVE[{IMAGEOWNERID}]}> is the proper thing that belongs in the template, and is there in the the default template set. Your change will simply cause it to function improperly and show the 'remove' option at the wrong times. You're simply using an ancient version from last year where it doesn't work, I gather. I thought I posted it earlier; nevermind. It's: It says you haven't uploaded badrequest.tpl.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

dreamweaver
Experienced

Usergroup:
Joined: May 05, 2004
Total Topics: 12
Total Posts: 53

Posted 06/18/05 - 03:59 PM:

#15

Quite right. You might want to consider editing the readme.txt, to say "upgrading from 0.15".

Damnit! Orderid still not working grin

. It's even odder this time. Pressing "Next" the first time is just fine, the second time, and it tries to put in this URL:

http://www.mysite.com/wsngallery/comments.php?action=detail&catid=44&orderid=0">Previous</a>  |  <a href= 
(sic)

Edit: Coool. It's working. Took the stuff from the new template, and have:

<p align="center"> 
<IF {PREVIOUSEXISTS}><a href="link.php?action=detail&catid={IMAGECATID}&orderid={PREVIOUS}">Previous</a></IF>  
<IF {PREVIOUSEXISTS} and {NEXTEXISTS}> | </IF> 
<IF {NEXTEXISTS}><a href="link.php?action=detail&catid={IMAGECATID}&orderid={NEXTLINK}">Next</a></IF> 
</p>

(changing to {NEXTLINK}...and it works like a charm, thanks.

Edited by dreamweaver on 06/19/05 - 06:00 AM

You don't have permission to post.

Please login or register.