Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options not deleted user 167
1 vote
1 answer
304 views

MySQL keeps crashing

Every couple of weeks or so, all the sites on my server (all running Craft) go down with the error message: CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access vio …
Clive Portman's user avatar
1 vote
Accepted

How to reduce database size?

Well, I started by removing unwanted orders over a month old and that's got the commerce_orders table down to 10 MB. Whether it's a coincidence I'm not sure, but now the searchindex and elements table …
Clive Portman's user avatar
2 votes
2 answers
780 views

How to reduce database size?

I'm getting alarmed by the size of the database backups and the database in general. … The site has Craft Commerce installed, which contributes I think, but if you look at the following list of backups there seems to have been a sharp increase in database size that has nothing to do with …
Clive Portman's user avatar
4 votes
Accepted

Working locally after cloning Craft 3 from Hyperlane

Before: return [ 'driver' => getenv('DB_DRIVER'), 'server' => getenv('DB_HOST'), 'user' => getenv('DB_USER'), 'password' => getenv('DB_PASSWORD'), 'database' => getenv('DB_NAME'), … getenv('DB_PORT') ]; After: return [ 'driver' => getenv('DB_DRIVER'), 'server' => getenv('DB_SERVER'), // changed 'user' => getenv('DB_USER'), 'password' => getenv('DB_PASSWORD'), 'database
Clive Portman's user avatar
2 votes
1 answer
740 views

Working locally after cloning Craft 3 from Hyperlane

What happens next is I go to install on my machine by viewing the admin panel but I get the following: Database Connection Error – craft\errors\DbConnectException Craft CMS can’t connect to the database … Configuration – yii\base\InvalidConfigException Connection::dsn cannot be empty. in C:\Users\clive\OneDrive\Desktop\repos\projectname\vendor\yiisoft\yii2\db\Connection.php at line 602 If I add the database
Clive Portman's user avatar