Log message #4113818

# At Username Text
# 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
# 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...