| # |
Jul 1st 2017, 14:16 |
 glanceded |
@dereuromark Interesting solution |
| # |
Jul 1st 2017, 14:15 |
glanceded |
@admad It works perfect now |
| # |
Jul 1st 2017, 13:49 |
dereuromark |
I think that one was more for normal binary blob data :slightly_smiling_face: |
| # |
Jul 1st 2017, 13:49 |
dereuromark |
binary16 would be best, but you would need to write your own type class here. I once tried https://github.com/dereuromark/cakephp-shim/blob/master/src/Database/Type/BinaryType.php not sure if it is actually still working though.. |
| # |
Jul 1st 2017, 13:39 |
glanceded |
ok, thanks a lot, I will give it a try |
| # |
Jul 1st 2017, 13:39 |
admad |
yes it will |
| # |
Jul 1st 2017, 13:39 |
admad |
so either native uid type (postgres) or char 36 for mysql etc |
| # |
Jul 1st 2017, 13:39 |
glanceded |
and it will create the uuid by it self if I set the collumn as char 36? |
| # |
Jul 1st 2017, 13:38 |
admad |
@glanceded you need to use the field type that cakephp supports |
| # |
Jul 1st 2017, 13:38 |
glanceded |
right now I'm creating the uuid manually |
| # |
Jul 1st 2017, 13:38 |
glanceded |
In addition to use an auto-increment key as the primary key, you may also use UUID columns. CakePHP will create a unique 36 character UUID (Cake\Utility\Text::uuid()) whenever you save a new record using the Table::save() method. |
| # |
Jul 1st 2017, 13:38 |
glanceded |
Yes , I respect the conventions, but I don't understand this p |
| # |
Jul 1st 2017, 13:34 |
glanceded |
the problem is only on my subscriptions table, as I have more tables with guids and they work well |
| # |
Jul 1st 2017, 13:34 |
cleptric |
> $user |
| # |
Jul 1st 2017, 13:33 |
glanceded |
char 36 is less in size than binary 36? |
| # |
Jul 1st 2017, 13:33 |
cleptric |
Should be `CHAR(36)` AFAIR |
| # |
Jul 1st 2017, 13:32 |
glanceded |
$this->setDisplayField('guid'); $this->setPrimaryKey('guid'); |
| # |
Jul 1st 2017, 13:32 |
glanceded |
binary 36 |
| # |
Jul 1st 2017, 13:32 |
admad |
what's the field type for gui in db? |
| # |
Jul 1st 2017, 13:31 |
cleptric |
I guid your primary key? |
| # |
Jul 1st 2017, 13:29 |
glanceded |
in db the guids are ok |
| # |
Jul 1st 2017, 13:29 |
glanceded |
all of my fields are accesibile |
| # |
Jul 1st 2017, 13:29 |
glanceded |
why the guid is a resource |
| # |
Jul 1st 2017, 13:28 |
slackebot |
{ 'time' => '2017-07-01T13:06:12+00:00', 'timezone' => 'UTC', 'fixedNowTime' => false } ] |
| # |
Jul 1st 2017, 13:28 |
glanceded |
[ 'guid' => resource, 'plan_id' => (int) 1, 'next_plan_id' => null, 'next_customer_token' => null, 'expiry' => object(Cake\I18n\FrozenTime) { 'time' => '2017-07-15T13:06:11+00:00', 'timezone' => 'UTC', 'fixedNowTime' => false }, 'transaction_guid' => null, 'created' => object(Cake\I18n\FrozenTime) { 'time' => '2017-07-01T13:06:12+00:00', 'timezone' => 'UTC', 'fixedNowTime' => false }, 'modified' => object(Cake\I1 |
| # |
Jul 1st 2017, 13:28 |
glanceded |
the result is this |
| # |
Jul 1st 2017, 13:28 |
glanceded |
thanks for that, I found out that find("first") doesn't exists anymore |
| # |
Jul 1st 2017, 13:28 |
admad |
if you want just 1 record then you should be using ->first() |
| # |
Jul 1st 2017, 13:28 |
glanceded |
I have removed ->all method, but the result is still the same |
| # |
Jul 1st 2017, 13:27 |
cleptric |
then you’ll get an array |
| # |
Jul 1st 2017, 13:27 |
cleptric |
Remove the `->all()` |
| # |
Jul 1st 2017, 13:26 |
glanceded |
$userData = $this->Partners ->find("all") ->where(['Partners.id' => $this->Auth->user('id')]) ->contain(['Websites', 'Plans', 'Subscriptions']) ->limit(1) ->all() ->toArray(); |
| # |
Jul 1st 2017, 13:26 |
glanceded |
I know, my query looks like this |
| # |
Jul 1st 2017, 13:25 |
admad |
find() never returns a field value |
| # |
Jul 1st 2017, 13:21 |
glanceded |
hello guys. Why is CakePHP returning "resource" instead of field value when making a find()? |
| # |
Jul 1st 2017, 11:53 |
marcusgoede |
ok, then i have to wait until monday. thank you! |
| # |
Jul 1st 2017, 11:53 |
admad |
ICU libs are indirectly used by php-intl extension |
| # |
Jul 1st 2017, 11:53 |
admad |
you have to update server software, nothing in composer.json |
| # |
Jul 1st 2017, 11:51 |
marcusgoede |
or do i have to update the server-software? because this is a managed server… |
| # |
Jul 1st 2017, 11:51 |
marcusgoede |
is do not require ICU libs in my composer.json anymore. is that correct? |
| # |
Jul 1st 2017, 11:50 |
admad |
@marcusgoede you need to update ICU libs |