The mysql tag has no wiki summary.
0
votes
0answers
8 views
AWS or EC2 hosting solution
I have a conflicting question. I felt like a noob reading the difference between AWS and EC2 although I haven't tried them. I did not have the time to test them out, so I am hoping to hear some ...
0
votes
1answer
27 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
20 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
18 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
45 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
34 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
35 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
46 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
19 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
18 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
77 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
26 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
41 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
54 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
59 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 ...
