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
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
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
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,587
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 ...
- 165
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,587
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,587
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" ...
- 165
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
1
vote
EE3 Multiple database settings without core 'hack'
@derek-jones Thanks for the nudge... I ended up with the following in mine.
/*
|-----------------------------------------------------------
| Database and Multi-environment
|--------------------------...
- 1,610
1
vote
Accepted
EE3 Multiple database settings without core 'hack'
In your dynamic config, define the $config['database']['expressionengine'] group conditionally. Have a look TJ Draper's dynamic config, specifically these lines
// Set up the database
$db = array(
...
- 2,255
1
vote
Accepted
best setup for a 1M entries EE site?
My suggestion would be to use services such as AWS. You would utilise RDS managed MYSQL services, Amazon S3 (Cloud based file storage), EC2 instances, auto scaling groups and a load balancer.
I know ...
- 126
1
vote
best setup for a 1M entries EE site?
What about using an SQL Cloud service like google or rackspace? Will that help?
It's not so much the size of the db, I think, as the expected traffic. You will certainly have to consider you hosting ...
- 506
1
vote
Multi-Site Manager Limits
https://ellislab.com/expressionengine/user-guide/msm/additional_sites.html
The theortical max limit on custom fields (which expands the channel_data table horizontally, not vertically) is the maximum ...
- 5,900
1
vote
Accepted
Use Expresso tags to show stock sold on front end
There is not going to be an actual Store tag that you could use to get this. Having said that it should be fairly simple to query the DB for the information that you need. Something along the lines of:...
- 7,566
1
vote
Accepted
How to access a custom table name that isn't prefixed with exp_
If I recall correctly, using the query module (and relative portion of the database class) doesn't force the prefix.
https://ellislab.com/expressionengine/user-guide/add-ons/query/
So you can use ...
- 5,900
1
vote
How to access a custom table name that isn't prefixed with exp_
You can set the database to be used like so:
$mydb = ee()->load->database('mydatabase', TRUE);
By setting the second parameter to TRUE the function will return the database object.
and then ...
- 7,176
Only top scored, non community-wiki answers of a minimum length are eligible