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/3a6998c1813bd0fa/371f42ccdc65e0f2?lnk=gst&q=Warning+%28512%29%3A+SQL+Error%3A+1064%3A#371f42ccdc65e0f2 http://groups.google.com/group/cake-php/browse_thread/thread/fa7a78b9673cf52a/3c5ee99aa6f81e58?lnk=gst&q=Warning+%28512%29%3A+SQL+Error%3A+1064%3A#3c5ee99aa6f81e58 http://groups.google.com/group/cake-php/browse_thread/thread/bbea2a13a03006ef/3d95f19cc642d675?lnk=gst&q=Warning+%28512%29%3A+SQL+Error%3A+1064%3A#3d95f19cc642d675 http://groups.google.com/group/cake-php/browse_thread/thread/f2d5632fda77653c/ef1218c3ed2d8702?lnk=gst&q=Warning+%28512%29%3A+SQL+Error%3A+1064%3A#ef1218c3ed2d8702 On Oct 21, 4:49 pm, fahd <[email protected]> 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 <[email protected]> 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 <[email protected]> wrote: > > > > Hi Fahd! > > > > 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 <[email protected]> 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
