Page 1 of 1
Error installing...
Posted: 27. June 2008 05:07
by 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
Re: Error installing...
Posted: 28. June 2008 11:59
by 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?
Re: Error installing...
Posted: 30. June 2008 04:27
by 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!
Re: Error installing...
Posted: 30. June 2008 08:11
by Kevin
devildog wrote: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.
Re: Error installing...
Posted: 2. July 2008 04:52
by 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.