Entries Tagged 'Database' ↓
September 1st, 2010 — Admin, Control Panel, Database, Errors, Setup, Troubleshooting, Web Hosting
Progress Bar Never Stops
You’re seeing the green “Loading… Please Wait” progress bar continuosly running – it never stops and comes back with any data.
If this is a new setup, then it’s possible that your web host does not have a library called “JSON” enabled. Just ask them to enable it for your server. It’s rather simple to do, and we’ve never seen a host that won’t do this for their customers.
If it’s an old setup, and it was working previously, then your host made some changes that caused the library to stop working. So you still need their help in resolving the issue.
Error Message: “There was an error returning data’”.
One possibility is that your database or web site is temporarily down, slow, or plain not responding for some reason. So DAP cannot connect to your database, and comes back with this error.
Or it could also be the “Progress Bar Never Stops” issue from above.
June 27th, 2010 — Activation, Admin, Control Panel, DAP, Database, Installation, Setup, Web Hosting
Here’s how you can move an existing DAP installation from one host – or domain – to another.
- Log in to your web hosting control panel, go to “phpMyAdmin”, select your WordPress database (which is where the DAP tables are also installed, by default)
- Do an “Export” of just the DAP tables. Select the “SQL” option and select “Save as File”. All DAP database tables start with the text “dap_”. Save this file on your desktop – let’s say you call it “dapexport.sql” (it could also be “dapexport.txt” – does not matter what the exact extension is – .txt or .sql).
- Make a back up of the dap-config.php file (located in the “dap” directory on your old site/domain) on your desktop
- At your new site, install WordPress
- Copy the database info from your new blog’s “wp-config.php” to the “dap-config.php” file stored on your desktop.
- Then log in to your web hosting control panel of your new site, go to “phpMyAdmin”, select your WordPress database, go to the “SQL” tab, open the export file from above (dapexport.sql), copy the contents, paste into the SQL tab and hit “Go”. All dap data from your old site is now on your new site.
- Upload all dap files to your new site (don’t do full installation – just upload the files).
- Also upload the LiveLinks files to wp-content/plugins/ .
- Upload the new dap-config.php file from your desktop to the “dap” folder on your new site.
- Log in as WP admin, and activate the LiveLinks plugin. It should give you a warning that DAP is already installed. That’s ok, that’s what we want it to say.
- That’s it. DAP is now moved over from your old site to your new site.
- Log into your DAP Dashboard using your old DAP admin login info, and you’re all set.
May 4th, 2010 — 3rd Party Integration, Access Control, Admin, Config, Customization, DAP, Database, LiveLinks, Setup, Users, WordPress, WordPress FAQ
NOTE: This content is for advanced users only, who understand the concept of user tables, database, etc. If you don’t understand any of this, then just ignore this – you don’t really need to know this in order to use DAP. This is only an explanation for those who wish to go under the hood of DAP and its integration with WordPress.
As you probably already know, WordPress has its own user database.
DAP has its own User database, and doesn’t use the WordPress database – for many reasons, not limited to the following…
1) Ability to store more user information than what WordPress allows
2) More powerful user search, profile updates, affiliate information, etc.
So, if you want to use any WordPress based plugins – like WordPress Forums or Subscribe2Blog – these forums are looking at WordPress’ native user database.
Now comes the necessity of “syncing” the DAP user data and your WordPress user data.
In the DAP Dashboard, in “Setup > Config > Advanced“, you will see two settings for syncing DAP & WP user data.

