The differences between PHP 4 & 5 and MySQL 4 & 5 are very much non-trivial.
On Thu, Aug 27, 2009 at 2:19 PM, superdav<da...@stonefamily.cjb.net> wrote: > > Greetings to all, > > This is my first cake app I've made and I am having problems after > moving it from my development server to a production server. > Everything is working fun except two actions are just giving me a > blank page when I try to view them. One is an advanced search action > and the other is just a basic index. When I turn the debug level to 1 > or higher nothing works at all. Here is the errors it gives: > > Illegal offset type [CORE/cake/libs/model/datasources/dbo_source.php, > line 331] > Array to string conversion [CORE/cake/libs/model/datasources/dbo/ > dbo_mysql.php, line 411] > Array to string conversion [CORE/cake/libs/model/datasources/ > dbo_source.php, line 519] > 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 'Array' at line 1 [CORE/cake/libs/model/datasources/ > dbo_source.php, line 526] > Array to string conversion [CORE/cake/libs/model/datasources/ > dbo_source.php, line 530] > Query: Array > Cannot modify header information - headers already sent by (output > started at /usr/home/rgctbp1/cake/cake/basics.php:111) [CORE/cake/libs/ > controller/controller.php, line 640] > > I know the headers already sent message is coming is happening because > it's trying to redirect to the login page and cannot. If I manually > enter the login url it looks normal but still has these errors and I > cannot login. Obviously something is wrong because it's sending an > array as a sql query. I did a print_r in dbo_source.php and the array > is: > > Array ( [class] => Query [alias] => Query [id] => ) > > If that helps at all. The only things that have changed from my dev > server to my production server is my dev server was running php5 and > mysql5 and the production server is running php4 and mysql4 but I > don't expect that to have made a difference. > > I have deleted all the cache information so that's not the problem. > > The production server does have a /~username/ in the url so I had to > add the rewriteBase /~user/ to the .htaccess file before it would > work. > > Any help would be appreciated. > > David > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---