Skip to main content
ExpressionEngine® Answers

Questions tagged [database-error]

Ask Question

The tag has no summary.

36 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
2 answers
166 views

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. ...
ccesarano's user avatar
  • 1
0 votes
1 answer
72 views

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 ...
Kokako's user avatar
  • 124
0 votes
1 answer
69 views

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 ...
Shayne's user avatar
  • 317
0 votes
2 answers
421 views

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 ...
Luke's user avatar
  • 1
0 votes
1 answer
81 views

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 ...
Jonathan Schofield's user avatar
  • 309
4 votes
1 answer
267 views

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 ...
Matts Härsing's user avatar
  • 41
1 vote
1 answer
254 views

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 ...
Jared's user avatar
  • 121
1 vote
0 answers
86 views

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 ...
Trevor Orr's user avatar
  • 281
0 votes
1 answer
254 views

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....
Matt Ellis's user avatar
  • 388
0 votes
0 answers
58 views

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 ...
RickL's user avatar
  • 603
1 vote
1 answer
547 views

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 ...
Crave's user avatar
  • 11
0 votes
1 answer
62 views

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 ...
davranooch's user avatar
  • 1
0 votes
1 answer
166 views

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 ...
mediapimp's user avatar
  • 741
-4 votes
1 answer
105 views

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 ...
DanAllen's user avatar
  • 101
0 votes
1 answer
114 views

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`, `...
Rien's user avatar
  • 71
0 votes
1 answer
124 views

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....
Gourav Anvekar's user avatar
  • 1
0 votes
0 answers
70 views

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 '...
Chris's user avatar
  • 101
1 vote
2 answers
222 views

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, ...
Jelle Dijkstra's user avatar
  • 1,917
0 votes
0 answers
191 views

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 ...
Frequency's user avatar
  • 169
0 votes
0 answers
57 views

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 ...
user2970's user avatar
  • 1
2 votes
1 answer
558 views

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:...
Andrew's user avatar
  • 393
2 votes
1 answer
6k views

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 ...
user2948's user avatar
  • 21
1 vote
1 answer
226 views

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 ...
4midori's user avatar
  • 382
1 vote
1 answer
112 views

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 ...
forrest's user avatar
  • 1,068
1 vote
0 answers
577 views

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 ...
jennetcetera's user avatar
  • 501
1 vote
1 answer
117 views

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' ...
Steven Grant's user avatar
  • 2,473
1 vote
2 answers
293 views

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 ...
Jonathan Schofield's user avatar
  • 309
0 votes
1 answer
631 views

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 ...
Peter Eastwood's user avatar
  • 1,481
1 vote
1 answer
110 views

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 ...
kitsimons's user avatar
  • 47
1 vote
1 answer
205 views

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 ...
Jimmy Mooney's user avatar
  • 133
1 vote
1 answer
186 views

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 ...
Mike Stecker's user avatar
  • 112
1 vote
1 answer
365 views

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 ...
Sergio Acosta's user avatar
  • 159
1 vote
1 answer
876 views

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 ...
Sergio Acosta's user avatar
  • 159
2 votes
1 answer
222 views

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 ...
KSPR's user avatar
  • 455
1 vote
1 answer
95 views

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 ...
Coalescent's user avatar
  • 11
4 votes
1 answer
8k views

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 ...
Stephen Callender's user avatar
  • 3,902