#3 Documentation to reflect $db_prefix

[William Entriken]

Documentation needs to address the $db_prefix feature
for manual installations.

[William Entriken]

Logged In: YES
user_id=100315

Clip from email:

I have been trying to manually install this for a friend and
have the
following problems;

1. The ISP only allows one mysql database so I edited the
config.php
file to accommodate this.

e.g.
<?php
$db_host = 'db.mywebsite.com'; // not revealed for security
$db_name = 'mydatabase'; // not revealed for security
$db_user = 'myusername'; // not revealed for security
$db_pass = 'mypassword'; // not revealed for security
$db_prefix = 'cameralife_';
$auth_cookie = 'cameralifeauth';
$installed = true;

2. Edited the install/install.mysql to add db_prefix to tables.
The site has phpMyAdmin so I ran the install.mysql which
successfully
created the tables.

3. Changed
UPDATE users SET auth=5;
to
UPDATE cameralife_users SET auth=5;
(assuming that it needed to set the table which is now
cameralife_users)
ran this SQL from phpMyAdmin

4. Cannot run the index.php as that gives the message;
Site preferences error!

So decided that the package needs further investigation from
me to get
it installed. Haven't the time so am leaving it for now.

Any recommendations gratefully received as the it does
appear to offer
what my friend is needing.

[William Entriken]

Logged In: YES
user_id=100315

Solved my problem, I changed the following in common.php;

from

// Load preferences
$preferences_query = mysql_query("SELECT
*,TO_DAYS(NOW())-TO_DAYS
(sitedate) as age from preferences",$photo_link)
or die('Site preferences error!');

to

// Load preferences
$preferences_query = mysql_query("SELECT
*,TO_DAYS(NOW())-TO_DAYS
(sitedate) as age from " . $db_prefix
."preferences",$photo_link)
or die('Site preferences error!');

[William Entriken]

Logged In: YES
user_id=100315

Documentation should explain how to create albums:

The package appears to be working now except I have not
created any
folders for the albums.

(My problem is that I read the instructions when all else fails)

Congratulations on a nicely presented program, (I just need
to figure
out how to create albums now).

[William Entriken]

Logged In: YES
user_id=100315

Adding to preferenes:

Thanks for getting back to me. Everytime I run these files I
am forced
out because the preferences are not setup.

I have created a .sql file to insert into cameralife_preferences
manually but am still not getting anywhere.

I recommend that you try a manual install yourself to reveal the
problems.

(I am new to mysql and php, but not to programming)

I shall try a bit more but it is fast losing its appeal as
it is proving
too difficult to install.

[William Entriken]

Logged In: YES
user_id=100315

I can now get into Administer but when I select User Manager
I keep
getting the following message;

You have an error in your SQL syntax near 'SE' at line 1

(Of course it may be a result of my manually entering the
admin user
data, but that was the only way I could get the program to
install.)

I cannot find any reference to the message so cannot get
beyond it
(yet).

[William Entriken]

Logged In: YES
user_id=100315

This is fixed and will be released in 2.5.3