18 replies [Last post]
Nice Deli's picture
Offline
Joined: 11/05/2009
Juice: 124
Was this information Helpful?

PLEASE SOMEONE RESPOND, SOMEONE MUST HAVE AN IDEA OD WHAT I CAN DO. I have flushed the caches, run cron and updates numerous times, disabled unessential modules, but still nothing, our site has been offline all day could someone lease give me some advice???

warning: array_keys() [function.array-keys]: The first argument should be an array in /home/nicedel1/public_html/main/includes/common.inc on line 3360.
warning: Invalid argument supplied for foreach() in /home/nicedel1/public_html/main/includes/common.inc on line 3363.
warning: array_keys() [function.array-keys]: The first argument should be an array in /home/nicedel1/public_html/main/includes/common.inc on line 3360.

this repeats a dozen times, it only started showing up after we moved to a new server on with the same hosting service. none of the products are showing up within each of the catalogs....

PLEASE HELP!!!

zeezhao's picture
Offline
Joined: 04/23/2008
Juice: 969
Some suggestions: - try

Some suggestions:

- try switching to garland theme, and then back to your theme, to see if issue with theme.

- check admin/settings/file-system - to ensure filesystem setup correctly.

- check: admin/reports/status - to see if any error messages.

Nice Deli's picture
Offline
Joined: 11/05/2009
Juice: 124
Re: Some suggestions: - try

Thank you for the suggestions:

#1 has the same errors (repeated more than below)

warning: include_once(modules/modules/node/node.admin.inc) [function.include-once]: failed to open stream: No such file or directory in /home/nicedel1/public_html/main/includes/theme.inc on line 283.
warning: include_once() [function.include]: Failed opening 'modules/modules/node/node.admin.inc' for inclusion (include_path='.:/usr/lib/php') in /home/nicedel1/public_html/main/includes/theme.inc on line 283.

#2 File system path: sites/default/files Temporary directory: /tmp set to public (looks normal to me)

#3 I've run reports but don't see anything that should be causing this, i've updated all the modules etc:

Drupal 6.16
Access to update.php Protected
CSS Gzip Files directory is writable and server is using public downloads
CTools CSS Cache Exists
Configuration file Protected
Cron maintenance tasks Last run 58 min 20 sec ago
You can run cron manually.
Database updates Up to date
Drupal core update status No update data available
No information is available about potential new releases for currently installed modules and themes. To check for updates, you may need to run cron or you can check manually. Please note that checking for available updates can take a long time, so please be patient.
File system Writable (public download method)
GD library bundled (2.0.34 compatible)
GD library bundled (2.0.34 compatible)
Image FUpload Missing or wrong files in subdirectory "swfupload"
Some needed files which are not bundled with this module, are missing or out-of-date! This can be either "swfupload.swf", "swfupload.js" or "swfupload.queue.js" which should be located in "modules/image_fupload/swfupload/". These files can be downloaded from SWFUploads project page. Note: Version 2.2.0 or higher is needed.
Image import Import directory has not been configured.
The import directory must be configured and exist in order for the Image import module to function.
Image module directories Exists (sites/default/files/images).
Image toolkit The gd toolkit is installed.
ImageMagick advanced options ImageMagick image toolkit is not properly installed
The modules/image/image.imagemagick.inc file must be copied to includes in order for the ImageMagick image toolkit to function.
MySQL database 5.0.90
MySQL max_allowed_packet limit 5 MB
MySQL: max_join_size -1
MySQL: sql_big_selects 1
MySQL: sql_mode
MySQL: wait_timeout 40
PHP 5.2.12
PHP memory limit 128M
PHP register globals Disabled
Unicode library PHP Mbstring Extension
Update notifications Enabled
Upload progress Not enabled
Your server is capable of displaying file upload progress, but does not have the required libraries. It is recommended to install the PECL uploadprogress library (preferred) or to install APC.
Web server Apache
jQuery Update 1.2.6

Any other suggestions would be greatly appreciated. Someone on drupal pointed that the fatal error message had duplicates i.e. modules/modules/forums/forums:

