Paul wrote: 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?
Do you mean the error message in post #8 above? I got that when I ran the hourly cron with debug on. However, just running it again with debug on and I get:
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 < 1208454514
Load time so far: 0.75 seconds.
Query 7: UPDATE wsnlinks_settings SET content='1209318514' WHERE name='lastrotation'
Load time so far: 0.77 seconds.
Query 8: UPDATE wsnlinks_settings SET content='M' WHERE name='currentletter'
Load time so far: 0.79 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 < 1209318514
Number of rows is 1
Creating link with Array as row
Creating link with 1011 as id
Load time so far: 0.85 seconds.
Query 10: 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 id=1011
Creating category with blank as blank
Creating category with blank as blank
Load time so far: 0.87 seconds.
Query 11: UPDATE wsnlinks_links SET deletedby='4461', timedeleted='1209318514' WHERE id=
Load time so far: 0.87 seconds.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Query 12: SELECT COUNT(id) FROM wsnlinks_links WHERE alias= AND validated=1
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/freewebb/public_html/databases/mysql.php on line 30 Count is
Load time so far: 0.87 seconds.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND validated=1' at line 1
Query 13: SELECT `id`,`type`,`objectid`,`filename`,`filetitle`,`filesize`,`width`,`height`,`memberid`,`time`,`deleted`,`field`,`downloads`,`validated`,`ownerip`,`catid`,`importurl` FROM wsnlinks_attachments WHERE type='link' AND objectid=
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/freewebb/public_html/databases/mysql.php on line 27
Number of rows is You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Creating modlog with new as new
Creating link with blank as blank
Creating category with blank as blank
Creating member with blank as blank
Creating member with blank as blank
Creating link with as id Non-numeric id value given in creating object.
WSN Links 4.1.40
I don't know if this just changed when I upgraded or what.
The original error in my post #1 - I get it every now and again when first going to the site.
I got that when I ran the hourly cron with debug on.
I think you mean, then, that you were running it from the admin panel -- so that, as I said in an earlier post, the path was bound to be wrong. I changed it since then to allow running from the admin panel.
Query 11: UPDATE wsnlinks_links SET deletedby='4461', timedeleted='1209318514' WHERE id=
There's some sort of link deletion going on here. Would I be correct to guess that you have expirations on and you have links set to delete when they expire?
Paul wrote: I got that when I ran the hourly cron with debug on.
I think you mean, then, that you were running it from the admin panel -- so that, as I said in an earlier post, the path was bound to be wrong. I changed it since then to allow running from the admin panel.
OOPS! sorry yes. I was just thinking of my first error message.
Paul wrote: Query 11: UPDATE wsnlinks_links SET deletedby='4461', timedeleted='1209318514' WHERE id=
There's some sort of link deletion going on here. Would I be correct to guess that you have expirations on and you have links set to delete when they expire?
Yes. and they are set to expire at 11.59pm of the expire date.
Aliases sound a likely factor, will try again with those.
As for subscriptions, there are so many different types of them that if they all don't work that's surely either a lack of email supplied in the system settings or a server email sending probelm.
Comments on mysql error
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
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?
Do you mean the error message in post #8 above? I got that when I ran the hourly cron with debug on. However, just running it again with debug on and I get:
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 < 1208454514
Load time so far: 0.75 seconds.
Query 7: UPDATE wsnlinks_settings SET content='1209318514' WHERE name='lastrotation'
Load time so far: 0.77 seconds.
Query 8: UPDATE wsnlinks_settings SET content='M' WHERE name='currentletter'
Load time so far: 0.79 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 < 1209318514
Number of rows is 1
Creating link with Array as row
Creating link with 1011 as id
Load time so far: 0.85 seconds.
Query 10: 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 id=1011
Creating category with blank as blank
Creating category with blank as blank
Load time so far: 0.87 seconds.
Query 11: UPDATE wsnlinks_links SET deletedby='4461', timedeleted='1209318514' WHERE id=
Load time so far: 0.87 seconds.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Query 12: SELECT COUNT(id) FROM wsnlinks_links WHERE alias= AND validated=1
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/freewebb/public_html/databases/mysql.php on line 30
Count is
Load time so far: 0.87 seconds.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND validated=1' at line 1
Query 13: SELECT `id`,`type`,`objectid`,`filename`,`filetitle`,`filesize`,`width`,`height`,`memberid`,`time`,`deleted`,`field`,`downloads`,`validated`,`ownerip`,`catid`,`importurl` FROM wsnlinks_attachments WHERE type='link' AND objectid=
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/freewebb/public_html/databases/mysql.php on line 27
Number of rows is You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Creating modlog with new as new
Creating link with blank as blank
Creating category with blank as blank
Creating member with blank as blank
Creating member with blank as blank
Creating link with as id
Non-numeric id value given in creating object.
WSN Links 4.1.40
I don't know if this just changed when I upgraded or what.
The original error in my post #1 - I get it every now and again when first going to the site.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
I got that when I ran the hourly cron with debug on.
I think you mean, then, that you were running it from the admin panel -- so that, as I said in an earlier post, the path was bound to be wrong. I changed it since then to allow running from the admin panel.
Query 11: UPDATE wsnlinks_links SET deletedby='4461', timedeleted='1209318514' WHERE id=
There's some sort of link deletion going on here. Would I be correct to guess that you have expirations on and you have links set to delete when they expire?
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
I got that when I ran the hourly cron with debug on.
I think you mean, then, that you were running it from the admin panel -- so that, as I said in an earlier post, the path was bound to be wrong. I changed it since then to allow running from the admin panel.
OOPS! sorry yes. I was just thinking of my first error message.
Query 11: UPDATE wsnlinks_links SET deletedby='4461', timedeleted='1209318514' WHERE id=
There's some sort of link deletion going on here. Would I be correct to guess that you have expirations on and you have links set to delete when they expire?
Yes. and they are set to expire at 11.59pm of the expire date.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
I'll have to run some expiration tests, since I can't find the problem by reading it.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Expire-deleting isn't causing any errors for me. Maybe it relates to the particular nature of the links which you're expiring, somehow.
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
They are all simple regular link types, with two added fields.
The only thing that is probably different is that they are all aliased to at least one or two categories.
I have it set to hard delete after 10 days. There are a lot of them - currently 9 pages.
This is also the site that subscriptions have never worked. I gave up on that one in the end
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Aliases sound a likely factor, will try again with those.
As for subscriptions, there are so many different types of them that if they all don't work that's surely either a lack of email supplied in the system settings or a server email sending probelm.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
It's trying to delete the aliases as though they were independant links. Fixed.