Webmastersite.net
Register Log In

orderid
Orderids not being created

Comments on orderid

dreamweaver
Experienced

Usergroup: Member
Joined: May 05, 2004

Total Topics: 12
Total Comments: 53
Posted May 30, 2005 - 5:06 PM:

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.
dreamweaver
Experienced

Usergroup: Member
Joined: May 05, 2004

Total Topics: 12
Total Comments: 53
Posted Jun 02, 2005 - 12:33 PM:

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
developer

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

Total Topics: 61
Total Comments: 7868
Paul
Posted Jun 02, 2005 - 11:23 PM:

Just checked on localhost and {PREVIOUSLINK} and {NEXTLINK} seem to be working there. Perhaps check your template against the default.
dreamweaver
Experienced

Usergroup: Member
Joined: May 05, 2004

Total Topics: 12
Total Comments: 53
Posted Jun 03, 2005 - 6:10 PM:

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

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

Total Topics: 61
Total Comments: 7868
Paul
Posted Jun 05, 2005 - 10:43 AM:

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.
dreamweaver
Experienced

Usergroup: Member
Joined: May 05, 2004

Total Topics: 12
Total Comments: 53
Posted Jun 06, 2005 - 5:54 AM:

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
developer

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

Total Topics: 61
Total Comments: 7868
Paul
Posted Jun 13, 2005 - 11:46 AM:

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.
Paul
developer

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

Total Topics: 61
Total Comments: 7868
Paul
Posted Jun 13, 2005 - 10:03 PM:

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

Usergroup: Member
Joined: May 05, 2004

Total Topics: 12
Total Comments: 53
Posted Jun 14, 2005 - 10:06 AM:

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
developer

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

Total Topics: 61
Total Comments: 7868
Paul
#10 - Quote - Permalink
Posted Jun 16, 2005 - 7:00 PM:

I was using the comments tempalte, but as you note my HTML was wrong.
dreamweaver
Experienced

Usergroup: Member
Joined: May 05, 2004

Total Topics: 12
Total Comments: 53
#11 - Quote - Permalink
Posted Jun 17, 2005 - 3:30 AM:

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.
Paul
developer

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

Total Topics: 61
Total Comments: 7868
Paul
#12 - Quote - Permalink
Posted Jun 18, 2005 - 12:02 AM:

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.
dreamweaver
Experienced

Usergroup: Member
Joined: May 05, 2004

Total Topics: 12
Total Comments: 53
#13 - Quote - Permalink
Posted Jun 18, 2005 - 5:52 AM:

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
developer

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

Total Topics: 61
Total Comments: 7868
Paul
#14 - Quote - Permalink
Posted Jun 18, 2005 - 3:40 PM:

<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.
dreamweaver
Experienced

Usergroup: Member
Joined: May 05, 2004

Total Topics: 12
Total Comments: 53
#15 - Quote - Permalink
Posted Jun 18, 2005 - 4:59 PM:

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:
www.mysite.com/wsngallery/c...=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.
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



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