Re: Clueless...Help please
Hi AD7 I actually downloaded the whole site, without leaving behind the old folders, I mean the folder and file layout is exactly the same. I'm not getting paid to move the site but I usually try to be helpful to customers and in this case it's a friend's site and I don't want to leave him stuck with this. I saw the tute but still I don't know what's controlling that sql sentence, I'm not new to php but since I did not develop the app I cannot figure out where exactly is that $conditions var or array defined, also some app's urls/buttons call some /c/ folder, defined on the routes.php file. That folder was unexistant in the old site so I don't understand what that /c/whatever/article-name stands for I'll keep on reading this is driving me insane man! Thanks for replying! On 13 ene, 11:41, AD7six andydawso...@gmail.com wrote: On Jan 12, 6:03 pm, javier0051 javier.ange...@gmail.com wrote: Thank you all for answering. I really appreciate it. My main business is hosting but I also do PHP coding but never did anything with cake. As I saw the error, as Ryan stated, it's obvious that there's something wrong with that sql query. The weird thing is that the site worked well on other box with same PHP version, same OS, same MySql version and same folder layout, and I'm still lost on which files make changes or look for the issue to correct it... The ones mentioned in the error message (and in replies to this thread). any suggestions on this? I'll read the tute By now I assume you've done this - it will have been the most valuable 15 minutes of your cake experience :) but it'd be great if you guys can hand me a clue on what file(s) to change... The error is in the application - look at the stack trace. You are not looking at a setup problem or afaics anything related to changing servers - it's an error in the way whomever wrote the menus controller. From what you've said I would say it's not your responsibility to fix it - unless they're paying you to do so. Changing from one functional server to another functional server doesn't magically introduce bugs of this kind. The fact that it worked before and doesn't act the same now means nothing in and of itself IMO - how do you know the bit of code generating the error was even executed on the old server - e.g. the old install might be relying on the existence of a cache file which you've (rightly) deleted when moving servers. hth, AD Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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: Clueless...Help please
On Jan 12, 6:03 pm, javier0051 javier.ange...@gmail.com wrote: Thank you all for answering. I really appreciate it. My main business is hosting but I also do PHP coding but never did anything with cake. As I saw the error, as Ryan stated, it's obvious that there's something wrong with that sql query. The weird thing is that the site worked well on other box with same PHP version, same OS, same MySql version and same folder layout, and I'm still lost on which files make changes or look for the issue to correct it... The ones mentioned in the error message (and in replies to this thread). any suggestions on this? I'll read the tute By now I assume you've done this - it will have been the most valuable 15 minutes of your cake experience :) but it'd be great if you guys can hand me a clue on what file(s) to change... The error is in the application - look at the stack trace. You are not looking at a setup problem or afaics anything related to changing servers - it's an error in the way whomever wrote the menus controller. From what you've said I would say it's not your responsibility to fix it - unless they're paying you to do so. Changing from one functional server to another functional server doesn't magically introduce bugs of this kind. The fact that it worked before and doesn't act the same now means nothing in and of itself IMO - how do you know the bit of code generating the error was even executed on the old server - e.g. the old install might be relying on the existence of a cache file which you've (rightly) deleted when moving servers. hth, AD Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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: Clueless...Help please
Thank you all for answering. I really appreciate it.
My main business is hosting but I also do PHP coding but never did
anything with cake.
As I saw the error, as Ryan stated, it's obvious that there's
something wrong with that sql query. The weird thing is that the site
worked well on other box with same PHP version, same OS, same MySql
version and same folder layout, and I'm still lost on which files make
changes or look for the issue to correct it...
any suggestions on this? I'll read the tute but it'd be great if you
guys can hand me a clue on what file(s) to change...
Thanks so much!!
On 11 ene, 14:19, Brian Mckphee jnsmit...@gmail.com wrote:
I agree with the last few posters. You may need to tell your client
to look at their code. Are you merely a hosting provider or are you a
coder?
On Jan 10, 8:13 am, javier0051 javier.ange...@gmail.com wrote:
Hi
I am a completely newbie to cake php. A new customer has a site
developed with cake php and we recently moved the site to one of our
boxes but we haven't been able to show all the page's content. No
errors, the news articles and other stuff are actually in the
database BUT no contents are displayed. (site's main page:www.acepweb.org.ar
Undisplayed contents example url (http://www.acepweb.org.ar/c/noticias/
ultimas-noticias)
The problem comes when trying to access one of the interior sections.
The contents are in the database, the routing.php file has this line
(Router::connect('/c/:categoria/:subcategoria', array('controller' =
'categories', 'action' = 'view', 'categoria' = null, 'subcategoria'
= null));) directing to some /c/ folder or whatever it is but it is
not physically present.
The connection to the db is established propperly but at this point I
am totally clueless on how to get that example page to display the
contents it used to display when hosted on the other box, with same
cPanel, same linux operating system.
Thank you .Help will be totally appreciated
Check out the new CakePHP Questions site http://cakeqs.org and help others with
their CakePHP related questions.
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: Clueless...Help please
Thanks for replying Tarique.
Actually I don't get any errors, the app just doesn't seem to find the
contents that were actually visible on the site mounted on the old
server. The contents are actually stored in the db... The URL is
http://www.acepweb.org.ar The main page is totally visible but when I
click a button to get to the secondary sections, eg. news, I get not
an error message but a message indicating that no articles were found
on the category... I'm still totally clueless about this
On 11 ene, 00:06, Dr. Tarique Sani tariques...@gmail.com wrote:
Can't seem to reach the URL you have mentioned but have you tried
setting the Debug on?
Probably you are not seeing any errors because Debug is set to 0
HTH
Tarique
On Mon, Jan 10, 2011 at 7:43 PM, javier0051 javier.ange...@gmail.com wrote:
Hi
I am a completely newbie to cake php. A new customer has a site
developed with cake php and we recently moved the site to one of our
boxes but we haven't been able to show all the page's content. No
errors, the news articles and other stuff are actually in the
database BUT no contents are displayed. (site's main page:www.acepweb.org.ar
Undisplayed contents example url (http://www.acepweb.org.ar/c/noticias/
ultimas-noticias)
The problem comes when trying to access one of the interior sections.
The contents are in the database, the routing.php file has this line
(Router::connect('/c/:categoria/:subcategoria', array('controller' =
'categories', 'action' = 'view', 'categoria' = null, 'subcategoria'
= null));) directing to some /c/ folder or whatever it is but it is
not physically present.
The connection to the db is established propperly but at this point I
am totally clueless on how to get that example page to display the
contents it used to display when hosted on the other box, with same
cPanel, same linux operating system.
Thank you .Help will be totally appreciated
Check out the new CakePHP Questions sitehttp://cakeqs.organd help others
with their CakePHP related questions.
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
athttp://groups.google.com/group/cake-php?hl=en
--
=
Cheesecake-Photoblog:http://cheesecake-photoblog.org
PHP for E-Biz:http://sanisoft.com
=
Check out the new CakePHP Questions site http://cakeqs.org and help others with
their CakePHP related questions.
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: Clueless...Help please
Alright... I set the debug mode to 1 under config/core.php... There's
indeed an error (thoug the site is setup just as in the old machine).
This is what I'm getting:
---
Warning (512): SQL Error: 1054: Unknown column 'conditions' in 'where
clause' [CORE/cake/libs/model/datasources/dbo_source.php, line 525]
Code | Context
$sql= SELECT COUNT(*) AS `count` FROM `articles` AS `Article` LEFT
JOIN `categories` AS `Category` ON (`Article`.`category_id` =
`Category`.`id`) LEFT JOIN `images` AS `Image` ON
(`Image`.`foreign_id` = `Article`.`id` AND `Image`.`thumb` = 1 AND
`Image`.`model` = 'Article') LEFT JOIN `galleries` AS `Gallery` ON
(`Gallery`.`article_id` = `Article`.`id`) WHERE conditions = ('43')
$error = 1054: Unknown column 'conditions' in 'where clause'
$out= null
$out = null;
if ($error) {
trigger_error(span style = \color:Red;text-
align:left\bSQL Error:/b {$this-error}/span,
E_USER_WARNING);
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::read() - CORE/cake/libs/model/datasources/dbo_source.php,
line 653
Model::find() - CORE/cake/libs/model/model.php, line 1988
Controller::paginate() - CORE/cake/libs/controller/controller.php,
line 1070
CategoriesController::view() - APP/controllers/
categories_controller.php, line 39
Object::dispatchMethod() - CORE/cake/libs/object.php, line 116
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 227
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194
[main] - APP/webroot/index.php, line 84
Query: SELECT COUNT(*) AS `count` FROM `articles` AS `Article` LEFT
JOIN `categories` AS `Category` ON (`Article`.`category_id` =
`Category`.`id`) LEFT JOIN `images` AS `Image` ON
(`Image`.`foreign_id` = `Article`.`id` AND `Image`.`thumb` = 1 AND
`Image`.`model` = 'Article') LEFT JOIN `galleries` AS `Gallery` ON
(`Gallery`.`article_id` = `Article`.`id`) WHERE conditions = ('43')
Query: SELECT `Article`.`id`, `Article`.`title`, `Article`.`preview`,
`Article`.`body`, `Article`.`category_id`, `Article`.`created`,
`Article`.`modified`, `Article`.`hot`, `Category`.`id`,
`Category`.`name`, `Category`.`description`, `Category`.`parent_id`,
`Category`.`url`, `Category`.`show_date`, `Category`.`order`,
`Image`.`id`, `Image`.`model`, `Image`.`foreign_id`,
`Image`.`filename`, `Image`.`dir`, `Image`.`mimetype`,
`Image`.`filesize`, `Image`.`height`, `Image`.`width`,
`Image`.`thumb`, `Image`.`description`, `Image`.`order`,
`Image`.`created`, `Image`.`modified`, `Gallery`.`id`,
`Gallery`.`name`, `Gallery`.`created`, `Gallery`.`article_id` FROM
`articles` AS `Article` LEFT JOIN `categories` AS `Category` ON
(`Article`.`category_id` = `Category`.`id`) LEFT JOIN `images` AS
`Image` ON (`Image`.`foreign_id` = `Article`.`id` AND `Image`.`thumb`
= 1 AND `Image`.`model` = 'Article') LEFT JOIN `galleries` AS
`Gallery` ON (`Gallery`.`article_id` = `Article`.`id`) WHERE
conditions = ('43') ORDER BY `Article`.`created` DESC LIMIT 10
ACEP: Asociación Civil Estudios Populares
* Home
* Sobre Nosotros
* Contacto
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 '__resetAssociations' at line 1 [CORE/
cake/libs/model/datasources/dbo_source.php, line 525]
Code | Context
$sql = __resetAssociations
$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 '__resetAssociations' at line 1
$out = null
$out = null;
if ($error) {
trigger_error(span style = \color:Red;text-
align:left\bSQL Error:/b {$this-error}/span,
E_USER_WARNING);
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
Button::__resetAssociations() - [internal], line ??
BindableBehavior::resetBindable() - APP/models/behaviors/
bindable.php, line 258
BindableBehavior::afterFind() - APP/models/behaviors/
bindable.php, line 317
Re: Clueless...Help please
On Jan 11, 2011, at 07:10, javier0051 wrote:
Alright... I set the debug mode to 1 under config/core.php... There's
indeed an error (thoug the site is setup just as in the old machine).
This is what I'm getting:
---
Warning (512): SQL Error: 1054: Unknown column 'conditions' in 'where
clause' [CORE/cake/libs/model/datasources/dbo_source.php, line 525]
Code | Context
$sql = SELECT COUNT(*) AS `count` FROM `articles` AS `Article` LEFT
JOIN `categories` AS `Category` ON (`Article`.`category_id` =
`Category`.`id`) LEFT JOIN `images` AS `Image` ON
(`Image`.`foreign_id` = `Article`.`id` AND `Image`.`thumb` = 1 AND
`Image`.`model` = 'Article') LEFT JOIN `galleries` AS `Gallery` ON
(`Gallery`.`article_id` = `Article`.`id`) WHERE conditions = ('43')
$error= 1054: Unknown column 'conditions' in 'where clause'
At the risk of stating the obvious, it sounds like there is no column called
conditions. Is there a column called conditions in any of the tables being
used in this query? (Off hand, I'm not sure which table it wants that column to
be in.)
Check out the new CakePHP Questions site http://cakeqs.org and help others with
their CakePHP related questions.
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: Clueless...Help please
On Jan 11, 3:37 pm, Ryan Schmidt google-2...@ryandesign.com wrote:
On Jan 11, 2011, at 07:10, javier0051 wrote:
Code | Context
$sql = SELECT COUNT(*) AS `count` FROM `articles` AS `Article`
LEFT
JOIN `categories` AS `Category` ON (`Article`.`category_id` =
`Category`.`id`) LEFT JOIN `images` AS `Image` ON
(`Image`.`foreign_id` = `Article`.`id` AND `Image`.`thumb` = 1 AND
`Image`.`model` = 'Article') LEFT JOIN `galleries` AS `Gallery` ON
(`Gallery`.`article_id` = `Article`.`id`) WHERE conditions = ('43')
$error = 1054: Unknown column 'conditions' in 'where clause'
At the risk of stating the obvious, it sounds like there is no column called
conditions.
a missing field named conditions shouts app-code error to me. Given it
comes from a paginate call, I guess this is in the code:
-paginate(array('conditions' = array(43)));
which is simply wrong.
javier I'd suggest doing the blog tutorial before continuing - it'll
answer these sort of problems for you by example.
AD
ps. there's a spanish google group cakephp-esp
Check out the new CakePHP Questions site http://cakeqs.org and help others with
their CakePHP related questions.
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: Clueless...Help please
that error usually happens when a call to a find query (in this case a
paginate query) is written wrong. That seems like an app error not
hosting.
On Jan 11, 9:07 am, AD7six andydawso...@gmail.com wrote:
On Jan 11, 3:37 pm, Ryan Schmidt google-2...@ryandesign.com wrote:
On Jan 11, 2011, at 07:10, javier0051 wrote:
Code | Context
$sql = SELECT COUNT(*) AS `count` FROM `articles` AS
`Article` LEFT
JOIN `categories` AS `Category` ON (`Article`.`category_id` =
`Category`.`id`) LEFT JOIN `images` AS `Image` ON
(`Image`.`foreign_id` = `Article`.`id` AND `Image`.`thumb` = 1 AND
`Image`.`model` = 'Article') LEFT JOIN `galleries` AS `Gallery` ON
(`Gallery`.`article_id` = `Article`.`id`) WHERE conditions = ('43')
$error = 1054: Unknown column 'conditions' in 'where clause'
At the risk of stating the obvious, it sounds like there is no column
called conditions.
a missing field named conditions shouts app-code error to me. Given it
comes from a paginate call, I guess this is in the code:
-paginate(array('conditions' = array(43)));
which is simply wrong.
javier I'd suggest doing the blog tutorial before continuing - it'll
answer these sort of problems for you by example.
AD
ps. there's a spanish google group cakephp-esp
Check out the new CakePHP Questions site http://cakeqs.org and help others with
their CakePHP related questions.
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: Clueless...Help please
I agree with the last few posters. You may need to tell your client
to look at their code. Are you merely a hosting provider or are you a
coder?
On Jan 10, 8:13 am, javier0051 javier.ange...@gmail.com wrote:
Hi
I am a completely newbie to cake php. A new customer has a site
developed with cake php and we recently moved the site to one of our
boxes but we haven't been able to show all the page's content. No
errors, the news articles and other stuff are actually in the
database BUT no contents are displayed. (site's main page:www.acepweb.org.ar
Undisplayed contents example url (http://www.acepweb.org.ar/c/noticias/
ultimas-noticias)
The problem comes when trying to access one of the interior sections.
The contents are in the database, the routing.php file has this line
(Router::connect('/c/:categoria/:subcategoria', array('controller' =
'categories', 'action' = 'view', 'categoria' = null, 'subcategoria'
= null));) directing to some /c/ folder or whatever it is but it is
not physically present.
The connection to the db is established propperly but at this point I
am totally clueless on how to get that example page to display the
contents it used to display when hosted on the other box, with same
cPanel, same linux operating system.
Thank you .Help will be totally appreciated
Check out the new CakePHP Questions site http://cakeqs.org and help others with
their CakePHP related questions.
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: Clueless...Help please
Can't seem to reach the URL you have mentioned but have you tried
setting the Debug on?
Probably you are not seeing any errors because Debug is set to 0
HTH
Tarique
On Mon, Jan 10, 2011 at 7:43 PM, javier0051 javier.ange...@gmail.com wrote:
Hi
I am a completely newbie to cake php. A new customer has a site
developed with cake php and we recently moved the site to one of our
boxes but we haven't been able to show all the page's content. No
errors, the news articles and other stuff are actually in the
database BUT no contents are displayed. (site's main page: www.acepweb.org.ar
Undisplayed contents example url (http://www.acepweb.org.ar/c/noticias/
ultimas-noticias)
The problem comes when trying to access one of the interior sections.
The contents are in the database, the routing.php file has this line
(Router::connect('/c/:categoria/:subcategoria', array('controller' =
'categories', 'action' = 'view', 'categoria' = null, 'subcategoria'
= null));) directing to some /c/ folder or whatever it is but it is
not physically present.
The connection to the db is established propperly but at this point I
am totally clueless on how to get that example page to display the
contents it used to display when hosted on the other box, with same
cPanel, same linux operating system.
Thank you .Help will be totally appreciated
Check out the new CakePHP Questions site http://cakeqs.org and help others
with their CakePHP related questions.
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
--
=
Cheesecake-Photoblog: http://cheesecake-photoblog.org
PHP for E-Biz: http://sanisoft.com
=
Check out the new CakePHP Questions site http://cakeqs.org and help others with
their CakePHP related questions.
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: Clueless...Help please
Check error logs. And/or turn debug on and go to page to see actual
errors.
On Jan 10, 8:13 pm, javier0051 javier.ange...@gmail.com wrote:
Hi
I am a completely newbie to cake php. A new customer has a site
developed with cake php and we recently moved the site to one of our
boxes but we haven't been able to show all the page's content. No
errors, the news articles and other stuff are actually in the
database BUT no contents are displayed. (site's main page:www.acepweb.org.ar
Undisplayed contents example url (http://www.acepweb.org.ar/c/noticias/
ultimas-noticias)
The problem comes when trying to access one of the interior sections.
The contents are in the database, the routing.php file has this line
(Router::connect('/c/:categoria/:subcategoria', array('controller' =
'categories', 'action' = 'view', 'categoria' = null, 'subcategoria'
= null));) directing to some /c/ folder or whatever it is but it is
not physically present.
The connection to the db is established propperly but at this point I
am totally clueless on how to get that example page to display the
contents it used to display when hosted on the other box, with same
cPanel, same linux operating system.
Thank you .Help will be totally appreciated
Check out the new CakePHP Questions site http://cakeqs.org and help others with
their CakePHP related questions.
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: Clueless...Help please
On Jan 10, 2011, at 08:13, javier0051 wrote:
No errors, the news articles and other stuff are actually in the
database BUT no contents are displayed. (site's main page: www.acepweb.org.ar
Undisplayed contents example url (http://www.acepweb.org.ar/c/noticias/
ultimas-noticias)
The problem comes when trying to access one of the interior sections.
The contents are in the database, the routing.php file has this line
(Router::connect('/c/:categoria/:subcategoria', array('controller' =
'categories', 'action' = 'view', 'categoria' = null, 'subcategoria'
= null));) directing to some /c/ folder or whatever it is but it is
not physically present.
Router::connect() is not directing to some /c/ folder or whatever;
Router::connect() informs CakePHP that when a visitor accesses a URL of the
form /c/:categoria/:subcategoria (where :categoria and :subcategoria are
placeholders which stand for any value), CakePHP will invoke the view method
of the categories controller. You may want to spend some more time reading
the CakePHP documentation to better understand this and other basics of CakePHP
applications.
http://book.cakephp.org/view/875/x1-3-Collection
Check out the new CakePHP Questions site http://cakeqs.org and help others with
their CakePHP related questions.
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
