# |
Sep 22nd 2011, 16:49 |
TheWarden |
let me be more clear, the present tables I will be working with within this context all resides on the in the same database. |
# |
Sep 22nd 2011, 16:49 |
scoutmstershke |
have you tried just doing a query to make sure it has access to the db? |
# |
Sep 22nd 2011, 16:48 |
robcowie |
hello again |
# |
Sep 22nd 2011, 16:48 |
TheWarden |
For now yes as I move forward there will be cases that it will be in different database. |
# |
Sep 22nd 2011, 16:48 |
scoutmstershke |
same* |
# |
Sep 22nd 2011, 16:48 |
scoutmstershke |
? |
# |
Sep 22nd 2011, 16:48 |
scoutmstershke |
are the tables in the sma db |
# |
Sep 22nd 2011, 16:47 |
TheWarden |
well presently it is only one database... also keep in mind what you are looking at is a plugin and the database.php is from the app. Therefore this is why I require multiple. |
# |
Sep 22nd 2011, 16:47 |
ScottO_ |
and you only need an association in one db |
# |
Sep 22nd 2011, 16:47 |
TheWarden |
scoutmstershke: no I haven't actually. |
# |
Sep 22nd 2011, 16:47 |
ScottO_ |
but that example is across multiple datbases |
# |
Sep 22nd 2011, 16:46 |
ScottO_ |
TheWarden: you may need the 'with' key in the association |
# |
Sep 22nd 2011, 16:46 |
ScottO_ |
lol |
# |
Sep 22nd 2011, 16:46 |
scoutmstershke |
nvm im wrong anyway |
# |
Sep 22nd 2011, 16:45 |
ScottO_ |
scoutmstershke: he shouldnt need usesTable |
# |
Sep 22nd 2011, 16:45 |
scoutmstershke |
have you noticed youe $useTable is spelled wrong? |
# |
Sep 22nd 2011, 16:45 |
TheWarden |
scoutmstershke: the table is dongle_keys_hardwares there is not prefix of web_. It's not loading the model from what I can tell at all and I don't see any query going to MySQL when I do a <?php echo $this->element('sql_dump'); ?> for that other table. |
# |
Sep 22nd 2011, 16:45 |
ScottO_ |
TheWarden: http://www.foldifoldi.com/?p=436 |
# |
Sep 22nd 2011, 16:44 |
ScottO_ |
its not like you are trying to do an association across multi[ple databases |
# |
Sep 22nd 2011, 16:44 |
ScottO_ |
its an association on one db |
# |
Sep 22nd 2011, 16:43 |
scoutmstershke |
wtf never seen that error before |
# |
Sep 22nd 2011, 16:43 |
TheWarden |
scoutmstershke: I'm just trying to link a table to another table. When I add $hasMany the I get the error of "Error: Database table web_dongle_keys_hardwares for model DongleKeysHardware was not found." |
# |
Sep 22nd 2011, 16:43 |
ScottO_ |
TheWarden: its been done many times, and is fully capable of it |
# |
Sep 22nd 2011, 16:42 |
ScottO_ |
scoutmstershke: http://pastebin.com/wwTBcfn3 |
# |
Sep 22nd 2011, 16:42 |
TheWarden |
hopefully I figure out what I've done wrong soon else I guess I may just have to dump this framework... no fault I'm sure them my own but gotta have multiple databases and tables accessible. can't be stuck on this forever you know. |
# |
Sep 22nd 2011, 16:42 |
scoutmstershke |
whats your problem and what are you trying to do? |
# |
Sep 22nd 2011, 16:42 |
scoutmstershke |
yeah that happens sometimes |
# |
Sep 22nd 2011, 16:41 |
TheWarden |
I've talked to a few people here about my issue... I think the assumption is I'm being an idiot and not doing it right so leave him to figure it out and read the book and API. |
# |
Sep 22nd 2011, 16:41 |
scoutmstershke |
I've never used multiple databases so I'd be of little to no help |
# |
Sep 22nd 2011, 16:40 |
scoutmstershke |
did you ask nicely? |
# |
Sep 22nd 2011, 16:40 |
ScottO_ |
maybe someone else would like to shed light upon it |
# |
Sep 22nd 2011, 16:39 |
ScottO_ |
still not sure why its tyring to grab your default database though |
# |
Sep 22nd 2011, 16:39 |
ScottO_ |
this is why the conventions are important |
# |
Sep 22nd 2011, 16:39 |
ScottO_ |
because DongleKeysHardware is the singular camelcased inflection of the table name |
# |
Sep 22nd 2011, 16:38 |
ScottO_ |
TheWarden: thats why i said $usesTable is unnecessary |
# |
Sep 22nd 2011, 16:38 |
TheWarden |
ScottO_: oh okay. mm |
# |
Sep 22nd 2011, 16:37 |
ScottO_ |
TheWarden: no thats right |
# |
Sep 22nd 2011, 16:37 |
TheWarden |
in all honestly I don't know how to even use caching yet. |
# |
Sep 22nd 2011, 16:37 |
TheWarden |
ScottO_: no I don't. mm I believe I have $belongsTo wrong as that is to be the class name not the database table name. |
# |
Sep 22nd 2011, 16:37 |
ScottO_ |
TheWarden: i tihnk it may be caching the model |
# |
Sep 22nd 2011, 16:36 |
ScottO_ |
TheWarden: do you have caching turned on? |