We have moved our forum to GitHub Discussions. For questions about Phalcon v3/v4/v5 you can visit here and for Phalcon v6 here.

i need help, about database crud

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



774

i think the code i wrote is right, maybe something wrong with my installation. how to fix it?

because the following errors occured 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

do i have to edit some files?



774

so the error about autoconf was solved. i removed autoconf2.13. ( apt-get remove --purge autoconf2.13 )

but still can not crud. i tested on debian 6 and centos 6 vps.



774

thank god i solved my problem. before: my php config like --with-mysql=/usr/local/mysql now: i change it config to --with-mysql=mysqlnd --with-mysqli=mysqlnd --with-pdo-mysql=mysqlnd

it works