# |
Feb 2nd 2018, 16:22 |
urowe |
Hi guys, do you have any idea why I'm getting this message: Cache engine Cake\Cache\Engine\FileEngine is not properly configured. |
# |
Feb 2nd 2018, 15:26 |
learningcake |
okay, gracia. merci. |
# |
Feb 2nd 2018, 15:10 |
hmic |
this is why you dont develop on these systems but build a vm to match you target production system as close as possible |
# |
Feb 2nd 2018, 15:10 |
hmic |
and/or your mysql config is set to be case insensitive |
# |
Feb 2nd 2018, 15:09 |
hmic |
learningcake, because the filesystem on your local system is case insensitive |
# |
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 |