The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
16 views

Database Environment Sync [duplicate]

We have a pretty simple setup for all of our expression engine websites, we have local, staging and live. We use Git for Version Control which makes pushing file based updates live incredible easy. ...
1
vote
2answers
45 views

Expresso Checkout conditional (use hook?)

So, at the end of the checkout process (where it becomes an order) I want to fire off an SQL query wrapped inside AJW export (which creates an xml file). However, within the confines of ...
0
votes
1answer
17 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 ...
2
votes
2answers
49 views

ExpressionEngine source control via git

Im trying use some form of source control with EE. I cannot clearly see a way to decouple the database from the templates and other structures, as would be the case in a most CMSes. Creating channels ...
0
votes
0answers
34 views

Errors importing MySQL database

I'm having issues uploading the DB i've exported from MAMP (And also from a Dev server) in to inMotion Hosting. I've had a few of these errors pop up (Below) and I've fixed it by deleting the content ...
3
votes
3answers
68 views

Add-on - Building Queries w/ Field Names vs Field ID's

I have an add-on I've built to provide custom e-commerce reports for a client. It started as one of those 'we need this very specific thing' builds and of course has grown and grown as more needs ...
1
vote
1answer
31 views

Solspace Freeform not updating, mySQL error?

I'm getting database errors when trying update Freeform. I think I've narrowed it down to one specific mySQL statement, but I don't know enough about mySQL to know what's wrong, I just know that this ...
0
votes
1answer
31 views

Get all entries where expiration date is within last 12 months

I know this is more of a SQL question, but I'm having trouble getting EE to cooperate. I have entries that expire, and want to show only entries which have expired in the last 12 months. I tried: ...
1
vote
2answers
95 views

All channel entries have had their statuses changed to 'closed'

It looks like one of my sites has been compromised with an SQL injection. All the channel entries have been closed, which amounts to over 5k entries. I restored the database with a previous daily ...
0
votes
1answer
57 views

table is marked as crashed and should be repaired

All of a sudden I cannot log into my control panel. Does anyone have any advice as to where I could start to get this repaired? A Database Error Occurred Error Number: 145 Table ...
2
votes
4answers
163 views

Very slow performance on production, not on local dev, doesn't seem to be the database

I'm running an ExpressionEngine site using CartThrob for a shopping cart. Some of the pages are loading extremely slowly on the production server (7, 10, 15 seconds of Controller Execution Time as ...
3
votes
1answer
79 views

How to prevent CartThrob from making hundreds of SQL queries and running extremely slow?

this may be somewhat of a noob question as I just started administering an ExpressionEngine site that uses CartThrob. My client complained of the site being slow during the shopping / checkout process ...
1
vote
1answer
54 views

Move categories from one group to another

In a category group "Shops & Services" we have three parent categories each with many sub-categories: Offices Services Retail The Retail (parent category) has grown to a point where it needs ...
1
vote
1answer
55 views

ExpressionEngine with Percona Cluster?

I've tried using Percona Cluster as a drop-in replacement for MySQL. However when templates are saved, each cluster node is updated with a different value for the primary key column template_id in ...
0
votes
1answer
74 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
2answers
97 views

Optimizing performance when sorting through hundreds of entries

Currently working on a new EE site that I've inherited, and having difficulty optimizing performance. Everything was dandy until I finished imported all the old content. Now there are ~700 page ...
1
vote
1answer
76 views

Help with SQL to Export Channel entry status

I've built an accessory to allow my client to export channel entry data to a CSV. All is working fine but they now want to add the entry status to the list of exported fields and I'm having trouble ...
1
vote
1answer
93 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
108 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 ...
3
votes
1answer
45 views

Assign parent category to entries with child categories (EE1)

In our EE1 installation we have the preference "Auto-Assign Category Parents" set to "No". Now I am faced with a situation where for once particular set of categories it would be very useful to have ...
0
votes
1answer
38 views

Store Data in Channel Tag Variable

I'm using the EXP:QUERY tag to get the count of a channel. And I am basically trying to use this for page pagination, and its a custom pagination because of the type of template I'm building. And I ...
0
votes
0answers
81 views

Weird text-formatting after upgrade to 2.7.0

I upgraded a site today from 2.5.5 to 2.7.0. Everything went well except from one ting: When outputting textareas with text formatting none EE will insert paragraphs and whitespaces - expected ...
3
votes
2answers
136 views

Entire site down - Seemingly random (and fatal) ExpressionEngine error

Every so often, my entire site goes down for an indefinite period of time. Restarting the MySQL service appears to temporarily fix the issue. I recently upgraded to EE 2.7 and about the same time my ...
0
votes
1answer
67 views

Solspace Calendar and Importer

So I'm looking for a work around with Solspaces' Importer and Calendar module and hoping someone has a fix, hack or whatever for this. My problem is that the two awesome modules do not exactly work ...
1
vote
0answers
43 views

Assets Upgrade “duplicate” error

I was in the process of trying to upgrade my Assets in the EE 2.5.2 install from version 1.1.5 to 2.1.4. I was able to do the update without issue in our development and staging environments, but when ...
1
vote
1answer
116 views

SQL query to count question marks in comment field?

Wanted to ask if anyone can help me with (code or commands to use) an sql query to count how many times the question mark character appears in table *exp_comments*, field comment? Thanks! Lee
1
vote
2answers
200 views

changing the assigned template to Structure listing

