The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [database-error]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
22 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
0answers
66 views

How to fix this database error?

I get this error when trying to return a range of newer entries (exp:entries) in a template, and I am looking for help trying to fix whatever happened in the database, or any clue of where to look. ...
0
votes
2answers
43 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
1answer
30 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
1answer
110 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
1answer
179 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
0answers
41 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
1answer
161 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
0answers
41 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
1answer
459 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
1answer
29 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
1answer
112 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
1answer
68 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
1answer
57 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
1answer
87 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
0answers
38 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
2answers
161 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
0answers
162 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
0answers
48 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
1answer
452 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
1answer
5k 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
1answer
195 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
1answer
92 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
0answers
547 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
1answer
76 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
2answers
227 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
1answer
578 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
1answer
67 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
1answer
147 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
1answer
148 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
1answer
341 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
1answer
808 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
1answer
181 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
1answer
54 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
1answer
7k 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 ...