http://siteframe.org/tag/mysql en-US ©2005-7 Glen Campbell Thu, 30 Aug 2007 22:46:42 MDT Siteframe 5.0.5 webmaster@siteframe.org http://blogs.law.harvard.edu/tech/rss 30 I recently upgraded to MySQL 5.21 beta and discovered that the home page of my Siteframe (v5) sites all look a bit strange. Evidently this little bit of SQL: ORDER BY page_id DESC LIMIT 20 returns the FIRST 20 page_ids, and not the LAST 20. I made this change in index.php: ORDER BY page_created... Thu, 30 Aug 2007 22:46:42 MDT http://siteframe.org/p/issues-with-mysql-5-21-beta http://siteframe.org/p/issues-with-mysql-5-21-beta bug mysql Various bits of information about using MySQL with Siteframe.MySQL PermissionsTypically, you need these permissions on your MySQL database:grant alter,index,select,insert,pdate,delete,create,drop on database.* to 'user'@'host' identified by 'password'or (somewhat easier)grant all on database.* to Sun, 24 Apr 2005 14:38:51 MDT http://siteframe.org/p/mysql_notes http://siteframe.org/p/mysql_notes beaumont grant mysql permission siteframe The README.txt file that is distributed with Siteframe should have the latest information on the product as well as a set of simplified installation instructions. These instructions are intended to be very comprehensive, and probably contain more information than any reasonable person... Sun, 24 Apr 2005 08:29:33 MDT http://siteframe.org/p/howto_install_siteframe_5x http://siteframe.org/p/howto_install_siteframe_5x apache beaumont hosting install installation mysql php siteframe siteframe.ini web Siteframe 5.x has two internal tables for logging. The first is the audit log; this is always functional and records any major changes to data. The purpose of this log is to track changes to the system; for example, if a large number of objects are deleted from the site, you can use this log to Sun, 17 Apr 2005 16:32:30 MDT http://siteframe.org/p/logging http://siteframe.org/p/logging apache archive log logging myisam mysql siteframe.ini userlog This document describes the software that is required to install Siteframe. Web server: Siteframe has been installed under Apache 2.0.53; it will most likely work under older versions of Apache, but it has not been verified. It should work under any web server that supports PHP5, but, again, Tue, 22 Mar 2005 21:18:03 MST http://siteframe.org/p/recommendedrequired_software http://siteframe.org/p/recommendedrequired_software apache curl exif installation mod_rewrite mysql php5 readme.txt rich-text smarty widgeditor xml-rpc