Thread

hooray!! it worked. now on to try and see if the installation will work.

thanks for all your help so far. I will try the installation and let you know.

Good stuff 😊 Let us know how you get on

okay so now it’s half working. the control panel runs and i can login and everything, but the site is not showing up at all :( i wonder if it’s because it was a new install and not an upgrade that i don’t have any templates in the cp. is there any way to get that back? if i have a backup of the database (of when it was live) will that bring them back or is that just in the cp? maybe i’m not asking the right question here.

I don’t think you would not have a site if you didn’t have the templates from the old server…..

The templates are stored in the db….that is, the templates you created
exp_templates

Some templates, such as the forum and the wiki, are stored in regular files.

I’m sure there are ways to restore it….importing and exporting the templates. But I think the preferred way would be to move the entire old DB back into place, because then all the relationships would match (such as who created the templates, superadmins, etc.).....

I’ll let the experts chime in on this one…..

If you only have a few templates, you can do some copy and paste and create new ones in the new setup…..but if you had a bunch of content (populated templates), then moving the whole EE db might be the best way to go.

okay, so i imported the previous db and the home page show up! but the cp is not working. i’m not sure, but i’m guessing that some of the links in the db are wrong because the cp is not coming up. it’s just blank and i can’t access it, where i could just before i imported the previous db. i tried changing a few of the ones that i could find in the templates from the old domain to the new one, but i’m not sure where to find the cp?

derrickkempf,

the blank page may be a suppressed error. Can you open up system/index.php and turn on debugging

$debug = 1;

Now revist the blank page. Does an error appear?

man it’s been longer then i thought. i’ve been crazy busy working on other projects and this one has been on hold for a little bit, but i am back in the fold…

i turned on debugging and this is what i got:

A Database Error Occurred

Error Number: 1054

Unknown column ‘show_sidebar’ in ‘field list’

SELECT `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`.`parse_smileys`, `m`.`last_email_date`, `m`.`notify_by_default`, `m`.`ignore_list`, `m`.`crypt_key`, `m`.`cp_theme`, `m`.`quick_links`, `m`.`quick_tabs`, `m`.`template_size`, `show_sidebar`, `g`.* FROM (`exp_members` m, `exp_member_groups` g) WHERE `g`.`site_id` = ‘1’ AND `unique_id` = ‘’ AND `password` = ‘’ AND m.group_id = g.group_id

Filename: libraries/Session.php

Line Number: 494

i have no idea what this means :o

Hi derrickkempf,

Can I confirm with you that you have installed the same version of EE on your new server as was running on your old one i.e. version 2.1.0? This error suggests that you have imported your old DB into a newer version of EE. Can you clarify exactly what you’ve done?

Cheers

Greg

good question. i actually installed the new version on the new server ad uploaded the old db to the new one.

Hi derrickkempf,

That’s the cause of this issue. The reason is that when there is a version number change then it means that there are alterations to the DB schema - that’s why there are two different processes; one for upgrading from an earlier build and one for upgrading from an earlier version. A build change only changes the content of files and doesn’t require a DB change so there is no need to run the installer. You will need to install the exact same version on your new server and then importing the DB should work properly. You can then run through the process to upgrade to the latest version.

Cheers

Greg

awesome. thank you so much! seriously.

i’ll post an update in a little bit after i do that.

thanks again though.

Hi derrickkempf,

No problem at all. We’ll be here when you have an update.

Cheers

Greg

not sure what i’m doing wrong, but when i go to domainname.org/system/installer i get “directory access is forbidden.” i made sure that the permission are set properly. i also removed the db and uploaded the files so i could try a clean install.

Hi derrickkempf,

Just go to domain.com/system. Do not specify the installer folder. The wizard should then run. Please try that and let me know if it works ok.

Cheers

Greg