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
