phrasetype fieldname?

[sabret00the]

this:
<phrasetype name="Email Body text" fieldname="Email Body text">
<phrase name="ActivationEmail_v3_Day3"><![CDATA[Dear $username,

Thank you for registering for the $vboptions[bbtitle]. It has been 3 days since you registered, and you have not yet activated your account.

Please note - you must complete this last step to become a registered member. You will only need to click on the link once, and your account will be updated.

To complete your registration, click on the link below:
$vboptions[bburl]/register.php?a=act&u=$userid&i=$activateid

<a href="$vboptions[bburl]/register.php?a=act&u=$userid&i=$activateid">AOL Users click Here to be Activated</a>

**** Does The Above Link Not Work? ****
If the above link does not work, please use your Web browser to go to:
$vboptions[bburl]/register.php?a=ver

Please to be sure not to add extra spaces. You will need to type in your username and activation number on the page that appears when you click on our copy the above link in your browser.

Your Username is: $username
Your Activation ID is: $activateid



If you are still having problems signing up please contact a member of our support staff at $webmasteremail

Thanks very much,
$vboptions[hometitle] Team]]></phrase>

gives me an error:

Database error in vBulletin 3.5.0:

Invalid SQL:
UPDATE language SET title = title, phrasegroup_hacklog = 'a:236:{s:34:\"are_you_sure_want_to_delete_hack_x\";s:160:\"Are you /* snipped */


MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Body text = 'a:3:{s:23:\"ActivationEmail_v3_Day3\";s:1135:\"Dear $username,\r\n\' at line 1
Error Number : 1064
Date : Wednesday, November 16th 2005 @ 02:32:50 PM
Script : http://localhost/3.5.x/forums/admincp/plugin.php
Referrer : http://localhost/3.5.x/forums/admincp/plugin.php?do=productadd
IP Address : 127.0.0.1
Username : sabret00the
Classname : vB_Database
my theory is that the phrasetype fieldname is wrong? am i right/wrong? what is the correct fieldname?

[Marco van Herwaarden]

Upgrade to 3.5.1

[sabret00the]

still getting the error

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Body text = 'a:3:{s:23:\"ActivationEmail_v3_Day3\";s:1135:\"Dear $username,\r\n\' at line 1
Error Number : 1064
Date : Wednesday, November 16th 2005 @ 04:22:54 PM
Script : http://localhost/3.5.x/forums/admincp/plugin.php
Referrer : http://localhost/3.5.x/forums/admincp/plugin.php?do=productadd
IP Address : 127.0.0.1
Username : sabret00the
Classname : vB_Database

[Andreas]

I assume this is a hand-crafted product XML (you should never-ever do that)?

The fieldname must be emailbody.

[sabret00the]

I assume this is a hand-crafted product XML (you should never-ever do that)?

The fieldname must be emailbody.

how do i make a non-hardcrafted product xml?

[Andreas]

Erm ... simply export it from product manager :)

[sabret00the]

Erm ... simply export it from product manager :)

theirs nothing to export though :shrug:

as it stands, i've done it by hand and failed so then i went into the product manager. clicked add product and it's let me add a name and product id, but how do i add stuff like phrases and templates?

[Andreas]

You simply create them, and when you create them you associate them with your product.
And when you are finished adding all phrases, templates, settings, plugins, you export the product.
Done.

[sabret00the]

ah ok, i get it now, long winded but indeed simpler :)

thanks andreas, thanks marco :)