The database tag has no wiki summary.
2
votes
1answer
42 views
How can I remove thousands of spam members on a non-member site?
My first EE 1.6.8 site is coming back to haunt me. The site crashed and burned the other day. Took a look at the members in the DB and there's about 78000 spam members in there. I have access to ...
2
votes
1answer
22 views
How to migrate an existing site into an MSM install?
I have inherited a client project that involves a number of EE installs (6 in all, though some are MSMs themselves, so total number of sites is ~10) which I would like to merge into a single MSM ...
2
votes
1answer
51 views
Unable to Load Site Preferences
I'm trying to duplicate a site onto a different server and am running into the old "Site Error: Unable to Load Site Preferences; No Preferences Found" error. Through searchign the forums some fixes ...
1
vote
2answers
49 views
Writing update queries more efficiently in EE
I've got two queries that I'm running separately in a template, one after the other, like this:
<?php
$sql = "UPDATE exp_channel_titles SET status = 'Registered' WHERE channel_id = '12' AND ...
0
votes
0answers
29 views
need to create v1.7.x plugin for pulling data from an oci8 database into template
I've used oci8 databases in CodeIgniter applications in the past, but before I have never connected to a database in EE plugins I have written in the past.
I imagine I could use the database class to ...
0
votes
1answer
34 views
Assets 2.0.5 problem when transferring database
I am trying to install a local copy of my database on Mamp. But I am getting the following error in the exp_assets_folders table:
#1062 - Duplicate entry 'ee-0-' for key ...
1
vote
1answer
65 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 ...
0
votes
1answer
18 views
Query module: lost connection to MySQL server during query
I have a query being compiled in a template but by the time it's run, it appears that the query module has lost it's connection to the DB:
Error Number: 2013
Lost connection to MySQL server during ...
2
votes
2answers
24 views
cannot edit global template preferences
I have a weird scenario where I am trying to edit my global template preferences. I change a simple dropdown or field, hit submit, and get a successful indicator (the green icon at the top of the ...
1
vote
1answer
32 views
Merging two ExpressionEngines databases
Just had a client enter a large amount of content (400+ articles) onto our development built by accident, trying to work out a cunning way of merging the live database with the development database ...
1
vote
2answers
46 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
48 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
48 views
NSM Config Bootstrap is not overwriting the settings in database.php
This is starting to make me tear my hair out. I've worked with NSM config bootstrap (http://ee-garage.com/nsm-config-bootstrap) on several sites now. It enables you to set your database connection ...
8
votes
4answers
267 views
Query optimization and database indexes
I noticed that there a handful of queries that ExpressionEngine runs that don't use any database indexes. An example is the query SELECT DISTINCT ee.* FROM exp_extensions ee WHERE enabled = 'y' ORDER ...
1
vote
1answer
47 views
Why settings in my config.php aren't overriding settings in the CP
It's my understanding that settings in the config.php override any settings in the control panel.
Background:
I have copied a site over so it runs from another domain (with the view of closing down ...
0
votes
0answers
28 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 ...
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
63 views
Hard Coding date_default_timezone_get()
I am getting this error when I transferred my ee site to a new host:
A PHP Error was encountered
Severity: Warning
Message: date_default_timezone_get(): It is not safe to rely on the system's ...
2
votes
2answers
58 views
Need to move several hundred Structure entries to a new template/template_id
A component of a site I am building has changed and as a result I need to move the entries over to a new template. It looks like this template data is stored in exp_sites > site_pages.
How would you ...
2
votes
3answers
349 views
Move ExpressionEngine from development to live (same server)
I'm 95% of the way through a project just now and soon I am going to have to move EE from the 'development' folder to the 'live' folder. My questions before I do this are:
Can I just copy all the EE ...
1
vote
1answer
37 views
Trouble Creating an accessory that will access DB field and modify value
I am creating an accessory that will access a table that I have created to update the value of a field. I have it set up so that if the value is 1 the page will be rendered and if the value is 0 the ...
1
vote
1answer
37 views
What's better for performance when storing multiple vars in a single entry with stash? Set or Set_list?
I'm curious if anyone that has either done a comparison between the two or simply knows why one would be more efficient than the other. Stash set vs. set_list in storing multiple individual field ...
0
votes
1answer
42 views
Database Error When Adding Entry With Multisite Manager
I have recently set up a second site using Multisite Manager with ExpressionEngine 2.5.2. I got everything working smoothly on my local environment, however, when I try to add entries through ...
4
votes
2answers
115 views
Is ExpressionEngine Right for iPhone App Development
I am in the process of deciding if ExpressionEngine can be used for a project where I am creating both a website and a native iPhone App.
I would need cron background worker jobs, to pull data with ...
2
votes
1answer
77 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 ...
0
votes
1answer
22 views
Database errors when deleting channel fields and second site with Multisite Manager
I'm using ExpressionEngine 2.5.2.
I recently added a second site using Multisite Manager on my local environment, staging environment, and production environment. The installation is complete and I ...
0
votes
1answer
67 views
SQL Query to write member username to custom channel field
Can anyone help with the syntax to write ALL members 'Usernames' in a particular member Group to a custom_field in a channel.
Each member would have one entry each in this channel and I need to pull ...
2
votes
1answer
41 views
Quick way to get user's signature in PHP
I'm just wondering if there is a quick way to get a user's signature using something like the session class? For example to grab the active user's email from the session class you can simply call ...
3
votes
2answers
49 views
Low Variable and conditional logic generating silent database queries
I’ve discovered a tricky question about parse order and low variables I’ve run into. This is a code base I’ve inherited, so I’m not sure how best to handle. (My apologies in advance; I am neither an ...
2
votes
2answers
68 views
Assets2: exp_assets_folders table gives error on migration [closed]
just upgraded to Assets 2 and must say the visuals are stunning.
When migrating from my local machine to my online development enviroment i got the following SQL error when uploading the database.
...
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
2answers
153 views
DB Error on Upgrade from 2.5.3 to 2.5.5
I've just run through the upgrade process from EE 2.5.3 to 2.5.5 but when attempting to visit the control panel the following error is returned:
A Database Error Occurred Error Number: 1054
...
1
vote
1answer
28 views
Information isn't updating & tracing
When submitting my form that stores my facebook id it is sent to the method save_settings(). No matter what I do I can't dump variables or echo them out to see what is being sent, so I think this is ...
3
votes
1answer
45 views
Get specific value without having to loop with db class
So I am trying to get a specific setting out of the database. And it seems that most of the CodeIgniter DB actions don't work in ExpressionEngine( ...
4
votes
2answers
57 views
After upgrading an EE1 site to EE2, should you delete any unused database tables?
For example, exp_weblog_ or exp_trackbacks? Any others? Is this something that you normally do?
8
votes
4answers
228 views
How to Hack the Core for Longer Titles?
My client needs longer titles/URL titles/Structure url titles, but there is no add-on available with this specific functionality. I already know about these add-ons, but they don't do what I need. A ...
4
votes
2answers
136 views
Database Error (exp_security_hashes)
I've been getting errors related to the exp_security_hashes table and it's always this statement:
Unknown column 'ip_address' in 'where clause'
Normally I would be looking at the add-on but this ...
2
votes
1answer
44 views
Changing entry_id: possible, but asking for trouble?
We have an internal system for assigning three digit numbers to the various accounts where we accept donations. These are set in stone and cannot be changed. If we could match these three digit ...
3
votes
2answers
90 views
Is it possible to clean up the database tables?
I recently inherited an EE site that the previous developer kind of put together while learning how to program. It works, and honestly for never having done it before he did a pretty good job of ...
2
votes
1answer
53 views
Should the channel data table have so many columns?
I have noticed that each custom field takes up 2 columns in the channel data table.
The second column often seems to have little value.
Existing columns do not seem to be recycled for new channel ...
1
vote
2answers
69 views
Managing database for single site across multiple servers?
Does anyone have any advice on how to deal with separate databases (local, staging, live) for the same EE site on different servers?
The client changes things on live, but I obviously do any site ...
4
votes
1answer
87 views
Deleting members / Changing Author of multiple entries
I used zoo member/safecracker to allow registered members submit 1 entry (application form) a few months back. I now need to open this form back up for submissions again. I need to save the original ...
2
votes
2answers
55 views
How to trace channel fields when there is a relationship?
I need to write a custom query against the exp_channel_data table. However, one of the channel's field is a relationship field. How do I track that back to the appropriate column in the ...
6
votes
3answers
128 views
Database Queries in Output Profiler Won't Display
With template debugging enabled, clicking the "show" link to display the database queries isn't working.
I suspect this is related to the fact that on all pages of this site there are 7 chunks of ...
4
votes
4answers
101 views
How to prune data in v2.x?
EE v1.x had nice tools to prune data. EE 2.x seems to have removed these features.
What I want to do is delete Pending user accounts (never activated their account). I can go through and manually ...
6
votes
2answers
174 views
Compatibility / Performance Gains from using MariaDB?
My hosting company is now offering MariaDB as an alternative to MySQL. Does anybody know if EE is compatible with MariaDB and if it offers any performance benefits?
https://mariadb.org/
4
votes
5answers
232 views
How to import data in EE?
I have a CSV that I'd like to import into EE. Looking at exp_channel_fields, I think I am able to connect them to the appropriate columns in exp_channel_data. Basically, it seems like the value in ...
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 ...
5
votes
4answers
100 views
Do username have to be unique in ExpressionEngine?
I am in the process of importing data from another application to ExpressionEngine. I know that EE expects screen_names to be unique as of Sept 2012.
The question is whether I have to make the ...
8
votes
3answers
109 views
Addon database interaction
When creating Addons should we utilise the underlying database structure provided by ExpressionEngine for storing large numbers of items / information. For instance use channel entries? Or should you ...
