The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
6 views

PHP Script to Crawl the the Web and Auto Email Notifications [on hold]

I am looking for a PHP script to crawl the web (searching for specific keywords and expressions) and the send my self a notification email (on a daily basis) containing the URL of the webpage and the ...
0
votes
2answers
29 views

What's wrong with this SQL query?

I have an SQL query which I'm adding to a small search plugin, however when I run the SQL in MySQL it works and results are found, however no rows are being returned when running the code in the ...
0
votes
0answers
8 views

Change EE Member Group on Action

I'm working on a site wherein we want users that are in the Members group transferred to another group, after making a purchase. Which group they are moved into depends upon the purchase they make. A ...
0
votes
1answer
31 views

MySQL strict mode: disable on a session basis?

I'm getting mysql errors suggesting that my host's use of strict mode is a problem (with an addon). The host wants mysql strict mode on their DB server. Can I override strict mode for my EE ...
1
vote
0answers
24 views

Highest version of mySQL and PHP for EE 1.7.3

My hosting company needs to upgrade my server to the latest versions of PHP and mySQL. The problem is I'm running a number of EE sites varying between versions 1.6.8 and 1.7.3. So what is the highest ...
0
votes
0answers
11 views

Remove symbols from jSON data with ce_str:ing

How do I remove symbols with json data which is fetch using a sql statement using ce_str:ing. My json data: "sb": [ {exp:query sql="SELECT t.title, d.field_id_1447 as info, ...
0
votes
0answers
24 views

SQL select channel entries by category, AJW export to create XML file

What would the query be to display all entries (with entry id, title) by category (with category name)? I hope to use AJW export to create an xml file with the information. So the result might look ...
0
votes
1answer
17 views

How does exp_channel_data table allocate it's primary key?

I am working on a site with EE where the client is having some of the data pushed into to the MySQL database from a external FilemakerPro database. I'm working with an external company who handle the ...
0
votes
2answers
26 views

Trying to login via database

As you have probably seen by my somewhat regular postings, I am a newbie to EE. The company that I work has all of their web sites using EE and some of the sites have not been updated or worked on ...
0
votes
1answer
32 views

Displaying Category Name and Channel Entry Data with Query Module

I have a SQL query set-up to display a list of entries based on the category ID found in the third segment, but I'm having a hell of a time trying to display the category name that goes along with it. ...
0
votes
0answers
36 views

Using Host file Centos 6.5 / mySQL / Apache / ExpressionEngine

I am having issues with my host file. I am tasked with creating a working local copy of our marketing website so that our sales team can access our website while in conventions. I guess the internet ...
0
votes
1answer
71 views

Getting To Know The EE Database Structure

I am new to ExpressionEngine2 and already working with it, but find the database structure very confusing coming from a pure OOP environment. What is an easy, fast way to actually find references or ...
0
votes
0answers
49 views

Field 'title' doesn't have a default value

I'm using getting a nice mysql error on submitting the exp:cartthrob:checkout_form Error Number: 1364 Field 'title' doesn't have a default value INSERT INTO `exp_channel_titles` (`site_id`, ...
0
votes
1answer
52 views

Categories of a category_group won’t show

I have a strange thing in EE 2.8.1. I want to show a list of all categories in category_group=“1” but nothing won’t show up. I have 3 category groups ID 1 - with 105 categories, top & sub ...
0
votes
0answers
18 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
64 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
46 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
73 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
52 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
86 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
44 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
83 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
105 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
283 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
356 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
115 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
68 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
77 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
112 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
110 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
135 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
114 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
183 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
55 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
44 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
83 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
161 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
88 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
60 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
144 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
249 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
1k 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
279 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
48 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
109 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
72 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
123 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
81 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
64 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
98 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 ...