i wrote code and tested on my pc, everything's ok. and i uploaded my code to my server....
my server is debian 6 32bit. i already installed amh (lnmp) with php5.3.27, mysql 5.5.33 and nginx. and added extension pdo_mysql, mcrypt, mysqli.
wget https://.../cphalcon 1.2.3.zip unzip cd build vi install change last line to:
/usr/local/php/bin/phpize; aclocal && libtoolize --force && autoheader && autoconf; ./configure --with-php-config=/usr/local/php/bin/php-config --enable-phalcon; make && make install;
./install
output error but got cphalcon.so
Configuring for: PHP Api Version: 20090626 Zend Module Api No: 20090626 Zend Extension Api No: 220090626 autoconf: Undefined macros: BUG in Autoconf--please report AC_CHECK_DECL BUG in Autoconf--please report AC_CHECK_HEADERS BUG in Autoconf--please report AC_DEFINE BUG in Autoconf--please report AC_CHECK_DECL BUG in Autoconf--please report AC_CHECK_HEADERS BUG in Autoconf--please report AC_DEFINE BUG in Autoconf--please report AC_CHECK_DECL BUG in Autoconf--please report AC_CHECK_HEADERS BUG in Autoconf--please report AC_DEFINE
phpinfo(), phalcon enabled
and i test my application. my application is small, just use few classes. most code run fine, but some code below have problems.
$photo = Photo::findFirst("id='123'"); // empty, but id 123 exist $photo = $this->modelsManager->executeQuery("SELECT * FROM Photo WHERE id=123"); //empty $photo = $this->modelsManager->executeQuery("UPDATE Photo SET url='abc' WHERE id=123"); //failed $photo = $this->modelsManager->executeQuery("DELETE FROM Photo WHERE id=123"); //failed $photo = $this->modelsManager->executeQuery("INSERT INTO Photo VALUES (123,'abc')"); //YES ,SUCCESS
i dont know where the problem are, so i check mysql log. on my pc, the log like query select ... query update ...
on my server, the log like prepare select... execute select... close stmt
even if i do a update/delete, the log is "select", and "select" nothing