Unknown column ‘site_id’ in ‘where clause’
Posted: 09 May 2008 09:46 AM   [ Ignore ]
Newbie
Rank
Total Posts:  4
Joined  2008-05-08

I’ve downloaded the Form Helper plugin, read the documentation and have implemented it into my templates - one with the edit link, and the other with the forms that are supossed to be populated with the weblog entry data. I know that the link works because I can load the page without the form data, but when I try to load the page with the SAEF tags I get this error:

Notice: Undefined property: Template::$site_ids in /var/www/html/ee/admin/modules/weblog/mod.weblog_standalone.php on line 209

Warning: implode() [function.implode]: Bad arguments. in /var/www/html/ee/admin/modules/weblog/mod.weblog_standalone.php on line 209
MySQL ERROR:

Error Number: 1054

Description: Unknown column ‘site_id’ in ‘where clause’

Query: SELECT weblog_id from exp_weblogs WHERE site_id IN (’’) AND blog_name = ‘blog_listing’ AND is_user_blog = ‘n’

Here is my current code:

{exp:weblog:entries weblog="blog_listing"}
{exp
:weblog:entry_form weblog="blog_listing" return="resources/blogs"}

<input type="hidden" name="entry_id" value="{entry_id}" />
<
input type="hidden" name="title" value="{title}" />
<
input type="hidden" name="entry_date" value="{entry_date format='%Y-%m-%d %g:%i %A'}" />

<
table>
<
tr>
<
td>

<
p>Name *<br />
<
span style="font-size:9px; color:gray; ">
First and Lastplease
</span><br />
<
textarea name="{exp:form_helper:field_grabber field_name='name'}" />{exp:form_helper:field_parser}{name}{/exp:form_helper:field_parser}</textarea>
<
input type="hidden" name="{exp:form_helper:field_grabber field_name='name' which='format'}" value="br" />
</
p>

--- 
other custom fields removed for easier readingthey are exactly the same as the above code just with a different name. ---

</
td>
<
td valign="top">

<
input type="submit" name="submit" value="Submit" />

{exp:form_helper:statuses entry_id="{entry_id}" exclude="open"}
<input type="radio" name="status" value="{entry_status}" {checked} /> {entry_status}
{
/exp:form_helper:statuses}

</td>
</
tr>
</
table>

{/exp:weblog:entry_form}
{
/exp:weblog:entries}

Any help would be appriciated.
Thank you!

p.s. I’ve never used ExpressionEngine before Monday so this is all rather new to me.

Profile
 
 
Posted: 12 May 2008 05:58 AM   [ Ignore ]   [ # 1 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  3350
Joined  2006-10-18

I’m assuming this is on the latest version of ExpressionEngine, and using Form Helper 1.9 off the Solspace site? smile

Also, do you have the Multiple Site Manager installed?

 Signature 
Profile
 
 
Posted: 12 May 2008 06:35 AM   [ Ignore ]   [ # 2 ]
Newbie
Rank
Total Posts:  4
Joined  2008-05-08

We’re using version 1.5.2 of EE and I downloaded and installed Form Helper 1.9 from the Solspace site.

How would I tell if I have Multiple Site Manager Installed?

Profile
 
 
Posted: 12 May 2008 06:45 AM   [ Ignore ]   [ # 3 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  3350
Joined  2006-10-18

Kurtis,

The very very left/first tab at the top would say “Sites” smile
I’m assuming you’ve taken over this website from someone else?

 Signature 
Profile
 
 
Posted: 12 May 2008 07:08 AM   [ Ignore ]   [ # 4 ]
Newbie
Rank
Total Posts:  4
Joined  2008-05-08

no “sites” tab - just these tabs:
Publish | Edit | Templates | Communicate |Modules | My Account | Admin

I’m actually a new employee to help develop parts of the site.

Profile
 
 
Posted: 12 May 2008 08:49 AM   [ Ignore ]   [ # 5 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  3350
Joined  2006-10-18

Kurtis,

What happens if you try to use just the Stand-Alone Entry Form from the ExpressionEngine Docs? smile

It would also be great if you would be able to upgrade your EE to the latest version (1.6.3) smile
Though I will warn you, it could break a few things, depending on some 3rd party software you have installed, but I’ll be more than happy to help you through it smile

 Signature 
Profile
 
 
Posted: 12 May 2008 10:03 AM   [ Ignore ]   [ # 6 ]
Newbie
Rank
Total Posts:  4
Joined  2008-05-08

I just tested the Stand Alone Entry Form and I get the same error. Now I’m thinking that something with EE is wrong and not Form Helper.

Thanks for your help. I’ll bring this up when I chat with the owner today and see if he can tell what’s wrong.

Profile