latest content error
Aug 1 2006
got this when i went to latest content:
* warning: mysql_query(): Unable to save result set in /home/libcom/public_html/includes/database.mysql.inc on line 101.
* user warning: Got error 134 from storage engine query: SELECT DISTINCT(n.nid), n.title, n.type, n.changed, n.uid, u.name, l.last_comment_timestamp AS last_post, l.comment_count FROM node n INNER JOIN users u ON n.uid = u.uid INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 2 AND na.realm = 'term_access'))) AND n.status = 1 ORDER BY last_post DESC LIMIT 0, 25 in /home/libcom/public_html/includes/database.mysql.inc on line 120.
Aug 1 2006
#2
It's a caching issue - nothing's actually going wrong when that shows up, just not going right iyswim. Refreshing the page ought to fix it. I've done some maintence on the db which will hopefully fix it, so please post up if you get the same thing.
Aug 1 2006
#3
warning: mysql_query(): Unable to save result set in /home/libcom/public_html/includes/database.mysql.inc on line 101.
user warning: Duplicate entry 'menu:12:fr' for key 1 query: INSERT INTO cache (cid, data, created, expire, headers) VALUES ('menu:12:fr', 'a:4:{s:10:\"path index\";a:252:{s:13:\"admin/filters\";s:1:\"9\";s:18:\"admin/filters/list\";i:-2;s:17:\"admin/filters/add\";i:-3;s:20:\"admin/filters/delete\";i:-4;s:11:\"filter/tips\";s:2:\"10\";s:10:\"admin/node\";s:2:\"13\";s:19:\"admin/node/overview\";i:-7;s:17:\"admin/node/search\";i:-8;s:19:\"admin/settings/node\";s:2:\"78\";s:28:\"admin/settings/content-types\";s:2:\"79\";s:4:\"node\";s:2:\"14\";s:8:\"node/add\";s:2:\"15\";s:7:\"rss.xml\";i:-13;s:12:\"system/files\";i:-14;s:5:\"admin\";s:1:\"2\";s:12:\"admin/themes\";s:2:\"21\";s:19:\"admin/themes/select\";i:-17;s:21:\"admin/themes/s in /home/libcom/public_html/includes/database.mysql.inc on line 120.
Since I got home it has this on the top of every page.
I'm going to try logging out.
edit: I logged in and out and now it's gone.
Aug 1 2006
#4
I've found where the problem is adnd how to fix it when it goes wrong, but not how to stop it from happening yet.
Aug 1 2006
#5
libcom wrote:
I've found where the problem is adnd how to fix it when it goes wrong, but not how to stop it from happening yet.
Good stuff.
The site keeps getting better and better.
Aug 1 2006
#6
not directly on topic, but i just got the error below when i tried to visit a thread. I post it because it says your mysql db username which may or may not compromise security:
Quote:
Unable to connect to database server
This either means that the username and password information in your settings.php file is incorrect or we can't contact the MySQL database server. This could mean your hosting provider's database server is down.
The MySQL error was: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2).
Currently, the username is something and the database server is localhost.
* Are you sure you have the correct username and password?
* Are you sure that you have typed the correct hostname?
* Are you sure that the database server is running?
For more help, see the Installation and upgrading handbook. If you are unsure what these terms mean you should probably contact your hosting provider.
Aug 1 2006
#7
That's me trying to fix stuff with the server. username isn't a massive problem since you can't connect remotely to our mysql server anyway, but thanks for posting it.
I'll edit out just in case.
Aug 1 2006
#8
Didn't want to create a new thread just for this. The CSS seems to overlap in two places (at least) in Aufheben in the library:
Here: http://drlight.multics.org/aufheben.png
and here: http://drlight.multics.org/aufheben2.png
I would have included the images here but the right end gets cut off and that's the relevant part.
Aug 1 2006
#9
thanks for that.
Apologies for server wobbles the past ten minutes - was upgrading php.
Aug 1 2006
#10
libcom wrote:
I've found where the problem is and how to fix it when it goes wrong, but not how to stop it from happening yet.
The above quote is an apt summary for how I live my whole life btw.!! Cheers for this! 
Also - Catch - for I suspect this is you - when the site issues are resolved, will we start to connect with individual admin. again incl. in a tech capacity as this is much more "user-friendly" for me 
than to address my query to the "collective".
Love
LW X
Aug 1 2006
#11
yeah I just can't be arsed to logout then in again at the moment. And I want to make a "view all forums as read" button as well so it doesn't look like there's loads of new posts when i'm logged in as myself.
I've made a couple of changes to the main forums index - with the debugging I'm using it's reduced load times by a third the past couple of times.
If you notice any big changes (slower or faster) please note them here!
Try logging out & logging back in again. Mine's sorted now.