Well, I've overextended while upgrading my Drupal site. Now there are a bunch of problems that have been springing up, and I don't know how to fix them.
Here's the story from part 1:
I started off with a Drupal site from version 4.6.3. I have about 100 users, 2000 nodes, and 100 node types. Needless to say, I wasn't eager to make a mistake and build up from ground zero again.
My original site was located at www.omegaseye.com/drupal, but I wanted to change that. When I upgraded to version 4.7, I put the new files in the root.
After some uninstalling and reinstalling, and a bit of theme-changing on the side, I got my new Drupal installed at www.omegaseye.com. However, some big problems have been popping up:
First: On the home page, I get these errors:
* warning: array_keys(): The first argument should be an array in /home/oadmin/public_html/modules/user.module on line 348.
* warning: implode(): Bad arguments. in /home/oadmin/public_html/modules/user.module on line 348.
* user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 query: SELECT DISTINCT(p.perm) FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN () in /home/oadmin/public_html/includes/database.mysql.inc on line 120.
* warning: array_keys(): The first argument should be an array in /home/oadmin/public_html/modules/user.module on line 348.
* warning: implode(): Bad arguments. in /home/oadmin/public_html/modules/user.module on line 348.
* user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 query: SELECT DISTINCT(p.perm) FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN () in /home/oadmin/public_html/includes/database.mysql.inc on line 120.
The errors, which each repeat twice, concern a) a MySQL error, and two problems with user.module. I have no clue as to why either of these would have popped up, so I'm wondering: how does user.module get errors in the first place?
Second: My users are having problems with getting to pages: they report a "Page Not Found" when they go to many pages. Now, at first I thought this was a "relative" problem: the relative links linking their buttons AFTER the already-existing tabs. However, when I send them a DIRECT link to the page, they still can't see it. This happens with the frint page on occasion, and is the biggest problem I have thus far.
There are a few more errors, but these are the ones I'm most concerned with. Can anybody help me with these at all?
Comments
Update
One more thing: the excerpt length is stuck at 100 characters. Any fix for this?
ronoxQ, My first suggestion
ronoxQ,
My first suggestion would be to start from the beginning. Deal with one problem at a time. Take the home page SQL error problem first.
1. Make sure all your base files are at either the latest CVS versions or at least on one of the RC's (preferably RC3)
2. If possible, check that all your contrib modules and files are also on the appropriate (latest) versions
3. Get to a point where you can consistently produce the error (sounds like you might be there already).
4. Open admin/modules in a different browser and start switching off your contrib modules one at a time. After each one, go back to your home page and refresh it. You may need to do this a couple of times depending on what caching you have.
This should help you identify the problem module(s) or at least narrow it down. Once you've got that far, post back here the problem module - or go check the forums and issues for that module and see if anyone else has the same problem.
Hope that helps get you started.
Regards
Patrick Nelson
=================================================================
All truth goes through three stages:
- First, it is ridiculed,
- Then it is violently opposed,
- And finally it is accepted as self-evident
Fixed!
...Except for the excerpts, which I think isn't a glitch so much as a silly-Ray-can't-find-that-option-in-4.7.
The problems:
1) PrivateMSG.module reports the above errors.
2) Any subscription module causes Flexinode module (both in cvs) to bring up 10 error messages.
No, this is a documented bug
No, this is a documented bug with Flexinode 4.7
http://drupal.org/node/52754