Fatal error: require_once() [function.require]: Failed opening required 'modules/modules/forum/forum.pages.inc' (include_path='.:/usr/lib/php') in /home/nicedel1/public_html/main/includes/menu.inc on line 346

Thanks!

zeezhao's picture
Offline
Joined: 04/23/2008
Juice: 969
Re: Re: Some suggestions: - try

Also check your settings.php in sites/default directory. Make sure no entries put in specific to old environment.

Maybe the forums module is duplicated in one of the directories. You can find that by doing a search on your directories e.g. using "find" in unix.

Apart from that, no more suggestions for now...

GreyHawk's picture
Offline
Joined: 03/17/2009
Juice: 174
Check my other item

I responded to your other post here; had similar issues, and shared how we approached and resolved 'em.

Good luck.

Nice Deli's picture
Offline
Joined: 11/05/2009
Juice: 124
Re: Check my other item

tried everything except replacing all the folders, did a restore from a backup, lost some data but luckily we have customer orders in our email.

Thanks for the responses~

Nice Deli's picture
Offline
Joined: 11/05/2009
Juice: 124
Re: Re: Check my other item

Spoke too soon! Everything has been fine all day since the site was restored from backup, the only things I've done are alter the taxonomy(move some products, change pictures) and add new products/pics. Then I flushed the caches and BANG the same problem has reoccurred and even worse than before with a string of warning/ errors a DOZEN pages long!

I honestly don't know what to do with this mess, feel like packing it in, can;t deal with the stress of maintaining drupal/ubercart....

warning: array_keys() [function.array-keys]: The first argument should be an array in /home/nicedel1/public_html/main/includes/common.inc on line 3350.
Backtrace: array_keys(a:1:{i:0;N;})[common.inc:3350] <=drupal_schema_fields_sql(a:2:{i:0;s:4:"node";i:1;s:1:"n";})[node.module:735] <=node_load(a:1:{i:0;s:3:"107";})[uc_order.module:1434] <=uc_order_get_total(...)[uc_order.line_item.inc:23] <=uc_line_item_subtotal(...)[uc_order.module:1237] <=uc_order_load_line_items(...)[uc_order.module:1124] <=uc_order_load(a:1:{i:0;s:3:"245";})[menu.inc:410] <=_menu_load_objects(...)[menu.inc:566] <=_menu_translate(...)[menu.inc:316] <=menu_get_item(a:1:{i:0;N;})[menu.inc:343] <=menu_execute_active_handler(a:0:{})[index.php:18] <=index.php

GreyHawk's picture
Offline
Joined: 03/17/2009
Juice: 174
Weird...have you run a cron?

Maybe reindexing will help -- not holding my breath, but might be worth it.

Quick Questions:

1. Are you running with a customized theme?
2. Have you ensured that all the modules you need are activated and checked the update status to ensure that you've got all the latest modules?
3. What versions of Drupal, Ubercart are you running?
4. Are you running any dev modules?
5. Which ubercart modules are you running?
6. What version of CCK and Views are you running?

...this info might help folks discern the problem.

This is why I asked about the custom theme:

http://drupal.org/node/665998 (http://drupal.org/node/665998#comment-2768754)

(use the 2nd URL, in parens, to get to the meat of the matter) ... apparently, webchick had an issue that was a result of a difference between a theme .info name and the actual machine name.

GreyHawk's picture
Offline
Joined: 03/17/2009
Juice: 174
Two other elements:

Are you running "Bazaar" or "Who Bought What"? (I found a previous issue from 2009 re: WBW -- wasn't sure if you'd given it another go)

Here's the links:

Bazaar (may be an older version of UC, so may not apply to you)
http://www.ubercart.org/forum/bug_reports/3332/unable_create_products
http://www.ubercart.org/issue/3397/array_keys_errors_until_catalog_enabled

The prior issue you'd hit with "Who Bought What"
http://www.ubercart.org/forum/support/14032/major_errors

