I recently updated from D6.19 to 6.20. Installed on one site everything appears okay. Tried another site and I get this on admin page:
By task
By module
Welcome to the administration section. Here you may control how your site functions.
Hide descriptions
And that is it.
I can click on "by module" and see the modules.
Then I checked other admin pages and got these results:
| Page | Admin Menu Item | displayed on page |
|---|---|---|
| content | Content Mng | You do not have any administrative items. |
| build | Site Buildin | You do not have any administrative items. |
| settings | Site Cnfig | (nothing) |
| store | Store Admin | Fatal error: Unsupported operand types in /hermes/bosweb/web005/b56/ipg.mellchandler/modules/system/system.module on line 627 |
| user | User Mng | (Okay) |
| reports | Reports | (Okay) |
| help | Help | (Okay) |
Went back to the first site. All work well except the "store admin" page.
Checked and first site reports 6.20 second site 6.19.
Has anyone else had any problems? I checked on Drupal's forums and issues with others reporting similar issues, but no solutions. So I was just going to restore the database and site to before the upgrade. Now I am going to prove I don't know what I am doing, because I am not really sure or feel very confident in doing so.
Comments
Read post #18 here:
Read post #18 here: http://drupal.org/node/595724 Does this help at all?
18 did not work so well.
18 did not work so well. Using #12 made it stop showing:
Fatal error: Unsupported operand types in /Blah/Blah/Blah/modules/system/system.module on line 627
12 solution add mlid instead of + on line 627
if (!isset($item['mlid'])) {$item['mlid'] = db_fetch_array(db_query("SELECT mlid, menu_name FROM {menu_links} ml WHERE ml.router_path = '%s' AND module = 'system'", $item['path']));
}
But this does not show the sub-items that are normally displayed. For example under /store/report there should be
* Cart links clicks
* Customer reports
* Product reports
* Sales reports
* Sales tax report
* Stock reports
Reading some of the linked items makes me think it is not just Ubercart having the problem. The error also showed up at "admin/store/reports". The other pages showing "You do not have any administrative items" was resolved by restoring the old site and clearing the caches.
Some more research made #20
Some more research made #20 from this post the best way, but it did not work on all instances.
What I learned. The menu link, that when clicked brought up the offending error - Fatal error: Unsupported operand types in /Blah/Blah/Blah/modules/system/system.module on line 627, is the menu item needing to be edited. This has happened to a number of modules (Ubercart, Simplenews, Drupal Tweaks and more) and with different core upgrades for different peoples sites.
I have three sites running Ubercart-6.x-2.4. The links to main store admin page (admin/store), store reports page (admin/store/reports) and store configuration page (admin/store/settings) each produced the error on each site. Site A was the first site I upgraded core on, then site B and then C. Thinking this was more complicated than it turned out to be, I restored sites B and C to an earlier state before understanding the solution (a waste of time). I un-enabled and deleted Ubercart from sites B & C. I then re-installed Ubercart from the original download rather than the backed-up version (probably doesn't matter, but I did). Re-enabled the modules, then went to the /admin/build/menu-customize/navigation opened up the menu item with edit and saved. That resolved the error on sites B & C for all three menu items.
On site A, I tried first to edit the menu links from the present install, that did not change the outcome. I un-enabled and deleted Ubercart, then re-enstalled and enabled from the original download, then edited the menu items. That worked for the reports and settings page, but not the admin/store page. Tried a number of times to flush the cache, ran update.php and edit the menu item to no avail. That is when I went back to the #12 solution and edited line 627 of system.module. That worked.
However, on this site my product catalog became corrupted and the products that were already entered can not be edited to show up in the catalog. Fortunately this store is not yet live and I only have five products. Otherwise this would be a big problem. Did not have this problem on sites B & C.
One more thing
In Ubertcart there are choices for how the admin pages are displayed. If the bottom one (Normal Drupal submenu listing) is chosen the system.module file doesn't need to be edited. This setting is found at admin/store/settings/store/edit/display.
On further study the first two choices cause the error. The last two choices do not.
Changing this display did not work for me
D20, uc 6.x-2.4.
Still another thing
I remembered this morning that another site has Simplenews on it, and it had the same error when the menu item was called. It was easily remedied with the menu item edit and save trick. No uninstall and re-install.
Edit and Save the menu item did work for me
So:
admin/store/settings
no longer throws the error. Didn't have to rebuild the menus with devel, just made this one change.
it is worse now
Well I was going to try and restore the database and site. Now all the sites on this server report "Site off Line. The mysqli error was: Access denied for user 'mellchandl_app'@'boscgi2403.eigbox.net' (using password: YES)." I then restored to the backed up versions I had before starting this whole process and still get the mysql error. I can't get into the sites at all.
eigbox.net
if you are/were using Netfirms first of all, at that time (DEC 2010 to JAN 2011 Netfirms servers gave me no end of trouble when i tried to launch a D6 website at that time. At the current time, I've been trying them again after thier big "migration" to new ownership. First I had troubles installing D6 due to database error. Then I tried thier scripted install of D7 which worked but since D7 lacks many modules I'd like to use I tried D6 on new databases I created and the main site installed OK although other sites/otherdomain.com installs had and erro message Access denied for user 'un'@'boscgi4103.eigbox.net'
(using password: YES). Then, after 2 days of the main site working without issue but no Control panel MYSQLADMIN access so I called tech support. I got MYSQL access finally but then the sameAccess denied for user 'un'@'boscgi4103.eigbox.net' ``error on my main d6 site. Still unresolved.Just curious: are you using
Just curious: are you using Backup and Migrate? BU&M had a rather nasty bug that messed mightily with the mysql server but since has been addressed. Can you restart the mysqld process?
Not BU&M
No I did not use Backup and Migrate. I Backed up using the hosting companies backup process. I also used there service for backing up the site files. How do you restart mysqld process?
Sorry, wasn't clear. Is the
Sorry, wasn't clear. Is the BU&M module enabled? As for restarting your mysqld process, I'd check with your host. For shared hosting, duplicating the files and db to a local server and checking the error logs will be helpful towards troubleshooting the issue.
Duplicate
Duplicate
clarification
BU&M is not an installed module (therefore not enabled). I had thought about installing on a different site that I don't have access to the Cpanel, but that is another separate issue. I will check with my host to see how to restart mysqld process.
What to do.
So, according to my hosting service, my connection to my databases had become broken. They fixed that so I can get to the sites.
I had tried to restore the sites with the backed up files I had downloaded. But I am wondering if it would not be better to upload Core and add on modules from the original files instead of the backups. I have been going through all my files and folders. Some were overwritten, but others were appended (don't know why).
Arrrgggghhhh.
I remain of the mind that if
I remain of the mind that if your site was working prior to the update, and the update broke something, then you should attempt to recreate the failure locally, and not to a live site. Working locally can allow you to monitor all aspects of your environment, error logs, memory consumption, etc, that a shared host can not show you.
Are you familiar with the WAMP/XAMP/MAMP environments? (Windows/xServer/Mac)) It's a great open-source solution for setting up a local AMP server without mucking with your OS.
Anecdotally, I've had zero issues with the 6.19 - 6.20 update, BTW.
I can say that I upgraded my
I can say that I upgraded my dev instance and prod instance of my site from 6.19 to 6.20 without issue. I also had to update the views module. For core and views it seemed like the sql schema didn't change.. is that right?
making the existing work right
I am not trying to recreate the problem on the live sites. I am just trying to clean up those messes.
I do have a local server (Uniform Server LAMP), but I am having problems with it currently also. I can't create a database. (There is so much more of this stuff I need to learn if I am going to be serious about this).
I use SimpleScripts
I use SimpleScripts for minor upgrades. You should check your cPanel for SS or Fantiastico. I know many of the smarter people poo-poo that idea, but click and click and you've upgraded. I've never had an issue with it.
Some progress
In the process of trying to restore a number of modules appended rather than being overwritten. I have been through every folder on the site checking for that problem and believe I have that cleaned up. I have been using FireFTP and don't understand why some files were overwritten and others appended. Would that be the permissions set on individual files and folders? My admin pages (admin, content, build, settings, user, reports, help) are back except for the Ubercart store configuration (store) where I still get the Fatal error listed above. I flushed caches, ran update.php and the error persists.
FTP: I am not a fan of it for
FTP: I am not a fan of it for reasons beyond this discussion. Of course, you could always remove the remote folder and then copy the original back up, then there's no guessing if there's been file errors.
Troubleshooting ANY AMP-based shared hosted site remotely is like bowling with the lights off. If you can't check your error output via logs, which for security reasons should NOT be expressed through HTML output, you can not establish cause-and-effect relationships between corrective actions and results.
Another way?
Well I am bowling in the dark. I acknowledge my ignorance in all of this, and my egregious use of FTP is only because I don't know another way, except host the sites myself, which I am not prepared to do.
Please don't read what I
Please don't read what I wrote as being critical. I personally don't like FTP, but oddly enough this is the ONLY way in .NET-land, so I carry this baggage. I wasn't criticizing anything you're doing, just offering alternatives.
If you wish you can directly contact me via this board and I can take a look to see if I can directly help say tomorrow or Monday.
No, no not at all
No no, seriously I know just enough about Drupal, and what if calls for, to get myself in big trouble. Especially when it involves manipulating code, databases or anything else besides admin work. I also appreciate any help that comes my way and wish I knew more so I could be more helpful in return. Just frustrated, and again spending an inordinate amount of time trying to fix it.
Since a number of these
Since a number of these modules have had the problem, and some folks on the forums called this a core problem while others say no, would the procedure for upgrading now be having to go through every menu item to make sure the error does not show up? It seems to be pages with multiple sub-menu links.