phpDivingLog
Hey Inferno,
I have completed the installation,
http://ruud.borghouts.net/logboek/v2.0a3/
It works,
All of it! But note that in Firefox the page goes outside the border, I mean I can't view the first 100px or so of the left side of the pages exept for the stastistics page. Don't know about IE, can't test that here.
Greetz IaMtHeOnE.
I have completed the installation,
http://ruud.borghouts.net/logboek/v2.0a3/
It works,
All of it! But note that in Firefox the page goes outside the border, I mean I can't view the first 100px or so of the left side of the pages exept for the stastistics page. Don't know about IE, can't test that here.
Greetz IaMtHeOnE.
Hi, could you please explain how the multiuser stuff actually works, and how I should import the data from Diving Log? I set up 2 users in the config.inc.php file (as well as setting multiuser to "true"):
$_config['user_prefix'][1] = 'michelle';
$_config['user_prefix'][2] = 'leif';
Then in order to get phpdivinglog to stop throwing errors, I had to create a leifPersonal and michellePersonal table and populate those. However obviously if I select a user from the interface it doesn't work.
At that point, I'm getting the "The requested URL /server/html/divelog/index.php/1/list was not found on this server." but I'm stuck at that point, and am not sure how exactly to store the data for each user in mysql.
Thanks.
$_config['user_prefix'][1] = 'michelle';
$_config['user_prefix'][2] = 'leif';
Then in order to get phpdivinglog to stop throwing errors, I had to create a leifPersonal and michellePersonal table and populate those. However obviously if I select a user from the interface it doesn't work.
At that point, I'm getting the "The requested URL /server/html/divelog/index.php/1/list was not found on this server." but I'm stuck at that point, and am not sure how exactly to store the data for each user in mysql.
Thanks.
In the Mysql export display (from within divinglog), you should enter a Table prefix
say for user: michelle enter michelle as the prefix
for user leif enter leif
You need to export all tables since for example the Personal table is needed for diver overview.
On http://rob.lensen.nu/divelog_dev/ you can see the multi user mode
This is the config
What is the server running?
Other important bit in the config file:
say for user: michelle enter michelle as the prefix
for user leif enter leif
You need to export all tables since for example the Personal table is needed for diver overview.
On http://rob.lensen.nu/divelog_dev/ you can see the multi user mode
This is the config
Code: Select all
/**
* When multiuser is set to true, you need to define the table prefixes
* Data for all the users should be in the same database
*/
$_config['multiuser'] = true;
/**
* Define the table prefix for each user
* $_config['user_prefix'][user_id] = 'table_prefix'
* The user_id should start with 1 and can be defined.
*/
$_config['user_prefix'][1] = 'rob';
$_config['user_prefix'][2] = 'sjaak';
$_config['user_prefix'][3] = 'sjaak2';
Other important bit in the config file:
Code: Select all
/**
* change this to your website url
*/
$_config['web_root'] = 'http://rob.lensen.nu/divelog_dev';
/**
* Your path where divelog is located
*/
$_config['abs_url_path'] = '/divelog_dev';
I got everything to import ok with the table prefixes (I didn't realize you could do that , but I'm still getting the same error, however I kind of see why. I set the following in my config:
$_config['web_root'] = 'http://cosmo.ogre.com';
/**
* Your path where divelog is located
*/
$_config['abs_url_path'] = '/server/html/divelog';
The address it's trying to go to is http://cosmo.ogre.com/server/html/divel ... php/1/list
which is wrong - why would it be putting the absolute path in the URL? However no combination of changing those 2 config options can make it work - I just get different "file not found" errors depending on what path I use. (I've tried using "http://cosmo.ogre.com/divelog", tried taking out parts of the absolute path, but nothing seems to work)
Also, if I try to go directly to the address I think is right, which I think is "http://cosmo.ogre.com/divelog/index.php/1/list", then it just pulls up the 2 usernames for me to select again.
$_config['web_root'] = 'http://cosmo.ogre.com';
/**
* Your path where divelog is located
*/
$_config['abs_url_path'] = '/server/html/divelog';
The address it's trying to go to is http://cosmo.ogre.com/server/html/divel ... php/1/list
which is wrong - why would it be putting the absolute path in the URL? However no combination of changing those 2 config options can make it work - I just get different "file not found" errors depending on what path I use. (I've tried using "http://cosmo.ogre.com/divelog", tried taking out parts of the absolute path, but nothing seems to work)
Also, if I try to go directly to the address I think is right, which I think is "http://cosmo.ogre.com/divelog/index.php/1/list", then it just pulls up the 2 usernames for me to select again.
Maybe this config option is a bit confusingmhedstrom wrote:I got everything to import ok with the table prefixes (I didn't realize you could do that , but I'm still getting the same error, however I kind of see why. I set the following in my config:
$_config['web_root'] = 'http://cosmo.ogre.com';
/**
* Your path where divelog is located
*/
$_config['abs_url_path'] = '/server/html/divelog';
The address it's trying to go to is http://cosmo.ogre.com/server/html/divel ... php/1/list
which is wrong - why would it be putting the absolute path in the URL? However no combination of changing those 2 config options can make it work - I just get different "file not found" errors depending on what path I use. (I've tried using "http://cosmo.ogre.com/divelog", tried taking out parts of the absolute path, but nothing seems to work)
Also, if I try to go directly to the address I think is right, which I think is "http://cosmo.ogre.com/divelog/index.php/1/list", then it just pulls up the 2 usernames for me to select again.
I think your config should be
Code: Select all
$_config['web_root'] = 'http://cosmo.ogre.com/divelog'
$_config['abs_url_path'] = '/divelog';
Oooh that worked, now to play with it. Thanks!
One bug: I do have all the metric to imperial units turned on, but in the list view of dives (the view you get after you click on a person), the depths in that list are all in meters. However if I click on a specific dive, they're all correctly in feet.
One bug: I do have all the metric to imperial units turned on, but in the list view of dives (the view you get after you click on a person), the depths in that list are all in meters. However if I click on a specific dive, they're all correctly in feet.
That is a bug, will fix itmhedstrom wrote:Oooh that worked, now to play with it. Thanks!
One bug: I do have all the metric to imperial units turned on, but in the list view of dives (the view you get after you click on a person), the depths in that list are all in meters. However if I click on a specific dive, they're all correctly in feet.
Not as easy as I thought, since this maybe a limitation of the phpmydatagrid class.Inferno wrote:That is a bug, will fix itmhedstrom wrote:Oooh that worked, now to play with it. Thanks!
One bug: I do have all the metric to imperial units turned on, but in the list view of dives (the view you get after you click on a person), the depths in that list are all in meters. However if I click on a specific dive, they're all correctly in feet.
Will search for a solution, however will take some time
mmm strange query works on mine Mysql 4.1mhedstrom wrote:Another bug, when clicking on the Dive Statistics link:
MySQL error 1054: Unknown column 'True' in 'where clause' :
Query: SELECT COUNT(*) AS Count FROM leifLogbook WHERE Deco = True
could you try
Code: Select all
SELECT COUNT(*) AS Count FROM leifLogbook WHERE Deco = 'true'
The dive statistics screen isn't set up for multiuser mode. For instance, if I go into there to see my dive stats, and next to where it says (for example) "Shortest Dive" with the time and a link to the dive number, clicking on the dive number goes to
http://cosmo.ogre.com/divelog/index.php/5
instead of
http://cosmo.ogre.com/divelog/index.php/1/5
Also I can fix the CSS myself, but everything is butted up right against the left margin.
Other bugs I found, these next 3 are all on the individual dive logbook pages:
1) Avg. depth says "35.66 feet m" instead of "35.66 feet"
2) The SAC rate and Tank Size both say "cu ft" instead of "cu ft". I fixed that in my english.inc.php file, but just an FYI.
3) The Dive Location is blank, even though if you look at the dive listings overview page, there is a Dive Site listed fine for each of those dives.
http://cosmo.ogre.com/divelog/index.php/5
instead of
http://cosmo.ogre.com/divelog/index.php/1/5
Also I can fix the CSS myself, but everything is butted up right against the left margin.
Other bugs I found, these next 3 are all on the individual dive logbook pages:
1) Avg. depth says "35.66 feet m" instead of "35.66 feet"
2) The SAC rate and Tank Size both say "cu ft" instead of "cu ft". I fixed that in my english.inc.php file, but just an FYI.
3) The Dive Location is blank, even though if you look at the dive listings overview page, there is a Dive Site listed fine for each of those dives.
Fixed in my dev version, will submit soonmhedstrom wrote:The dive statistics screen isn't set up for multiuser mode. For instance, if I go into there to see my dive stats, and next to where it says (for example) "Shortest Dive" with the time and a link to the dive number, clicking on the dive number goes to
http://rob.lensen.nu/divelog_dev/divestats.php/1/list
It is just Firefox I think IE looks okAlso I can fix the CSS myself, but everything is butted up right against the left margin.
will look1) Avg. depth says "35.66 feet m" instead of "35.66 feet"
Fixed in dev version2) The SAC rate and Tank Size both say "cu ft" instead of "cu ft". I fixed that in my english.inc.php file, but just an FYI.
Is it possible to make a mysql dump, since I found a bug in the export query of divinglog, where the divesite_id is not set in the Logbook table. If that is the case divesites will be empty3) The Dive Location is blank, even though if you look at the dive listings overview page, there is a Dive Site listed fine for each of those dives.
Which version of mysql you have got? I will fix the query's anyway