Chandan Web Blog.

Entries Tagged ‘Typo3’

TYPO3 FAL (file abstraction layer) in Extbase/Fluid extension

Recently I came across to implement extbase plugin having multiple file upload FE form. My Typo3 version was 6.1 The extension was created using Extension Builder File ext_tables.sql CREATE TABLE tx_clientside_domain_model_orderitems ( : files int(11) unsigned DEFAULT ’0′ NOT NULL, : ); File Configuration/TCA/OrderItems.php $TCA['tx_clientside_domain_model_orderitems'] = array( //…… removed code ‘files’ => array( ‘exclude’ => 1, ‘label’ [...]

Running a SQL Query using TypoScript

Well, after using this feature for quite long time, I though I should post this info:Consider the following Query: SELECT DISTINCT FROM_UNIXTIME(`datetime`, ‘%Y’) AS `year` FROM tt_news where pid=113 order by datetime limit 1 My main goal was to get the latest year from the tt_news records, that is then going to be pushed to [...]

Allowed memory size of … bytes exhausted

Recently, I had to do a t3d export/import, where the data size was nearly 2GB, and no matter what memory_limit we tried, it always failed. Finally we tried memory_limit = -1, which basically removes the memory limit, and lets us use the max available memory of the Operating System.

A simple note on using “Fluid Display”

Tesseract is a powerful tool, combined with “Fluid Display” the possibilities are almost limitless. Here is a simple note on how to use it to group based on a specific field. The Query: SELECT   doc_cat.title AS mydocs.title, mydocs.name, mydocs.path, mydocs.file_path FROM mydocs LEFT JOIN doc_cat_mm ON … LEFT JOIN doc_cat ON … The Fluid Display: [...]

Teeseract and JOIN tables using a CSV field

Latest News allows us to use content elements within a News. This opens up a vast set of possibilities. However, when we look in depth, the news manages related content element IDs in a CSV format. Now this seems like a bad way to mange it, as we do not have a mm_table, and there [...]

Subscribe to this page grab our RSS feed
search_left
Theme & Wordpress Integration - by Chandan