General Error

[mr fun]

Your Portal Version: 1.0.2
Your phpBB Type: Standard phpBB3
MODs installed: No
Your knowledge: Basic Knowledge
Boardlink: http://www.thebloodyfist.com/forum/

PHP Version: Not sure - shared hosting server
MySQL Version: Not sure - shared hosting server

What have you done before the problem was there?
Forums are up everything seem good to go. Followed directions. Came up with errors.

What have you already tryed to solve the problem?
Yes, I ahve done severl hours worth of searches on the internet for the error messages and I have completely reinstalled the portal.

Description and Message

General Error
SQL ERROR [ mssql ]

Invalid column name 'phpbb3x1_portal_config'.
Invalid column name '%.*ls'. [207]

SQL

if exists (select * from sysobjects where name = phpbb3x1_portal_config) drop table phpbb3x1_portal_config

BACKTRACE

FILE: includes/db/mssql.php
LINE: 137
CALL: dbal->sql_error()

FILE: install_portal/install.php
LINE: 268
CALL: dbal_mssql->sql_query()

That is the error message. After I copy and edit all required files I surf to:
http://www.thebloodyfist.com/forum/inst ... nstall.php
I get:

Portal Install/Update Utility
Welcome to the Portal Install/Update Utility, hereby known as PInUp

Please click Install to start the install utility.

I click on install then it takes me to a page with a yes or no bullett. I click on Yes, then I click Submit.

That is when I get the error that you see at the top of this post.

[Kevin]

Do you have or had another portal installed?

[mr fun]

No. This is a fresh install.

Thanks for the quick responce.

Edit: If I could get some idea of what they mean I might be able to troubleshoot further. If explained in a newbie format I might figure it out?
Edit2: I found that the first error points to:

Code: Select all

if (($this->query_result = @mssql_query($query, $this->db_connect_id)) === false)

[mr fun]

To clairify my portal is still not working.

[Kevin]

You might have a try to open the install.php and search for:

Code: Select all

                // Drop thes tables if existing
                switch( $db->sql_layer )
                {
                    case 'mysql4':
                    case 'mysqli':
                    case 'oracle':
                    case 'firebird':
                    case 'sqlite':
                    case 'mysql':
                        $sql = 'DROP TABLE IF EXISTS ' . $table_prefix . 'portal_config';
                        $result = $db->sql_query($sql);
                        $db->sql_freeresult($result);
                    break;
                    case '':
                        $sql = 'SELECT version() as version';
                        $result = $db->sql_query($sql);
                        $data = $db->sql_fetchrow($result);
                        if( version_compare($data['version'], '8.1.11', '>') === TRUE )
                        {
                            $sql = 'DROP TABLE IF EXISTS ' . $table_prefix . 'portal_config';
                            $result = $db->sql_query($sql);
                            $db->sql_freeresult($result);
                        } else {
                            $sql = 'DROP TABLE ' . $table_prefix . 'portal_config';
                            $result = @$db->sql_query($sql);
                            $db->sql_freeresult($result);
                        }
                    break;
                    case 'mssql':
                        $sql = 'if exists (select * from sysobjects where name = ' . $table_prefix . 'portal_config)
                        drop table ' . $table_prefix . 'portal_config';
                        $result = $db->sql_query($sql);
                        $db->sql_freeresult($result);
                    break;
                } 

Beginning at line 237. Delete this code and try it again.

Sorry for the late response, we're quite busy at the moment and nobody has a mssql testing environment.

[mr fun]

I had a SQL buddy get it going for me.
My problem now is that when people surf to "www.thebloodyfist.com" it pulls up the index.php and not the portal.php because NT will not reconise the ".htaccess" file. Any ideas?
This is a shared hosting FYI.

[Kevin]

First of all:
Would you mind to tell us what your "SQL buddy" has done? We would like to know if this is a bug or what was going on.

Regarding the unusable .htaccess on IIS:
There is an configuration option in the IIS to set which page should be loaded as the index page. If you don't have the possibility to set it yourself, ask your webhoster.
It's just a few clicks for him.
I don't know about another solution for IIS.

[mr fun]

I guess he edited the installer and removed calls to the mySQL and set them to use MSSQL?


This is what my host said... I think I will be switching hosts here soon:

I escalated a ticket on your behalf to see if portal.php
could be made the first loaded file on the server.
Unfortunately this does not seem like a possibility. The
ticket was escalated to and reviewed by our technical
manager and unfortunately we cannot conceive a way for this
to be done on an NT windows platform. I understand this
will cause problems for you since your board is installed to
your index.php but there is nothing we can do to fix this.
If you have further questions please feel free to contact
Aplus.net support available 24/7

Jocef Knapp
Aplus.Net Customer Care
1-(888) 301-2516

[Kevin]

I guess he edited the installer and removed calls to the mySQL and set them to use MSSQL?

I don't think so, that wouldn't work. I guess he has maybe done, what i have suggested.
If you like to do me a favor, test it on a testing subdomain or wherever and get back here with the results. We have a lack of user testing with mssql and i would like to sort out what has happend.

This is what my host said... I think I will be switching hosts here soon:

Hm, it's IIS7 your host is running.
I had W2K Server with IIS6 running a while ago, no problem to switch it to portal.php, that's for sure - as i said: just a few clicks. Maybe you should sent them this link: http://blogs.iis.net/bills/archive/2008 ... onfig.aspx
But as a hint: it's good to have a hoster who runs apache and MySQL, as this is a quasi-standard for PHP scripts.
And many scripts or mods don't (or barely) support mssql.
So if you don't want to run other scripts than PHP and Perl it's a good idea to change your host.

[joe21]

I too had this problem when trying install the portal on my development forum. Running MSSQL

I followed the instructions by Kevin about removing the lines from 237 and this solved the issue. I was then presented with an installation completed Now to have a play!

Thank you for your help!

Joe
www.coltuk.org

[Kevin]

Thank you for the response, Joe!
Good to know that it works that way.