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 » Mon Jul 13, 2009 14:47

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: 252
Joined: Thu Apr 19, 2007 20:36
Location: The Netherlands
Contact:

Re: phpDivinglog 2.2 development

Post by Inferno » Mon Jul 13, 2009 18:45

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 » Thu Mar 11, 2010 07:59

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: 252
Joined: Thu Apr 19, 2007 20:36
Location: The Netherlands
Contact:

Re: phpDivinglog 2.2 development

Post by Inferno » Thu Mar 11, 2010 08:10

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 » Thu Mar 11, 2010 20:08

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: 252
Joined: Thu Apr 19, 2007 20:36
Location: The Netherlands
Contact:

Re: phpDivinglog 2.2 development

Post by Inferno » Thu Mar 11, 2010 22:45

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 » Sun Mar 14, 2010 04:01

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: 5027
Joined: Sat Feb 08, 2003 21:02
Location: Coburg
Contact:

Re: phpDivinglog 2.2 development

Post by divinglog » Sun Mar 14, 2010 15:07

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: 252
Joined: Thu Apr 19, 2007 20:36
Location: The Netherlands
Contact:

Re: phpDivinglog 2.2 development

Post by Inferno » Sun Mar 14, 2010 19:29

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: 5027
Joined: Sat Feb 08, 2003 21:02
Location: Coburg
Contact:

Re: phpDivinglog 2.2 development

Post by divinglog » Sun Mar 14, 2010 19:49

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 » Sun Mar 14, 2010 20:15

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: 252
Joined: Thu Apr 19, 2007 20:36
Location: The Netherlands
Contact:

Re: phpDivinglog 2.2 development

Post by Inferno » Sun Mar 14, 2010 20:25

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 » Sun Mar 14, 2010 21:19

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: 252
Joined: Thu Apr 19, 2007 20:36
Location: The Netherlands
Contact:

Re: phpDivinglog 2.2 development

Post by Inferno » Sun Mar 14, 2010 21:30

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 » Sun Mar 14, 2010 23:19

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