Need help setting up EE

[jallinder]

I experienced a problem similar to hamid's. I downloaded the altered setup.php file (non-backquote) and I got as far as:
----------------------------------
INSERTING CORE EE DATA:

.... DROP TABLE IF EXISTS ee_camera .... [DONE]
.... 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 .... [DONE]

Warning: MySQL: Unable to save result set in /usr/local/www/vhosts/wildlifephoto.net/htdocs/gallery/setup.php on line 254


ERROR IN QUERY:
INSERT INTO ee_camera VALUES (1, 'Unknown', 'Unknown', '', '2000', 1, '', '', '', '', '1')
------------------------------------------

I also ran the ee_test_db, which produced the following:

-------------------------------
MySQL version:3.22.32

DATABASES AVAILABLE:

Owners
gallery (EE USES THIS DATABASE)
mysql
running.....

drop_1 OK
create_1 OK
ERROR IN drop_2: You have an error in your SQL syntax near '`ee_test` ' at line 3
----------------------------------

Any help would be greatly appreciated. Thank you.

[Pekka]

jallinder wrote:
I experienced a problem similar to hamid's. I downloaded the altered setup.php file (non-backquote) and I got as far as:
----------------------------------
INSERTING CORE EE DATA:

.... DROP TABLE IF EXISTS ee_camera .... [DONE]
.... 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 .... [DONE]

Warning: MySQL: Unable to save result set in /usr/local/www/vhosts/wildlifephoto.net/htdocs/gallery/setup.php on line 254


ERROR IN QUERY:
INSERT INTO ee_camera VALUES (1, 'Unknown', 'Unknown', '', '2000', 1, '', '', '', '', '1')
------------------------------------------



line 245 belongs a "success" message of a function which is called first time at line 1931! I think the error message PHP gives is not related to the real problem: you might have problem writing to the database. The reason could be

- privileges error
- disk full (not enough quota set for MySQL)
- not enough RAM


I also ran the ee_test_db, which produced the following:

-------------------------------
MySQL version:3.22.32

DATABASES AVAILABLE:

Owners
gallery (EE USES THIS DATABASE)
mysql
running.....

drop_1 OK
create_1 OK
ERROR IN drop_2: You have an error in your SQL syntax near '`ee_test` ' at line 3
----------------------------------



This error is due backslashes. Reason for your system not accepting MySQL backquotes in unknown. The notation is legal:

See http://www.mysql.com/doc/L/e/Legal_names.html
telling "Note that if the identifier is a restricted word or contains special characters you must always quote it with ` when you use it."

What is your MySQL version?

[jallinder]

--------------
I think the error message PHP gives is not related to the real problem: you might have problem writing to the database. The reason could be

- privileges error
- disk full (not enough quota set for MySQL)
- not enough RAM"
----------------

If this is the problem, what can I do to resolve it? I do have root access on my server. How could I set the privileges or quota for MySQL?


--------------
What is your MySQL version?
--------------

3.22.32

I certainly would like to figure out what's wrong so I could give EE a try. It really looks like an ideal solution for stock photographers. Thank you for your hard work and willingness to share.

[Pekka]

I think the action you should take is contact you server administrator (helpdesk/admin/support) and ask them to upgrade MySQL to version 3.23.32.

I checked the version history between MySQL 3.22.32 and 3.23.32 and there are so many new features in 3.23 - the main one being MyISAM table type (which does not exist before 2.32 at all and is needed by EE) - that I'm sure upgrading MySQL will get things running smoothly.

For version history see http://www.mysql.com/documentation/mysql/bychapter/manual_News.html#News-3.22.32

Also, check the PHP version is at least 4.06.

[jallinder]

I got fed up with that particular host. They wouldn't help me upgrade to the new version of MySQL. It seems that things are handled or installed a little differently on virtual servers. Oh well. Since then, I've placed moved one of my domains to a new server that does use the most current versions of PHP & MySQL and everything installed without a hitch.

I am eager to start working on the new domain. http://www.stock-images.net. and setting up the look & feel for the site and incorporating it into EE. Thanks for your help and a wonderful product.