Hey Dom... How did you imported the data? I ran into a similar problem about a month ago after the mysql tables got locked in read only (phpMyAdmin displaying them as 'in use'). That's likely to happen if you use InnoDB tables and mysql is not properly shutdown. I'm assuming you knew that already, but if anybody else didn't, the best way to transfer mysql data is still through a dump (a full sql file building the tables and/or the data). Copying the various database files (.frm, ...) works in some instances (same db version, same filesystem, ...) but definitely not on two different OS.
When I had the problem, I dug down the dbo_mysql.php code and the only thing I can tell you is that something is preventing cake from running the sql statement properly. It's nothing to do with the mod_rewrite. Maybe try to connect to the mysql server running of the SUSE box, using the same credentials as the cake app, and see if you can run the sql manually. Again.. that's very likely to be a mySQL server prob. Hope that helps! Seb. On Feb 12, 1:58 pm, "DominiqueM" <[EMAIL PROTECTED]> wrote: > Hija, > > Problem: > Deployment of a functional App (Windows XAMP PHP 4) to a Suse Linux > Server > causes the error mentioned above to appear when i try to access app on > server. > > Warning: Invalid argument supplied for foreach() in /usr/share/php/ > cake/cake/libs/model/dbo/dbo_mysql.php on line 171 > > Does anybody know why this could happen? Even better how I could fix > it > > I've only got two models atmo and they both have their $name > specified. > The DB config file is: > var $default = array('driver' => 'mysql', > 'connect' => > 'mysql_connect', > 'host' => > 'localhost', > 'login' => > 'root', > 'password' => > 'password', > 'database' => > 'Name', > 'prefix' => > 'T_'); > > Cake Build: cake_1.1.13.4450 > The application works fine on the windows machine. > Mod_Rewrite is off on both. > > Any help appreciated, > > Dominique --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---