Questions tagged [database]

The tag has no usage guidance.

35 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1 vote
0 answers
94 views

Transfered EE site to cPanel and keep getting errors

Had this site on an ispManager server. Moved it over to cPanel and kept getting errors. Now down to this. Not sure why I can't get the site to pull up and just how to fix these errors. A PHP Error ...
phfeiler's user avatar
1 vote
1 answer
121 views

Database Insert is encoding data

So I have a custom plugin that inserts data from a csv. I build up the array of data and then issue the insert command. Right before the insert I am dumping my array so I can see the values which ...
Chris's user avatar
  • 31
1 vote
1 answer
20 views

Cannot access sql manager

I cannot access sql manager on a site which is running EE v 4.0.8 I've checked the file permissions and they look fine. This is the error message. Any suggestions of what to check next? View file ...
dorothy Dorothy's user avatar
1 vote
0 answers
36 views

Possible to merge two databases?

We have a production and dev database. The dev database is typically only used to change core features, channel setup, add-ons, etc. Never content. We’re in a situation where we need to pull some ...
Brandon Durham's user avatar
1 vote
1 answer
89 views

Has anyone set the database on a remote server while the controllers sit on local/hosted system

I host the MySQL server providing the database functions and the site itself on the same hosting platform (a semi-dedicated server). I was wondering if I could improve expression engine performance ...
George B.'s user avatar
1 vote
0 answers
60 views

Database Error When Adding/Editing Pages With Structure

Whenever I attempt to add or edit a page in Structure, I get the following error: A Database Error Occurred Error Number: 1064 You have an error in your SQL syntax; check the manual that corresponds ...
Jason Morehead's user avatar
1 vote
0 answers
56 views

Is EE able to handle this db/site ok?

It's quite a "general" question. Our site has 60k posts. Each post has 10-15 relations and almost 50 custom fields and several categories options. Mostly focused in one channel. One category group ...
Martin Pede's user avatar
1 vote
0 answers
60 views

Calendar entries not saving event dates

I have a channel form that users can enter their own calendar events into from behind a login. Randomly, some of the event dates do not get entered into the database. Looking at the tables, it appears ...
Donovan Cronkhite's user avatar
1 vote
0 answers
67 views

profile:edit on EE 2.7.2 and mySQL 5.6 can't install

Tried to contact mightybigrobot a few times but impossible to get a hold after buying their plugin profile:edit. It trows an error when I'm tryign to install the default templates. EE 2.7.2 , mySQL ...
bomanden's user avatar
  • 243
1 vote
0 answers
42 views

Liquibase A Good Replacement for Krasimir Method of Database Syncing?

Like everyone, a major headache for us has been keeping databases between development and production servers in sync. We had implemented Krasimir's method to great success. http://krasimirtsonev.com/...
grovberg's user avatar
  • 213
1 vote
0 answers
439 views

Why is my site giving me a relationship field error?

I pushed an update to my ee site recently and came across a very strange error where none of my pages work in the site properly and I get a relationship field error on the homepage which was never ...
M dunbavan's user avatar
1 vote
0 answers
52 views

Channel Field Group gone

