Questions tagged [database-error]
The database-error tag has no usage guidance.
36
questions
0
votes
2
answers
49
views
Define Database Error (Upgrading 2.10.1 to 3)
I apologize for a question that I know has been asked and answered. However, I don't have enough reputation to reply to the answer, just to provide another "answer", which I don't have. ...
0
votes
1
answer
43
views
Error when creating new channel: Unknown field ChannelField.group_id
I have this nagging issue on a site and I can't track down the cause..
When I attempt to create a new channel, I get: Unknown field ChannelField.group_id
This site has been updated over time and ...
0
votes
1
answer
38
views
SuperSearch Install Error
EE 5.2.6
I'm trying to install the SuperSearch module and I'm getting an error.
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes:
I'm ...
0
votes
2
answers
219
views
Unable to connect to your database using the configuration settings you submitted
I’m kind of lost on what’s going on here. We are trying to install EE and are getting the error “Unable to connect to your database using the configuration settings you submitted”. I’ve installed many ...
0
votes
1
answer
35
views
Database error on creating new Low Search Collection
I have an instance of Low Search 4.4.3 running on an MSM enabled instance of EE 2.11.8.
It runs many Collections happily across 3 sites.
But with a new site recently added, when I go to Save any ...
4
votes
1
answer
206
views
DB connection refused - credentials exposed
So suddenly I get a "Connection refused" to the MySql database on my site which is running ExpressionEngine 3.5.2 in a shared environment. Fine...
...but the stack trace, when expanded, shows the ...
1
vote
1
answer
191
views
Generic error during install on DB config
I'm receiving the above error when attempting to install a new EE3 site. This is the first site we are attempting to stand up on a new WHM server running PHP7. Is there a mechanism to try and get a ...
1
vote
0
answers
53
views
exp_online_users table corrupt after PHP upgrade
We have a server with several sites running various version of Expression Engine. We upgraded PHP last night and after the upgrade 2 sites has the table exp_online_users corrupt. I ran a repair ...
0
votes
1
answer
213
views
Table doesn't exist after upgrade
I upgraded from EE 2.9.2 to 2.11.5
Everything is working good, except I get this error when I view a News entry at domain.com/news/news-entry-title:
Error Number: 1146
Table 'db_name....
0
votes
0
answers
45
views
Getting Error number 1054 on one channel entry in CP
I've just imported a copy of a live site into my local development environment in order to make some changes, but almost immediately I've found that there is one channel entry that I cannot edit in ...
1
vote
1
answer
514
views
ExpressionEngine 2.3.1 and PHP 5.6 support
My service provider have upgrading from PHP 5.4 to PHP 5.6.
I'm currently running EE 2.3.1.
After the upgrade, I get a "ERR_CONTENT_DECODING_FAILED" on frontend.
In the backend, I can log in, but ...
0
votes
1
answer
32
views
SuperSearch Module Install Creates 1044 Error
I've just attempted to install SuperSearch 2.2.3 on EE 2.9.2 and receive a a database 1044 error:
Access denied for user 'db######'@'%' to database 'db202322_##########'
It then goes on to list the ...
0
votes
1
answer
120
views
Database Error on Update
I am trying to update EE v2.4 to v2.10.1 and got a database error.
Error Number: 1060
Duplicate column name 'can_search'
ALTER TABLE exp_member_groups ADD COLUMN can_search char(1) NOT NULL default ...
-4
votes
1
answer
73
views
How Do You Kll EE's 40-Headed Error-Reporting Dagon? [closed]
Tbe main think I love about errors not displaying them on the screen viewing production systems. My phone rings less, people are happier. Everything is logged, nothing to the screen. We have a ...
0
votes
1
answer
76
views
Mustash Cache breaking rules
When I try saving Cache breaking rules with Mustash, I get this error:
Error Number: 1366
Incorrect integer value: 'NULL' for column 'group_id' at row 1
INSERT INTO `exp_stash_rules` (`plugin`, `...
0
votes
1
answer
98
views
Expression Engine Search Issue: Incorrect Key file for table
The search query below is failing and results in a "Incorrect Key file for table '/tmp/....'; try to repair it" SQL error.
SELECT DISTINCT(t.entry_id), t.entry_id, t.channel_id, t.forum_topic_id, t....
0
votes
0
answers
40
views
Adding 10+ Sites to MSM - Does this workaround sound crazy?
Here's the situation. I tried to add a 10th site to my MSM and I got an SQL error that effectively says, you can't add another column to the exp_weblog_data table.
Description: Can't create table '...
1
vote
2
answers
163
views
unable to update the site_pages field
I'm having an issue that seems to originate in the site_pages field in the exp_sites table of my database.
somehow an entry title made it's way into that array. So, i copied the contents of the field, ...
0
votes
0
answers
168
views
Large Database Error - Upgrading EE 1.x to 2.9.2
I’m trying to upgrade an installation of EE 1.6.8 to 2.9.2 and have come unstuck on the “Database too large” error in the upgrade wizard.
Specifically:
The following error occurred:
An unexpected ...
0
votes
0
answers
51
views
Matrix / Low Variables Database Error
I am getting the following Database error, which prevents me from even accessing the low variables module screen...
Low Variables - 2.5.0
Matrix - 2.6
A Database Error Occurred Error Number: 1054
...
2
votes
1
answer
509
views
Database error 1118 - Row size too large
The error occurs when I try to add a new custom field of any kind. The install contains 210 custom fields but will not accept any more. Any advice to troubleshoot would be great. Further details below:...
2
votes
1
answer
6k
views
EE Error: "Unable to Load Site Preferences; No Preferences Found"
I'm getting this error and can't understand why. This is for a site that I've reset the hosting to it's default state and have uploaded the site files and database to a basically new installation. It ...
1
vote
1
answer
198
views
Problem importing database - import hangs on exp_stash table
Here's a weird one. I need to set up a dev server, so I'm importing a DB from and existing production EE install. The import proceeds fine until it gets to the exp_stash table. Then I get MySQL error ...
1
vote
1
answer
95
views
Database Error when I attempt to Publish an Entry
I created a new channel and a field group that has a large number of custom fields. When I attempt to Publish a new entry I get the following error:
A Database Error Occurred Error Number: 1054
...
1
vote
0
answers
551
views
Database errors in Sessions.php
I am seeing several errors in my site logs regarding a the sessions.php file. What is this and how can I fix it?
Here are my EE details:
ExpressionEngine v2.5.2 - Build Date: 20120606 - © Copyright ...
1
vote
1
answer
77
views
cached relationship entries db error
I've been trying to clear the caches prior to running this EE upgrade but when I do I'm getting this error:
A Database Error Occurred
Error Number: 1054
Unknown column 'rel_data' in 'field list'
...
1
vote
2
answers
230
views
Anyone experiencing intermittent Submit fail and redirect to CP dashboard/home? (ee 2.7.2)
On several different installs I'm finding that when I finish editing an entry and hit Submit, the submission sometimes completely fails and I am redirected to the Control Panel home page.
I'd like to ...
0
votes
1
answer
611
views
Error Number: 1062 Duplicate entry '465628' for key 'PRIMARY'
Running into some serious issues with CartThrob. All of a sudden I am getting this error when I add an item to the cart and try to view cart or checkout:
It was working last night and sometime over ...
1
vote
1
answer
70
views
Orders tag error: order_status parameter
I've just updated to Store 2.0.4 and have come across the following error on a page using the orders tag with "order_status" parameter:
Error Number: 1054
Unknown column 'order_status' in 'where ...
1
vote
1
answer
158
views
Unable to install EE - config.php and database.php not being written
When installing EE - I get the dreaded database connection error. I've verified the DB works with the credentials by connecting locally in mysql with the same info. I've also utilized your dbtest.php ...
1
vote
1
answer
153
views
Super Search DB error with Matrix fields
I want to re-hash this issue: http://www.solspace.com/forums/viewthread/17419/
The error is:
Error Number: 1052
Column 'field_id_90' in field list is ambiguous
It seems there was never a proper ...
1
vote
1
answer
344
views
One alert when importing a production database
I now have a local copy of a live EE site. Front and backend are working with no problems.
However, when I imported the production database I got this one alert:
[ERROR in query 912] You have an ...
1
vote
1
answer
838
views
Errors when importing a MySQL database
Trying to make a local copy of a live ExpressionEngine site, my process stop when importing the live database.
I'm using EE 2.5.5 and several key add-ons like Publisher, Playa, Matrix and CE Cache.
I ...
2
votes
1
answer
186
views
Field editor breaks grid
I use the "field editor" plugin a lot.
But it doesn't seem to work with the new grid fieldtype.
So it now just messes up channel fields with grid.
I now can't delete the messed up field group.
A ...
1
vote
1
answer
58
views
DB error when creating file upload location after 272 update
We recently updated a 255 install to 272. Things are working fine except we got an error when we first tried to add a new File Upload location under File Upload Preferences. The error was:
A Database ...
4
votes
1
answer
8k
views
Database Error - Unable to connect to your database server using the provided settings
My site won't show up (white screen of death). When I try to access the control panel, I am setting this error:
A Database Error Occurred
Unable to connect to your database server using the provided ...