5
votes
Accepted
Where is the base_url in the database?
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-...
4
votes
Accepted
Upgrade error: Unknown column ‘protect_javascript’ in ‘field list’
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
votes
Accepted
Run plugin without affecting loading time (external)
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.)
...
4
votes
Run plugin without affecting loading time (external)
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 ...
4
votes
EE3 --> Multiple Concurrent Database Connections via config files
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 ...
3
votes
Accepted
What's wrong with this SQL query?
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
...
3
votes
Accepted
Database corruption due to InnoDB?
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 ...
3
votes
EE Version Number Error on version 2.4
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 ...
3
votes
Accepted
Disabling Cartthrob via database - How to?
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 ...
3
votes
Accepted
Set Entry ID & Member ID's higher
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, ...
3
votes
Accepted
Database connection issues upgrading to EE5
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' =&...
2
votes
New to EE - looking for some insight
The idea behind EE is that you don't need to manage database tables. using the admin interface to create channels and custom fields will do all that for you. I suggest you start by reading an EE ...
2
votes
New to EE - looking for some insight
Welcome to the EE community!
Have a look at an add-on called Freeform. This is a free add-on that allows you to create different forms (there's a paid version if you need additional functionality, ...
2
votes
Super Search DB error with Matrix fields
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 ...
2
votes
Automatically removing old entries
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 ...
2
votes
Unable to connect to database using WAMP
It sounds to me like you'll need to setup a multi-environment /system/expressionengine/config/database.php file. Here's a glimpse of how I typically set mine up:
<?php if ( ! defined('BASEPATH')) ...
2
votes
Different values of checkbox for different members?
...and also a checkbox that will show whether the user has completed that
resource
You can't store the member choices in the channel entries information.
Well, technically you could, but it would ...
2
votes
Accepted
Is it possible to use ExpressionEngine with an Oracle database?
Nope - ExpressionEngine requires MySQL or a compatible drop-in replacement.
2
votes
Accepted
Transfer EE site to GoDaddy
@BrianMallett was able to resolve this by re-importing his database as it did not properly import to GoDaddy the first time.
2
votes
is it healthy to built a web services or a web app using EE?
The real value/power of EE is in the control panel, and how quickly you can pull together complex data-driven sites by not having to build an admin interface. I'm currently building a mobile app that ...
2
votes
is it healthy to built a web services or a web app using EE?
It's really a matter of "it depends"
There are a lot of factors that can help you determine whether EE is good as a long-term platform for a site, so there's no clear answer.
You have to look at ...
2
votes
Upgrade error: Unknown column ‘protect_javascript’ in ‘field list’
Quick dirty nasty fix to get you out of a hole.
EE is was having a problem with the contents of a template when I ran into this.
Go to your exp_templates table and find the offending template. (in ...
2
votes
Keeping Expression Engine DB's In Sync
I typically make database changes on the live site and then copy that from live to live to staging/local and then do templates/css/js work before pushing it back to staging/live.
This has worked well ...
2
votes
Accepted
How To Manipulate Database In Custom Expresso Store Payment Gateway
I assume you are using Store > 2. If that is the case you would be making your own extension. Store has a default layout for these extensions available on github here.
If you notice in the ext....
2
votes
Accepted
Date When A Channel Field Was Added
It doesn't look like it. The only field that could hold that data is the field_settings column, and that just has a few settings in an array that are serialized.
Array
(
[tagger] => Array
(
[...
2
votes
Accepted
Where are relationship field data stored?
Relationships are stored in exp_relationships - the exp_channel_data content for a relationship field is irrelevant.
So your query would need to do a join between exp_channel_titles and ...
2
votes
ExpressionEngine database redundency
A few things to make note of when switching to Percona, MyISAM replication is experimental and disabled by default. I would be surprised if it ever becomes fully supported.
MyISAM replication is done ...
2
votes
How can I import a Filemaker database into EE?
DataGrab and Solspace Importer add-ons can both import various types of data into EE, such as CSV, XML, etc that can be exported from FileMaker.
I would look at both of these add-ons and work out ...
2
votes
Accepted
Variables overwritten by database
Low Variables variable syncing works like this. Note that each time you save a LV in the Control Panel, its DB edit date is updated:
Vars marked save as file are fetched from the DB;
Variable ...
2
votes
Accepted
Can you tell which version EE is just from the database?
This would only work if the install of EE had been updated at least once since initial install, but there is a log of version updates found in table exp_update_log. You've probably already checked ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
database × 215mysql × 28
ee2 × 23
query × 16
php × 13
error × 12
database-error × 12
channel-entries × 10
config × 10
members × 9
upgrade × 9
multi-site-manager × 8
custom-fields × 8
add-on-development × 7
plugin × 7
performance × 7
cartthrob × 6
ee2-upgrades × 6
cache × 6
assets × 5
control-panel × 5
channel × 5
structure × 5
module × 5
templates × 4