phpDivinglog 2.2 development
Re: phpDivinglog 2.2 development
Hi Rob,
Can you have a look at your WebSVN?
The "archiv download" function produces corrupted tgz-archives.
regards
Uli
Can you have a look at your WebSVN?
The "archiv download" function produces corrupted tgz-archives.
regards
Uli
Re: phpDivinglog 2.2 development
For the time being, the latest export can be found here:TheULi wrote:Hi Rob,
Can you have a look at your WebSVN?
The "archiv download" function produces corrupted tgz-archives.
regards
Uli
http://rob.lensen.nu/devdoc/
it is beta4
Re: phpDivinglog 2.2 development
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?
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?
Re: phpDivinglog 2.2 development
Do you know it you imported your divinglog mysql data?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 have phpmyadmin? So you can check out if the table is in your Database
Re: phpDivinglog 2.2 development
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.
Re: phpDivinglog 2.2 development
Can you make a screenshot of phpmyadmin?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.
Do you have an url to the site?
Re: phpDivinglog 2.2 development
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
http://www.diving.stodge.org.uk/phpadmin.jpg
go up a level to see where the database should be
Cheers
Re: phpDivinglog 2.2 development
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.
Sven
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.
Sven
Re: phpDivinglog 2.2 development
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
Re: phpDivinglog 2.2 development
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.
Re: phpDivinglog 2.2 development
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/
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/
Re: phpDivinglog 2.2 development
Did you read the comments in the config.inc.php file?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/
Code: Select all
/**
* change this to your website url
*/
$_config['web_root'] = 'http://rob.lensen.nu/divelog';
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';
Re: phpDivinglog 2.2 development
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.
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.
Re: phpDivinglog 2.2 development
My mistake, the absolute path should be empty in your case.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.
Will update the comments to make it more clear
Re: phpDivinglog 2.2 development
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.
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.