phpDivinglog : PHP - Warning

Michaelangelo · 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?

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 · Post by **Michaelangelo** » Thu Aug 09, 2007 18:53

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

thanx!