Thread

Where do I export my posts, categories, and templates from the hosted demo?

I set up a test EE Core site, want to put in the work we’ve done.

And how do I import?

Thanks

Hi Ppolack,

You can find instructions for updating from the 30-day demo in the User Guide.

That document says to the Full Version. Is it going to work in the Core Version, until we buy it?

> Step 3

> Restore the database you backed up in step 1 to your new server, replacing the database tables that were created when you installed ExpressionEngine in step 2.

How do I do this?

Through EE Admin panel?

ppolack, you’re going to need something like PHPMyAdmin to replace those tables.

I imported the sql file from the hosted demo via PHPmyadmin. I went to Import, chose the file, clicked import. It added some tables.

“Import has been successfully finished, 423 queries executed.”

But now the admin is not working:

MySQL ERROR:

Error Number: 1054

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

Query: SELECT m.weblog_id, m.tmpl_group_id, m.username, m.screen_name, m.member_id, m.email, m.url, m.location, m.join_date, m.last_visit, m.last_activity, m.total_entries, m.total_comments, m.total_forum_posts, m.total_forum_topics, m.last_forum_post_date, m.language, m.timezone, m.daylight_savings, m.time_format, m.profile_theme, m.forum_theme, m.private_messages, m.accept_messages, m.last_view_bulletins, m.last_bulletin_date, m.display_signatures, m.display_avatars, m.last_email_date, m.notify_by_default, m.ignore_list,  m.upload_id, m.cp_theme, m.quick_links, m.quick_tabs, m.template_size, g.* FROM exp_members AS m, exp_member_groups AS g WHERE   g.site_id = ‘1’
              AND   unique_id = ‘bunch of numbers and letters’
              AND   password = ‘bunch of numbers and letters’
              AND   m.group_id = g.group_id

And the site is not working:

MySQL ERROR:

Error Number: 1054

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

Query: SELECT member_id, admin_sess, last_activity
                      FROM   exp_sessions
                      WHERE session_id = ‘bunch of numbers and letters’
                      AND   ip_address = ‘’
                      AND   user_agent = ‘’ AND site_id = ‘1’

Is the issue that I am working with Core and not a different version?

Also looks like the hosted demo is v1.5.2 and the Core is 1.6.0

Hi ppolack,

A couple things.

1. Since you’re moving from 1.5.2 to 1.6, you’ll need to run the update script for 1.6. Make sure you’ve uploaded the system/update and system/update.php and then start with Step 4 of the Upgrade instructions.

2. Moving from the full version of 1.5.2 (which is what your demo is) to 1.6 Core is no problem as there are no database changes. Just be aware that any functionality requiring the full version will not work until you update 1.6 Core to the full version of 1.6.