Diving Log Online

3rd party extensions (phpDivingLog, dive computer downloader,...)
vasco_nl
Posts: 37
Joined: Tue Jul 24, 2007 22:25

NO DEVELOP OR SUPPORT ANYMORE!

Post by vasco_nl » Thu Sep 03, 2009 09:23

NO DEVELOP OR SUPPORT ANYMORE!
Last edited by vasco_nl on Mon Aug 02, 2010 13:28, edited 3 times in total.

absalon
Posts: 40
Joined: Sat Jan 28, 2006 08:40
Location: Vojens / Denmark
Contact:

Re: Diving Log Online

Post by absalon » Thu Sep 03, 2009 10:06

Is it possible to show pictures in Diving Log Online?

Henrik

vasco_nl
Posts: 37
Joined: Tue Jul 24, 2007 22:25

NO DEVELOP OR SUPPORT ANYMORE!

Post by vasco_nl » Thu Sep 03, 2009 11:32

NO DEVELOP OR SUPPORT ANYMORE!
Last edited by vasco_nl on Mon Aug 02, 2010 13:28, edited 4 times in total.

vasco_nl
Posts: 37
Joined: Tue Jul 24, 2007 22:25

NO DEVELOP OR SUPPORT ANYMORE!

Post by vasco_nl » Fri Sep 04, 2009 09:09

NO DEVELOP OR SUPPORT ANYMORE!
Last edited by vasco_nl on Mon Aug 02, 2010 13:28, edited 3 times in total.

vasco_nl
Posts: 37
Joined: Tue Jul 24, 2007 22:25

NO DEVELOP OR SUPPORT ANYMORE!

Post by vasco_nl » Mon Sep 07, 2009 12:17

NO DEVELOP OR SUPPORT ANYMORE!
Last edited by vasco_nl on Mon Aug 02, 2010 13:28, edited 1 time in total.

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

Re: Diving Log Online

Post by Inferno » Mon Sep 07, 2009 22:36

The interface of Diving Log online really looks cool.

But be warned to me it looks like none of the MySQL queries are escaped well. Take a look on this page http://unixwiz.net/techtips/sql-injection.html and special look at "Escape/Quotesafe the input"

See here why addslashes doesn't work: http://cow.neondragon.net/index.php/130 ... on-Attacks

This project is made under GNU GPL which is nice, but next to being Open Source it would be nice if the code has some comments...

To me the outside looks nice, but the inside really could have some improvements.

vasco_nl
Posts: 37
Joined: Tue Jul 24, 2007 22:25

NO DEVELOP OR SUPPORT ANYMORE!

Post by vasco_nl » Tue Sep 08, 2009 07:14

NO DEVELOP OR SUPPORT ANYMORE!
Last edited by vasco_nl on Mon Aug 02, 2010 13:28, edited 1 time in total.

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

Re: Diving Log Online

Post by Inferno » Tue Sep 08, 2009 07:35

vasco_nl wrote: I started this project to learn about PHP and MySQL so your comments are welcome to me. I read some things about SQL-injection and found at that time the use of addslashes should do the job. I'm going to read the pages you provide here and look more on the internet to see what I need to do against SQL-injections.
You can easily solve the problem by using an interface library like Pear MDB2 or AdoDB then those problem are solved for you.

vasco_nl
Posts: 37
Joined: Tue Jul 24, 2007 22:25

NO DEVELOP OR SUPPORT ANYMORE!

Post by vasco_nl » Thu Sep 10, 2009 14:59

NO DEVELOP OR SUPPORT ANYMORE!
Last edited by vasco_nl on Mon Aug 02, 2010 13:29, edited 1 time in total.

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

Re: Diving Log Online

Post by ianr » Thu Sep 17, 2009 11:51

Hi,

I'm trying to get this working but am struggling with MySQL. I have the diving log online side of things working but get the message 'A database is not found on this server, export databases from Diving Log first' I have tried configuring the diving log 4.0 app to connect to my database but apparently my host (1and1) don't allow direct connections to the database so this is a non starter. I can see the admin table in phpmyadmin but have no idea how to import the dump of the sql file from the diving log 4.0 app into my MySQL database. If I also read other posts in this thread correctly then the ability to do this is academic since you have to upload this file directly.

Is it worth my persisting and trying to fumble my through the MySQL admin or am I flogging a dead horse?

Thanks for your help.

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

Re: Diving Log Online

Post by divinglog » Thu Sep 17, 2009 20:10

Hi

If your provider doesn't allow external access to the MySQL database you can export the data from Diving Log to a MySQL dump file and import this file using the phpMyAdmin program which should be available from your hoster (you can find there an easy way to select the dump file and execute it).

Kind regards,
Sven

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

Re: Diving Log Online

Post by ianr » Thu Sep 17, 2009 20:46

Hi,

I've tried to import the dump via myphpadmin but get lots of errors, assuming I;m doing it correctly, so the data still doesn't show up. I guess I need to read up on MySQL and myphpadmin a little more as it's very confusing...

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

Re: Diving Log Online

Post by divinglog » Thu Sep 17, 2009 21:11

There is also a chance that the MySQL dump file is not correctly exported from Diving Log. Can you copy/paste the errors from phpMyAdmin here or email them to me?

vasco_nl
Posts: 37
Joined: Tue Jul 24, 2007 22:25

NO DEVELOP OR SUPPORT ANYMORE!

Post by vasco_nl » Fri Sep 18, 2009 06:39

NO DEVELOP OR SUPPORT ANYMORE!
Last edited by vasco_nl on Mon Aug 02, 2010 13:29, edited 1 time in total.

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

Re: Diving Log Online

Post by ianr » Sun Sep 20, 2009 03:04

Hi Guys,

Thanks for the assistance.

errors are as follows:

SQL query:

#
# Data for table 'Equipment'
#
INSERT INTO Equipment
VALUES ( 1, 'Compass', '', '', NULL , NULL , '', '', NULL , , '', '', NULL , '771af827-72ea-4f3b-9092-c95ffb318fe8', NULL )

It appears to have created the extra tables in the database although I have little knowledge of MySQL.

Any ideas?

Thanks

Locked