Error while trying to install.php

jpasint · September 5th, 2004, 10:48 AM

I can run http://photos.evergladesgator.com/install.php but as soon as I click on the link to begin the installation process IE closes. I checked the log on my hosting service and this is the error that seems to be being generated.

1266 HTTP/1.1 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322) - -

I have setup and tested this on my own server at home but after publishing the site and trying to get it run on my hosting service, things are not going so well. What should be in the path statement in the config-inc.php file? On my own server it is c:\inetpub\wwwroot\photos. But how would I know what the install path would be on my hosting service server? I saw something in the phpinfo.php on their site that I thought was what I should put there. This is what I saw. Should I use this in the config-inc.php file?

H:\hshome\jpasint\photos.evergladesgator.com\phpinfo.php

Thank you in advance.

Joe

Chuck S · September 5th, 2004, 10:59 AM

Yes your path is H:\hshome\jpasint\photos.evergladesgator.com

I would suspect a browser issue here. I can access your install and go to the next step just fine.

Try another browser if it continues

jpasint · September 5th, 2004, 12:44 PM

Thanks, I'll try that.

jpasint · September 5th, 2004, 12:50 PM

Man, happened on my son's PC also. Could it be a firewall/NAT issue? We are both patched to the latest IE so maybe a security setting in IE?

Thanks again.

Joe

jpasint · September 5th, 2004, 12:59 PM

I tried putting one PC in the DMZ in the firewall and the browser just closes when I try to click to the next step. Any other ideas?

Thanks.

Joe

jpasint · September 5th, 2004, 01:02 PM

Never mind. Turned out to be either PestPatrol or Adaware's Adwatch. At least I made it to the next step now. Let you know if I have any other trouble. Sorry for the false alarm and waisting your time.

Joe

jpasint · September 10th, 2004, 11:12 PM

One step closer as they say. I now get the following error after going through all of the install.php routine.

My Photo Gallery Message
MySQL error reported!

Script: index

Query: SELECT userid,username,email,password,usergroupid,timezoneoffset FROM user WHERE username=''

Result: Table 'jpasint_pho.user' doesn't exist

Database handle: Resource id #6

Thanks.

Joe

fatma · September 11th, 2004, 06:55 AM

you might find the solution here:

Problem With User DB After Upgrading...

jpasint · September 11th, 2004, 08:21 AM

I do not have that pp_ set on line 83. I did notice that the SQL database I am pointing to for the forum has no tables. Should I use the same database for both when I go through the install.php routine?

Thank you.

Joe

jpasint · September 11th, 2004, 08:52 AM

After I click on "Complete PhotoPost Installation" in pauses for several seconds and the displays a blank white screen. Is this normal? Also, there is in fact no user named jpasint_pho. Where is it getting that user name from and why is it trying to use it?

Thanks.

Joe

jpasint · September 11th, 2004, 10:33 AM

Any ideas?

monocle · September 11th, 2004, 11:08 AM

If you have database access which I think you do, why not just run the photopost.sql file as a query to create all the tables manually?

jpasint · September 11th, 2004, 02:33 PM

That would populate the database with the tables I guess is what you are saying but my propblem seems be something else in addition to this. I get errors so I guess it is not completing the install. Is anybody from PP monitoring the forum?
Thanks.

monocle · September 11th, 2004, 02:41 PM

Well I can access your Photopost install and all it's telling me is that there is nothing in the database. Why not populate the database and see what you get? As far as I can see Photopost IS installed. It's just that you need to point to the right database with the correct tables in it and set the correct paths in the config file because as I am sure you are aware at present it's pointing to "www.domain.com"

jpasint · September 11th, 2004, 05:56 PM

You don’t get this error below?

MySQL error reported!

Script: index

Query: SELECT userid,username,email,password,usergroupid,timezoneoffset FROM user WHERE username=''

Result: Table 'jpasint_pho.user' doesn't exist

Database handle: Resource id #6

That’s all I get.

Are there any sample config files that you know of? I have some instructions but they contain very little info.

I think I fixed the "www.domain.com" problem.

Thanks again.

Joe

jpasint · September 11th, 2004, 07:22 PM

I tried to run the .sql script but received the error below.

Database jpasint_pho running on localhost:3306
Error

SQL-query :

CREATE TABLE {$pp_db_prefix}admlog(

id int( 10 ) NOT NULL AUTO_INCREMENT ,
adminuser varchar( 50 ) NOT NULL default '',
description varchar( 255 ) NOT NULL default '',
datestamp int( 20 ) NOT NULL default '0',
ip varchar( 35 ) NOT NULL default '',
PRIMARY KEY ( id )
) TYPE = MYISAM

MySQL said:

#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 '{$pp_db_prefix}admlog (id int(10) NOT NULL auto_increment,admin

monocle · September 11th, 2004, 08:10 PM

OK, I'm not sure exactly what you have done. But When I type this address

photos.evergladesgator.com

I get the photopost index page, which does give me the sql error. If you have your photopost index page here you must also have all the other Photopost pages. But when I ftp to your webspace I can only see a few other photopost files. What I can see is a directory called Photopost. But when I try to access this directory from my browser I get "File Not Found", which suggests to me that the file is not there.

I suggest you start from scratch.

Navigate to your root directory. www.evergladesgator.com

Create a directory in there called 'photopost'

Upload ALL the Photopost files to this directory.

Fill in the cofig-inc.php file with the correct paths. I have included a config file for you to look at in which I have filled in what I think are your settings, but they could easily be wrong so you need to double check them.

To be honest I would create a new database if you know how. Call your database 'photopost' and don't use a database prefix. This will make things a lot easier for you.

If you don't know how then I think this is your database name 'jpasint_pho'.

Then try the whole install process again.

jpasint · September 11th, 2004, 08:15 PM

I'll give it whirl. Appreciate the help and the patience.

Joe

monocle · September 11th, 2004, 08:19 PM

I can now access your install.php file, but it does seem to me that many of your settings are wrong. Where is your photopost install? Is it in a directory called photopost or a directory called photos in a sub domain called photos? Some of your paths point to a drive called H:\ This can't be correct as your photopostr install is on a host server not your own server...yes?

Plus are you sure the database host is 'mysql2.infinology.net' not 'localhost' as it usually is?

I'd go with the start from scratch option.

jpasint · September 11th, 2004, 08:21 PM

I have already created a "sub web" called "photos.evergladesgator.com"
Does that change where I should put the files?