BIG PROBLEM

[hamid]

INSERTING CORE EE DATA:

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

What to do?

It's Linux server running MySQL version:3.22.30

PLease help

[Pekka]

OK; you see in the beginning of the setup a list of available databases right?

Can you see next to one of them a yellow text which says: "(EE USES THIS DATABASE)"? If you see it there, check the databasename next to it: do you have user permissions to alter that database? You need all permissions to modify the database (ALTER, INSERT, DROP, DELETE, UPDATE) Ask you system admin if you have these rights as database user.

The DROP TABLE IF EXISTS `ee_camera`is the first DROP statement in installer - there can not be syntax errors in that statement as it does not rely on any predefined database structure.

[hamid]

I have the permissions.

http://www.bih.net/3dkingdom.org/php/gallery/setup.php

[Pekka]

Download and run this test script (place it next in same folder as setup.php). It uses all 7 MySQL commands in several ways to create, update, insert, alter, select, add and drop table ee_test

http://photography-on-the.net/ee/files/ee_test_db.zip

If you see any errors there let me know.

Your MySQL version is three years old, so updating it may help, too. I have here version 3.22.30 and on this server 3.23.36.

[hamid]

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


What to do?

[Pekka]

Now we're getting somewhere! :)

It seems your system (old MySQL or PHP) does not accept backquotes around table names. Open the setup.php in text editor and search all
`
characters and replace them with nothing (empty). Save and try again.

That should do it.

EE does not really need those backquotes, as EE does not use table or row names with spaces or special characters.

[hamid]

I did that. Still doesn't work. :( :'(

This gallery looks really nice, too bad I can't install it.

I will try again and in meantime I will look for a worthy replacement in case I can't install this.

[Pekka]

I see from http://www.bih.net/3dkingdom.org/php/gallery/setup.php that you removed also single quotes. They are essential, only backquotes are not needed.

Try this setup:

http://photography-on-the.net/ee/files/non_backquote_setup.zip

meantime I will look for a worthy replacement in case I can't install this.

Worthy? There is nothing like EE out there :)

PS. What www server do you use, what operating system and what is your PHP version?

[hamid]

http://www.bih.net/3dkingdom.org/php/gallery/setup.php :(

I'll look over the code (again)

[Pekka]

I uploaded another

http://photography-on-the.net/ee/files/non_backquote_setup.zip

Try that.

[hamid]

That one works :)

But http://www.bih.net/3dkingdom.org/php/gallery/index.php :(

[hamid]

It works. Thanx a lot!

One more question: am I allowed to change to code to make this gallery look like my PostNuke site (just a few includes)?

[Pekka]

You are allowed to modify EE as long as you keep the copyrights and EE logo there, and that you don't distribute modified versions.

[hamid]

Cool, thanx