CiviCRM Community Forums (archive)

I am getting an error In the sandbox: Sorry but we are not able to provide this at the moment.

http://sandbox.drupal.civicrm.org/civicrm/admin/custom/group/field/add

When I create custom fields / add set of custom fields / set name   (gave it a name: more user info )  sandbox will change, but it's there now if you want to look.  I added a custom field 1, (it's there) but when I tried to add a second field I get:
Sorry but we are not able to provide this at the moment.

someone had the backtrace on, so I attached those results (see attachment)
On screen the more details are below:

any ideas???   


Error Details:
Database Error Code: 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 's name (ie yhow )'' at line 2, 1064
Additional Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -2
    [message] => DB Error: syntax error
    [mode] => 16
    [debug_info] =>         ALTER TABLE civicrm_value_more_user_info_4
        ADD COLUMN `other_8` varchar(255) DEFAULT 'friend's name (ie yhow )' [nativecode=1064 ** 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 's name (ie yhow )'' at line 2]
    [type] => DB_Error
    [user_info] =>         ALTER TABLE civicrm_value_more_user_info_4
        ADD COLUMN `other_8` varchar(255) DEFAULT 'friend's name (ie yhow )' [nativecode=1064 ** 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 's name (ie yhow )'' at line 2]
    [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="        ALTER TABLE civicrm_value_more_user_info_4
        ADD COLUMN `other_8` varchar(255) DEFAULT 'friend's name (ie yhow )' [nativecode=1064 ** 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 's name (ie yhow )'' at line 2]"]
)



Return to home page.


Thanks!  That's it!   (oops, I should say that is it    )