Thread

Thanks. Let’s try repairing the tables on the old site. Go to Admin ›  Utilities ›  SQL Manager ›  Manage Database Tables. Then select all of the tables, choose ‘Repair selected tables’ at the bottom and click Submit.

Do you still get that SQL Error when logged in?

I do the BD repairing in the old server and I have the same problem the explorer shows:
MySQL ERROR:
Error Number: 1146
Description: Table ‘brokerde_bddbrokernegocios.exp_global_variables’ doesn’t exist
Query: SELECT variable_name, variable_data FROM exp_global_variables WHERE site_id = ‘1’ AND user_blog_id = ‘0’

As soon as i enter http://www.brokerdenegocios.net/, if I delete the cookies It desapears.

In the new server I already have installed the new EE (different from the EE on the old server) but I dont know what is next??
Please help me I have been in this issue for several weeks and I find really complicated the migration.
Thanks for your help.

Please check your email.

I already fill the form with the data from the new server, because is there where I want to install the site, Im not interested in solving things in the old one, because Im gonna delete the site in the old one. I want things solve in the new one.
I can send you the backup of the database of the old one and the ftp access to the files in order to perform the installation in the new one.
If you can help with this.
Thanks!

Webmaster esDinamico,

It would be best if we could solve the problem on the old server. Then you could simply transfer the database over to the new server (we can not do that via FTP). Please fill out the form again with details for the old server.

Ok I filled the form. I will appreciate you can solve this issue. Thanks.

Webmaster esDinamico,

I took a look and the error on the homepage is caused by PHP in your index template (broker_de_negocios/index). In fact, all of the templates in that group have huge amounts of PHP, as if the code from another content management system was pasted in as EE templates.

The good news is that the site only has 19 weblog entries. I would suggest that you create the templates you need on the new site (there is eventually HTML in the templates on the old site if you scroll down far enough, then you can copy and paste just the HTML to the new templates) and then recreating the weblog entries. I would NOT suggest moving your database directly from the old site to the new.

Brandon,
Yes we have PHP code inside the pages because we do queries to another database, we created that code by ourself we didnt use another content management. And we need this to get the main information of the site.
There is a database conflict? What we can do if we dont want to delete this php code as you suggest?
And we can’t do everything again if we need to migrate to another hosting. It will be so much work.
A migration shouldn’t be a big problem, it is supossed to be easier. Anyway can you explain me what we are supossed to do if we want to migrate this site to ahother hosting without create the pages again?
Thanks in advance.

Hi Webmaster esDinamico,

You should try and fix the PHP errors that your site has before attempting the move because if there are problems during the move you won’t know what is causing the issue. In terms of a migration you would copy of your site files over to the new host, export the database from your old host and import it using a tool like PHPMyAdmin on your server. Then you would need to edit the site preferences appropriately. However, as Brandon says, do not do this if your existing site has problems. Try and fix them first and you might also test out the move by recreating your site on a local server first.

Cheers

Greg

Hello I im doing the migration but I have a problem with a column of the exp_category_groups table, this is the error:

INSERT INTO `exp_category_groups` ( `group_id` , `site_id` , `group_name` , `sort_order` , `field_html_formatting` , `can_edit_categories` , `can_delete_categories` , `is_user_blog` )
VALUES ( 1, 1, ‘Default Category Group’, ‘a’, ‘all’, ‘’, ‘’, ‘n’ ) ;

MySQL ha dicho: Documentación
#1054 - Unknown column ‘is_user_blog’ in ‘field list’

What can I do in order to insert that records.

Also you mentioned that I need to edit the site preferences appropriately, wich are this preferences can you give a hand with this? Thanks in advance.

In fact I have several problems migrating the database, some tables has changed and once I tried to restore the database it shows error because this changes, What can I do?

Webmaster esDinamico,

lets just review what you have done so far.

Your original site is version 1.6.7 correct?

Do not touch anything on your target server yet. Don’t install EE there as that is not how to migrate an installation.

You concentrate on getting your existing site working first and upgraded and then you migrate the site but this is done by moving files and importing a database not by installing a new site and merging installations.

To reiterate, these are the docs you follow to upgrade you existing installation.
EE Docs : Updating from a Previous Version of ExpressionEngine

To get rid of your errors you will need to edit those templates. The PHP you added is the cause of that error.

One thing you could try temporarily is in your Database settings change the Database Connection Type to Persistent

Admin > System Preferences > Database Settings

Hello thanks for the answer but unfortunately I have problems with the updating, I am following the steps on:
http://expressionengine.com/legacy_docs/installation/update.html
but I cant figure out wich folders Im supossed to upload if the paths are not the same in the production server and in the folders of the new version of the ExpressionEngine software, in this case ExpressionEngine 2.x Freelancer License.
Here is the detail of the folders:

The folder system/core/: I cant find it in the same path, there are core folders in:
system\codeigniter\system\core
system\expressionengine\core
system\installer\core

I can’t find the folder system/cp/ in the new version  

There is not a system/db/ folder, there Is just a database folder in:
system\codeigniter\system\database  

The folder system/language/: I cant find it in the same path, there are language folders in:
system\codeigniter\system\language
system\expressionengine\language
system\installer\ language  

I can’t find the folder system/lib/in the new version
     
The folder system/modules/: I cant find it in the same path, there are modules folders in:
system\expressionengine\modules  
 
The folder system/plugins/: I cant find it in the same path, there are plugins folders in:
system\expressionengine\ plugins
 
I can’t find the folder updates in the new version

I can’t find the file system/update.php in the new version

The folder system/utilities/: I cant find it in the same path, there are utilities folders in:
system\expressionengine\utilities  

Please Could you reply faster?, I have to wait one day for each post. I will appreciate if you can help me sooner. Thanks in advance.

Hi Webmaster esDinamico,

If you are trying to upgrade a 1.x installation to 2.x you need to follow these instructions.

Cheers

Greg