CiviCRM Community Forums (archive)

When I attempted to run either "http://<mysite.org>/civicrm/upgrade?reset=1" or "http://<your_drupal_home>/?q=civicrm/upgrade&reset=1" I got this error: "The requested page could not be found." I do have Clean URLs working. Drupal 6.14, MySQL 5.0.67.d7, PHP 5.2.8. I also tried it with the full path, same result.

Shouldn't there be a upgrade.php file in sites/all/modules/civicrm? There's only a civicrm.config.php file.

same thing here.

But I also get this error after uploading the 3.0 files - maybe this causes the missing update function:

Sorry. A non-recoverable error has occurred.

DB Error: no such field

Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => SELECT *
 FROM civicrm_preferences
 
 WHERE (  civicrm_preferences.domain_id = 1 )  AND (  civicrm_preferences.is_domain = 1 )
 
 
 
 [nativecode=1054 ** Unknown column 'civicrm_preferences.domain_id' in 'where clause']
    [type] => DB_Error
    [user_info] => SELECT *
 FROM civicrm_preferences
 
 WHERE (  civicrm_preferences.domain_id = 1 )  AND (  civicrm_preferences.is_domain = 1 )
 
 
 
 [nativecode=1054 ** Unknown column 'civicrm_preferences.domain_id' in 'where clause']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT *
 FROM civicrm_preferences
 
 WHERE (  civicrm_preferences.domain_id = 1 )  AND (  civicrm_preferences.is_domain = 1 )
 
 
 
 [nativecode=1054 ** Unknown column 'civicrm_preferences.domain_id' in 'where clause']"]
)
[/code]

For anyone having this problem (which I just did). I added this solution in the troubleshooting section of the upgrade page itself:

http://wiki.civicrm.org/confluence/display/CRMDOC/Upgrade+Drupal+Sites+to+3.0#UpgradeDrupalSitesto3.0-PageNotFounderror

Well thanks for making mention of it. I was just so frustrated at the amount of time it took me to find the solution, I figured I had to do something.

As with so much open source: great project, documentation needs some love...

I wrote this whole thing, and then thought it needed a little summation, so here's my thesis: You want more participation? You need to make it fun and easy to participate and you need more people on the system. In order to draw more people, the install and upgrade procedures need to be dreamy smooth and fast, and once it's installed a nutless monkey should be able to start adding data and using it right away (props to Tom Cruise in Tropic Thunder).

Here's the long version:
---
Wow. Great question - and one I'm just beginning to struggle with in my own work (http://govluv.org/), so I appreciate the opportunity to think it through.

I guess I'd say that there are a couple of things you can do, not that I'm an expert in any regard except as a frustrated user who solely uses open source software.

1. Make it easy to engage and fun. What's the benefit for someone to participate? Why would they come back? Sure, you have a great community and you're responsive, but it takes awhile for people to build up that feeling of camaraderie which drives them to participate just for the sake of doing so. In the meantime, you make it fun. Make the design great (on this site, not just after install). Make it easy to navigate and find what you need (you've done a pretty good job on this one). Make it fun. What sort of game can you make out of closing bugs? What sort of prizes can you award for making positive contributions to the documentation? What do you have at your disposal that will cost you little or nothing, but make a huge impact on an end user, and make them feel like they are part of a vibrant, growing community?

Have you considered adding social networking functionality? I don't know what software you're using for the forum or much about confluence, but even mediawiki has networking profiles complete with titles you can earn for making edits, friending, walls to write on - you know, a reason to hang around on the site - to come back, to visit, to see what's up.

Don't know if it's right for you, but it's an idea.

2. Power Law. 90% of the people will just download and read and use and never contribute. 9% of the people will comment (in this case, use the forums). 1% of the people will actively contribute to making it a better product (I'd be curious to know if these numbers are accurate for what you've seen). From that perspective, it's a straight numbers game and all you need to do is get more people!

How do you do that?

3. Easier setup. From my research, this is the biggest complaint about CiviCRM. You have all sorts of high end users (Amnesty International if I remember right - bravo!) and once it's installed, the functionality is amazing, but getting from A to B is awful. If there was another open source CRM out there, I wouldn't be using this simply because of the difficulties I had getting it installed.

And once it's up and running, I want to immediately grasp how to use it, enter my data and see benefit. Design is as important as functionality today, and design is what gets you intuitive interaction. I'm a geek from way back but today, if I have to think about how to do something, I will only stick with the software if I don't have another option. Eventually, it becomes intuitive but that's not how you get adoption.



I don't know if I've given you anything useful or just overwhelmed you with additional things for your todo list, but since you asked such a sincere question I was happy to take the time to answer it. I'm happy to continue this conversation if you like. Feel free to move it to a better spot on the forum or whatever is necessary.

Wayne