| # |
Feb 2nd 2018, 14:55 |
 neon1024 |
..and you have a table in your database called “Carts” ? |
| # |
Feb 2nd 2018, 14:55 |
learningcake |
$this->setTable('Carts'); |
| # |
Feb 2nd 2018, 14:55 |
neon1024 |
Or maybe `table()` if you’re pre 3.4 |
| # |
Feb 2nd 2018, 14:54 |
learningcake |
checking |
| # |
Feb 2nd 2018, 14:54 |
neon1024 |
In your `CartsTable.php` what does your `setTable()` method call look like? |
| # |
Feb 2nd 2018, 14:54 |
learningcake |
ok. thank you Gurus |
| # |
Feb 2nd 2018, 14:53 |
neon1024 |
Just, yeah, what hmic said :P |
| # |
Feb 2nd 2018, 14:53 |
neon1024 |
So a table with a dot in will never exist, as hmic said |
| # |
Feb 2nd 2018, 14:53 |
learningcake |
mysql |
| # |
Feb 2nd 2018, 14:53 |
neon1024 |
Well, just as hmic said, what you’ve got there is `database.table` |
| # |
Feb 2nd 2018, 14:53 |
learningcake |
is it case sensitive? |
| # |
Feb 2nd 2018, 14:53 |
learningcake |
yea, it is called carts |
| # |
Feb 2nd 2018, 14:52 |
learningcake |
but their is not . there |
| # |
Feb 2nd 2018, 14:52 |
neon1024 |
Perhaps it’s a Microsoft database |
| # |
Feb 2nd 2018, 14:52 |
neon1024 |
I bet the table in your `siscomed_amplifyhub` is called `carts` and not `Carts` |
| # |
Feb 2nd 2018, 14:52 |
hmic |
better setup a second datasource in the config and switch the table to use this other datasource |
| # |
Feb 2nd 2018, 14:51 |
hmic |
and you do not want to access multiple databases this way, even if your setup and user allows to |
| # |
Feb 2nd 2018, 14:50 |
hmic |
it is used as the database seperator |
| # |
Feb 2nd 2018, 14:50 |
hmic |
you can't have . in a tablename in mysql |
| # |
Feb 2nd 2018, 14:50 |
hmic |
it does not |
| # |
Feb 2nd 2018, 14:50 |
hmic |
learningcake: like the error tells |
| # |
Feb 2nd 2018, 14:50 |
learningcake |
Take exist in the database so I wonder why I am getting this error |
| # |
Feb 2nd 2018, 14:50 |
learningcake |
Hello guys, what do you think is the cause of this error: Error: [Cake\Database\Exception] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'siscomed_amplifyhub.Carts' doesn't exist |
| # |
Feb 2nd 2018, 14:48 |
neon1024 |
I’m using empty, but it’s submitting an empty value in my post data, which in turn fails validation when being patched. I can obviously check in the request data and unset it, but is there a Better Way (tm) |
| # |
Feb 2nd 2018, 14:47 |
neon1024 |
Is there a neat way to make a dropdown totally optional? |
| # |
Feb 2nd 2018, 14:43 |
neon1024 |
:) |
| # |
Feb 2nd 2018, 14:43 |
hmic |
lets see what of a community i can kick off, maybe 2020 cakefest will be hosted in hong kong :P |
| # |
Feb 2nd 2018, 14:43 |
neon1024 |
Totally failed to go and visit her and she’s coming home in the summer |
| # |
Feb 2nd 2018, 14:43 |
neon1024 |
My cousin teaches at an international school in Shanghai |
| # |
Feb 2nd 2018, 14:43 |
neon1024 |
I would like to visit Asia |
| # |
Feb 2nd 2018, 14:42 |
neon1024 |
Closest I’ve ever gotten to Hong Kong is playing Sleeping Dogs on my PC |
| # |
Feb 2nd 2018, 14:42 |
hmic |
you certainly helped a lot in this regard neon1024 :) |
| # |
Feb 2nd 2018, 14:42 |
hmic |
so english and mandarin is a sure bet and you dont need to learn that other "dialect", nobody else understands :D |
| # |
Feb 2nd 2018, 14:41 |
neon1024 |
:P |
| # |
Feb 2nd 2018, 14:41 |
neon1024 |
Yeah, you’re welcome |
| # |
Feb 2nd 2018, 14:41 |
hmic |
most hong kong ppl can either speak mandarin as well, because they came from the mainland in the last 20 years, or they can speak english as well, becasue they are there longer than that... |
| # |
Feb 2nd 2018, 14:40 |
hmic |
absolutely |
| # |
Feb 2nd 2018, 14:40 |
neon1024 |
I mean, I’d learn Mandarin as well. More useful as a language I’d imagine |
| # |
Feb 2nd 2018, 14:39 |
hmic |
yes, they do. |
| # |
Feb 2nd 2018, 14:39 |
hmic |
maybe i start building a cakephp community there, which might want to translate the things... |
| # |
Feb 2nd 2018, 14:39 |
neon1024 |
But doesn’t Hong Kong speak Cantonese predominantly ? |