Have inherited an EE build that uses Structure and has a handful of channels. There is 1 'page' type and 4 'listings'. Unfortunately, the dev has decided to use 1 template for the single entry views ...
1
vote
2answers
756 views

SQL SELECT using custom field name (not ID) in WHERE

Forgive me if I missing something obvious, but I have a need to select channel entries from the EE database, but I want to select those entries based on a value assigned to one of my channels custom ...
1
vote
1answer
176 views

Error 122 from Storage Engine

Getting the following error message on the front end of the sites sub pages and not the home page of the site. I have fixed it before by optimising & repairing the database but it has come up ...
0
votes
2answers
46 views

Logging custom data to the DB

I'm working on a film site and need to log some custom information about a user's activity. On the site you can click a play button to start watching a film. (This link just takes you to Amazon ...
1
vote
1answer
106 views

Cannot create channel field

After upgrading to EE 2.6.1, i now try to create a new channel field, but instead get this SQL error: A Database Error Occurred Error Number: 1064 You have an error in your SQL syntax; check the ...
1
vote
1answer
63 views

MySQL - Change Entry Category ID?

Looking for help doing what I hope is a simple task. We have approximately 2500 entries that are need to be reclassified (choose new category ID). I am hoping that a simple MySQL script can ...
1
vote
0answers
95 views

Message: Undefined property: stdClass

Part of my Dashee widget isn't working. I'm setting the settings like so... $this->settings = array( 'title' => 'Recent Orders', 'channel_id' => '6', ...
1
vote
2answers
70 views

WHERE and JOIN in EE Add-on Dev

I'm trying to get my EE add-on (using Dashee) to get entries from the DB. So far I have $this->_EE->db->select('ct.channel_id, ct.title, ct.entry_date, ct.status, cd.field_id_52, ...
1
vote
1answer
59 views

MySQL: Update Rows Based on Specific Set of Entry IDs

I have a random group of about 40 entries in the same channel where I need to copy the url_title from exp_channel_titles over to the uri column in exp_structure_listings. If I wanted to copy the urls ...
1
vote
0answers
90 views

Help repairing ObjectiveHTML Entries addon

Trying to use ObjectiveHTML's public beta addon, Entries. The thing is that I really need this addon to work, and the developer is not answering as this is a beta version. I looked at the code and ...
1
vote
1answer
69 views

Copy Data from exp_channel_titles Based on entry_id

I'm trying to copy some channel data from the exp_channel_titles table into Better Workflow's exp_ep_entry_drafts table. I want to copy the data by matching the entry_ids, which already exist in both ...
0
votes
1answer
69 views

Error Number: 1364 on insert to exp_member_data

I am working with an add-on that does an insert into a custom member data field and I am getting the following kind of error: A Database Error Occurred Error Number: 1364 Field 'm_field_id_2' ...
1
vote
1answer
169 views

performance issues - is it the database?

I'm experiencing pages loading very slowly, it's happening intermittently on a low traffic EE site. Most of the traffic is just me. When they load slow, they take a good 30 seconds or so. But when ...
1
vote
1answer
102 views

MySQL connection on a non-standard port

We were experimenting with running an EE database stored on AWS and we found that MySQL was running on a non-standard port.
0
votes
1answer
77 views

EE 1, adding another server

So I have searched but I seem to only find information on setting up EE in the config.php for multiple server environments - local, staging, production. What Im looking to get some information on is ...
1
vote
2answers
97 views

MySQL channel table problem

Whilst upgrading a site from EE1 to EE2.5.5 I have been doing a lot of editing the database in Sequel Pro. All of which seems to be working fine so far... But I'm having a problem with a ...
2
votes
2answers
150 views

Executing multiple SQL statements with Database class

Using $this->EE->db->query(); is it possible to execute a query as complicated as this: CREATE TEMPORARY TABLE exp_temp_table (...); INSERT INTO exp_temp_table () SELECT ...; UPDATE ...
2
votes
1answer
79 views

Expresso Store - Change order_id start point

My client would like the order numbers (order_id)'s to start at 30000 (thirty thousand) rather than starting at 0. Looking at the database I can see in the exp_store_orders table that order_id is set ...
3
votes
1answer
117 views

SQL Query Help Needed

During a migration from 1x to 2x on an EE site, I needed to switch to current Google Maps add-ons and chose MX Google Maps (for now anyway). The site was using a geotagger that filled a Latitude field ...
1
vote
1answer
134 views

Transferring data from one field to another

I have a current checkbox field which contains 8 options. I want to change this field to a P&T checkbox field, to make use of the option_name : Option Label ability. I've been told I can run an ...
1
vote
1answer
92 views

Is this channel data query possible?

Pseudo Query: Select zoo visitor channel fields from exp_channel data And author_id from exp_channel_titles (joined on entry_id) Where channel_id = my zoo visitor channel And author_id does not have ...
3
votes
2answers
70 views

How can I close comments on a mass scale?

Having just relaunched a site containing a decade of content, I'd like to close comments on everything over a couple years old. I thought there was something built in, but either it's not there or I ...
2
votes
3answers
37 views

How do I track down a bug with a custom field?

This is related to an channel module php error I am getting. I've been able to determine that if I use disable="custom_fields" the error goes away. On a backup copy of the site I've gone in and ...
2
votes
1answer
263 views

Correct syntax for inserting a channel entry with a playa field?

I've been experimenting with using SQL INSERTs and UPDATEs instead of using the Channel Entries API in my add-on. In one of my channels I am using a playa field which is simply connected to a separate ...