Tag: mysql

Issues with MySQL 5.21-beta 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 DESC LIMIT 20 I presume this is a beta bug in MySQL 5.21, and it will be fixed shortly....
0 comment(s) / glen / Internals / on August 30, 2007 at 22:46

MySQL Notes Various bits of information about using MySQL with Siteframe. MySQL Permissions Typically, 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 ' user '@' host ' identified by ' password ' though this is possibly...
0 comment(s) / glen / Internals / on April 24, 2005 at 14:38

HowTo: install Siteframe 5.x 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 needs. Assumptions You have an account with an ISP or web hosting provider You know the final...
8 comment(s) / glen / HowTo / on April 24, 2005 at 08:29

Logging 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 find what event or user initiated the deletion. The second log is called the user log and...
0 comment(s) / glen / Internals / on April 17, 2005 at 16:32

Recommended/Required Software 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, nothing besides Apache 2.0 has been confirmed and tested. PHP5: Siteframe...
0 comment(s) / glen / Internals / on March 22, 2005 at 21:18