FreeForm / Mailing List Module Error
Posted: 27 March 2008 10:08 AM   [ Ignore ]
Newbie
Rank
Total Posts:  5
Joined  2008-02-24

I just downloaded the FreeForm module and created a form:

{exp:freeform:form form_name="perspectives" redirect_on_duplicate="weblog/already_posted" mailinglist="perspecitves_newsletter" notify="pmeissner@mediciglobal.com" required="name" send_user_email="yes" form_title ="Perspectives Newsletter Sign-up Form"}
<p><label>Name</label><br />
<
input type="text" name="name" value="" />
</
p>
<
p><label>Email</label><br />
<
input type="text" name="email" value="" />
</
p>
<
p><label>Phone</label><br />
<
input type="text" name="phone1" value="" />
</
p>
<
p><label>Street 1</label></br>
<
input type="text" name="street1" value="" /></p>
<
p><label>Street 2</label>
<
input type="text" name="street2" value="" /></p>
<
p><label>City</label><br />
<
input type="text" name="city" value="" /></p>
<
p><label>State</label><br />
<
input type="text" name="state" value="" /></p>
<
p><label>Postal Code</label><br />
<
input type="text" name="postalcode" value="" /></p>
<
p><label>Country</label><br />
<
input type="text" name="country" value="" /></p>
<
p><label>Newsletter Format</label><br />
<
input type="radio" name="deliveryformat" value="Postal" /> Postal Service<br />
<
input type="radio" name="deliveryformat" value="Email" /> Email<br />
</
p>
<
p>
<
button type="submit" name="submit" value="submit"><img src="{my_path}images/mg_images/icon_check.png" alt="image" width="16" height="16" />Submit Form</button>
</
p>

When I head over to the Mailing List module to select the mailing list (or a newly created list) I get this error.

MySQL ERROR:

Error Number: 1054

Description: Unknown column ‘ip_address’ in ‘field list’

Query: SELECT user_id, list_id, email, ip_address FROM exp_mailing_list WHERE list_id = ‘3’

Did FreeForm add a field that it shouldn’t have? Any thoughts?

Profile
 
 
Posted: 27 March 2008 02:44 PM   [ Ignore ]   [ # 1 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  3343
Joined  2006-10-18

I’ve actually managed to duplicate this accidently before, although I wasn’t sure if it was Freeform that caused it…

I’ll have Mitchell look into this smile

Thank you for your patience

 Signature 
Profile
 
 
Posted: 27 March 2008 06:05 PM   [ Ignore ]   [ # 2 ]
Newbie
Rank
Total Posts:  5
Joined  2008-02-24

Thanks Pie-Man. I compared my database to another install of EE and noticed the the ip_address field was missing. So I created the field, and it seems to work fine now. I’m not sure how that field got deleted.

Profile
 
 
Posted: 27 March 2008 07:29 PM   [ Ignore ]   [ # 3 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  3343
Joined  2006-10-18

Thanks for posting the update smile

 Signature 
Profile