Incorrect syntax near the keyword 'top'.

Corporal Joined: Aug 16, 2003 Posts: 52

Well, im a COMPLETE newbie at all this, I set this up on MySQL before with no problem, however, this time its a paid-for server which runs Windows 2000 and MSSQL 2000. I am able to run MSSQL commands on the database and change it's config, but thats about it. I dont know much abotu SQL anyway. I've set up phpBB2 on this server, but nuke doesnt seem to work.

I've also added the following lines to db/mssql.php right after function sql_query($query = "", $transaction = FALSE)
{ as it was stated in another post:

Code:

$SQLReservedNamesRE = "/(s|,{1})(top|view|count)(s|,|={1})/i";
$query = preg_replace($SQLReservedNamesRE, "$1[$2]$3", $query);

If anyone could help me out, id appreciate it.

Code:

Warning: MS SQL message: Incorrect syntax near the keyword 'top'. (severity 15) in D:\nuke\html\db\mssql.php on line 142

Warning: MS SQL: Query failed in D:\nuke\html\db\mssql.php on line 142

Warning: Cannot add header information - headers already sent in D:\nuke\html\mainfile.php on line 165

Warning: Failed opening 'language/lang-.php' for inclusion (include_path='') in D:\nuke\html\mainfile.php on line 166

Warning: MS SQL message: Invalid object name 'nuke_main'. (severity 16) in D:\nuke\html\db\mssql.php on line 142

Warning: MS SQL: Query failed in D:\nuke\html\db\mssql.php on line 142

Warning: MS SQL message: Invalid object name 'nuke_users'. (severity 16) in D:\nuke\html\db\mssql.php on line 142

Warning: MS SQL: Query failed in D:\nuke\html\db\mssql.php on line 142

Warning: MS SQL message: Invalid object name 'nuke_session'. (severity 16) in D:\nuke\html\db\mssql.php on line 173

Warning: MS SQL: Query failed in D:\nuke\html\db\mssql.php on line 173

Warning: MS SQL message: Invalid object name 'nuke_session'. (severity 16) in D:\nuke\html\db\mssql.php on line 142

Warning: MS SQL: Query failed in D:\nuke\html\db\mssql.php on line 142

Warning: MS SQL message: Invalid object name 'nuke_session'. (severity 16) in D:\nuke\html\db\mssql.php on line 156

Warning: MS SQL: Query failed in D:\nuke\html\db\mssql.php on line 156

Warning: Failed opening 'themes//theme.php' for inclusion (include_path='') in D:\nuke\html\header.php on line 31

Fatal error: Call to undefined function: themeheader() in D:\nuke\html\header.php on line 47
PHP Warning: MS SQL message: Incorrect syntax near the keyword 'top'. (severity 15) in D:\nuke\html\db\mssql.php on line 142 PHP Warning: MS SQL: Query failed in D:\nuke\html\db\mssql.php on line 142 PHP Warning: Cannot add header information - headers already sent in D:\nuke\html\mainfile.php on line 165 PHP Warning: Failed opening 'language/lang-.php' for inclusion (include_path='') in D:\nuke\html\mainfile.php on line 166 PHP Warning: MS SQL message: Invalid object name 'nuke_main'. (severity 16) in D:\nuke\html\db\mssql.php on line 142 PHP Warning: MS SQL: Query failed in D:\nuke\html\db\mssql.php on line 142 PHP Warning: MS SQL message: Invalid object name 'nuke_users'. (severity 16) in D:\nuke\html\db\mssql.php on line 142 PHP Warning: MS SQL: Query failed in D:\nuke\html\db\mssql.php on line 142 PHP Warning: MS SQL message: Invalid object name 'nuke_session'. (severity 16) in D:\nuke\html\db\mssql.php on line 173 PHP Warning: MS SQL: Query failed in D:\nuke\html\db\mssql.php on line 173 PHP Warning: MS SQL message: Invalid object name 'nuke_session'. (severity 16) in D:\nuke\html\db\mssql.php on line 142 PHP Warning: MS SQL: Query failed in D:\nuke\html\db\mssql.php on line 142 PHP Warning: MS SQL message: Invalid object name 'nuke_session'. (severity 16) in D:\nuke\html\db\mssql.php on line 156 PHP Warning: MS SQL: Query failed in D:\nuke\html\db\mssql.php on line 156 PHP Warning: Failed opening 'themes//theme.php' for inclusion (include_path='') in D:\nuke\html\header.php on line 31 PHP Fatal error: Call to undefined function: themeheader() in D:\nuke\html\header.php on line 47

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

Hi can you install analyzer for us from the front page? I'd like to look at it.

Corporal Joined: Aug 16, 2003 Posts: 52

*edit* i figured out how to put up the analyzer

after showing my config.php info, it wrote this:
Could not connect to your MySQL Database, visit Nuke Cops for support..

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

Hi, you can download the analyzer from our front page at the top, and then you can upload it to your server. Make sure you save it to the directory where the files

config.php
mainfile.php
modules.php

is located.

Corporal Joined: Aug 16, 2003 Posts: 52

Yep, I put it in, but why cant it connect to the database? I have all the correct info, same info that my phpbb forum is using which works fine.

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

Hi can you share the link?

Corporal Joined: Aug 16, 2003 Posts: 52

I hope you dont mind me PMing you, I just pmed you the link. I dont know if its harmful to post the link here Razz

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

I must admit that phpnuke today is native linux and mysql. However, instead of "mssql" put it in as this precisely:

mSQL

Corporal Joined: Aug 16, 2003 Posts: 52

Fatal error: Cannot instantiate non-existent class: sql_db in D:\nuke\html\db\db.php on line 86
PHP Fatal error: Cannot instantiate non-existent class: sql_db in D:\nuke\html\db\db.php on line 86

Still has issues Confused

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

Do me a favor, because this hasn't been tested before to my knowledge. Change all instances of "mSQL" here to "mssql" and reset your config.php back to "mssql":

includes/sql_layer.php:/* $dbtype = "mSQL"; */
includes/sql_layer.php: case "mSQL":
includes/sql_layer.php: $dbi=msql_connect($host);
includes/sql_layer.php: msql_select_db($db);
includes/sql_layer.php: case "mSQL":
includes/sql_layer.php: $dbi=@msql_close($id);
includes/sql_layer.php: case "mSQL":
includes/sql_layer.php: $res=@msql_query($query, $id);
includes/sql_layer.php: case "mSQL":
includes/sql_layer.php: $rows=msql_num_rows($res);
includes/sql_layer.php: case "mSQL":
includes/sql_layer.php: $row = msql_fetch_row($res);
includes/sql_layer.php: case "mSQL":
includes/sql_layer.php: $row = msql_fetch_array($res);
includes/sql_layer.php: case "mSQL":
includes/sql_layer.php: $row = msql_fetch_object($res);
includes/sql_layer.php: case "mSQL":
includes/sql_layer.php: $row = msql_free_result($res);

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

Oh and change "msql" to "mssql".

Corporal Joined: Aug 16, 2003 Posts: 52

Same problem in the analyzer, but check out index.php, it has a whole load of new errors :/

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

This is my first time working on the mssql bug. It appears someone has found some stuff:

http://nukeresources.com/postp561.html

How familiar are you with the mssql underlying code? Can you give me a link I can follow and try to resolve this?

Corporal Joined: Aug 16, 2003 Posts: 52

I have absolutely no idea what im doing, im not familiar with SQL at all.

But I seem to have fixed the NT ANONYMOUS LOGON thing, in sql_layers line 85 or so, it was written

$dbi=mssql_connect($host);

I changed it to
$dbi=mssql_connect($host, $user, $password);
and that message was gone, but i still have the same errors as before.

I found a link somewhere on these forums about a guy who made an mssql .sql file, transporting mysql one.

Corporal Joined: Aug 16, 2003 Posts: 52

Wahahaha! Check back on the analyze page please, i edited it and changed all "mysql" entries to "mssql". It shows all the info now...