Webmastersite.net
Register Log In

mysql error

Comments on mysql error

babrees
Expert

Usergroup: Customer
Joined: Aug 19, 2005
Location: England

Total Topics: 391
Total Comments: 1303
babrees
Posted Mar 28, 2008 - 6:12 AM:

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

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

Total Topics: 61
Total Comments: 7868
Paul
Posted Mar 29, 2008 - 5:00 AM:

See if you can get debug output, though if it doesn't appear on consecutive page loads that could be difficult.
babrees
Expert

Usergroup: Customer
Joined: Aug 19, 2005
Location: England

Total Topics: 391
Total Comments: 1303
babrees
Posted Mar 30, 2008 - 12:38 AM:

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




Paul
developer

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

Total Topics: 61
Total Comments: 7868
Paul
Posted Mar 30, 2008 - 7:56 AM:

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?
dorjepy
Beginner

Usergroup: Customer
Joined: Mar 06, 2006

Total Topics: 1
Total Comments: 3
dorjepy
Posted Apr 05, 2008 - 11:04 AM:

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
dorjepy
Beginner

Usergroup: Customer
Joined: Mar 06, 2006

Total Topics: 1
Total Comments: 3
dorjepy
Posted Apr 06, 2008 - 10:29 AM:

Links with "related" = ", ||" are causing the "Non-numeric id value given in creating object" error messages.
Paul
developer

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

Total Topics: 61
Total Comments: 7868
Paul
Posted Apr 06, 2008 - 4:52 PM:

This sounds related to the related links problem which was fixed in 4.1.37. Do you still get it in the current version?
babrees
Expert

Usergroup: Customer
Joined: Aug 19, 2005
Location: England

Total Topics: 391
Total Comments: 1303
babrees
Posted Apr 23, 2008 - 1:57 AM:

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

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

Total Topics: 61
Total Comments: 7868
Paul
Posted Apr 23, 2008 - 2:56 PM:

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.
babrees
Expert

Usergroup: Customer
Joined: Aug 19, 2005
Location: England

Total Topics: 391
Total Comments: 1303
babrees
#10 - Quote - Permalink
Posted Apr 25, 2008 - 4:25 AM:

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

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

Total Topics: 61
Total Comments: 7868
Paul
#11 - Quote - Permalink
Posted Apr 26, 2008 - 3:07 AM:

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.
babrees
Expert

Usergroup: Customer
Joined: Aug 19, 2005
Location: England

Total Topics: 391
Total Comments: 1303
babrees
#12 - Quote - Permalink
Posted Apr 26, 2008 - 4:40 AM:

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.

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

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

Total Topics: 61
Total Comments: 7868
Paul
#13 - Quote - Permalink
Posted Apr 26, 2008 - 5:50 AM:

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.
babrees
Expert

Usergroup: Customer
Joined: Aug 19, 2005
Location: England

Total Topics: 391
Total Comments: 1303
babrees
#14 - Quote - Permalink
Posted Apr 26, 2008 - 6:07 AM:

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.


aha! Shame, but understandable.
Paul
developer

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

Total Topics: 61
Total Comments: 7868
Paul
#15 - Quote - Permalink
Posted Apr 27, 2008 - 12:57 AM:

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?
Search thread for
Download thread as
  • 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.