phpDivinglog 2.2 development

3rd party extensions (phpDivingLog, dive computer downloader,...)
Post Reply
TheULi
Posts: 40
Joined: Tue Dec 04, 2007 08:18
Location: Sottrum / Germany
Contact:

Re: phpDivinglog 2.2 development

Post by TheULi »

Hi Rob,

Can you have a look at your WebSVN?
The "archiv download" function produces corrupted tgz-archives.

regards
Uli
Diving Log 4.0.11, Suunto Vytec DS, phpDivingLog 2.2
++++++++++++++
Mein Online-Logbuch
Inferno
Posts: 264
Joined: Thu Apr 19, 2007 20:36
Location: The Netherlands
Contact:

Re: phpDivinglog 2.2 development

Post by Inferno »

TheULi wrote:Hi Rob,

Can you have a look at your WebSVN?
The "archiv download" function produces corrupted tgz-archives.

regards
Uli
For the time being, the latest export can be found here:

http://rob.lensen.nu/devdoc/

it is beta4
ianr
Posts: 47
Joined: Thu Sep 17, 2009 11:44

Re: phpDivinglog 2.2 development

Post by ianr »

I've tried this after unsuccessfully trying the other php extension.

It would seem that my knowledge of php and mySQL are really bad :?

I get the following error on my website when i try to access the database:

MySQL error 1146: Table 'db297922610.Logbook' doesn't exist :
Query: SELECT Number, Divedate, Divetime, Depth, Place, City FROM Logbook ORDER BY Number DESC

Any ideas?
Inferno
Posts: 264
Joined: Thu Apr 19, 2007 20:36
Location: The Netherlands
Contact:

Re: phpDivinglog 2.2 development

Post by Inferno »

ianr wrote:I've tried this after unsuccessfully trying the other php extension.

It would seem that my knowledge of php and mySQL are really bad :?

I get the following error on my website when i try to access the database:

MySQL error 1146: Table 'db297922610.Logbook' doesn't exist :
Query: SELECT Number, Divedate, Divetime, Depth, Place, City FROM Logbook ORDER BY Number DESC

Any ideas?
Do you know it you imported your divinglog mysql data?
Do you have phpmyadmin? So you can check out if the table is in your Database
ianr
Posts: 47
Joined: Thu Sep 17, 2009 11:44

Re: phpDivinglog 2.2 development

Post by ianr »

Yes I have checked phpadmin and the tables and data are there. I have also put the database name, server, user and password into the config file but still no joy.
Inferno
Posts: 264
Joined: Thu Apr 19, 2007 20:36
Location: The Netherlands
Contact:

Re: phpDivinglog 2.2 development

Post by Inferno »

ianr wrote:Yes I have checked phpadmin and the tables and data are there. I have also put the database name, server, user and password into the config file but still no joy.
Can you make a screenshot of phpmyadmin?

Do you have an url to the site?
ianr
Posts: 47
Joined: Thu Sep 17, 2009 11:44

Re: phpDivinglog 2.2 development

Post by ianr »

screen dump of the index page of phpadmin at the following link:

http://www.diving.stodge.org.uk/phpadmin.jpg

go up a level to see where the database should be

Cheers
divinglog
Site Admin
Posts: 5768
Joined: Sat Feb 08, 2003 21:02
Location: Coburg
Contact:

Re: phpDivinglog 2.2 development

Post by divinglog »

Hi Ian

What looks to me like a problem is the message "Table 'db297922610.Logbook' doesn't exist". The table name should be just "Logbook" without the database name in front of. But maybe it's the server configuration to display the message in this way and it doesn't mean anything.

I'm sorry, to me everything looks normal and I have no idea why it doesn't work. :cry:

Sven
Inferno
Posts: 264
Joined: Thu Apr 19, 2007 20:36
Location: The Netherlands
Contact:

Re: phpDivinglog 2.2 development

Post by Inferno »

If I look at your screenshot there is no table Logbook, only tables prefixed with DL_ so what you should do is enter the table prefix DL_ in your config.inc.php
divinglog
Site Admin
Posts: 5768
Joined: Sat Feb 08, 2003 21:02
Location: Coburg
Contact:

Re: phpDivinglog 2.2 development

Post by divinglog »

You are right, I have not noticed this. There are other tables without prefix, but the logbook table is missing. Remove either the prefix from the MySQL export settings, or edit the config file.
ianr
Posts: 47
Joined: Thu Sep 17, 2009 11:44

Re: phpDivinglog 2.2 development

Post by ianr »

Thanks for the help so far guys.

I have dropped the tables prefixed "DL_" and have exported new MySQL data and imported into phpmyadmin. The database now appears but the formatting is all wrong and none of the links work.

http://www.diving.stodge.org.uk/
Inferno
Posts: 264
Joined: Thu Apr 19, 2007 20:36
Location: The Netherlands
Contact:

Re: phpDivinglog 2.2 development

Post by Inferno »

ianr wrote:Thanks for the help so far guys.

