All posts by Jon Hibbins

‘Windlands’ Developer On VR Motion Controls: “Oculus Touch Is The Way To Go”

By | HTC Vive, Oculus Rift, Virtual Reality | No Comments

Upload VR : Oculus Touch Is The Way To Go

How to Reset Zend Server Statistics

By | Quick Tips, SQL, sqlite, Zend, Zend Server | No Comments

Reset Zend Server Statistics

I had to work this one out myself, hopefully this will save you some time:

sudo rm /usr/local/zend/var/db/statistics.db
sudo sqlite3 statistics.db < /usr/local/zend/share/statistics_sqlite_create_database.sql
sudo sqlite3 statistics.db < /usr/local/zend/share/stats_sqlite_fixtures.sql

Zend Server 5 to 6 mysql 5.1 to 5.5 fix

By | MySQL, Software Development, Zend, Zend Server | No Comments

I recently upgraded a Zend Server installation from version 5 to version 6, a side effect of this was that MySQL server was upgraded from version 5.1 to version 5.5.

I was then receiving the error message:

“Error Code: 1548 Cannot load from mysql.proc. The table is probably corrupted”

After rebuilding the databases and trying the mysql_upgrade -u root -p command, i discovered this is just a try to fix the core issue.

The true cause of the issue is that the table definition of mysql.proc is different

To fix the mysql.proc table just run the following command :

alter table mysql.proc modify comment text;