I've started getting the following mysql error messages. I THINK I first noticed after upgrading to .35. It only happens very occasionally. Just now happened after submitting a link, link did submit ok. Am posting this now and will keep an eye on it and see when it happens again.
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/freewebb/public_html/databases/mysql.php on line 30
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/freewebb/public_html/databases/mysql.php on line 27 Non-numeric id value given in creating object.
Unfortunately it might only happen once a week. So I am awaiting the next time to see if there is a pattern, ie after submitting a link, But when I refresh it NEVER appears again
It could be an hourly/daily cron, or a randomly-timed action. Try index.php?dorand=1 , and the run now links for the three crons from Admin -> Misc -> Crons
I'd only expect those to come up on index.php though, not after submitting a link. You're talking about the redirect "thanks for submitting" page, right?
I am also getting "non-numeric id value given in creating object" They occur only on accessing specific links. Regen of cats did not help. If I perform the sql query directly, I get no error with 1 result.
Here is the debug info:
Query 19: SELECT `id` FROM wsn_links WHERE catid=82702 AND validated=1 AND hide=0 ORDER BY time ASC
Number of rows is 5
Load time so far: 0.31 seconds.
Query 20: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`numexlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`subscriber`,`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`,`exlinkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`unvalidatedreviews`,`actaslink`,`countposts`,`subcatshtml`,`nummembers`,`linksperpage`,`wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaultnoaccess`,`lastthreadurl`,`lastposturl` FROM wsn_categories WHERE id=75955
Load time so far: 0.31 seconds.
Query 21: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`numexlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`subscriber`,`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`,`exlinkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`unvalidatedreviews`,`actaslink`,`countposts`,`subcatshtml`,`nummembers`,`linksperpage`,`wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaultnoaccess`,`lastthreadurl`,`lastposturl` FROM wsn_categories WHERE id=82594
Non-numeric id value given in creating object. WSN Links 4.1.36
Paul wrote: It could be an hourly/daily cron, or a randomly-timed action. Try index.php?dorand=1 , and the run now links for the three crons from Admin -> Misc -> Crons
I'd only expect those to come up on index.php though, not after submitting a link. You're talking about the redirect "thanks for submitting" page, right?
I get a problem with running the hourly cron - error with debug on comes up with...
Load time so far: 0.14 seconds.
Query 5: SELECT `filename` FROM wsnlinks_crons WHERE id=6
Load time so far: 0.14 seconds.
Query 6: DELETE FROM wsnlinks_links WHERE deleted=1 and timedeleted < 1208069746
Load time so far: 0.57 seconds.
Query 7: UPDATE wsnlinks_settings SET content='1208933746' WHERE name='lastrotation'
Load time so far: 0.58 seconds.
Query 8: UPDATE wsnlinks_settings SET content='D' WHERE name='currentletter'
Load time so far: 0.59 seconds.
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`,`banner`,`smallbanner`,`tinybanner`,`membersonly`,`timesrenewed`,`couponcode`,`bargain`,`articletext`,`author`,`copyright`,`tel`,`contact`,`otherbannerattach`,`nochex`,`merchant`,`price`,`timedeleted`,`offertype` FROM wsnlinks_links WHERE deleted=0 AND hide=0 AND expire > 0 AND expire < 1208933746
Number of rows is 1
Warning: require_once(classes/modlog.php) [function.require-once]: failed to open stream: No such file or directory in /home/freewebb/public_html/crons/hourly.php on line 39
Fatal error: require_once() [function.require]: Failed opening required 'classes/modlog.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/freewebb/public_html/crons/hourly.php on line 39
You don't have a classes/modlog.php file, or are you running that from the admin panel? It's not made to handle admin panel relative paths. Will change it to, even though it doesn't normally run from there.
Paul wrote: You don't have a classes/modlog.php file, or are you running that from the admin panel? It's not made to handle admin panel relative paths. Will change it to, even though it doesn't normally run from there.
The classes/modlog.php file is definitely there - I have not changed anything and wouldn't even know or understand how to run it from the admin panel.
Paul, I am subscribed to this forum so I am notified immediately of posts and of course any replies to posts I make. This has always worked perfectly, but for some reason over the last few weeks I am only getting the odd notice - I didn't realise you had replied to this thread! And, no, they are not going into my spam box I checked
If it says "Failed opening required 'classes/modlog.php" then there are only three possibilities: 1) The page being viewed is in the admin subdirectory, so that /classes/ isn't a subdirectory of it. 2) classes/modlog.php doesn't exist. 3) classes/modlog.php is inaccessible in some way, like a 403 forbidden error. Try visiting it directly in your web browser.
Paul wrote: If it says "Failed opening required 'classes/modlog.php" then there are only three possibilities: 1) The page being viewed is in the admin subdirectory, so that /classes/ isn't a subdirectory of it. 2) classes/modlog.php doesn't exist. 3) classes/modlog.php is inaccessible in some way, like a 403 forbidden error. Try visiting it directly in your web browser.
1) nope - it is a normal setup in the root of my domain. It has happened when submitting but recently mainly when I first go to the site's home page.
2) nope - it is DEFINITELY there. In fact I have just upgraded the site to 4.1.40 and my server now shows that file with a modified date of today.
Subscriptions were switched off on the forum... probably when I was trying to drastically cut down on emails going through the server which were bogging it down.
Paul wrote: Blank page is normal since it has no output.
Have you tried reuploading classes/modlog.php?
Yep - just tried it again but still no joy, just the error messages.
Paul wrote: Subscriptions were switched off on the forum... probably when I was trying to drastically cut down on emails going through the server which were bogging it down.
Can you give me a specific example of a URL where you know you've seen this modlog message -- not the earlier different message about which you started the thread?
0/5
1
2
3
4
5
Sorry, you don't have permission to post posts. Log in, or register if you haven't yet.
Comments on mysql error
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
I've started getting the following mysql error messages. I THINK I first noticed after upgrading to .35. It only happens very occasionally. Just now happened after submitting a link, link did submit ok. Am posting this now and will keep an eye on it and see when it happens again.
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/freewebb/public_html/databases/mysql.php on line 30
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/freewebb/public_html/databases/mysql.php on line 27
Non-numeric id value given in creating object.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
See if you can get debug output, though if it doesn't appear on consecutive page loads that could be difficult.
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
Unfortunately it might only happen once a week. So I am awaiting the next time to see if there is a pattern, ie after submitting a link, But when I refresh it NEVER appears again
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
It could be an hourly/daily cron, or a randomly-timed action. Try index.php?dorand=1 , and the run now links for the three crons from Admin -> Misc -> Crons
I'd only expect those to come up on index.php though, not after submitting a link. You're talking about the redirect "thanks for submitting" page, right?
Beginner
Usergroup: Customer
Joined: Mar 06, 2006
Total Topics: 1
Total Comments: 3
I am also getting "non-numeric id value given in creating object"
They occur only on accessing specific links. Regen of cats did not help.
If I perform the sql query directly, I get no error with 1 result.
Here is the debug info:
Query 19: SELECT `id` FROM wsn_links WHERE catid=82702 AND validated=1 AND hide=0 ORDER BY time ASC
Number of rows is 5
Load time so far: 0.31 seconds.
Query 20: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`numexlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`subscriber`,`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`,`exlinkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`unvalidatedreviews`,`actaslink`,`countposts`,`subcatshtml`,`nummembers`,`linksperpage`,`wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaultnoaccess`,`lastthreadurl`,`lastposturl` FROM wsn_categories WHERE id=75955
Load time so far: 0.31 seconds.
Query 21: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`numexlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`subscriber`,`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`,`exlinkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`unvalidatedreviews`,`actaslink`,`countposts`,`subcatshtml`,`nummembers`,`linksperpage`,`wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaultnoaccess`,`lastthreadurl`,`lastposturl` FROM wsn_categories WHERE id=82594
Non-numeric id value given in creating object.
WSN Links 4.1.36
Beginner
Usergroup: Customer
Joined: Mar 06, 2006
Total Topics: 1
Total Comments: 3
Links with "related" = ", ||" are causing the "Non-numeric id value given in creating object" error messages.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
This sounds related to the related links problem which was fixed in 4.1.37. Do you still get it in the current version?
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
It could be an hourly/daily cron, or a randomly-timed action. Try index.php?dorand=1 , and the run now links for the three crons from Admin -> Misc -> Crons
I'd only expect those to come up on index.php though, not after submitting a link. You're talking about the redirect "thanks for submitting" page, right?
I get a problem with running the hourly cron - error with debug on comes up with...
Load time so far: 0.14 seconds.
Query 5: SELECT `filename` FROM wsnlinks_crons WHERE id=6
Load time so far: 0.14 seconds.
Query 6: DELETE FROM wsnlinks_links WHERE deleted=1 and timedeleted < 1208069746
Load time so far: 0.57 seconds.
Query 7: UPDATE wsnlinks_settings SET content='1208933746' WHERE name='lastrotation'
Load time so far: 0.58 seconds.
Query 8: UPDATE wsnlinks_settings SET content='D' WHERE name='currentletter'
Load time so far: 0.59 seconds.
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`,`banner`,`smallbanner`,`tinybanner`,`membersonly`,`timesrenewed`,`couponcode`,`bargain`,`articletext`,`author`,`copyright`,`tel`,`contact`,`otherbannerattach`,`nochex`,`merchant`,`price`,`timedeleted`,`offertype` FROM wsnlinks_links WHERE deleted=0 AND hide=0 AND expire > 0 AND expire < 1208933746
Number of rows is 1
Warning: require_once(classes/modlog.php) [function.require-once]: failed to open stream: No such file or directory in /home/freewebb/public_html/crons/hourly.php on line 39
Fatal error: require_once() [function.require]: Failed opening required 'classes/modlog.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/freewebb/public_html/crons/hourly.php on line 39
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
You don't have a classes/modlog.php file, or are you running that from the admin panel? It's not made to handle admin panel relative paths. Will change it to, even though it doesn't normally run from there.
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
You don't have a classes/modlog.php file, or are you running that from the admin panel? It's not made to handle admin panel relative paths. Will change it to, even though it doesn't normally run from there.
The classes/modlog.php file is definitely there - I have not changed anything and wouldn't even know or understand how to run it from the admin panel.
Paul, I am subscribed to this forum so I am notified immediately of posts and of course any replies to posts I make. This has always worked perfectly, but for some reason over the last few weeks I am only getting the odd notice - I didn't realise you had replied to this thread! And, no, they are not going into my spam box I checked
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
If it says "Failed opening required 'classes/modlog.php" then there are only three possibilities:
1) The page being viewed is in the admin subdirectory, so that /classes/ isn't a subdirectory of it.
2) classes/modlog.php doesn't exist.
3) classes/modlog.php is inaccessible in some way, like a 403 forbidden error. Try visiting it directly in your web browser.
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
If it says "Failed opening required 'classes/modlog.php" then there are only three possibilities:
1) The page being viewed is in the admin subdirectory, so that /classes/ isn't a subdirectory of it.
2) classes/modlog.php doesn't exist.
3) classes/modlog.php is inaccessible in some way, like a 403 forbidden error. Try visiting it directly in your web browser.
1) nope - it is a normal setup in the root of my domain. It has happened when submitting but recently mainly when I first go to the site's home page.
2) nope - it is DEFINITELY there. In fact I have just upgraded the site to 4.1.40 and my server now shows that file with a modified date of today.
3) Going to http://www.freewebbargains.com/classes/modlog.php gives me a blank page - NOT a 403 or indeed any other error.
This is the ONLY site it is happening on - ALL my other sites (which are on the same server) are ok. All my sites are set up the same way.
Again - I did not get email notification re the update of this thread. Although I did for Jez's last post, which is how I happened to see this.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Blank page is normal since it has no output.
Have you tried reuploading classes/modlog.php?
Subscriptions were switched off on the forum... probably when I was trying to drastically cut down on emails going through the server which were bogging it down.
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
Blank page is normal since it has no output.
Have you tried reuploading classes/modlog.php?
Yep - just tried it again but still no joy, just the error messages.
Subscriptions were switched off on the forum... probably when I was trying to drastically cut down on emails going through the server which were bogging it down.
aha! Shame, but understandable.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Can you give me a specific example of a URL where you know you've seen this modlog message -- not the earlier different message about which you started the thread?