Also, over on Drupal, some reports from March 30th of this year from a couple different folks in this thread:
http://drupal.org/node/442312

And regarding Pollfield:
http://drupal.org/node/733578

...which leads me to ask: have you added any new modules recently, or relatively recently which then required some type of update? If you recently updated the Views module, for example, you should throw the site into maintenance mode, toast the Views folder and re-upload the updated Views module, then run update.php and check your status again.

Nice Deli's picture
Offline
Joined: 11/05/2009
Juice: 124
Hi Thanks again for the

Hi

Thanks again for the thorough response, went over the suggested problems you mentioned, and it doesn't seem to be related to those. Basically I' haven't installed any new modules for several weeks, and everything was updated to the latest version about 2 weeks ago, I've been too busy to work on the site. Last weekend the site was moving at a snails pace and getting time outs and was completely down a lot of the time. After going back and forth with my hosting services tech folks they determined it was my ISP causing it (I confirmed this), so the site was moved to another server, but it proved to be about the same so after running a bunch of tracerts I chose another server. After moving to this server the site was nice and fast but riddled with the aforementioned warnings/errors.

I realized today that I am still able to access my cpanel on both of the earlier sever locations/addresses as well as the new one, and I think this may be the reason for the duplicate or fatal error message:

warning: include_once(modules/modules/node/node.admin.inc) [function.include-once]: failed to open stream: No such file or directory in /home/nicedel1/public_html/main/includes/theme.inc on line 283.
Backtrace: _theme_process_registry()[theme.inc:283] <=_theme_process_registry(...)[theme.inc:399] <=_theme_build_registry(...)[theme.inc:225] <=_theme_load_registry(...)[theme.inc:179] <=_init_theme(...)[theme.inc:59] <=init_theme(a:0:{})[theme.inc:738] <=path_to_theme(a:0:{})[fckeditor.module:1153] <=fckeditor_path_to_theme(a:0:{})[fckeditor.module:521] <=fckeditor_process_textarea(...)[form.inc:1056] <=_form_builder_handle_input_element(...)[form.inc:882] <=form_builder(...)[form.inc:923] <=form_builder(...)[form.inc:400] <=drupal_process_form(...)[form.inc:119] <=drupal_get_form(a:1:{i:0;s:32:"system_site_maintenance_settings";})[?:?] <=call_user_func_array(...)[menu.inc:348] <=menu_execute_active_handler(a:0:{})[index.php:18] <=index.php

awaiting a response from them...

GreyHawk's picture
Offline
Joined: 03/17/2009
Juice: 174
Prior host...

...the problems you describe with slowdowns and unresponsiveness sounds very much like the reason I just moved my client's site.

Who was the host? Mine was iPower.

Another question just came to mind, too -- what was the PHP version...is it the latest, or an earlier version of PHP5? I'm wondering if that might make a difference...particularly if the php on the prior host was slightly newer than on the new/current host...

...nevermind the stuff I struck out...I found your PHP version listed at the top after replying...

Nice Deli's picture
Offline
Joined: 11/05/2009
Juice: 124
Re: Prior host...

My hosting service is 'justhost', they just responded and said the site is pointing to the correct server, not sure where to go from here. I'm thinking of uninstalling Drupal from my database then doing a fresh installation and then just uploading my backups of ubercart and my Energetic theme, maybe that will work??

GreyHawk's picture
Offline
Joined: 03/17/2009
Juice: 174
Can you try the following...

Can you try the following:

1. Temporarily turn off your theme; switch to Garland or something
2. Run update.php
3. Run cron
4. See if you get the same errors

Something has to be interfering. Whether it's data in the db or code from a module or theme, there's got to be a conflict somewhere.

The problem is that you can't resolve the issue simply with a rollback / restore -- you've already done that.

So, either "bad data" got loaded after your last/most recent restore (i.e., you restored stuff, then started operating as usual and entered in records from email to catch back up on orders, and some funky character got loaded) or something you've got loaded in module, core code or theme is causing an escalating error.

