Skip to content

Instantly share code, notes, and snippets.

@guinslym
Last active January 2, 2016 13:39
Show Gist options
  • Save guinslym/8311841 to your computer and use it in GitHub Desktop.
Save guinslym/8311841 to your computer and use it in GitHub Desktop.
database cakephp errors
<div class="configurations form">
<?php echo $this->Form->create('Configuration', array('type' => 'file')); ?>
<fieldset>
<legend><?php echo __('Edit Configuration'); ?></legend>
<?php
echo $this->Form->input('id');
echo $this->Form->input('username');
echo $this->Form->input('profession');
echo $this->Form->input('description', array('type' => 'textarea','label' => 'Content of this Article', 'rows' => '10', 'cols' => '120'));
echo $this->Form->input('userphoto', array('type' => 'file'));
echo $this->Form->input('tel_mobile');
echo $this->Form->input('address');
?>
</fieldset>
<?php echo $this->Form->end(__('Submit')); ?>
</div>
<div class="actions">
<h3><?php echo __('Actions'); ?></h3>
<ul>
<li><?php echo $this->Form->postLink(__('Delete'), array('action' => 'delete', $this->Form->value('Configuration.id')), null, __('Are you sure you want to delete # %s?', $this->Form->value('Configuration.id'))); ?></li>
<li><?php echo $this->Html->link(__('List Configurations'), array('action' => 'index')); ?></li>
</ul>
</div>
Database Error
Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Array' in 'field list'
SQL Query: UPDATE `mongexc_cake214`.`configurations` SET `id` = 1, `username` = 'bill clinton', `profession` = 'president', `description` = 'Ob Jones-D is a Thai Massage and Electronic Acupuncture Specialist. Lorem ipsum dolor sit amet, consectetur adipisicing elit. Quam, repellat optio officiis neque ea repudiandae sint corrupti illo? Maiores adipisci mollitia quae perferendis numquam minima deserunt ratione placeat rem. Numquam?', `tel_mobile` = '000-000-0000', `address` = '000 new york of africa V99 999', `userphoto` = Array WHERE `mongexc_cake214`.`configurations`.`id` = '1'
Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp
@guinslym
Copy link
Author

guinslym commented Jan 8, 2014

guinslym, thats because your 'userphoto' field is a file input. upon submission file field send an array of data

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment