Error running setup.php

ashgrove

Error message is:

Warning: main(classes.php) [function.main]: failed to open stream: No such file or directory in /mnt/w0713/d48/s25/b0288033/www/ashgrovevisualarts.com/zenphoto/zen/admin-functions.php on line 3

Fatal error: main() [function.require]: Failed opening required 'classes.php' (include_path='.:/usr/local/nf/php5/lib/php') in /mnt/w0713/d48/s25/b0288033/www/ashgrovevisualarts.com/zenphoto/zen/admin-functions.php on line 3

Lee Eschen

trisweb

Well, like it says, it can't find `classes.php`! :-)

That's very weird, and it seems like an odd PHP configuration is to blame. You may have to (unfortunately) add something to the include path for every "require" statement:

`require_once("classes.php");` becomes `require_once(dirname(__FILE__) . "/classes.php");`

Note the new slash as well.

ashgrove

Thanks, trisweb. Apparently some files didn't get transferred when I FTP'd ZP up to the server. Now I get past the above error, but it stops while trying to create tables with:

`zenphoto setup<<br />
Creating tables...<<br />
MySQL Query ( CREATE TABLE IF NOT EXISTS `albums` ( `id` int(11) NOT NULL auto_increment, `folder` varchar(255) NOT NULL default '', <<br />
`title` varchar(255) NOT NULL default '', `desc` text, `date` datetime default NULL, `place` varchar(255) default NULL, `show` int(1) NOT NULL default '1', `thumb` varchar(255) default NULL, `sort_type` varchar(20) default NULL, `sort_order` int(11) default NULL, PRIMARY KEY (`id`), KEY `folder` (`folder`) ); ) Failed. Error: CREATE command denied to user 'u70337253'@'cgihost' for table 'albums'`

Is it perhaps because my username doesn't have create permissions? I have tried an admin rated user with no difference. Could it have to do with permissions set at the server?

This could be so much easier if the wiki was up and running.

Lee

trisweb

Wouldn't be much easier with the Wiki up -- it doesn't have specific advice like this.

It sounds like a user permissions problem with the MySQL server. Check the perms in the database (the one you named in the config) and for the user, and make sure they're all matching. If you have another app working, take a look at what config works for it.

If you need, I can send you the raw SQL to run manually, if all else fails.

ashgrove

trisweb wrote:
If you need, I can send you the raw SQL to run manually, if all else fails.

It's beginning to look like I may need to do just that. I can't get setup.php to run. I can get phpMyAdmin 2.4.0 running on mySQL from the webhost control panel, but haven't yet figured how to use the program to change permissions. It does show no tables yet created in the database. I can figure that the table name needs to be "albums" from the error message, but can guess at little else.

Below is an approximation of the screen I am faced with in phpMyAdmin:
~~~~~~~~~~~~~~~~~~~
Database d60310081 running on MySQL Server Farm 2
Structure SQL Export Search

No tables found in database.

*
Create new table on database d60310081 :
Name :
Fields :
~~~~~~~~~~~~~~~~~~~~~~~~~~

Thanks again and again!

Lee

ashgrove

Hallelujah! It's working! I don't know why, but it looks like Filezilla is sometimes not actually overloading the old file (zp-config.php) on the server after I've made corrections to it. I had assumed it was, but when I actually loaded the editor direct from the server, the file was actually the old version. Once I fixed the file, it started working correctly. You can see my first album at:

www.ashgrovevisualarts.com/zenphoto

Thanks for all your help. After doing 3 days of battle with my webhost's "PicturePro", I really appreciate ZenPhoto's much cleaner UI and simpler admin functions.

The PicturePro version is at:

www.ashgrovevisualarts.com/nfpicturepro

I have only just begun to setup my gallery. Neither of the above should be considered complete. My final choice of which to use will depend on many things, but right now, ZenPhoto is way out front. Simple is sweet!

Lee