(1) Sync DAP User data and WP User data
If you turn this to “Y” (for “Yes”), then every time someone logs into DAP, their DAP user data (just name and email) is automatically “synced” with WordPress user data. If you set this to “N”, then no data will be transferred from DAP to WordPress.
(2) Sync WP data only for PAID users
This one matters only if you have set (1) above to “Y”.
If you want only your “PAID” members to be synced with WordPress, then set this to “Y“.
If you want both “FREE” and “PAID” members synced with WordPress, then set this to “N“.
Here’s how it actually works:
- For the sync to work, you must first setup and save the above 2 config settings
- After you save the above two config settings, make sure you log out of DAP and re-log in (if you are/were logged in and testing as a regular user), because only then, the Config settings above will take effect.
- Your user must log in through a DAP login form (not the WP login form).
- Make sure the user is redirected to any part of your WordPress blog after log in. This can be done via “Logged In URL” setting in DAP Config.
- The user can be redirected to any WP page, WP post or even your blog home page – that’s the only time the ‘syncing’ kicks in.
- When user lands on any page/post of your WP blog, then the DAP LiveLinks plugin (which you have already installed & enabled) kicks of the “sync”, copies the logged in member’s name and email over to the WordPress user table, and also automatically logs him into your WordPress blog.
That’s all there is to it.
Also see: Forum Integration
July 12th, 2009 — Access Control, Database, Users
Removing User Access to a Product
1. First search for user in the “Users > Manage” screen.
2. At the end of the user’s row of information, you’ll see a link called “Remove”.
Every time you click on “Remove”, the user’s access is “rolled back” by a month (or the recurring period of the product). So if they have been a member for 3 months, then the first time you click on “Remove”, the user’s access is rolled back by 1 month, so the user now has access to your content for 2 months. So, two more clicks on “Remove” and the product is completely removed from the user’s account. We realize this is a little bit of an inconvenience when removing large number of users from a product, so in the next release, we will be adding a feature that makes it easier.
Deleting users
If you wish to completely remove the users from your database, then check the checkbox next to the user’s row, and then in the upper right hand section, click on the “Go” button next to the text “Fully Delete Selected Users from the database”. That should do it.
January 1st, 2009 — DAP, Database, Updates
The following is relevant to you only if you are “Upgrading” DAP from an earlier version.
Yay, DAP version 1.0 is here! (click here to see the what changed )
This is an important update, so do not skip this.
Here’s how to upgrade to the new version:
1. Download the zip file and unzip to desktop. You should now see a folder by name “dap” on your desktop.
2. Overwrite the contents of your current “dap” folder on your site with the contents of the new “dap” folder on your desktop.
3. Do not try to use any admin functionality yet. Visit the following link:
http://YourSite.com/dap/update.php and follow the instructions on your screen.
NOTE: Replace YourSite.com with your actual domain name.
That’s it!
<sidebar>
This is just for your information….
We have moved the email and header/footer templates from text files into the database, as some web hosts were very weird with file permissions and were causing issues. So all files which were previously located under /dap/templates/email/ and /dap/templates/content/ have now been moved to the database.
The contents of these template files have been copied over as-is to your database. But just as a sanity check, visit your “Admin > Templates” screen and double-check the content of these templates.
</sidebar>
February 23rd, 2008 — Cron, Database, Installation
NOTE: If you are using WordPress, then click here for instructions on how to install DAP as a WordPress Plugin.
This documentation below is only for installing DAP on a Non-WordPress, plain HTML web site.
But you don’t need to be doing this!
Did you know you get free installation along with your purchase of DAP? Yes, even if you are only trying out the free trial and haven’t paid us a dime!
But for some reason, if you do not wish to take us up on the free offer, and wish to do it yourself, then here are the instructions.
We’ve tried to make DAP installation extremely simple. To do a full installation of DAP (non-WordPress version), it will take about 15-20 minutes.
Uploading the files
Download dap.zip from the members area:
Unzip to your desktop. You should see a folder named dap
Upload the entire dap folder on your computer, to the root of your web site. The root directory is where your web site’s home page is usually located. This directory also goes by the name “public_html” or “www” or “htdocs”.
Once this is done, the dap folder should now be accessible by typing in http://www.Example.com/dap/ – but wait – don’t visit that link yet.
Creating the Database
You will first need to create a database for DAP to use and store its data. So log in to your web host control panel, go to the “MySQL Databases” section, create a new database, then create a new user (with password), then finally make sure you “Add” the newly created database user to the newly created database (to give the user access to create, read, update and delete data from the database).
Note down the new database name, username and password.
Installing DAP
Visit http://YourSite.com/dap/install/
Fill out the form there with the above database details.
Put in “localhost” for the database host name (unless your host has specifically asked you to use something else).
Submit the form.
That should create the dap-config.php file within your dap folder.
And you’ll see a series of messages about how the installation went.
That’s it for the basic DAP installation. You just need to set up the cron jobs to complete installation.
Setting Up the Cron Jobs
See this link to set up the cron jobs.
That’s it!
For support, open a ticket at http://www.DigitalAccessPass.com/support/