CiviCRM Community Forums (archive)

Using on-line event registration, hitting continue on confirmation screen, I get a DB table missing error. 

Can anyone tell me what table is missing or how to determine this. 

I really do not want to reinstall and have to rebuild everything. 

Thanks

Jonathan

screen shot attached - no details were available under the "twistie"

I think the following is what you are looking for.  And now seeing this, I can give you a clue ...


I created a custom profile with a "release agreement" field.  However I have cloned/reinstalled enough times since I created it, that it
is easy for me to imagine that something got lost in the shuffling.  Is the fix likely to be as simple as going back and recreating the field and profile?

Thanks
Jonathan


                                        <div class="crm-section">Database Error Code: Table 'xperment.civicrm_value_releaseagreement_1' doesn't exist, 1146</div>
                                        <div class="crm-section">Additional Details: <p><pre>Array
(
    [callback] =&gt; Array
        (
           

• =&gt; CRM_Core_Error
[1] =&gt; handle
        )

   

=> -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] =>
ALTER TABLE civicrm_value_releaseagreement_1
MODIFY      agreecheckbox_2 varchar( 4 )
             NOT NULL
 [nativecode=1146 ** Table 'xperment.civicrm_value_releaseagreement_1' doesn't exist]
    [type] => DB_Error
    [user_info] =>
ALTER TABLE civicrm_value_releaseagreement_1
MODIFY      agreecheckbox_2 varchar( 4 )
             NOT NULL
 [nativecode=1146 ** Table 'xperment.civicrm_value_releaseagreement_1' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="
ALTER TABLE civicrm_value_releaseagreement_1
MODIFY      agreecheckbox_2 varchar( 4 )
             NOT NULL
 [nativecode=1146 ** Table 'xperment.civicrm_value_releaseagreement_1' doesn't exist]"]
)
</pre></p><p></p></div>
                     </div><

Donald -

civicrm_custom_group has one record, id 1, name ReleaseAgreement, extends individual, table name civicrm_value_releaseagreement_1

there is record in civicrm_custom_field that relates to the above-referenced record

there is no civicrm_value_* table in the db (nor in any other db I have)

So how did I clone? - badly.

It is a long story - tragic, informative, funny or something else .... you will have to let me know how it strkes you. 

I started out with just Joomla, and being in a learning phase, thought it was appropriate to backup sites, and create branches.

Tried X-cloner (useless) and one other forgotten package.  Then tried Akeeba/Kickstart; had issues, got some (plainly annoyed) help from the package's author who thought his documentation was completely lucid.  Struggled through two issues before sorting out what Akeeba was meant to do.  Then found out that Akeeba gags on thumb.db files (the Windows Explorer cache of reduced-to-desktop-size graphic images) and gave up as I concluded I could copy the subfolder of WWW and the MySQL isam files using Windows explorer, fix three settings in Joomla and I was good.  This worked fine. 
Then I installed CiviCRM and (being ignorant of the innodb BLOBs) thought that my cloning procedure was still working. 
Then everything CiviCRM got messed up and I realized the deficiency of my cloning procedure.  I was also tripping over some bugs in 3.3.3 and followed the advice to go to 3.4.8, after which I followed the real civicrm cloning procedure, which I thought had worked until I hit the current problem. 

Jonathan