Problem solved! Here's the explanation: http://stackoverflow.com/questions/1603575/mamp-and-cakephp-call-to-model-issue/1626179#1626179
On Oct 26, 11:59 am, fahd <fahd...@gmail.com> wrote: > This seems to not be related to MAMP as I thought before. Its > basically an issue with certain HABTM models not loading - and other > people seem to have the same problem. The solutions say it could be a > "typo" of the model names, but so far I haven't found any. Not sure if > anyone has found a solution to this - let me know if you do! > > Some related > discussions:http://groups.google.com/group/cake-php/browse_thread/thread/3a6998c1...http://groups.google.com/group/cake-php/browse_thread/thread/fa7a78b9...http://groups.google.com/group/cake-php/browse_thread/thread/bbea2a13...http://groups.google.com/group/cake-php/browse_thread/thread/f2d5632f... > > On Oct 21, 4:49 pm,fahd<fahd...@gmail.com> wrote: > > > Thanks for the answers. > > > I tried upgrading my CakePHP core to the latest 1.2.5 - but the > > problem didn't go away. The MySQL on MAMP (5.1.37) seems to be more up- > > to-date than my host MediaTemples (5.1.26-rc) ... which is concerning. > > > On Sep 25, 11:09 am, Martin Westin <martin.westin...@gmail.com> wrote: > > > > On 1 I second the opinion that vhosts are the way to go. I have never > > > ever ever bothered modifying htaccess files just to get a few apps to > > > run under localhost/one, /two and so on. You are on a Mac and in > > > perfect position to setup in a way that is 100% identical to a > > > production deployment. You need two things. vhosts in the apache conf > > > and fake hostnames for each vhost. > > > There might be a gui but I just edit the file /etc/hosts adding fake > > > names pointing to 127.0.0.1 > > > 127.0.0.1 one.site > > > 127.0.0.1 two.site > > > ... > > > That is very convenient. > > > > Managing vhosts were mentioned by Frederick. An alternative is to pay > > > for MAMP pro which has built-in support for vhosts and "advanced" > > > features. Personally I use Apples supplied Apache and PHP and install > > > MySQL as a pkg so I have no details to offer on vhosts in MAMP. > > > > Speaking of MySQL. Your second problem might be caused by differing > > > versions of MySQL if the errors apply only to certain queries. If they > > > are advanced as you say then they might require a more up-to-date > > > version than MAMP has. Either that or the version of Cake. > > > > And when reading the backtrace, the top line is closest to the error. > > > Cake is born in webroot and looking at the error MySQL has problems > > > interpreting __getUsersForUsers as a SQL syntax... which I can > > > understand. That indicates to me that your version of Cake might be > > > the problem. It looks like a bug in your code but if you are sure the > > > same code is executed without problem on another install then it may > > > be a version problem. > > > > /Martin > > > > On Sep 25, 3:58 pm, FrederickD <manzanillo.engl...@gmail.com> wrote: > > > > > HiFahd! > > > > > I can advise you on the first question, but not the second. I had been > > > > using MAMP but decided to take it off and go with a stock approach. It > > > > took a little bit, but works solidly now. What makes it very easy is > > > > to use a cheap product called VirtualHostX. You can find it > > > > athttp://www.macupdate.com/info.php/id/25689/virtualhostx. The price > > > > recently went up it appears, but it is so worth it to not be > > > > frustrated while developing multiple sites. VirtualHostX is MAMP- > > > > friendly. > > > > > I use it to have a sandbox site where I'm testing code and integration > > > > before moving that code over to the development site. Both can be up > > > > at the same time, obviously with different databases, but it could be > > > > the same one. Hmmm... > > > > > Anyway, I am also using a product called ModelBaker > > > > fromhttp://widgetpress.com > > > > that also is MAMP-friendly and removes the need to use a command line > > > > when baking. All the database design is visual and the configuration > > > > of Cake is a snap. It is a RAP (rapid application prototype) tool that > > > > does a great job at generating 80% of the Cake code so you can focus > > > > on the 20% that is unique to your application. Plus it can generate an > > > > iPhone-aware web application. That's like getting a two-for-one deal! > > > > Very promising product. > > > > > I hope some of this helps. > > > > > On Sep 24, 3:10 pm,fahd<fahd...@gmail.com> wrote: > > > > > > Hey fellow Cakers, > > > > > > I've been developing on CakePHP for a bit and decided to have a > > > > > localhost version on MAMP so that I could demo my app to people > > > > > without being dependent on an Internet connection. > > > > > > Ran into a few issues ofcourse and hoping someone can give some > > > > > insight: > > > > > > 1) I have several sites under the /Sites/ folder and I pointed MAMP's > > > > > Apache document root there. For example /Sites/project1/ is where the > > > > > Cake app sites. It finds the /project1/ site fine (after some > > > > > htaccess mods) but there are issues with relative links. Any link that > > > > > is manually coded and not using $html->link uses /Sites/ instead of / > > > > > Sites/project1/ as the base. This is for images and any Ajax calls > > > > > from jQuery. (css and js files are fine). The images I can bare, but > > > > > the site is unusable without Ajax. > > > > > > Temp solution: changed the document root to /Sites/project1/. This is > > > > > not ideal, but I'd like to know if you guys have a fix so I don't have > > > > > to change the document root all the time for previewing different > > > > > projects. > > > > > > 2) We have a lot of complex MySQL queries being made, using > > > > > $this->query('SELECT...'). We've placed these in the appropriate > > > > > models > > > > > > within a function. Hence from the Controller we'll have something like > > > > > $this->Users->getMeSomething($variable), that goes to the user.php > > > > > model and runs that function. This works fine on our live and dev > > > > > sites, but for some reason on MAMP I'm getting the error: > > > > > > Warning (512): SQL Error: 1064: You have an error in your SQL syntax; > > > > > check the manual that corresponds to your MySQL server version for the > > > > > right syntax to use near '__getUsersForUsers' at line 1 [CORE/cake/ > > > > > libs/model/datasources/dbo_source.php, line 525] > > > > > > The context: > > > > > ====== > > > > > DboSource::showQuery() - CORE/cake/libs/model/datasources/ > > > > > dbo_source.php, line 525 > > > > > DboSource::execute() - CORE/cake/libs/model/datasources/ > > > > > dbo_source.php, line 201 > > > > > DboSource::fetchAll() - CORE/cake/libs/model/datasources/ > > > > > dbo_source.php, line 336 > > > > > DboSource::query() - CORE/cake/libs/model/datasources/dbo_source.php, > > > > > line 297 > > > > > Model::call__() - CORE/cake/libs/model/model.php, line 441 > > > > > Overloadable::__call() - CORE/cake/libs/overloadable_php5.php, line 52 > > > > > AppModel::__getUsersForUsers() - [internal], line ?? > > > > > UsersController::view() - APP/controllers/users_controller.php, line > > > > > 401 > > > > > Object::dispatchMethod() - CORE/cake/libs/object.php, line 118 > > > > > Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 227 > > > > > Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194 > > > > > [main] - APP/webroot/index.php, line 88 > > > > > ====== > > > > > Line 88 on webroot is this: $Dispatcher->dispatch($url); > > > > > > Thanks for any help > > > > > >Fahd --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---