I have an odd one where it appears that 1 of my custom field groups has disappeared. I don;t when, there is no backup (even if there was I can't tell wether it disappeared yesterday or last year). It ...
stuartmcd69's user avatar
  • 3,163
1 vote
0 answers
47 views

Playa upgrade from 3.0.9 to 4.4.3 missing relationship data

I just upgraded EE from 2.1 to 2.6.1, then upgraded Playa from 3.0.9 to 4.4.3. I realized I had to rewrite the syntax in the templates. That wasn't fun. But the real issue I am having is the missing ...
LucasCranac's user avatar
0 votes
0 answers
42 views

Too many database queries

My site no longer loads and I can no longer access the control panel. After some investigation, it seems there are requests that are taking too long to load or are stuck. When I try to log into ...
mediapimp's user avatar
  • 741
0 votes
0 answers
32 views

Is there a way to disable CE Cache DB references?

We have a heavily trafficked site, where we keep running to bottleneck issues with cache trying to clear and that bogging things down. The issue is the DATABASE is being taxed by CE Cache maintaining ...
ByteMyPixel's user avatar
0 votes
0 answers
64 views

How to use {exp:query} results in {exp:channel} parameter?

Since i can not retrieve {parents} from grid field, i am trying to find simplest workaround. This works great: {exp:channel:entries channel='channel-one' entry_id=' <?php $...
shbchk's user avatar
  • 11
0 votes
2 answers
56 views

Stash and database replication

We are running EE 2 and Stash, 2 DB's: 1 master, 1 slave. The master-slave relationship keeps breaking with the following error: CRITICAL - Slave sql is not running. Last error: Could not execute ...
studio1057's user avatar
0 votes
1 answer
338 views

Decrypt Password as string

We are using ExpressionEngine v2.10.1, we are going to import data from the database. We have created API that returns data as JOSN by using: {exp:query sql="SELECT * FROM exp_member_data"} But we ...
Amit Kumar's user avatar
0 votes
1 answer
52 views

Where does EE2 get the latest member_id from?

I've deleted a bunch of members (on purpose), so that I only have member_id '1' left. Now if I create a new member... The newest member_id is '176' and then increments as I add more… If the members ...
Third_Hyperion's user avatar
0 votes
1 answer
25 views

Load data from "File System" rather than "Database"? Modify template file is not working

I am migrating an EE application to a new server. However, it shows the previous version. And if I modify the template file, it's not showing on the site. Someone said it's because it's loaded from ...
Fangzhou He's user avatar
0 votes
1 answer
116 views

Optimising structure of exp_channel_data table

I have a site with around 800 columns on exp_channel_data table. I would like to know if I can go ahead and optimise the structure of this table by doing the following 1) changing field from text to ...
Sarvesh Shejwadkar's user avatar
0 votes
2 answers
73 views

Expression Engine Database Load

We are running a high traffic site in expression engine 2.10.1.This has a page-views of 150k daily.The server is load balanced and is running fine. Recently we have strange issue of some pages being ...
Aswin Sathish's user avatar
0 votes
2 answers
97 views

Entries can't be updated - 404

I'm having a problem with EE; when updating or creating an entry I get redirected to the 404 page. I've researched a lot because this is getting annoying. I've tried checking the .htaccess as a common ...
Omar Fabricio Mejia's user avatar
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 ...
davranooch's user avatar
0 votes
2 answers
30 views

Adding new functionality to Live site while keep members

I have a live(Production) site, in which new users are signing up every day. Meanwhile, I have a local version of this site on which I've built lots of new functionality. If I were to push the local ...
SteveO's user avatar
  • 231
0 votes
1 answer
76 views

Duplicate order numbers in Cart Throb

We've got quite high traffic cart throb site which occasionally gets duplicate order numbers. The most recent one was when 2 orders were placed at exactly the same time (to the second). Both orders ...
Andrew Armitage's user avatar
0 votes
1 answer
71 views

Convert a row's site_pages cell (inside exp_sites) into a key-value array

For the purpose of using PHP to automate the creation of custom URLs that will be placed in the Pages Module, I'm first retrieving and decoding the whole block of encoded, serialized data in the ...
Rob Butz's user avatar
  • 173
0 votes
0 answers
41 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 '...
Chris's user avatar
  • 101
0 votes
0 answers
87 views

exp_cartthrob_cart is marked as crashed and should be repaired

On two separate websites in the past few months (one with EE 2.8.1 and CartThrob 2.6, and another with EE 2.5.5 and CartThrob 2.3.6), we've had an EE website break due to a corrupted CartThrob table (...
Stephen's user avatar
  • 1,349
0 votes
0 answers
170 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 ...
Frequency's user avatar
  • 169
0 votes
0 answers
25 views

I need help tagging articles in a way that doesn't slow down the database

I have an article-based site that runs slowly, and I would like to change that. First, each article has 3 options for tags in the backend (we use this add-on: http://www.solspace.com/software/detail/...
Allison S's user avatar
0 votes
0 answers
76 views

Blank Screen After Migration to New Server

I have just migrated my site to the live server and I have a blank screen for both the site and the control panel. I have added the dbtest.php file to my root and there is no error. I have turned on ...
Stephen O'Connor's user avatar
0 votes
0 answers
34 views

Lag in Data Returned

I have a pretty simple template set up that has one image and a block of text, but for some reason the page takes 3 seconds to load at 37 queries. I have tag caching set so subsequent loads of the ...
Roger Erik Tinch's user avatar
0 votes
0 answers
229 views

Database error 1054 following update to 2.7.0

I've just updated a staging instance of EE to 2.7.0 from 2.5.2 following a successful update of a development instance and the live production instance. The reason for update was because we have MSM ...
Alex Adams's user avatar
0 votes
0 answers
59 views

Can´t post comments, have pagination issues - assume Database Probs due to migration from Dev to Production

In my DEV-envoronment I can post comments and pagination works. On my production machine not. I assume, that I did something wrong, when I used phpMyAdmin to dump the Dev-DB and then uploaded the DB ...
awa's user avatar
  • 525