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-...
- 5,900
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 ...
- 2,255
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' =&...
- 5,900
2
votes
Channel Entry Model how do I get file url in grid field?
You've probably already found a workaround to this, but thought I'd throw in my 2¢ for others that are trying to get models to work.
Models seem to be decent to use if you're doing simple things with ...
- 21
2
votes
Export and import of Cartthrob/EE data?
For data import, I highly recommend using AJW datagrab with CSV data.
http://brandnewbox.co.uk/products/details/datagrab
data export is a little bit trickier, but you can setup a template to output ...
- 589
2
votes
Accepted
Database error 1054 after upgrade to ee 2.11.6
The "Fingerprint field" is missing in DB.
Go to Database to trigger this query.
ALTER TABLE `exp_sessions` ADD `fingerprint` VARCHAR( 40 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER ...
- 2,177
2
votes
Accepted
Table doesn't exist after upgrade
Seems related to this bug report. If you have a conditional checking for something like this:
{if grid_field:total_rows > 0}
try changing that to this:
{if '{grid_field:total_rows}' > 0}
- 11.3k
2
votes
How to use a remote database inside docker containers
Figured it out.
FROM php:fpm-alpine
Doesn't include the mysql mods. I had to add this line to my dockerfile for php container:
RUN docker-php-ext-install mysqli pdo pdo_mysql
- 21
1
vote
syntax error or access violation: 1118 row size too large
It would help to know what version of EE you are using - good practice is to include this along with details of your php environment in your question; different versions of EE have different ...
- 3,585
1
vote
Accepted
What's the best, and fastest way, to remove large amounts of data from the database?
We ended up running similar queries found here Quick and safe way to delete all entries with a given status? and here Quickly delete 1000s of members
We were actually able to remove millions of rows ...
- 167
1
vote
Accepted
Export and import of Cartthrob/EE data?
For a simple EE to EE migration (within v.2 at least) there's no need for Datagrab et al, just export the SQL tables that you want and import into the other database.
- 4,885
1
vote
Accepted
Passing a GET variable back in a query while using mysqli_real_escape_string()
Use ee()->db->escape_str($event) - it's the native way to escape potentially-unsafe data in EE.
- 17.4k
1
vote
How to proceed after upgrade error ee2 to 3?
EE2 and EE3 have their config files in different directories. Did you do these two things?
Copy system/expressionengine/config/config.php to system/user/config/config.php
Copy system/expressionengine/...
- 526
1
vote
Cannot convert exp_channel_data to INNODB
After spending some months on this exact problem (we have 360 or so custom fields), here's what I've learned:
RDS snapshots are only consistent for InnoDB tables.
Converting exp_channel_data to ...
1
vote
Accepted
Creating user datasets when logged in
I don't know if this is exactly what you're after, but you can use the plugin Shortlist to let visitors tag channel entries and then collect them into a list.
https://eeharbor.com/shortlist
1
vote
Accepted
InnoDB or MyISAM - What's the "correct" database storage engine for EE4/EE5?
EE now defaults to using InnoDB type tables in MySQL.
The docs have instructions on how one can convert MyISAM tables to InnoDB (here).
Whether it makes any difference on an average site is moot, ...
- 3,585
1
vote
Database access from another server
EE stores its data (by default) in a MySQL database using InnoDB type tables (earlier versions of EE used MyISAM type tables): MySQL or Percona are listed as requirements for the latest versions of EE,...
- 3,585
1
vote
Accepted
Settings in Admin get dropped, will save temporarily, hours later are reset/gone
This actually turned out to be an issue with the plugin "Template Sync" - EE support helped me figure it out (thanks Robin!).
Narrowed it down to just a templates issue, and found "Template Sync" ...
- 167
1
vote
Accepted
How to make EE ignore database table prefix when writing your own queries
You should never use any table in EE without prefix. Its totally not recommended. Now you have only 1 possibility. Instead of using EE (CI) query, use sql.
ee()->db->query( "INSERT INTO `...
- 2,177
1
vote
New EE3 installation and other SQL-base
Never ever do direct EE1 to EE3. First of all upgrade EE1 to EE2. That will make necessary changes to your database. (Remember change all the plugins with EE2 version otherwise backend and/or frontend ...
- 2,177
1
vote
Accepted
Preventing SQL Injections
You should always scrub any user input before it gets to your query.
The first thing you should do is run and input variables through the input class.
i. e. $var = ee()->input->post('my_var', ...
- 1,987
1
vote
Accepted
Generic error during install on DB config
This ended up being simple. For my instance, the MySQL module wasn't installed for PHP. Once it was added it worked as expected... My issue ended up being the fact that the error was completely non-...
- 121
Only top scored, non community-wiki answers of a minimum length are eligible