Questions tagged [database-error]
The database-error tag has no usage guidance.
36
questions
0
votes
0answers
8 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
1answer
32 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
256 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
106 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
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
1answer
135 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
189 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
43 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
180 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
44 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
488 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
115 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
70 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
63 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
90 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
167 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
474 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
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
1answer
196 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
93 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
548 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
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
2answers
229 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
595 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
69 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
150 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
343 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
827 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
184 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
57 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 ...
