[TYPO3-dev] I LOVE ext_tables_static+adt.sql

[Sudara Williams]

Thanks Stefan!

I have tried this, as I wrote in my first post.

I noticed one other person had the same behavior when he was missing a comma in his SQL query, but my query is valid.

RTFSource is my next plan of action. Either a strange obscure bug, or a strange installation issue, I'm guessing.

thanks!

sudara



-----Original Message-----
From: typo3-dev-bounces at lists.netfielders.de on behalf of Stefan Geith
Sent: Mon 4/30/2007 12:00 PM
To: List for Core-/Extension development
Subject: Re: [TYPO3-dev] I LOVE ext_tables_static+adt.sql
 
Sudara Williams schrieb:
> Hello Fellas and Fellerin,
> 
> Are there secret rules when trying to load static data with an  
> extension using ext_tables_static+adt.sql ?
> 
> my INSERT queries do not um...insert
> 
> ...I've tried to dump my queries and table definitions from mysql and  
> the EM
> ...tested that the queries are working directly with the database
> ...made sure I have the exact same CREATE definition in ext_tables.sql
> ...looked at other extensions to make sure I'm following the same style
> ...tried with and without DEFAULT values for the fields
> ...tried full inserts and specific (INSERT INTO tx_blah (uid, pid,  
> name))
> 
> Any other rule to follow or am I having a moment of absolute stupidity?

Goto ExtensionManager; Select your Extension;
Switch to 'Backup/Delete';
Look at 'Data tables': there are your Tables and you
can donwload there a dump of the table that you can
copy/paste into your ext_tables_static+adt.sql

-

Stefan
_______________________________________________
TYPO3-dev mailing list
TYPO3-dev at lists.netfielders.de
http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-dev