The mysql tag has no wiki summary.
1
vote
1answer
15 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
15 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
41 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, ...
0
votes
0answers
23 views
Database error 1064 after 2.6 update [closed]
Have just updated to EE 2.6 and am getting the following error when I try to edit a channel entry:
A Database Error Occurred
Error Number: 1064
You have an error in your SQL syntax; check the manual ...
1
vote
1answer
33 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 ...
0
votes
0answers
43 views
Repair EE addon?
the thing is that i Really need this addon to work , and somehow the developer is not answering as this is a beta version. I looked around it and this is the problematic code :
public function ...
1
vote
1answer
16 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
14 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
67 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
21 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
34 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
48 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
50 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 ...
1
vote
1answer
29 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
79 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
69 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
35 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
60 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
31 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
80 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 ...
4
votes
2answers
111 views
Changing Member ID #s - possible?
This may be just me being a stickler for order, but sometimes I start a new project using an old database where I have to delete a bunch of data. Some of that data includes member info. Now, while ...
4
votes
6answers
128 views
How to create a form and insert form data to database in ExpressionEngine?
I am developing a website in ExpressionEngine and I am a newbie for ExpressionEngine and CodeIgniter.
I want to create a form on page and want to insert it data after submission to my customized ...
3
votes
2answers
206 views
Long open/save for entries with 10-column Matrix fields
I am moving over a thread started on P&T's Get Satisfaction.
I am getting a MySQL timeout saving an entry that had a 10-column Matrix field and some 70 rows. Raising the MySQL limits fixes the ...
0
votes
0answers
30 views
EE-tuned my.cnf [closed]
Could someone post a good/optimized my.cnf configuration for EE? I'm having slow database issues with my hosting and I'd like to compare the MySQL configuration with others.
Thanks.
4
votes
2answers
49 views
EE - move channel entries from one channel to another ( they share the same channel fields )
I accidently created two channels ( news & press-releases ). They share the same custom-fields - how do I merge them ( news into press-releases ) ?
Tried this ( 23 being the id of press-releases ...
3
votes
2answers
140 views
What is the MySQL function for exp_members password column?
I forgot to save my password and am unable to get MAMP Pro's postfix working so I can't resend the password to myself from my local machine, unfortunately.
What is the MySQL function used to generate ...
4
votes
2answers
61 views
How to populate Relationships
I'd like to manually populate the relationships table with some data.
I can see the structure of the exp_relationships table, which relates parent_entries to children.
However, for a custom field ...
4
votes
2answers
137 views
ExpressionEngine 1 Query Module and Ordering SQL UNION
I'm receiving a MYSQL Error on this code in ExpressionEngine 1.6.4 (very old version)
{exp:query limit="10" paginate="bottom"
sql="SELECT 'gallery' AS `content_type`, `cat_id` AS `entry_id`, ...
3
votes
1answer
57 views
How to Batch Update Channel Preferences?
I inherited a site with a zillion channels, and every channel has "Automatically Convert URLs to Links?" set to "yes".
Is there a query I can use to update the preferences for all of these channels ...
4
votes
1answer
40 views
Computing word, image, video and audio file counts in a scalable way?
I am attempting to gather as much interesting metadata as possible to display for readers of an EE site I'm developing and am looking for guidance on methods (or indeed the feasibility) of computing ...
2
votes
4answers
157 views
What is the maximum number of custom fields you can use in an installation?
I have a fairly large-scale site to build? How many custom fields can I use without running into MySQL database limitations?
8
votes
2answers
82 views
Field with huge amount of content
I have a custom field for some body text, but the content for one particular entry is so long that it gets chopped off, presumably because of the MySQL limit for columns of type TEXT.
I absolutely ...
4
votes
1answer
95 views
Reformat external Date-Format to unix-timestamp / ee-compatible format
I have a date-field where I get some raw data from another system (I have no control over the export of the other system) … the date is published in the following format:
2010-10-26T07:11:18Z
Is ...
