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-...
user avatar
  • 5,900
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
user avatar
  • 7,176
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.) ...
user avatar
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 ...
user avatar
  • 5,781
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 ...
user avatar
  • 2,255
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 ...
user avatar
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 ...
user avatar
  • 2,255
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 ...
user avatar
  • 7,556
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 ...
user avatar
  • 5,407
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, ...
user avatar
  • 2,418
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' =&...
user avatar
  • 5,900
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 ...
user avatar
  • 231
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, ...
user avatar
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 ...
user avatar
  • 131
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 ...
user avatar
  • 1,156
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')) ...
user avatar
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 ...
user avatar
  • 5,353
2 votes
Accepted

Is it possible to use ExpressionEngine with an Oracle database?

Nope - ExpressionEngine requires MySQL or a compatible drop-in replacement.
user avatar
  • 17.4k
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.
user avatar
  • 1,449
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 4,747
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....
user avatar
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 ( [...
user avatar
  • 234
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 ...
user avatar
  • 17.4k
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 11.3k
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 ...
user avatar
  • 607

Only top scored, non community-wiki answers of a minimum length are eligible