Install Script Errors?

[sebuck]

Here is my current configuration:
vBulletin 3.5.2
MySQL 5.0.16
PHP 5.1.1
2000 Advanced Server with IIS
All of the PhotoPost files have full permissions.

I didn't have any problems install vBulletin. It is running fine. I'm now trying to install PhotoPost Pro 5.21.

1. The first problem I encountered was the I only had the php_mysqli.dll extension for php enable and this was causing install.php to fail at the mysql_connect call. So I then also enable php_mysql.dll (can I have both enabled?).

2. The second problem I encountered was when I was trying to setup PhotoPost to manage its own user info (instead of using vBulletin). I got the following error:
Failed MySQL Query: INSERT INTO pp_users (userid,usergroupid,username,password,email,joindate) VALUES(NULL,'5','Steve','912ec803b2ce49e4a541068d495ab570','asdf@asdf.com','') / Out of range value adjusted for column 'joindate' at row 1
I deduced that localtime() was failing and causing the joindate variable to not be set. I'm not sure why. So I just changed install.php and hardcoded a joindate. However, when completed, I get the message "You are not a valid administrator or moderator!".

3. The third problem I encountered is that the logon screen keeps linking everything to "http://www.domain.com/...". Its as if my domain name is not getting set. If I change install.php again by replacing "http://www.domain.com/" with my domain, it seems to work.

The only php errors I get are:
Warning: Invalid argument supplied for foreach() in C:\Website\photopost\install.php on line 1302
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in C:\Website\photopost\forums\vb2.php on line 341

And the only sql errors I get are:
Step 3: MySQL error reported: [INSERT INTO pp_categories (id,catname,description,catorder,thumbs,parent,children) VALUES (1,'Main','',2,'no',0,'2')]
Result: Field 'theme' doesn't have a default value
Database: photopost
Step 3: MySQL error reported: [INSERT INTO pp_categories (id,catname,description,catorder,thumbs,parent,children) VALUES (2,'A Category','Photos of a particular subject',1,'yes',1,'')]
Result: Field 'theme' doesn't have a default value
Database: photopost
Step 3: MySQL error reported: [INSERT INTO pp_categories (id,catname,description,catorder,thumbs,parent,children) VALUES (500,'Member Galleries','Individual user galleries - any photo category',1,'yes',0,'')]
Result: Field 'theme' doesn't have a default value
Database: photopost
Step 3: MySQL error reported: [INSERT INTO pp_settings VALUES (169,'GMT Offset', 'gmtoffset', 'If you are running VB and want the server to display the time as an offset of GMT (for example, to the timezone where your server is located), enter the offset here.', '0', 25, 1)]
Result: Data too long for column 'description' at row 1
Database: photopost
Step 3: MySQL error reported: [INSERT INTO pp_settings VALUES (208,'Orignial Image storage directory server path','origfull','Typically this path matches your DATA directory server path, unless you want to store your original images seperatly from your thumbnails/medium images.','/path/to/your/photopost/data',35,1)]
Result: Data too long for column 'description' at row 1
Database: photopost


I'm absolutely lost. I've restarted from scratch MANY times. Started with a completely new database. Tried installing Photopost alone. Nothing works. PLEASE, can somebody help me?

Thanks,
sebuck

[Chuck S]

Seeing alot of this lately people installing mysql 5

We are not compatible with mysql 5 to knowledge yet.

There is also a bug with php 5.1x with localtime();

Everywhere in our scripts where you see this

$mon = $mon+1;

You would need to add right below this

$year = $year+1900;