phpDivinglog : PHP - Warning

3rd party extensions (phpDivingLog, dive computer downloader,...)
Post Reply
Michaelangelo
Posts: 4
Joined: Thu Aug 09, 2007 18:00

phpDivinglog : PHP - Warning

Post by Michaelangelo » Thu Aug 09, 2007 18:06

I installed version PhPDivinglog 1.9 using the readme-file. After installation I made an SQL-dump and imported it into my database. This allready gave the following error in PHPmyadmin:

SQL-query:

#
# Data for table 'Personal'
#
INSERT INTO Personal
VALUES ( 1, '', '', '', '', '', '', '', '', '', '', '', NULL , NULL , , '', '', '', '' )

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' '', '', '', '')' at line 5


I ignored this errormessage, but when I look at the site, it gives the following warning after selecting a dive in the overview:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /srv/divelog/includes/misc.inc.php on line 139

What do I do wrong?

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

Post by divinglog » Thu Aug 09, 2007 18:42

You can either try to enter some data in the User Information dialog of Diving Log or unchecking the table "Personal" in the MySQL Dump export dialog. I'll check the Dump Export when no data is entered in the dialog, maybe there is a bug.

Michaelangelo
Posts: 4
Joined: Thu Aug 09, 2007 18:00

Post by Michaelangelo » Thu Aug 09, 2007 18:53

That did the trick! No errors, was it really that easy?

thanx!

Post Reply