Easiest thing to try for right now, turn off your theme as a test. See if a generic core theme causes issues. (While doing this, maybe also double check data that was recently entered to see if any of it had funky or reserved characters.)

I don't know how customized the theme is, but hopefully it's not an end-of-the-world-if-it's-my-theme kind of thing.

GreyHawk's picture
Offline
Joined: 03/17/2009
Juice: 174
'Nother thought...

When you moved to the new site, did you copy the existing Drupal core code from the OLD server to the new, or did you create a fresh Drupal install and simply import the DB and then add freshly downloaded modules?

Anything that may have been copied directly from the old server -- given the response and performance issues -- is something I'd regard as suspect, and my own recent experience underscores that there is an increased likelihood of corruption from copied elements.

When I did the DB backup/restore, I used the backup and migrate module and was sure to exclude cache and session table data (not the tables themselves, but the data within them). That was a fairly clean file, so when I got the plethora of errors I knew that it was likely code that was copied directly. I was able to verify this, and since I'd started with a fresh base Drupal install I knew that my modules/themes were the only possible issues. I checked, and sure enough there were missing files and corrupt ones.

If file corruption is a possibility, then backups of those modules may have their own (and slightly different) corruption, as they came from the poorly performing old host server.

So, that would mean refresh your files with fresh downloads...hopefully, you didn't modify any core or contributed modules, or if you did you've retained an original copy so that you don't have to use backed-up and possibly corrupt files.

Nice Deli's picture
Offline
Joined: 11/05/2009
Juice: 124
Re: 'Nother thought...

Ok, thanks for the detailed reply! The theme can be reconfigured it wasn't really altered that much. My main concern is keeping all the customer/order/product/catalog data and I'm not sure where all of it is.

If I install a fresh drupal and ubercart, what files from my old backup do I need to restore all my customer/user accounts and our catalogs/products?

Thanks again~

GreyHawk's picture
Offline
Joined: 03/17/2009
Juice: 174
The best option, imo...

I don't know what your old backup consists of, but what I'd recommend is, if you believe that most of your data is currently in the database, add the backup and migrate module and export the database. You'll get a text file of the tables and contents with all the data; the file will end with a .sql extension. You'll need to exclude data from a few tables (but not tables themselves) in order to bring it up cleanly -- cache tables mostly.

Most of the tables should already be selected. Here's a reference point that I found Drupal.org.

You'll want to have the same modules (freshly downloaded, I'm presuming) set up on the new DB that you'll be importing into, and have the Backup and Migrate module installed on it as well so that you can import the data.

You can hit my company site @ http://services.realmquests.com or email me at realmquests at gmail dot com if you want to touch base and exchange phone numbers if you think you'd like the additional help, tho I dunno where you're located (we could Skype, tho). I'm located just south of the Boston, MA area, USA (east coast).

GreyHawk's picture
Offline
Joined: 03/17/2009
Juice: 174
'Nother really good link

Definitely read through this link about migrating a Drupal site.

GreyHawk's picture
Offline
Joined: 03/17/2009
Juice: 174
Looks like you're back!

Hey, looks like you're back!

How's the site working...? Any problems...? ~fingers crossed~

Nice Deli's picture
Offline
Joined: 11/05/2009
Juice: 124
thanks!

Yes after trying to migrate different folders manually (before I read your last post), I was still getting the errors and cound't restore customer accounts and our products.

So I went to an even older backup and things seem ok, but I'm afraid to alter or do anything with the site lest the same thing happen again the next time I flush the cache or run cron. Where would be a good place to look for the corrupt or troublesome data? You mentioned it could be in the cache tables? I'm hoping it isn't in this backup as it is older than the start of the initial problems, we lost a of of customer/order/ user data but not have the site running was causing us to lose new orders and users signing up.

Really appreciate your concern and help, I'm in Korea and there is basically no one here I can go to in person, Koreans by-and-large use a totally different approach (centered around IE6!!) to web design and don't even know Drupal.

I'm not going to change or update anything for the time being and try to figure out where the problem could be and let our customers see that we are up and running again.

Thanks again for the advice and help!