CiviCRM Community Forums (archive)

I installed civicrm 2.1.2 (I think) and a few months later, decided to upgrade to 2.2.3. The install "went through" according to the display message but it completely borked my site - meaning whenever anyone clicked on an event link, I got mysql errors. Okay, my bad for running an install on a production environment (this is a pro bono gig for our community pool), but I had to get stuff fixed ASAP (nothing like it when the people screaming at you know where you live and where your kids go to school...).

So basically, whenever I got an error saying that it was missing this or that column from a table, I went ahead and added the column to the mysql db (yes I dumped the db first). And guess what? It worked! I got the main features of the site back operational again.

However, now I want to add a new contribution page. And it is telling me that an entire TABLE is missing. Crap. Error listed below.

   Sorry. A non-recoverable error has occurred.

    DB Error: no such table

    Database Error Code: Table 'joomla.civicrm_pcp' doesn't exist, 1146

    Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
            

• => CRM_Core_Error
[1] => handle
        )

    

Code: [Select]

=> -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] => SELECT  id, title  
 FROM civicrm_pcp
 
 WHERE (  civicrm_pcp.is_active = 1 )  
 
 
 ORDER BY title  
 [nativecode=1146 ** Table 'joomla.civicrm_pcp' doesn't exist]
    [type] => DB_Error
    [user_info] => SELECT  id, title  
 FROM civicrm_pcp
 
 WHERE (  civicrm_pcp.is_active = 1 )  
 
 
 ORDER BY title  
 [nativecode=1146 ** Table 'joomla.civicrm_pcp' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT  id, title  
 FROM civicrm_pcp
 
 WHERE (  civicrm_pcp.is_active = 1 )  
 
 
 ORDER BY title  
 [nativecode=1146 ** Table 'joomla.civicrm_pcp' doesn't exist]"]
)


 

Frankly, I'd be happy with the db schema to dump into the db, though I am sure this is just leading me deeper and deeper into a pit of hell. Whatever, they get what they pay for, right?

Note, I really really really do not want to do a clean install of this site - as I said above, it is a pro bono gig so my time to spend on this is limited. If I do need to do a clean install, it won't be this summer season.