got pliggB9 working on PHP5.2.0 + mysql 5.0.2 on IIS5.1

[thehesiod]

*numerous* changes were required...mostly the warnings when uninitialized variables were being acecssed. I'm sure there's still more warnings to resolve.

Also, it seems the code is really half-written...it doesn't support setting the correct properties under certain circumstances. I would say this really isn't beta-level code, it's probably actually alpha.

Also, either the database creation script is screwy or the code is screwy for some tables. i.e. when you're in the process of creating a link the code tries to create an empty link without setting many of the columns in the link table...however almost all the columns are set to NOT NULL! so creation fails. I went the route by removing the NOT NULL requirement.

I'm sure someone will want this. It's the culmination of ~20hrs of work. Just let me know and I can stick it somewhere. Perhaps if more people are interested we can do a better job and get it back into the trunk.

- Alex

[newuser]

Now this is the kind of dev that Im talking about. BRAVO! I almost wish it would work with older version of PHP (does it?).

[Yankidank]

We've had a couple users in the past document the changes required for IIS, so you weren't alone.

[thehesiod]

Originally Posted by Yankidank

We've had a couple users in the past document the changes required for IIS, so you weren't alone.

actually there were *several* code-level changes beyond set-up.

Examples:

I had to manually re-enabled some commented out code in a template to enable hierarchal categories.

I fixed a bug in login.php to support an "all" topic that wasn't called "all"

I found I had to enable a module because code in a template wasn't checking to see if the private message module was installed or not.

[thehesiod]

Originally Posted by newuser

Now this is the kind of dev that Im talking about. BRAVO! I almost wish it would work with older version of PHP (does it?).

probably, wanna try?

[AshDigg]

Please send me a copy of the changes you've made, or just send the whole thing an I can compare it.

thanks!

[newuser]

Originally Posted by thehesiod

probably, wanna try?

Heck yeah. I'll install it on some of my test servers

[posterboy]

I'm getting some of the problems reported by thehesiod when running on Window XP, MySQL 5.0.27, PHP 5.2.0, Apache 2.2.

My problems appear to be related to running mysql in strict mode. I think it would be correct to have the codebase work in this mode and doesn't look like it would be a lot of work. Some users are going to encounter these problems and not bother to try to find workarounds.

My specific problems trying to set up the system and add stories and comments:

install/installtables.php
the links tables has the fields link_field10 - link_field15 which are type text and have a default value. According to the MySQL documentation this is not permitted.
creation of the 'god' user fails as '' is being inserted into the last_reset_request field even though it is a not null timestamp.

libs/link.php
the insert statement in store_basic doesn't give values to the text fields that don't have defaults so the query fails. The affected fields are link_content, link_summary, link_title, link_field10 - link_field15
for the same insert statement the link_published_date is given a value of 0. This fails to save as the from_unixtime converts this to '1970-01-01 00:00:00' which is not allowed in a timestamp column according to the MySQL documentation.

References:
http://dev.mysql.com/doc/refman/4.1/en/blob.html
http://dev.mysql.com/doc/refman/5.0/...-overview.html

[ayyash]

that message is dates 12-25-2006, i have the 9.6 but still i get the same database, can u please tell me if fixing those columns would make the problem go away? (i cant submit any links) and what is the solution for the from_unixtime(0)

thanks a lot