I have installed the latest phpmydiving solution and I wanted to upadte the website with my latest dives.
Afte some errors I just created a new (empty) database and tried to import the sql file I got from divinglog.
Unfortunatley I am getting the following errors:
Code: Select all
Static analysis:
2 errors were found during analysis.
Unexpected beginning of statement. (near "EATE" at position 0)
Unrecognized statement type. (near "TABLE" at position 5)
SQL query:
EATE TABLE Brevets (ID int(11) auto_increment, Brevet varchar(255) default '', Org varchar(255) default '', CertDate date default NULL, Number varchar(255) default '', Instructor varchar(255) default '', InstructorNo varchar(255) default '', Scan1Path varchar(255) default '', Scan1 blob default NULL, Scan2Path varchar(255) default '', Scan2 blob default NULL, UUID char(36) default '', Updated date default NULL, SortOrd int(11) default NULL, PRIMARY KEY (ID)) ENGINE=MyISAM DEFAULT CHARSET=UTF8
MySQL said: Documentation
#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 'EATE TABLE Brevets (ID int(11) auto_increment, Brevet varchar(255) default '', O' at line 1
Code: Select all
CREATE TABLE Brevets (ID int(11) auto_increment, Brevet varchar(255) default '', Org varchar(255) default '', CertDate date default NULL, Number varchar(255) default '', Instructor varchar(255) default '', InstructorNo varchar(255) default '', Scan1Path varchar(255) default '', Scan1 blob default NULL, Scan2Path varchar(255) default '', Scan2 blob default NULL, UUID char(36) default '', Updated date default NULL, SortOrd int(11) default NULL, PRIMARY KEY (ID)) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
CREATE TABLE Buddy (ID int(11) auto_increment, FirstName varchar(255) default '', LastName varchar(255) default '', Street varchar(255) default '', Address2 varchar(255) default '', Zip varchar(50) default '', City varchar(255) default '', State varchar(255) default '', Country varchar(255) default '', Phone varchar(255) default '', Mobile varchar(255) default '', Fax varchar(255) default '', Email varchar(255) default '', Birthdate date default NULL, PhotoPath varchar(255) default '', Photo blob default NULL, Comments text, UUID char(36) default '', Updated date default NULL, LinkID int(11) default NULL, URL varchar(255) default '', PRIMARY KEY (ID)) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
Br,
Johannes