Long story... I would characterize myself as a designer, not developer. I'm implementing and configuring modules, not editing them. So I'm looking for a module to configure, delete, or add, or a specific row in a specific table in the database I can edit using PhPmyAdmin. No Linux command line. I know I've screwed up here and any help is appreciated. This is volunteer effort for me. I'm not an IT guy!
We have this site for over a year. Recently upgraded to 6.19 a few weeks ago with no problem. Tried to add mailhandler, so we could email into the forums from the outside. This required ctools, feeds, data. Plus we have a number of other modules. So we wound up with an out of memory (OOM) error. Running on 1and1 servers with D6.19, mySql 5.0.91, PHP 5.2.14. PHP memlim 128M, reg glob off, all per Drupal's status report. The addType and addHandler settings in .htaccess are being used as recommended for 1and1 hosting. Somewhere I've heard that 1and1 does not provide more than 40M PHP memory, even though the Drupal status reports more, but even phpinfo.php is reporting 128M. As of this writing, I've increased it to 256M and the status and phpinfo are reporting 256M now, but I still need to get myself out of this issue in order to move forward.
So tried to fix the problem and caused more memory errors. Was getting missing menu items - meaning for example clicking on Administration should bring up all modules in their categories. I wanted to work on Menus but that item was not on the list. Could not get to Maintenance mode to take the site offline either. Tried doing an update.php anyway, resulting in more OOM errors. Did a search here and got to http://drupal.org/node/470862 but this is where I went awry. Per Ambiance on 4/8/10 I went into phpmyadmin and cleared (truncated/emptied) the cache tables, and re-ran update.php. No joy there, still no extra menu items. Then I kept reading and here is where I screwed up , listening to Kyle 4/27 who suggested truncated menu_links, which I did. Still no help, except now of course I had no menu items, except some of the basic things. Anyway, I later found this:
require_once './includes/bootstrap.inc';
drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);
menu_rebuild();
I don't recall who posted this, but creating a file with this content, and calling it rebuilt the complete default menu, except of course for all the custom things I did. Thanks to that user who posted this! At least it got me moving forward again.
So now I have 2 books on the site. I could see them in the content but not on the book list. So I tried adding them to a book of the same name as the original book and I could not. I did discover that i could save the page content, delete the page, create a new page and I could add it to a book of the original name. Then I started adding all of the child pages to the book and kept getting duplicate entry errors, but they were adding to the book. Now I discovered that one of the pages was on the book main page listed twice and with the same URL and node id. Plus the Prior, Up, and Next links are gone from most of the book pages, except new ones.
Okay, that's it. Is there some way I can fix this even if by getting into a specific table in the DB and editing entries? Or an easier way would be fine too. Is it possible the original books are still hanging around somewhere and can be deleted? They are not visible on the Book list.
I've looked at the new menu_links table and the book table and the content_type table but can't seem to find any references to duplicate node ids or menu link ids. Perhaps another table? And what to look for?
I realize that may be TMI, but I felt it's better to lay it all out for proper diagnosis. Thanks in advance.
Comments
fixing duplicate book entries after menu crash
No thoughts?