Hi Dom. This is quite interesting indeed. Of course we all know Linux
*IS* case sensitive and Windows *isn't*... but I've always experienced
Cake using the correct case. I wonder if that has anything to do with
the table prefix...?! Also.. can you see if the DESC statement is
checking for T_User or T_user on the windows box?
Best I can say if to digg down the core code.. or the API. First let
me know if you still experience the issue... (it HAS been two days..!)
and if so.. I could probably try to give it a look myself!
It's weird though... Cake should handle it.. I have developed apps on
Win and made them live on a nux box...! never userd the table prefix
though...
Cheers,
Seb.
On Feb 12, 3:50 pm, "DominiqueM" <[EMAIL PROTECTED]>
wrote:
> Hi Seb,
>
> Just tried accessing the Linux maching with Putty, MySql worked fine.
> The DB on the Server is already configured by a collegue of mine,
> so that shouldnt be the reason.
>
> I'm just wondering. I have a model object called User, but the debug
> statement says Cake is asking for user.
> Is that something anyone has encountered?
>
> The Debug mentions:
> DESC `T_portalnutzer` ?
>
> I just don't know how to convince Cake to ask for the Capitalised
> Table.
>
> thanks for help :)
>
> Dominique
>
> On Feb 12, 4:57 am, "Seb" <[EMAIL PROTECTED]> wrote:
>
> > 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
-~----------~----~----~----~------~----~------~--~---
