Re: MAMP + CakePHP issues
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=gstq=Warning+%28512%29%3A+SQL+Error%3A+1064%3A#371f42ccdc65e0f2 http://groups.google.com/group/cake-php/browse_thread/thread/fa7a78b9673cf52a/3c5ee99aa6f81e58?lnk=gstq=Warning+%28512%29%3A+SQL+Error%3A+1064%3A#3c5ee99aa6f81e58 http://groups.google.com/group/cake-php/browse_thread/thread/bbea2a13a03006ef/3d95f19cc642d675?lnk=gstq=Warning+%28512%29%3A+SQL+Error%3A+1064%3A#3d95f19cc642d675 http://groups.google.com/group/cake-php/browse_thread/thread/f2d5632fda77653c/ef1218c3ed2d8702?lnk=gstq=Warning+%28512%29%3A+SQL+Error%3A+1064%3A#ef1218c3ed2d8702 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: 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 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
Re: MAMP + CakePHP issues
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,fahdfahd...@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,fahdfahd...@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/
Re: MAMP + CakePHP issues
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:
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 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/
Re: MAMP + CakePHP issues
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 at
http://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 from http://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
-~--~~~~--~~--~--~---
Re: MAMP + CakePHP issues
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:
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 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() -
MAMP + CakePHP issues
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
-~--~~~~--~~--~--~---
