The database tag has no wiki summary.
1
vote
1answer
29 views
How do I decode columns in the exp_sites table?
I need to look at the contents of the site_system_preferences column in the exp_sites table. How do I decode this data?
2
votes
0answers
19 views
Control Panel locking me out after uploads and template changes - says no data
Prolem:
I am using ExpressionEngine Core 2.6.1. After I click around the control panel for a bit, sometimes updating templates and sometimes uploading images, I get kicked out. When I get kicked out, ...
2
votes
1answer
27 views
How to bulk import multi language data to channel entries?
I'm trying to import a data base that has multi language entries to EE and thought of using DataGrab. I'm using Publisher plugin to relate multilanguage entries. Is there a way that I can import the ...
1
vote
1answer
24 views
Automatically removing old entries
I have a channel which is growing large through automatic daily imports. Is there any way to automatically remove (prune) entries older than X days? I've looked through the extension space without ...
0
votes
0answers
10 views
Assets/File Manager throws a DB error 1364 whilst uploading
The assets file manager uploads the file but before giving a summary of the upload it gives this error:
http://s16.postimg.org/7q1ezrcnp/Capture.png
After I close this the file is uploaded anyway, ...
0
votes
1answer
41 views
Can upload image with Assets, but image does not “stick” to entry
I can upload an image to my Asset field(s) and publish the entry. However, here are the weird issues I'm experiencing:
The Asset field is blank when re-editing the published entry, (but...)
The ...
4
votes
1answer
44 views
Redirect to static page if EE database is down
We have a client that would like to see a branded, non-EE error message if there is a problem with the EE database connection. Their database is hosted on a different server and has, on one or two ...
1
vote
1answer
31 views
Adding new channel fields takes 5 minutes
I work with an EE website that has 293 custom fields, and 125k entries. Nowadays, whenever I am adding a new channel field, it takes between 4 and 5 minutes to complete the task! Also, it can take up ...
1
vote
1answer
32 views
DB Connection Error
My site was pointed to an IP without an attached domain. Now that the domain is pointed there, the pages stopped resolving and I get an error 500 message. After some trouble shooting I found:
A ...
0
votes
1answer
20 views
add new channel fields for existing site
I´ve a site with a channel, this channel has a channel field group with 2 fields. So far, so standard.
My problem:
I know exactly, that after some time when the site evolves I´ll ned more channel ...
0
votes
1answer
51 views
SQL query getting entries from current day
I am trying to use this script that I have put together, forgive me I am a bit of a newbie with sql.
When I run the script it is outputting an empty csv file, only showing column titles, no data.
...
1
vote
0answers
24 views
Playa upgrade from 3.0.9 to 4.4.3 missing relationship data
I just upgraded EE from 2.1 to 2.6.1, then upgraded Playa from 3.0.9 to 4.4.3.
I realized I had to rewrite the syntax in the templates. That wasn't fun. But the real issue I am having is the missing ...
1
vote
1answer
20 views
Attempting to trouble shoot email issues but I have no exp_postmaster_mailbox
I currently have two sites I'm working on right now which utilize the built in email module. I can fill the form out, hit submit and I get a message saying it's been sent, but it never gets sent. I ...
0
votes
2answers
33 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 ...
0
votes
2answers
49 views
System folder & database.php path
I moved my system folder above the root and was updating the database.php file and was confused about the correct path for one of the settings.
Should it be:
$db['expressionengine']['cachedir'] = ...
0
votes
2answers
45 views
What steps do I need to take to remove borked entry from database (channel_titles: yes, channel_data: no)
Before I troubleshoot what caused the problem in the first place (entry made using safecracker form), I'd like to know how to remove the bad data.
EE Version v2.5.2 - Build Date: 20120606*
...
2
votes
1answer
25 views
Database error when www prefix is used
I am using a version of the Focus Labs Master Config setup and I am getting a database error when using the www. prefix in front of the URL. This is a problem that I haven't run into before. Anyone ...
0
votes
3answers
29 views
I'll get a databae error when updating a entry using the channel polls field type
Recently I've installed the Channel Polls module of Devdemon on my development environment.
I addded the fieldtype to the channel and edited a existing entry, when I press submit the system will throw ...
0
votes
1answer
40 views
retrieve the database name in an extension
I'm building a small plugin for EE and I need to retrieve the name of the database. ( specified in config > database.php )
But I can't seem to find any docs that point me in the right direction.
0
votes
1answer
30 views
Database error from Safecracker
I have a page that allows registered users to post a entry on my site.
Since upgrading to the latest version of EE, I'm getting the following error, instead of the page loading:
Error Number: 1054
...
2
votes
1answer
114 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
41 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
352 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
120 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
1answer
35 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
40 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
92 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
90 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
41 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
54 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
61 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
75 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
93 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
349 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
56 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
35 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
91 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 ...
2
votes
1answer
163 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
74 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
606 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
70 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
46 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
63 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
153 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
127 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
24 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
105 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
73 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
73 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
77 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.
...
