| # |
Jun 23rd 2019, 19:39 |
 vossen.steven |
@madbbb ok ty, I'll have to check out my host then to see how I can access it |
| # |
Jun 23rd 2019, 19:39 |
vossen.steven |
I checked my db, it was only on the db not on the tables |
| # |
Jun 23rd 2019, 18:15 |
madbbb |
you always have access to mysql encoding settings on shared hosting |
| # |
Jun 23rd 2019, 18:15 |
niel45 |
@vossen.steven isn't utf8mb4 set on the individual database or table? |
| # |
Jun 23rd 2019, 18:01 |
vossen.steven |
figured it out with your help, I have to add this to my.ini `character-set-server = utf8mb4` how would one fix this if they don't have access to it though? |
| # |
Jun 23rd 2019, 17:31 |
slackebot |
encoding anymore in my code |
| # |
Jun 23rd 2019, 17:31 |
madbbb |
my seeds with Russian characters work fine with this settings: app.php Datasources['default']['encoding'] uses default utf8 and I use docker version of mysql 5.7.23 with override.cnf with this settings: ```[client] default-character-set = utf8mb4 [mysql] default-character-set = utf8mb4 [mysqld] character-set-client-handshake = FALSE character-set-server = utf8mb4 collation-server = utf8mb4_unicode_ci ``` I don't have to specify collation or |
| # |
Jun 23rd 2019, 17:17 |
vossen.steven |
cause as far as I know you can't pass a collation and I have no clue where it's getting it from |
| # |
Jun 23rd 2019, 17:16 |
vossen.steven |
and that doesn't fix the issue if you use newEntity either |
| # |
Jun 23rd 2019, 17:15 |
vossen.steven |
so if i do this ``` $data = ['charr' => 'ë']; $table = $this->table('test', ['collation' => 'utf8mb4_unicode_ci']); $table->insert($data)->save(); ``` it works fine, but it seems to me it shouldn't be like that, because if I change my datasource encoding I would have to change that as well |
| # |
Jun 23rd 2019, 17:10 |
vossen.steven |
if i pass `'collation' => 'utf8mb4_unicode_ci'` as option when I call $this->table in the seeder it works fine |
| # |
Jun 23rd 2019, 17:09 |
vossen.steven |
been reading the docs and I might have a solution |
| # |
Jun 23rd 2019, 17:08 |
vossen.steven |
both utf8mb4 |
| # |
Jun 23rd 2019, 17:02 |
madbbb |
@vossen.steven what's is your table collation and Datasource.encoding? |
| # |
Jun 23rd 2019, 15:49 |
slackebot |
object(Cake\ORM\Entity) { 'id' => (int) 2, 'charr' => 'ë', } ] ``` as you can see the seeder doesn't encode the data properly. |
| # |
Jun 23rd 2019, 15:49 |
vossen.steven |
Does anyone know how to get the seeder to encode data properly? I have the following test in my controller and a seeder ``` $testTable = TableRegistry::get('test'); $new = $testTable->newEntity([ 'charr' => 'ë', ]); $testTable->save($new); ``` now when I retrieve the data I get ``` [ (int) 0 => object(Cake\ORM\Entity) { 'id' => (int) 1, 'charr' => 'ë', }, (int) 1 => |
| # |
Jun 23rd 2019, 15:06 |
olanowsubomi |
hello, goodday. please can i asked some few questions concerning cakephp download |
| # |
Jun 23rd 2019, 08:23 |
challgren |
Does anyone have any pros vs cons for using CakePHP over .NET core? Client wants to use .NET and I want to persuade him otherwise |
| # |
Jun 22nd 2019, 19:14 |
joey.mukherjee |
Nevermind! I can just move my $userGroups into the function ($q)! Cool! |
| # |
Jun 22nd 2019, 19:11 |
slackebot1 |
return $q->where (['OR' => ['Groups.name' => 'public', 'Groups.id IN' => $userGroups]]); });``` These queries work independently. However, by doing a subquery, I get an `Undefined variable: userGroups` error. clearly userGroups is there in the line before. Any ideas? |
| # |
Jun 22nd 2019, 19:11 |
joey.mukherjee |
I've made some progress on my querying, but I'm having one more issue: ``` $userGroups = $this->Groups->find ()->select (['id']) ->matching ('MyUsers', function ($q) { return $q->where (['MyUsers.id' => $this->Auth->user ('id')]); }); $query = $this->Projects->find ()->select (['name']) ->matching ('Groups', function ($q) { |
| # |
Jun 22nd 2019, 19:04 |
madbbb |
and now all models' beforeMarshal event fire this listener. How do I connect to only InvoiceTable model? |
| # |
Jun 22nd 2019, 19:01 |
madbbb |
I want to move all my events to listener class to keep all callbacks in one place. bootstrap.php: $invoices = TableRegistry::get('Invoices'); $invoiceListener = new InvoiceListener(); EventManager::instance()->attach($invoiceListener); invoicelistener.php: class InvoiceListener implements EventListenerInterface { public function implementedEvents() { return [ 'Model.beforeMarshal' => 'test', ]; } |
| # |
Jun 22nd 2019, 18:52 |
Chetan |
Can anyone tell me, how to update cakephp 3.7.8 to 4.0 alpha 1 ? |
| # |
Jun 22nd 2019, 18:48 |
chetanvarshney |
Please help me, How to Update cakephp 3.7.8 to 4.0 alpha1 ?? |
| # |
Jun 22nd 2019, 18:47 |
chetanvarshney |
Hello |
| # |
Jun 22nd 2019, 16:43 |
joey.mukherjee |
Maybe this is easier: ``` $query = $this->Projects->find ()->select (['name'])->contain (['Groups']) ->innerJoinWith ('Groups', function ($q) { return $q->where (['Groups.name' => 'public']); })->all ();``` How do I also add the groups the user is part of to this query? |
| # |
Jun 22nd 2019, 16:37 |
joey.mukherjee |
I actually have both of them as "belongsToMany" since my users can be part of many groups and groups can have many users. But I guess what I am after is how to use "find" on something like this. Ideally, I want to join it with another table (Projects) but I can't even get the initial find to work. |
| # |
Jun 22nd 2019, 16:25 |
admad |
GroupsUsers belongsTo Users and belongsTo Groups, then contain them |
| # |
Jun 22nd 2019, 16:14 |
joey.mukherjee |
Can someone show me the CakePHP way of expressing this SQL statement: `select groups.id, groups.name from groups_users join users on users.id=groups_users.user_id join groups on groups.id=groups_users.group_id;` assuming I have my Model/Tables defined correctly? |
| # |
Jun 22nd 2019, 14:16 |
Demeter |
Hello |
| # |
Jun 22nd 2019, 12:08 |
slackebot1 |
for now |
| # |
Jun 22nd 2019, 12:08 |
bgrinter |
@challgren thanks - we actually use CakePDF now. Its more a function of the engine, CakePdf uses dompdf, Tcpdf and WkHtmlToPdf among others. From what I've read I should look at Tcpdf We're on CakePHP 2.x and planning to migrate to 3 so there's a bit of a backlog - this is a feature that'll only be used by a handful of users (although a vocal handful) so I might put on the back burner now. There's other features that'll offer more benefit |
| # |
Jun 22nd 2019, 11:59 |
challgren |
@bgrinter check out https://github.com/FriendsOfCake/CakePdf |
| # |
Jun 22nd 2019, 11:13 |
bgrinter |
Hi all - I'm currently using dompdf to create PDF documents in an app for a volunteer run youth group. One form we create is a parent permission form for events and I've had a request to have a form that the parent can sign with a digital signature. dompdf doesn't support this - does anyone have any experience with other PDF engines? I've heard TCPDF supports it |
| # |
Jun 22nd 2019, 07:06 |
madbbb |
Hello. I'm a little bit confused. When do you use CakePHP Event system and when model callbacks like afterSave? Should I put image uploading/processing in the event listener class when I save a post with an image attached to it? |
| # |
Jun 22nd 2019, 00:30 |
joey.mukherjee |
I have a belongsToMany association (Users and Groups - users can belong to many groups and groups can have many users). can someone give me an example of how to query the groups based on the user id? |
| # |
Jun 21st 2019, 23:30 |
rightscoreanalysis |
i did composer install before copying the site over |
| # |
Jun 21st 2019, 23:29 |
challgren |
ahh `composer install` should fix that |
| # |
Jun 21st 2019, 23:25 |
rightscoreanalysis |
thanks - it was the vendor directory which was wrong |
| # |
Jun 21st 2019, 23:18 |
mrfeedback |
and you could try to change debug level. maybe you get some output what happens :slightly_smiling_face: |