5
Well, it doesn't particularly matter where it is stored in the database, as you can override that value in your config file.
https://docs.expressionengine.com/latest/general/system-configuration-overrides.html
https://docs.expressionengine.com/latest/general/system-configuration-overrides.html#base_url
So as long as you have access to the file system, you ...
4
There are two issues here to deal with.
Exporting Data from the old site
This can be done in a variety of ways. And it's arguably the easier task. I generally write custom PHP scripts, or sometimes a CodeIgniter app to connect to a copy of the original database and output XML files from it. It's just a matter of collecting all the needed fields. Since you'...
4
You can use the channel fields api to get the field names:
ee()->load->library('api');
ee()->api->instantiate('channel_fields');
$fields = ee()->api_channel_fields->fetch_custom_channel_fields();
//change 1 to your site_id if using MSM
$quantity_field_id = $fields['custom_channel_fields'][1]['your_quantity_field_name'];
$sql .= "picd....
4
For the sake of completeness you can fix this with a simple SQL query to add the required column. See see this official EE thread
4
You can do this by developing your add-on as a module rather than a plugin since only modules can use EE actions. (See the EE docs for an explanation of the difference between the types of add-on.)
More info on EE actions here.
Essentially, you need to develop a module to perform your desired action, then call the associated ACT URL (e.g. http://example....
4
You can make a module - like Steve advice. Use Yeoman ExpressionEngine Add-On generator to simplify developing process. On server you will need to setup cron with wget:
execute cronjob every day at 3am
00 03 * * * wget http://example.com/index.php?ACT=XX&task_id=1
Or if you want something really quick and simple:
Create a special template with some ...
4
Please see the documentation for full details: Connecting to an External Database
But the basic pattern for spinning up a separate DB connection in v3 would be:
Create a DBConfig object from your database's connection settings
Create a new Database object using the DBConfig object
Issue queries to a Query object on the new database with ->newQuery(), ...
3
I figured it out.
in API_channel_entries.php, the title was being brought in before insertion like this:
'title' => ($this->EE->config->item('auto_convert_high_ascii') == 'y') ? ascii_to_entities($data['title']) : $data['title'],
I don't update regularly (we've made a lot of hacks to make EE work for us) so it's likely just my issue but that ...
3
Can you define what you mean by "a modern CMS"? Any database driven system will face similar problems when using Git source control. This isn't specifically an ExpressionEngine problem. The only systems that wouldn't suffer this difficulty are those using flat file architecture.
I often use Git with ExpressionEngine. The only possible sticking point being, ...
3
It's tricky. I'm in a similar situation, though I'm migrating from a non-EE site. So, I've had to write a number of SQL and PHP scripts that "know" what data can change and what can be new, and can grab just the change and insert or update into the EE database in the right place.
But, take a look at this technique for capturing database queries on one EE ...
3
To get all your paths/urls changed is a bit of a PITA since they are located in so many different sections of the CP. The easiest way to do this is with an addon. The two most popular are:
Deeploy Helper $22 (I prefer this one - use it on almost every build)
or
REElocate (free)
3
Since your files transferred just fine, it's the database export/import process that failed you.
If you are transferring a database from one server to another it is ideal to do one or both of the following:
Export the database you are duplicating with DROP TABLES syntax and gzipped. If you don't add DROP tables syntax, you'll just merge the tables possibly ...
3
You can temporarily disable ALL addons by adding this to your config file:
$config['allow_extensions'] = 'n';
This should allow you to access the Control Panel and then attempt to delete Cartthrob from there (if you're sure you don't want to delete all your sales data!). If that fails then look in the exp_modules and exp_extensions tables in the database ...
3
You will want to open up your CP and navigate to Admin > System Preferences > General Configuration and scroll down to New Version Auto Check and set that to "No". From the EE1 docs:
New Version Auto Check
Enabling this feature will cause a message to be displayed in the
Control Panel when a new version of ExpressionEngine is available. It
will ...
3
You probably need to check with your web host, as that error tells me that they made a change to MySQL server, and it's no longer configured to work with InnoDB. Or that you just moved from a host that supported InnoDB to one that does not.
There aren't any huge gotchas with running different engines on different tables as long as you or your web host are ...
3
I ran it and I'm getting results just fine.
Are you outputting the results correctly?
$query = ee()->db->query('SELECT cat_url_title, cat_name, ch.channel_name FROM exp_categories c
LEFT JOIN exp_channels ch ON ch.cat_group = c.group_id
WHERE c.cat_name LIKE "%'.ee()->db->escape_str($keywords).'%"');
foreach($query->...
3
It is possible, and I think it's safe but as you are doing make sure you backup test and roll back if you get unextpected results. (Is it safe??? lol)
You where almost rigth with what you did before, however exp_channel_data is not the indexed table for channel data, you want exp_channel_titles, these are your 2 queries :
ALTER TABLE `exp_channel_titles` ...
3
In EE 3/4/5, your database connection configuration lives in your system/user/config/config.php file. The configuration should look like this:
$config['database'] = array (
'expressionengine' =>
array (
'database' => '',
'hostname' => '',
'username' => '',
'password' => ''
),
...
2
Yes there is! Andrew Weaver's Purgedata plugin will do exactly this.
Plugin page on brandnewbox
Download EE 2.x version from Bitbucket
From his website:
Delete content from selected weblogs that is older than a specified time
Ideal to accompany FeedGrab, CSVGrab and XMLGrab.
It works by adding the plugin's tag to an EE template and visiting the ...
2
In your config.php, you can set the site URL like this, and it should work on both your localhost and live server without needing to be updated.
$config['site_url'] = 'http://' . $_SERVER['HTTP_HOST'];
Or, you can put the literal URL in there, and edit it once you move the file from server to server.
2
Set the value of $config['site_url']on the file system/expressionengine/config/config.php.
But you gonna maybe have to set another variables, too:
$config['cp_url']
$config['tmpl_file_basepath']
$config['avatar_path']
$config['avatar_url']
$config['captcha_path']
$config['captcha_url']
$config['theme_folder_path']
$config['theme_folder_url']
And don't ...
2
Turns out it was a password issue. MT didn't like the original password I entered for some reason. Changing it fixed everything.
2
Don't try and mess with a failed upgrade. Revert back to previous & start again.
Given the failure point was updater I'd recommend a manual update.
2
I am experiencing the same problem where it seems to happen when "Is field searchable?" is enabled within the field settings containing the Matrix field-type (not sure why??!)...
I found a solution by changing line 7595 from
$select .= ', field_id_'.$fields[$key].' AS `'.$key.'`';
to
$select .= ', cd.field_id_'.$fields[$key].' AS `'.$key.'`';
Within mod....
2
Ok.
I changed the storage engine of EE database from MyISAM to InnoDB. And now the database is replicating the primary key columns of the exp_templates and exp_template_groups tables correctly.
It may have something to do with Percona Clusters' limitations:
The main Percona site (Percona XtraDB Cluster Limitations) states:
Currently replication works ...
2
Indeed, EE is missing a native workflow module. This is what it is. Thankfully, there is a robust developer community that stepped in and created options. I'd say your best bet is to get one of these working to protect the integrity of your data. Here are three in no particular order:
Better Workflow
http://devot-ee.com/add-ons/better-workflow
Publisher
...
2
Make sure you also remove any rows referencing Structure references in the modules, extensions, and accessories tables.
2
You can store your field id's as config vars, so you can change them per environment. Nice thing about this is you don't incur an extra query to get the field names.
In your main config.php
$config['your_addon_quantity_field'] = 3;
In your addon:
$quantity_field = ee()->config->item('your_addon_quantity_field');
$sql .= "picd.field_id_{$...
2
I think this should do it, but you should take a database backup just in case. You might need to run each group separately.
// Update the Categories Table
UPDATE exp_categories
SET 'cat_id' = 137
WHERE 'cat_id' = 130
// Update the Categories Field Table
UPDATE exp_category_field_data
SET 'cat_id' = 137
WHERE 'cat_id' = 130
// Update the Category Posts ...
2
For this particular quandary, this worked:
Add this line to the top of the SQL file:
SET FOREIGN_KEY_CHECKS = 0;
Source: http://devot-ee.com/add-ons/support/stash/viewthread/5700
If you see this problem and the above solution doesn't work, check this thread as well:
http://devot-ee.com/add-ons/support/stash/viewthread/10311
Only top voted, non community-wiki answers of a minimum length are eligible