Huge problems

[yazankmanasrah]

I'm having major problems trying to install Serendipity on a Windows IIS 6.0 host.
I don't really know where to begin finding the root cause of the problem, so if anyone has any idea's I'd be most appreciative.
Here are images describing my problem exactly:
My phpinfo() output
Serendipity install screen

Thanks.

[garvinhicking]

Hi!

Your problem is that your Windows IIS host does not seem to have PHP properly enabled. You seem to be missing most of the modules (session etc.).

You might want to talk to your IIS administrator and try to install PHP as a CGI environment. Sadly this is a bit outside of the scope of the Serendipity application so you might need to ask for proper IIS+PHP setup on a dedicated forum? I would love to help, but I personally only use Apache and have no experience with IIS.

Best regards,
Garvin

[yazankmanasrah]

Alright, I've gotten the installation to detect the settings by replacing:
ini_get(...);
with
get_cfg_var(...);

and extension_loaded(...) with the following:
$loaded_ext = get_loaded_extensions();

and then writing the following in the if conditions:
if ( in_array('extension_name',$loaded_ext) )

BUT now i'm having a problem where Serendipity won't create the database tables, so I'm wondering if I can just manually import the sql scripts.

[garvinhicking]

Hi!

About creating the DB tables - do you get an error upon installation for that? Are the DB options correctly entered?

You cannot just import the db.sql file because it contains tstrings that are replaced for proper expansion (like {UTF_8}...)

Regards,
Garvin

[yazankmanasrah]

This is some of the output I get:
Creating default database setup... Done
Creating primary author 'John Doe'... Done
Setting default template...

INSERT INTO serendipity_config (name,value,authorid) values ('template', 'carl_contest', '0')

/ Table 'yazankmanasrah.serendipity_config' doesn't exist Done
Installing default plugins... Done

For some reason it's not importing the schema at all, there are no tables in the database after the installation is run and yet it tells me that the installation completed successfully.
I'm going to dig around in the source files and see if it uses any functions that are disabled by my webhost.

Edit: quick question, does Serendipity make use of mysql_pconnect() ?
Thanks for your help

[garvinhicking]

Hi!

Are you using MySQL? Which version of MySQL? Does the user account you are using to connect to MySQL have "CREATE" privileges?

Best regards,
Garvin

[yazankmanasrah]

Yes I am using MySQL, version 3.23.49 , and yes my user account has full priviledges.

[garvinhicking]

Hi!

Since you seem to be well with PHP code, you might want to check the include/db/mysql.inc.php file. Check what the SQL queries are that are emitted by the serendipity_db_schema_import() function (echo the queries). Then you could see why those tables are not created?

Best regards,
Garvin

[yazankmanasrah]

I figured out what the problem was, and it was staring me in the face the whole time. The function fopen is disabled by my webhost, and that's why Serendipity can't install the db correctly, because it can't even load the .sql files.

I've emailed my webhost and unfortunately they won't enable these functions, so i'm SOL.

Thanks for all your help, it's nice to see the developers actively supporting their projects, and I hope one day I get to use Serendipity because of this dedication on your part.

Thanks again.

[garvinhicking]

Hi!

WHAT, disabled fopen()? What kind of freakin' provider is that? Virtually every larger PHP software I know depends on that function.

You should definitely search yourself a real web hoster, I'm really sorry for you.

(At least all blog applications I know depend on fopen!)

Best regards,
Garvin

[yazankmanasrah]

Well, my webhost is GoDaddy.com =/

[garvinhicking]

Hi!

Oh, I know several people on Godaddy.com where fopen is not disabled and where s9y works without a problem! Which kind of package did you buy there? Maybe low-cost packages don't really support PHP for them?

Regards,
Garvin