ae.hugeobject.com

This is perhaps more of a convenient place for me to store install instructions than anything… BUT:

Installing CoolUri in Typo3 on linux / apache2 / php5

Based on: http://docs.google.com/View?docid=dd33gg45_3f8j96p
Steps :

Check if the weberver has the following settings:
PHP5+ with SimpleXML enabled
MySQL 4.1+
Apache’s mod_rewrite enabled

Go into the extension manager
Choose menu option ‘Import extensions’
Upload extension file: cooluri_1.0.4.t3x
Found here ( http://typo3.org/extensions/repository/view/cooluri/ )

Once imported, install it and accept its defaults (altering tables etc.)

Add a htaccess:
(check that it covers all folders in the root directory)

# Enable URL rewriting
RewriteEngine On
RewriteRule ^/(typo3|typo3temp|typo3conf|t3lib|tslib|css|calculator|fileadmin|uploads|showpic\.php)/ - [L]
RewriteRule ^/(typo3|typo3temp|typo3conf|t3lib|tslib|css|calculator|fileadmin|uploads|showpic\.php)/.*$ - [L]
RewriteRule ^typo3$ typo3/index_re.php [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !-l

# Main URL rewriting.
RewriteRule .* index.php [L]

Copy across the CoolUriConf xml file:
cp typo3conf/ext/cooluri/cooluri/CoolUriConf.xml_default typo3conf/CoolUriConf.xml

Add a domain record
- Go to the homepage, -> NEW -> DOMAIN (add the domain name in)

Add the following to the main template setup::

# Cooluri
config.simulateStaticDocuments = 0
config.baseURL = http://mtaa.supernaut/
config.tx_cooluri_enable = 1
config.redirectOldLinksToNew = 1

Go to the backend and select the ‘CoolUri’ menu item
Click ‘Delete/Update all’ -> DELETE EVERYTHING AND START AGAIN

Clear cache

Try.

For CATMENU see note from Jan:

try to remove the part which removes cHash parameter from URLs. Since
tt_news are cached, they either require cHash or you’d need to make them
COA_INT.

I’ve spend the last half of the day trying to optimise (thats how you spell it in Australia) a MySQL script that was grabbing a heap of data to build a excel spreadsheet.

The script included four left joins and was selecting from about 20,000 rows.  It had gradually become slower and slower over the last month as the database grew, until now it was taking over 30 seconds to run the script and make the excel file.

(more…)

I’ve recently being working on a flash ecommerce application using SSL.

But, after checking to make sure its all good in IE, I started getting that annoying “do you want to display the non-secure items” message. After a few minutes trying out a few things I realised that it was getting upset because of the plugin urls specified in the Macromedia code:

pluginspage=”http://www.macromedia.com/go/getflashplayer”

To get rid of the message, I changed the http to https
ie.
pluginspage=”https://www.macromedia.com/go/getflashplayer”

technorati tags: Flash