The 2026 Drupal Business Survey is open. Your response will help shape the future of the Drupal business ecosystem.
By andre75 on
When I click the browze button on my website (this is what calls the taxonomy_dhtml node) I get tons of errors like this:
Got error 12 from storage engine query: SELECT n.nid, n.title, n.type, u.uid, u.name FROM term_node r LEFT JOIN node n ON r.nid = n.nid LEFT JOIN users u ON n.uid = u.uid WHERE n.status = 1 AND 1 AND r.tid = '46' ORDER BY n.changed DESC LIMIT 0, 200 in /pathtomysite/includes/database.mysql.inc on line 66.
The error does not always show up though, it is hard to repeat once it occured.
What is this? What is going wrong? Help please!
If you want to try it out: http://www.opentravelinfo.com
Click on the browze in the upper right corner.
Thanks a bunch.
Andre
Comments
The only error I got (which
The only error I got (which was consistant) was when I clicked on "articles" in the Navigation menu. path was taxonomy-menu/4
warning: mysql_query(): Unable to save result set in /www/a/aguntherphot/htdocs/opentravelinfo/includes/database.mysql.inc on line 49.
I couldn't get any errors by clicking on browze.
gpdinoz
"If we can see further it is because we stand on the shoulders of giants"
Regards
Geoff
Any idea?
Hm. I went to phpmyadmin yesterday and repaired all tables. Since you are still getting an error I guess I still have a problem.
Any Idea what I can do?
Andre
-------------------------------------------------
http://www.opentravelinfo.com
http://www.aguntherphotography.com
No errors now
I tried it today and I couldn't get an error. Maybe you have fixed it. I would keep an eye on it.
gpdinoz
"If we can see further it is because we stand on the shoulders of giants"
Regards
Geoff
Thanks
Thanks for your help. I appreciate it.
-------------------------------------------------
http://www.opentravelinfo.com
http://www.aguntherphotography.com
And I didn't get any error
And I didn't get any error at all. I got a nice list of all the categories:-)
No errors here, have you fixed it?
I'm curious to know what code you are using for the menus - I tried to implement an Interakt version of this style of menu and kept getting errors under IE only.
Your menu seems stable under IE and FF.
Yes
Sort of. I have repaired the database.
For the second error I had to reduce the number of queries. Seems to be related to a memory limit of my provider.
Andre
-------------------------------------------------
http://www.opentravelinfo.com
http://www.aguntherphotography.com
My Menus
I am using taxonomy menu module for the Navigation menu and Taxonomy dhtml for the Browze button.
I think your problems may be related to the theme you are using not so much the menu creation itself.
Andre
-------------------------------------------------
http://www.opentravelinfo.com
http://www.aguntherphotography.com
Hello Andre,
Hello Andre,
I see that taxonomy_menu actually gives a nice navigation menu on your site. When I tried it, it seemed to plop everything into the main content area. Is there a setting that I am missing?
Also, the breadcrumbs show up nicely. Does taxonomy_menu do that automatically or are you using any other module?
You know
Since you are asking. I never bothered with it, since it worked right out of the box for me.
I am using the Spreadfirefox theme. Maybe that has something to do with it.
I told it what to display here:
admin/settings/taxonomy_menu
and arranged the menu here:
admin/menu
For some reason this is also where I renamed Area to Location and Interest to Activity (I guess I was still trying to figure out how to sort the menu until I found out about weights.)
Well you need to have your categories set up correctly:
admin/taxonomy
So in essence I have no clue what went wrong on your site since it worked right away for me.
You could try a different theme in your sandbox to see if that works.
I also remember trying some other taxonomy navigation opitons.
The two I am using are those:
http://drupal.org/node/3724 (for the Nav menu)
http://drupal.org/project/taxonomy_dhtml (for Browze)
I seem to remember trying:
http://drupal.org/project/taxonomy_browser
http://drupal.org/node/15192
with different results.
What are breadcrumbs?
Andre
-------------------------------------------------
http://www.opentravelinfo.com
http://www.aguntherphotography.com
Thanks for all the tips. I
Thanks for all the tips. I will need to try it again, probably with a different theme, as you suggested.
Breadcrumbs are essentially the path trails at the top of the page that give users a sense of where they are on the site. For instance, Home>>Activity
Hm
Sorry I couldn't give you a definite answer though.
This is one piece that never gave me trouble ;-)
-------------------------------------------------
http://www.opentravelinfo.com
http://www.aguntherphotography.com