Error installing...

[devildog]

Greetings!

I tried installing the portal, and when I run the install.php file I am getting this error:

Code: Select all

SQL ERROR [ mssql_odbc ]

[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'LIMIT'. [37000]

SQL

UPDATE phpbb_portal_config SET config_value = '1' WHERE config_name = 'portal_poll_allow_vote' LIMIT 1

BACKTRACE


FILE: includes/db/mssql_odbc.php
LINE: 149
CALL: dbal->sql_error()

FILE: install_portal/install.php
LINE: 601
CALL: dbal_mssql_odbc->sql_query()

If I just run the MSSQL Schema, I can get the portal to run, but cannot make any changes to the any of the blocks in the ACP. Any suggestions?

Thanks!

DD

[Kevin]

Hi,

please open install.php, search for:

Code: Select all

							$sql2 = 'UPDATE ' . PORTAL_CONFIG_TABLE . " SET config_value = '" . $config[$row['config_name']] . "' WHERE config_name = '" . $row['config_name'] . "' LIMIT 1";
							$db->sql_query($sql2);
							$sql3 = 'DELETE FROM ' . CONFIG_TABLE . " WHERE config_name = '" . $row['config_name'] . "' LIMIT 1";
							$db->sql_query($sql3);

and replace with:

Code: Select all

							$sql2 = 'UPDATE ' . PORTAL_CONFIG_TABLE . " SET config_value = '" . $config[$row['config_name']] . "' WHERE config_name = '" . $row['config_name'] . "'";
							$db->sql_query_limit($sql2, 1);
							$sql3 = 'DELETE FROM ' . CONFIG_TABLE . " WHERE config_name = '" . $row['config_name'] . "'";
							$db->sql_query_limit($sql3, 1);

General question: you're doing a update from phpbb3portal?

[devildog]

I'll give that a try... It runs fine without doing the install.

I don'tthink I'm upgrading from phpbb3portal. I think we tried putting that on before but had issues converting the MySql stuff to MSSQL. I thought I removed all the other stuff. It's possible that I didn't!

Thanks for the help!!

BTW.. I love the Board3portal!

[Kevin]

I'll give that a try... It runs fine without doing the install.

Sorry, but i don't understand.
Now everything works fine for you??

It's important for us to know, because we don't have MSSQL as a test environment and people using this DB type are rare.

[devildog]

It's odd.. It wouldn't let me use the isntall.php, but the portal works. I was able to go into the ACP and add the mods. I haven't had any problems since.

The schema for MSSQL works great. When I was having problems with the install.php file, I executed the MSSQL Schema and it seemed to do the trick.