| # |
Feb 2nd 2018, 15:08 |
learningcake |
thank you guys. But I wonder why it works on my localhost system but when I deploy it, started getting the problem. I push to git and clone it to the production server |
| # |
Feb 2nd 2018, 14:57 |
 neon1024 |
To quote American Dad “Bob is introduced in “Homeland Insecurity”, where he mentions his wife had passed away of “the big C” - when a giant letter ‘C’ from a sign had fallen on her.” |
| # |
Feb 2nd 2018, 14:56 |
hmic |
you just said yourself it's called carts |
| # |
Feb 2nd 2018, 14:56 |
neon1024 |
Do bear in mind that “Carts” and “carts” are not the same |
| # |
Feb 2nd 2018, 14:55 |
hmic |
so this table does not exist, like the error tells you |
| # |
Feb 2nd 2018, 14:55 |
learningcake |
yea |
| # |
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 |