Error on install

[jarmen]

Having some troubles with the install. I'm on a linux box and used wget to download the zip. Edited the connect.php with Pico. Upon going to setup.php , I get the following error:


You have an error in your SQL syntax near '`ee_camera` ' at line 2
IN QUERY
DROP TABLE IF EXISTS `ee_camera`

If I delete that line (figuring a new install, no need to drop), it comes up with the following error:

You have an error in your SQL syntax near '`ee_camera` ( `ee_camera_id` int(11) NOT NULL auto_increment, `ee_camera_dis' at line 2
IN QUERY
CREATE TABLE `ee_camera` ( `ee_camera_id` int(11) NOT NULL auto_increment, `ee_camera_displayname` varchar(255) NOT NULL default '', `ee_camera_manufacturer` varchar(255) NOT NULL default '', `ee_camera_model` varchar(255) NOT NULL default '', `ee_camera_year` year(4) NOT NULL default '0000', `ee_camera_type_id` int(11) NOT NULL default '0', `ee_camera_features` text NOT NULL, `ee_camera_description` text NOT NULL, `ee_camera_comments` text NOT NULL, `ee_camera_photo_url` text NOT NULL, `ee_camera_focal_multiplier` float NOT NULL default '0', PRIMARY KEY (`ee_camera_id`), KEY `ee_camera_type_id` (`ee_camera_type_id`) ) TYPE=MyISAM

Any ideas?

[HotDogOne]

Hmm, not sure about this one, sorry. I think this is one for Pekka to answer when he gets back.

[Pekka]

Hi,

I'm now at a netcafe in Vienna - I have a day off and was going to do some photography but it rains heavily and it seems shooting is not an option today, at least outdoors....

Anyways, about your problem:

The drop table ee_camera command is the first one in the installer, so it makes me think maybe you do not have a permission to drop or create tables on your MySQL? This is just a guess, as the installer has worked on all other machines and I have not had any other reports like yours.

One way to check your database setup is to install phpMyAdmin (as I always advertise, it's the most useful tool for MySQL debugging and maintenance).

[maarten]

I have the same problem.. just started installing today..
But I have always problems with SQL databases only a few work for me.
Is there a other why to install the tables??

Thanks

Maarten




You have an error in your SQL syntax near '`ee_camera` ' at line 2
IN QUERY
DROP TABLE IF EXISTS `ee_camera`

If I delete that line (figuring a new install, no need to drop), it comes up with the following error:

You have an error in your SQL syntax near '`ee_camera` ( `ee_camera_id` int(11) NOT NULL auto_increment, `ee_camera_dis' at line 2
IN QUERY
CREATE TABLE `ee_camera` ( `ee_camera_id` int(11) NOT NULL auto_increment, `ee_camera_displayname` varchar(255) NOT NULL default '', `ee_camera_manufacturer` varchar(255) NOT NULL default '', `ee_camera_model` varchar(255) NOT NULL default '', `ee_camera_year` year(4) NOT NULL default '0000', `ee_camera_type_id` int(11) NOT NULL default '0', `ee_camera_features` text NOT NULL, `ee_camera_description` text NOT NULL, `ee_camera_comments` text NOT NULL, `ee_camera_photo_url` text NOT NULL, `ee_camera_focal_multiplier` float NOT NULL default '0', PRIMARY KEY (`ee_camera_id`), KEY `ee_camera_type_id` (`ee_camera_type_id`) ) TYPE=MyISAM

[Pekka]

I can provide a phpMyAdmin dump if you like. But if you get an error with simple
DROP TABLE IF EXISTS `ee_camera`
command I'm not sure the database can accept any dumps either. It must be a user privilege problem in MySQL.

One workaround which you can try is to create the tables by hand, delete all DROP TABLE commands in setup and run it - it will fill the empty tables. This is just a hunch, maybe you have no privileges to DROP tables and that's why you've had problems with some databases.