Undefined variable: sql

Current Version: 1.0.2
Released: 04/25/2010
Post Reply
mauricio
Newbie
Newbie
Posts: 3
Joined: Wed 13. Jul 2011, 20:58
phpbb.com: 308

Undefined variable: sql

Post by mauricio »

Hello,

Look what I'm getting when I try to run the install directory:
[phpBB Debug] PHP Notice: in file /install/index.php on line 134: Undefined variable: sql

Any ideas?

Im on PhpBB 3.0.8
User avatar
Marc
Administrator
Administrator
Posts: 620
Joined: Tue 2. Sep 2008, 22:48
phpbb.com: Marc
Location: Munich
Contact:

Re: Undefined variable: sql

Post by Marc »

What kind of database and which version are you using?
Image
mauricio
Newbie
Newbie
Posts: 3
Joined: Wed 13. Jul 2011, 20:58
phpbb.com: 308

Re: Undefined variable: sql

Post by mauricio »

DB: sql server 2008R2
PhpBB: 3.0.8
User avatar
Marc
Administrator
Administrator
Posts: 620
Joined: Tue 2. Sep 2008, 22:48
phpbb.com: Marc
Location: Munich
Contact:

Re: Undefined variable: sql

Post by Marc »

Sorry for the late reply. I'm currently not able to test phpBB Statistics on an SQL Server. I'll try to test it before releasing the next version. Sorry about that.

I think that your are using mssqlnative. You can try to fix it by searching for every instance of this in the install files:

Code: Select all

				case 'mssql':
				case 'mssql_odbc':
And replace it with this:

Code: Select all

				case 'mssql':
				case 'mssql_odbc':
				case 'mssqlnative':
Image
mauricio
Newbie
Newbie
Posts: 3
Joined: Wed 13. Jul 2011, 20:58
phpbb.com: 308

Re: Undefined variable: sql

Post by mauricio »

Erro Geral
SQL ERROR [ mssqlnative ]

SQLSTATE: 42000 code: 156 message: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near the keyword 'IF'. [156]

SQL

DROP TABLE IF EXISTS myforumstats_config

BACKTRACE


FILE: includes/db/mssqlnative.php
LINE: 313
CALL: dbal->sql_error()

FILE: install/install_functions.php
LINE: 170
CALL: dbal_mssqlnative->sql_query()

FILE: install/install_functions.php
LINE: 129
CALL: stats_drop_table()

FILE: install/install_install.php
LINE: 115
CALL: stats_create_table()

FILE: install/install_install.php
LINE: 73
CALL: install_install->load_schema()

FILE: install/index.php
LINE: 256
CALL: install_install->main()

FILE: install/index.php
LINE: 56
CALL: module->load()
Post Reply