Posted by laughnan on November 20, 2012 at 3:47am
When I got to submit a custom form that I created (the fields mentioned below DO exist...I promise) I get a 500 Site Error. Thoughts? Attached is the db setup, and below is the Drupal API db_insert method.
function mymodule_details_submit($form, &$form_state) {
$today = date("j/n/Y");
$data = db_insert('donate_data') // Table name no longer needs {}
->fields(array(
'firstname' => $form_state['values']['first'],
'lastname' => $form_state['values']['last'],
'email' => $form_state['values']['email'],
'street1' => $form_state['values']['street1'],
'city' => $form_state['values']['city'],
'state' => $form_state['values']['state'],
'zip' => $form_state['values']['zip'],
'amount' => $form_state['values']['amount'],
'datecreated' => $today,
))
->execute();
}Field Type Collation Attributes Null Default Extra Action
ID int(11) No None auto_increment
firstname varchar(100) utf8_general_ci No None
lastname varchar(100) utf8_general_ci No None
email varchar(65) utf8_general_ci No None
street1 varchar(65) utf8_general_ci No None
city varchar(65) utf8_general_ci No None
state varchar(65) utf8_general_ci No None
zip varchar(10) utf8_general_ci No None
amount varchar(11) utf8_general_ci No None
datecreated varchar(65) utf8_general_ci No None
Comments
The multi-site had a table
The multi-site had a table prefix and I was calling a table that didn't have the same prefix. Should have just read the site db logs... SMH.