[TYPO3-english] Inserting TS Config Text into sys_template

Scotty C superscotty19 at yahoo.com
Mon Apr 12 11:59:26 CEST 2010


Oops,

Looks like we have a PEBKAC situation, specifically me! The problem is the quotes in the <BODY> tag.

Sorry for the bother!
-Scott.




----- Original Message ----
From: Scotty C <superscotty19 at yahoo.com>
To: typo3-english at lists.typo3.org
Sent: Mon, April 12, 2010 3:52:17 AM
Subject: [TYPO3-english]  Inserting TS Config Text into sys_template

Hey everybody,

I'm trying to manually insert a record into the sys_template table of my TYPO3 DB, using PHP. So, I have a few variables:

$template_id = <the next usable UID in the table>
$site_root = <the ID of the page containing the template>
$typoscript_constants = <2 lines of TS code>
$typoscript_config = <TS code, 3200 characters long>

... and then I slap that into the massive insert statement like this:

$create_template_query = "INSERT INTO  sys_template ( uid, pid, t3ver_oid, t3ver_id, t3ver_wsid, t3ver_label, t3ver_state, t3ver_stage, t3ver_count,t3ver_tstamp, t3_origuid, tstamp, sorting, crdate, cruser_id, title, sitetitle, hidden, starttime, endtime, root, clear, include_static, include_static_file, constants, config, editorcfg, resources, nextLevel, description, basedOn, deleted, includeStaticAfterBasedOn,static_file_mode,tx_impexp_origuid) VALUES ( '$template_id', '$site_root_id', 0, 0, 0, '', 0, 0, 0, 0, 0, 1266097202, 256, 1265252387, 1, '$template', '', 0, 0, 0, 1, 3, '77,57,43', 'EXT:css_styled_content/static/', '$typoscript_constants', '$typoscript_config', NULL, NULL, '', NULL, '', 0, 0, 0, 0);";

However, the result is a failure. In particular, I've isolated the problem to be caused when trying to insert the contents of the $typoscript_config variable. 

When I checked the structure of the sys_template table, it says the "config" field is a text field, meaning it can support 64k characters. As mentioned, I'm well under that ... what else could be the problem?


This may sound like a MySQL question, but all my research seems to conclude there is no reason for MySQL to be the problem.


Any input is as always appreciated - thanks!
-Scott.



      __________________________________________________________________
Make your browsing faster, safer, and easier with the new Internet Explorer® 8. Optimized for Yahoo! Get it Now for Free! at http://downloads.yahoo.com/ca/internetexplorer/
_______________________________________________
TYPO3-english mailing list
TYPO3-english at lists.typo3.org
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english



      __________________________________________________________________
Be smarter than spam. See how smart SpamGuard is at giving junk email the boot with the All-new Yahoo! Mail.  Click on Options in Mail and switch to New Mail today or register for free at http://mail.yahoo.ca


More information about the TYPO3-english mailing list