Body text not displayed after updating EE 1.1
Posted: 17 August 2004 07:04 AM
[ Ignore ]
Lab Assistant
Total Posts: 163
Joined 09-16-2003
My site is only showing the headlines and not the body text after updating to ExpressionEngine
1.1
Any ideas?
Signature
AFpunt - - - - A Pointless Weblog - - - -
Posted: 17 August 2004 07:48 AM
[ Ignore ]
[ # 1 ]
Administrator
Total Posts: 2541
Joined 12-21-2001
Is the body visible if you edit an entry?
Signature
Posted: 17 August 2004 08:06 AM
[ Ignore ]
[ # 3 ]
Administrator
Total Posts: 2541
Joined 12-21-2001
Did you rename the body field to something else, in your Admin > Custom Weblog Fields page? If so, the {body} variable used in your templates will need to be updated to the new name. That’s the only thing I can think of that would cause a field to not show up.
Signature
Posted: 17 August 2004 08:14 AM
[ Ignore ]
[ # 4 ]
Lab Assistant
Total Posts: 163
Joined 09-16-2003
No, I didn’t rename the body field.
Besides this problem, my links like this one: <li><a href=”{path=weblog/archives}”>Compleet Archief</a></li>
don’t work anymore. It’s very confusing!?
Signature
AFpunt - - - - A Pointless Weblog - - - -
Posted: 17 August 2004 08:37 AM
[ Ignore ]
[ # 5 ]
Administrator
Total Posts: 2541
Joined 12-21-2001
Are you using any plugins with the body field? Or are you showing the body field in a conditional or some other scripting? What is the syntax of you weblog tag?
Signature
Posted: 17 August 2004 09:37 AM
[ Ignore ]
[ # 6 ]
Lab Assistant
Total Posts: 163
Joined 09-16-2003
{exp:weblog:entries weblog=“weblog1” orderby=“date” sort=“desc” limit=“15”}
{date_heading}
<h3 class=“date”>{entry_date format=’ %l, %d %F, %Y ‘}</h3>
{/date_heading}
<h2 class=“title”>{title}</h2>
{body}
{/exp:weblog:entries}
Signature
AFpunt - - - - A Pointless Weblog - - - -
Posted: 17 August 2004 10:35 AM
[ Ignore ]
[ # 7 ]
Lab Assistant
Total Posts: 163
Joined 09-16-2003
I copied the old EE 1.0 files back to the server and still the body is not displaying?
So I guess there must be something wrong with the SQL database?
Signature
AFpunt - - - - A Pointless Weblog - - - -
Posted: 17 August 2004 10:46 AM
[ Ignore ]
[ # 8 ]
Administrator
Total Posts: 2541
Joined 12-21-2001
Try repairing your mysql database.
In your EE control panel, go to:
Admin > SQL Manager > Manage Database Tables
Select all the tables using the checkboxes, then with the pull-down menu at the bottom, select “Repair”.
Signature
Posted: 17 August 2004 10:51 AM
[ Ignore ]
[ # 9 ]
Lab Assistant
Total Posts: 163
Joined 09-16-2003
After repairing the MySQL database I get the following error”
MySQL ERROR:
Error Number: 1146
Description: Table ‘afbase.exp_actions’ doesn’t exist
Query: SELECT action_id FROM exp_actions WHERE class= ‘Trackback_CP’ AND method = ‘receive_trackback’
Signature
AFpunt - - - - A Pointless Weblog - - - -
Posted: 17 August 2004 11:07 AM
[ Ignore ]
[ # 10 ]
Administrator
Total Posts: 2541
Joined 12-21-2001
In the same page where you repaired your tables, do you see a table called exp_actions listed?
Run the repair utility again.
Signature
Posted: 17 August 2004 01:47 PM
[ Ignore ]
[ # 12 ]
Administrator
Total Posts: 2541
Joined 12-21-2001
Sounds like you are having serious database problems.
In the SQL query form (in SQL manager), submit this:
CREATE TABLE exp_actions (
action_id int ( 4 ) unsigned NOT NULL auto_increment ,
class varchar ( 50 ) NOT NULL ,
method varchar ( 50 ) NOT NULL ,
PRIMARY KEY ( action_id )
)
You’ll then need to go into your MODULES page and install each one of your modules.
Hopefully that’s the only problem.
Signature
Posted: 18 August 2004 12:05 AM
[ Ignore ]
[ # 13 ]
Lab Assistant
Total Posts: 163
Joined 09-16-2003
Ok, I created the actions table and installed the modules.
Now the MySQL error is gone and I’m back with only the Headlines displaying and not the body!?
Signature
AFpunt - - - - A Pointless Weblog - - - -
Posted: 18 August 2004 01:20 AM
[ Ignore ]
[ # 14 ]
Lab Assistant
Total Posts: 163
Joined 09-16-2003
I deleted the config.php and put back the ‘old’ one and now my body is displaying correctly.
So now I’m back at the point before updating to ExpressionEngine 1.1
I don’t now what exactly caused this problem. I’m afraid when I do the update again, the same situation will occur.
Signature
AFpunt - - - - A Pointless Weblog - - - -
Posted: 18 August 2004 01:27 AM
[ Ignore ]
[ # 15 ]
Lab Assistant
Total Posts: 163
Joined 09-16-2003
These are the lines that are new in the config.php and one of them must cause the problem!?
$conf[‘captcha_require_members’] = “y”;
$conf[‘require_ip_for_posting’] = “y”;
$conf[‘new_posts_clear_caches’] = “y”;
$conf[‘tmpl_display_mode’] = “auto”;
$conf[‘default_site_timezone’] = “”;
$conf[‘default_site_dst’] = “n”;
$conf[‘enable_js_calendar’] = “y”;
$conf[‘save_tmpl_files’] = “n”;
$conf[‘tmpl_file_basepath’] = “”;
$conf[‘calendar_thumb_path’] = “http://guus.afpunt.nl/images/cp_images/calendar.gif”;
$conf[‘cp_image_path’] = “http://guus.afpunt.nl/images/cp_images/”;
$conf[‘redirect_submitted_links’] = “n”;
$conf[‘site_404’] = “”;
$conf[‘weblog_nomenclature’] = “weblog”;
Signature
AFpunt - - - - A Pointless Weblog - - - -
Posted: 18 August 2004 08:51 AM
[ Ignore ]
[ # 17 ]
Research Scientist
Total Posts: 7534
Joined 08-05-2002
Have you tried turning on debugging and see if any errors are shown? I put those values in my config and my entries still showed up fine.
Signature