Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 258
Total Posts: 819
Posted 03/28/08 - 04:12 AM:
#1
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.
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 258
Total Posts: 819
Posted 03/29/08 - 10:38 PM:
#3
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
Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 49
Total Posts: 5539
Posted 03/30/08 - 05:56 AM:
#4
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?
Usergroup: Member
Joined: Mar 06, 2006
Total Topics: 1
Total Posts: 3
Posted 04/05/08 - 09:04 AM:
#5
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
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 258
Total Posts: 819
Posted 04/22/08 - 11:57 PM:
#8
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`,`not ify`,`suspect`,`pendingedit`,`funds`,`suspended`,`alias`,`ex pire`,`ip`,`inalbum`,`typeorder`,`recipurl`,`hitsin`,`recipw ith`,`hitsinips`,`hitsoutips`,`lastcomment`,`related`,`inhid den`,`viewers`,`threadviewers`,`hitsintemp`,`hitsouttemp`,`o rigtype`,`importance`,`parentids`,`timesdead`,`timesemailed` ,`threadclosed`,`threadposters`,`lastposterid`,`lastposterna me`,`ownername`,`deleted`,`deletionreason`,`movedto`,`delete dby`,`timevalidated`,`filefield`,`message`,`sticky`,`downloa ds`,`pollid`,`posticon`,`savedby`,`validatedemail`,`unpaid`, `recipverified`,`effectivetime`,`sugcatid`,`pagerank`,`wysih tml`,`movedid`,`unrevised`,`feedurl`,`feedcache`,`feedcachet ime`,`tags`,`xmlsource`,`ordercomments`,`lastpadupdate`,`pad file`,`lastmonthlycheck`,`invisibleto`,`profileurl`,`lastpro fileurl`,`banner`,`smallbanner`,`tinybanner`,`membersonly`,` timesrenewed`,`couponcode`,`bargain`,`articletext`,`author`, `copyright`,`tel`,`contact`,`otherbannerattach`,`nochex`,`me rchant`,`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
Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 49
Total Posts: 5539
Posted 04/23/08 - 12:56 PM:
#9
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.
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 258
Total Posts: 819
Posted 04/25/08 - 02:25 AM:
#10
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
Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 49
Total Posts: 5539
Posted 04/26/08 - 01:07 AM:
#11
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.
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 258
Total Posts: 819
Posted 04/26/08 - 02:40 AM:
#12
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.
Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 49
Total Posts: 5539
Posted 04/26/08 - 03:50 AM:
#13
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.
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 258
Total Posts: 819
Posted 04/26/08 - 04:07 AM:
#14
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.
Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 49
Total Posts: 5539
Posted 04/26/08 - 10:57 PM:
#15
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?
Print
mysql error
