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\"><b>SQL 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\"><b>SQL 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
ModelBehavior::dispatchMethod() - CORE/cake/libs/model/
behavior.php, line 162
BehaviorCollection::trigger() - CORE/cake/libs/model/
behavior.php, line 456
Model::__filterResults() - CORE/cake/libs/model/model.php, line
2230
Model::find() - CORE/cake/libs/model/model.php, line 1993
MenusController::findButtons() - APP/controllers/
menus_controller.php, line 201
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
Query: __resetAssociations
Query: __resetAssociations
On 11 ene, 00:06, "Dr. Tarique Sani" <[email protected]> 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 <[email protected]> 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 [email protected]
> > To unsubscribe from this group, send email to
> > [email protected] 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 [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
