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
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 ...
- 5,781
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.)
...
- 442
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, ...
- 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' =&...
- 5,900
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 ...
- 208
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 ...
- 11.3k
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 ...
- 442
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 ...
- 607
2
votes
Accepted
Total entry views for all entries in a given category
You should be able to simply add:
SUM(t.view_count_one) as view_count
... to your SELECT statement.
- 17.4k
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
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
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
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
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
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
Getting images out of the system
You started fine with the manual deletion; you just need to complete the process. Open your Edit form and find your entry_id. Then, go to your field groups and find the field_id of the file field. ...
- 5,900
1
vote
Pulling data from external database
For an operation of this size, you should be using an enterprise solution, not a web application. You should be exporting the data from the other SQL database in chunks so you can move it gently. What ...
- 5,900
1
vote
Accepted
Switching default database engine to InnoDB
Short version, No you can't alter this setting via a config file.
Long version, you see in your snippet in the OP it is defined as a const constant on the Class, conversly the items you change via ...
- 2,418
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,556
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
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