Invalid arguement supplied for a view?

[Opie]

I'm working on this new component to list currently active projects for my company.  The front end works on 1.5RC3 on a XAMPP server running on a WinXP machine.

However, when I bring it to work and install it, which it does without errors, it provides the following warnings / errors.  The office environment is a Win2k machine with IIS.

Warning: Invalid argument supplied for foreach() in ...\views\projects\tmpl\default.php on line 10

Line 10 of that file is

Code: Select all

<?php foreach ( $this->projects as $project ) : ?>

I'm assuming it is $this->projects that is the problem.

Any ideas for what I need to look into?

[ianmac]

Trace back to where $this->projects comes from and echo at various points along the way to figure out what is going wrong...

Presumably, $projects is not an array as it is supposed to be for foreach.

If that is in your layout, then go back into your view and make sure it gets assigned.  Then, check your model to see if something is going wrong there, and work back until you figure out what is failing.

Ian

[Opie]

Thanks.  I'll post back if I can't find it from there.

[Opie]

Trace back to where $this->projects comes from and echo at various points along the way to figure out what is going wrong...

Presumably, $projects is not an array as it is supposed to be for foreach.

If that is in your layout, then go back into your view and make sure it gets assigned.  Then, check your model to see if something is going wrong there, and work back until you figure out what is failing.

Ian

It seems this call is failing in my model.  The model is being called.

Code: Select all

$this->_data = $this->_getList($query);

Any ideas?  I have tried to model this on the weblinks core component.

[ianmac]

Have you tested to ensure that the query does work?

Ian

[Opie]

Have you tested to ensure that the query does work?

Ian

The little things will get you.  Apparently, I need to work on my install.sql file for the installation.  The table was not created in the database.

At the end of my create table I have the following.

Code: Select all

ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;

When I try to create the table with phpMyAdmin, an error occurs regarding the CHARSET=utf8; portion.  Should I not have that in there?

[ianmac]

I dunno...  this is what I use:*

TYPE=MyISAM DEFAULT CHARSET=utf8 COLLATE `utf8_general_ci` AUTO_INCREMENT=1;


Ian


*I am not a database expert.  I know basics of SQL, and that is about it.  I don't even know joins that well, so, take that for what it is worth.

[Opie]

I dunno...  this is what I use:*

TYPE=MyISAM DEFAULT CHARSET=utf8 COLLATE `utf8_general_ci` AUTO_INCREMENT=1;


Ian


*I am not a database expert.  I know basics of SQL, and that is about it.  I don't even know joins that well, so, take that for what it is worth.

You're ahead of me.   It still did not work.  However, I don't see a need for this component in the general public as this is for internal use for my company's project list.  I'll have to look into this SQL issue at a later date.

Thanks for the help.

[ianmac]

What version of MySQL are you using?

Ian

[Opie]

It's been so long since I installed, I can't remember.

It appears to be Server version 4.0.18 and Client version of 5.0.0.  Looks like I may need to update it.