I have dropped the tables prefixed "DL_" and have exported new MySQL data and imported into phpmyadmin. The database now appears but the formatting is all wrong and none of the links work.

http://www.diving.stodge.org.uk/
Did you read the comments in the config.inc.php file?

Code: Select all

/**
 * change this to your website url
 */
$_config['web_root']        = 'http://rob.lensen.nu/divelog'; 
You should enter:
http://www.diving.stodge.org.uk/

Code: Select all

/**
 * Your path where divelog is located
 * EXAMPLE: http://www.foo.com/users/j/jo/john
 * abs_url_path = /users/j/jo/john
 * Nothing todo where phpdivinglog is installed on your harddrive!
 */
$_config['abs_url_path']    = '/divelog'; 
Should be: '/' since the files are not in the folder diving as you entered
ianr
Posts: 47
Joined: Thu Sep 17, 2009 11:44

Re: phpDivinglog 2.2 development

Post by ianr »

The website URL was correct but I still had '/divelog' in the absolute path. I did find that last part confusing when setting up the config file and to be honest I still don't really understand what it is asking.

I've changed it now but it doesn't seem to have made a difference. I'm pretty sure all of the other config settings are correct.
Inferno
Posts: 264
Joined: Thu Apr 19, 2007 20:36
Location: The Netherlands
Contact:

Re: phpDivinglog 2.2 development

Post by Inferno »

ianr wrote:The website URL was correct but I still had '/divelog' in the absolute path. I did find that last part confusing when setting up the config file and to be honest I still don't really understand what it is asking.

I've changed it now but it doesn't seem to have made a difference. I'm pretty sure all of the other config settings are correct.
My mistake, the absolute path should be empty in your case.

Will update the comments to make it more clear
ianr
Posts: 47
Joined: Thu Sep 17, 2009 11:44

Re: phpDivinglog 2.2 development

Post by ianr »

Cool, putting "" worked for the main page. I tried to go through all of the links and experienced the following errors with the statistics page:


Notice: Undefined variable: userpath_web in /homepages/23/d168663142/htdocs/diving/classes.inc.php on line 2893

Notice: Undefined variable: title in /homepages/23/d168663142/htdocs/diving/classes.inc.php on line 2893

Notice: Undefined variable: Scan1Path in /homepages/23/d168663142/htdocs/diving/classes.inc.php on line 2893

Notice: Undefined variable: cert_scan_front in /homepages/23/d168663142/htdocs/diving/classes.inc.php on line 2893

Notice: Undefined variable: Scan2Path in /homepages/23/d168663142/htdocs/diving/classes.inc.php on line 2894

Notice: Undefined variable: cert_scan_back in /homepages/23/d168663142/htdocs/diving/classes.inc.php on line 2894

Notice: Undefined variable: userpath_web in /homepages/23/d168663142/htdocs/diving/classes.inc.php on line 2893

Notice: Undefined variable: title in /homepages/23/d168663142/htdocs/diving/classes.inc.php on line 2893

Notice: Undefined variable: Scan1Path in /homepages/23/d168663142/htdocs/diving/classes.inc.php on line 2893

Notice: Undefined variable: cert_scan_front in /homepages/23/d168663142/htdocs/diving/classes.inc.php on line 2893

Notice: Undefined variable: Scan2Path in /homepages/23/d168663142/htdocs/diving/classes.inc.php on line 2894

Notice: Undefined variable: cert_scan_back in /homepages/23/d168663142/htdocs/diving/classes.inc.php on line 2894

Notice: Undefined variable: userpath_web in /homepages/23/d168663142/htdocs/diving/classes.inc.php on line 2893

Notice: Undefined variable: title in /homepages/23/d168663142/htdocs/diving/classes.inc.php on line 2893

Notice: Undefined variable: Scan1Path in /homepages/23/d168663142/htdocs/diving/classes.inc.php on line 2893

Notice: Undefined variable: cert_scan_front in /homepages/23/d168663142/htdocs/diving/classes.inc.php on line 2893

Notice: Undefined variable: Scan2Path in /homepages/23/d168663142/htdocs/diving/classes.inc.php on line 2894

Notice: Undefined variable: cert_scan_back in /homepages/23/d168663142/htdocs/diving/classes.inc.php on line 2894

Notice: Undefined variable: userpath_web in /homepages/23/d168663142/htdocs/diving/classes.inc.php on line 2893

Notice: Undefined variable: title in /homepages/23/d168663142/htdocs/diving/classes.inc.php on line 2893

Notice: Undefined variable: Scan1Path in /homepages/23/d168663142/htdocs/diving/classes.inc.php on line 2893

Notice: Undefined variable: cert_scan_front in /homepages/23/d168663142/htdocs/diving/classes.inc.php on line 2893

Notice: Undefined variable: Scan2Path in /homepages/23/d168663142/htdocs/diving/classes.inc.php on line 2894

Notice: Undefined variable: cert_scan_back in /homepages/23/d168663142/htdocs/diving/classes.inc.php on line 2894

The stats were there but they were under all of the errors.

Thanks for all of the help so far. This looks like it will be really useful.
Post Reply