Welcome to Geeklog Wednesday, August 21 2019 @ 08:13 pm EDT

Geeklog Forums

1.4.1 Install Problems with MSSQL


Status: offline

porpoise

Forum User
Newbie
Registered: 27/09/06
Posts: 1
We're trying to install Geeklog as blog solution on our corporate Intranet. We use primarily Windows 2003 Servers/MSSQL so I was pleased to see that your newest version supported MSSQL. Unfortunately, we're running into some problems during/after installation.

I was able to get past the 2nd page of the install script, however after we hit the button to begin the db table creation, the "success" page does not appear. It creates the tables in the db (we verify this after), but just hangs on the blank page. Then, when we access our public_html/index.php page (I didn't move the folder yet), we get the generic "unfortunately an error has occurred rendering this page. please try again later" message.

We are, however, able to see several other pages. Just for laughs, I tried to view other .php pages in the public_html dir. I pulled up 404.php, and it rendered! I can click on the following links without error: contribute, adv search, calendar, links, polls, general news, new user, and password. I cannot render these pages: stats.php & directory.php.

I tried setting the "rootdebug" to true, but we still get the default error msg.

Any thoughts on what might be causing this problem? We're completely stumped. Is there something askew in the config file? I'm assuming if the tables in the db have been created then it might be something else. Please help!

Regards,

porpoise

___________________________

Ok folks. This is an update...I realized I had changed the location of my 'admin' folder. I replaced it to its normal location, reset the path, and now I'm getting the following error message when I try to view public_html/index.php:

An error has occurred:
2 - mktime() expects parameter 6 to be long, string given @ D:\Inetpub\Blog\public_html\lib-common.php line 5476

array(6) {
["date"]=>
string(3) "Sep"
["time"]=>
string(2) "27"
["atok"]=>
bool(false)
["atoks"]=>
array(1) {
[0]=>
string(3) "Sep"
}
["btok"]=>
bool(false)
["btoks"]=>
array(1) {
[0]=>
string(2) "27"
}
}

Any thoughts on this? At least we're getting a real error message now, and not the default.

Status: offline

mevans

Forum User
Full Member
Registered: 08/02/04
Posts: 393
Location:Texas
porpoise,

I ran into this same problem when testing GL 1.4.1B1 as well. I believe it has to do with the PHP version you are running. Under PHP 5.1.x it happens, lower versions of PHP seem to be fine.

To fix is pretty simple, edit the lib-common.php file, on line 5475 put an @ in front of the mktime call so it looks like this:

PHP Formatted Code

@mktime

 


That will surpress the error.

I wasn't able to re-create this one on my other test box so I wondered if it was just me. Looks like a valid issue so I'll put a bug report into the bug tracker about it this evening.

Good luck,
Mark

Status: offline

randy

Forum User
Newbie
Registered: 18/01/03
Posts: 11
Glad to see its not a MSSQL problem.
But do note that there are fixes being made to the known MSSQL specific bugs which have been reported.

All times are EDT. The time is now 08:13 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content