I'm getting an error when selecting "options" from the menu also.
Using version 5.0.45
It throws a PM notification on top of it, and turning off IM/PM doesn't get rid of it.
I'm not quite sure how to decipher it.
An error occoured at http://www.finsandfur.net/profile.php?action=memb... on 2009-04-25 15:26:25. Please relay this data to support. Error #2: 'mysql_num_rows(): supplied argument is not a valid MySQL result resource' in /home/finsnet/public_html/databases/mysql.php on line 47. Debug info:
That's a toplist problem. No way to tell from here which toplist is the problem, except it's apparently one that doesn't apply to any of my websites or tests. So, things I don't normally use which are in that page would include xml feeds, expired links, hidden links, pending links. Which of those does the account you're testing with own any of?
Looks like the expired links toplist is in there twice, but with different numbers so that probably wouldn't be generating that error.
I dont use any toplists. Well I take that back, I had the default toplist functional on the front page that showed the last five added links, but that's it and is turned off.
If the "options" page is calling for toplists it's not anything I've initiated.
Like Finsandfur I don't have any toplists on this site I am working on (http://www.papillonclub.co.uk/wsnlinks/). I have removed the toplist from the main.tpl. The only toplists therefore are those default ones on the members options. My debug is slightly different. Attached in case you need it.
Your error appears to show a misnamed reference to the feeds table. Are you sure you've been applying the template update instructions given on upgrade? The template has:
<!-- BEGIN TOPLIST 5 --> <CONFIG>xmlfeeds,time,20,descending,ownerid={THISMEMBERID}</CONFIG>
Paul wrote: Your error appears to show a misnamed reference to the feeds table. Are you sure you've been applying the template update instructions given on upgrade? The template has:
<!-- BEGIN TOPLIST 5 --> <CONFIG>xmlfeeds,time,20,descending,ownerid={THISMEMBERID}</CONFIG>
What does your template have for toplist #5?
This probably changed about six months ago.
I found this in the home.tpl and no, it did not have the "xmlfeeds" bit, just feeds. However, I always apply template update instructions, and beside which that template has not been customised or touched, so it should have been upgraded automatically anyway.
I have actually wondered before if the upgrade sometimes misses something. For instance I have upgraded two different sites in the past which have both had a template customised in the same manner. One site upgrade gave me upgrade instructions whilst the other did not.
finsandfur - If you have two toplist #5's in the member home main template, that would be a problem. The quotes toplist was certainly never shipped in that template.
babrees wrote: that template has not been customised or touched, so it should have been upgraded automatically anyway.
It must've been marked in the 'customized' color. Please check which templates are in the customized color in your template editor, and revert any that aren't actually customized. Uploading via FTP can cause them to be marked as customized when they aren't, because of operating system differences in the number of characters involved in a line break.
As for why it wouldn't list the instructions, I see it in the list for changes between the 4.1 and 5.0 series templates: www.wsnforum.com/filecompar...=%2Ftemplates%2Fdefault%2F (search for "feeds," and you'll see it there). It'll run a 4.1 -> 5.0 upgrade test to see if it's in the admin panel output too.
Hi Finsandfur - did you check on your home.tpl template that the configuration was as #7 above? I found the xml was missing in mine, as soon as I copied and pasted Paul's configuration it worked ok for me.
Comments on MySQL error in options
Forum Regular
Usergroup: Customer
Joined: Apr 18, 2006
Total Topics: 28
Total Comments: 103
I'm getting an error when selecting "options" from the menu also.
Using version 5.0.45
It throws a PM notification on top of it, and turning off IM/PM doesn't get rid of it.
I'm not quite sure how to decipher it.
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
So am I. V.5.0.45
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7867
That's a toplist problem. No way to tell from here which toplist is the problem, except it's apparently one that doesn't apply to any of my websites or tests. So, things I don't normally use which are in that page would include xml feeds, expired links, hidden links, pending links. Which of those does the account you're testing with own any of?
Looks like the expired links toplist is in there twice, but with different numbers so that probably wouldn't be generating that error.
Forum Regular
Usergroup: Customer
Joined: Apr 18, 2006
Total Topics: 28
Total Comments: 103
I dont use any toplists. Well I take that back, I had the default toplist functional on the front page that showed the last five added links, but that's it and is turned off.
If the "options" page is calling for toplists it's not anything I've initiated.
Forum Regular
Usergroup: Customer
Joined: Apr 18, 2006
Total Topics: 28
Total Comments: 103
And as I look further, I can see the toplists initiated by the "options" page which are;
I would assume my account owns all of them since I am the only administrator, and the only one with admin or moderator status/permissions.
These are toplists that are automatically being generated by the options page, so how can they "not apply to any of your websites or tests".
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
Like Finsandfur I don't have any toplists on this site I am working on (http://www.papillonclub.co.uk/wsnlinks/). I have removed the toplist from the main.tpl. The only toplists therefore are those default ones on the members options. My debug is slightly different. Attached in case you need it.
Attached Files:
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7867
Your error appears to show a misnamed reference to the feeds table. Are you sure you've been applying the template update instructions given on upgrade? The template has:
What does your template have for toplist #5?
This probably changed about six months ago.
Forum Regular
Usergroup: Customer
Joined: Apr 18, 2006
Total Topics: 28
Total Comments: 103
No, I've been going around the template upgrades thinking it would trash all my alterations.
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
Your error appears to show a misnamed reference to the feeds table. Are you sure you've been applying the template update instructions given on upgrade? The template has:
What does your template have for toplist #5?
This probably changed about six months ago.
I found this in the home.tpl and no, it did not have the "xmlfeeds" bit, just feeds. However, I always apply template update instructions, and beside which that template has not been customised or touched, so it should have been upgraded automatically anyway.
I have actually wondered before if the upgrade sometimes misses something. For instance I have upgraded two different sites in the past which have both had a template customised in the same manner. One site upgrade gave me upgrade instructions whilst the other did not.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7867
finsandfur - If you have two toplist #5's in the member home main template, that would be a problem. The quotes toplist was certainly never shipped in that template.
that template has not been customised or touched, so it should have been upgraded automatically anyway.
It must've been marked in the 'customized' color. Please check which templates are in the customized color in your template editor, and revert any that aren't actually customized. Uploading via FTP can cause them to be marked as customized when they aren't, because of operating system differences in the number of characters involved in a line break.
As for why it wouldn't list the instructions, I see it in the list for changes between the 4.1 and 5.0 series templates: www.wsnforum.com/filecompar...=%2Ftemplates%2Fdefault%2F (search for "feeds," and you'll see it there). It'll run a 4.1 -> 5.0 upgrade test to see if it's in the admin panel output too.
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
In looking at the Manage Templates about half of those in the customised colour are not actually customised. How do I revert them?
Forum Regular
Usergroup: Customer
Joined: Apr 18, 2006
Total Topics: 28
Total Comments: 103
I completely removed TOPLIST 5 and the "Options" button error still exists.
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
Hi Finsandfur - did you check on your home.tpl template that the configuration was as #7 above? I found the xml was missing in mine, as soon as I copied and pasted Paul's configuration it worked ok for me.
Forum Regular
Usergroup: Customer
Joined: Apr 18, 2006
Total Topics: 28
Total Comments: 103
I keep forgetting about that home template for logged in members.
That worked babrees.
You mentioned it and I still overlooked it.
Thanks Much!
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7867
In looking at the Manage Templates about half of those in the customised colour are not actually customised. How do I revert them?
Click them, then click "revert to default" which appears just to the upper right of the box where you edit the template content.