General Error

Current Version: 1.0.6
Released: 09.01.10
Forum rules
Before creating a new support thread, please take a look in the board3 Portal FAQ and use the search!
Many questions have already been answered.
Locked

Topic author
mr fun
Active Member
Posts: 7
Joined: 15. October 2008 09:01

General Error

Post by 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.
Last edited by mr fun on 15. October 2008 17:38, edited 1 time in total.
User avatar

Kevin
Site Admin
Posts: 2989
Joined: 7. January 2006 20:11
phpBB.de User: Saint
phpBB.com User: Saint_hh
Location: Hamburg
Contact:

Re: General Error

Post by Kevin »

Do you have or had another portal installed?
~~~ They say the definition of madness is doing the same thing and expecting a different result ~~~

Kein Support per PN / No support via PM!

Topic author
mr fun
Active Member
Posts: 7
Joined: 15. October 2008 09:01

Re: General Error

Post by 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)

Topic author
mr fun
Active Member
Posts: 7
Joined: 15. October 2008 09:01

Re: General Error

Post by mr fun »

To clairify my portal is still not working.
User avatar

Kevin
Site Admin
Posts: 2989
Joined: 7. January 2006 20:11
phpBB.de User: Saint
phpBB.com User: Saint_hh
Location: Hamburg
Contact:

Re: General Error

Post by 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.
~~~ They say the definition of madness is doing the same thing and expecting a different result ~~~

Kein Support per PN / No support via PM!

Topic author
mr fun
Active Member
Posts: 7
Joined: 15. October 2008 09:01

Re: General Error

Post by 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.
User avatar

Kevin
Site Admin
Posts: 2989
Joined: 7. January 2006 20:11
phpBB.de User: Saint
phpBB.com User: Saint_hh
Location: Hamburg
Contact:

Re: General Error

Post by 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.
~~~ They say the definition of madness is doing the same thing and expecting a different result ~~~

Kein Support per PN / No support via PM!

Topic author
mr fun
Active Member
Posts: 7
Joined: 15. October 2008 09:01

Re: General Error

Post by 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
User avatar

Kevin
Site Admin
Posts: 2989
Joined: 7. January 2006 20:11
phpBB.de User: Saint
phpBB.com User: Saint_hh
Location: Hamburg
Contact:

Re: General Error

Post by Kevin »

mr fun wrote: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. :(
mr fun wrote: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.
~~~ They say the definition of madness is doing the same thing and expecting a different result ~~~

Kein Support per PN / No support via PM!

joe21
Active Member
Posts: 1
Joined: 20. October 2008 18:01

Re: General Error

Post by 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 :mrgreen: Now to have a play! :D

Thank you for your help!

Joe
www.coltuk.org
User avatar

Kevin
Site Admin
Posts: 2989
Joined: 7. January 2006 20:11
phpBB.de User: Saint
phpBB.com User: Saint_hh
Location: Hamburg
Contact:

Re: General Error

Post by Kevin »

Thank you for the response, Joe! :)
Good to know that it works that way.
~~~ They say the definition of madness is doing the same thing and expecting a different result ~~~

Kein Support per PN / No support via PM!
Locked

Return to “board3 Portal 1.0.x - English Support”