phpmyfaq1.5.0rc1 with MS SQL

[Thorsten]

Hi,

it is possible that you're trying to insert the CREATE TABLE from install/mssql.php by hand?

bye
Thorsten

[Thorsten]

Hi,

I'll install the Microsoft SQL Server 2000 Desktop Engine on my laptop to test it, too. Until yesterday I didn't knew that the SQL Server 2000 Engine is free of charge.

bye
Thorsten

[nanor]

Hi,

As you suggested, I've created the tables by hand but I'm not sure it worked because I have this message on the homepage.

Code: Select all

Warning: mssql_result(): supplied argument is not a valid MS SQL-result resource in D:\Data\www\phpmyfaq.1.5.0.rc3\inc\mssql.php on line 326

Warning: Cannot modify header information - headers already sent by (output started at D:\Data\www\phpmyfaq.1.5.0.rc3\inc\mssql.php:326) in D:\Data\www\phpmyfaq.1.5.0.rc3\index.php on line 119

What do you think?

Ronan

[Thorsten]

Hi,

please open the file inc/mssql.php and change the line 326 from

Code: Select all

$currentID = mssql_result($result, 0, 'current_id');

to

Code: Select all

$currentID = mssql_result($result, 1, 'current_id');

and try it again. Thanks a lot!

bye
Thorsten

[nanor]

Hi Torsten,

I've tested what you suggsted and I get the same message:

Code: Select all

Warning: mssql_result(): supplied argument is not a valid MS SQL-result resource in D:\Data\www\phpmyfaq.1.5.0.rc3\inc\mssql.php on line 326

Warning: Cannot modify header information - headers already sent by (output started at D:\Data\www\phpmyfaq.1.5.0.rc3\inc\mssql.php:326) in D:\Data\www\phpmyfaq.1.5.0.rc3\index.php on line 119

Ronan

[Thorsten]

Hi,

okay, I'll have to test this. Do you have a error log from MS SQL server so that I can see which query failed?

Thanks!

bye
Thorsten

[nanor]

This is the log I get when I exec index.php:

Code: Select all

exec sp_server_info 18
go
SELECT max(sid) as current_id FROM faqsessions
go
INSERT INTO faqsessions (sid, ip, time) VALUES (1, '10.196.148.123', 1112707000)
go
SELECT id, lang, parent_id, name, description FROM faqcategories WHERE lang = 'fr' ORDER BY id
go
SELECT count(sid) FROM faqsessions WHERE time > 1112706700 GROUP BY ip
go
SELECT datum, header, artikel, link, linktitel, target FROM faqnews ORDER BY datum desc
go
SELECT id FROM faqdata WHERE active = 'yes'
go
SELECT DISTINCT faqdata.id, faqdata.lang, faqdata.thema, faqcategoryrelations.category_id, faqvisits.visits FROM faqvisits, faqdata LEFT JOIN faqcategoryrelations ON faqdata.id = faqcategoryrelations.record_id AND faqdata.lang = faqcategoryrelations.record_lang WHERE faqdata.lang = 'fr' AND faqdata.id = faqvisits.id AND faqdata.lang = faqvisits.lang AND faqdata.active = 'yes' ORDER BY faqvisits.visits DESC
go
SELECT DISTINCT faqdata.id, faqdata.lang, faqcategoryrelations.category_id, faqdata.thema, faqdata.datum, faqvisits.visits FROM faqvisits, faqdata LEFT JOIN faqcategoryrelations ON faqdata.id = faqcategoryrelations.record_id AND faqdata.lang = faqcategoryrelations.record_lang WHERE faqdata.lang = 'fr' AND faqdata.id = faqvisits.id AND faqdata.lang = faqvisits.lang AND faqdata.active = 'yes' ORDER BY faqdata.datum DESC
go

This is the log I get when I exec admin/index.php:

Code: Select all

exec sp_server_info 18
go
DELETE FROM faqadminsessions WHERE time < 1112705496
go
SELECT id, name, realname, email, pass, rights FROM faquser WHERE name = 'admin' AND pass = '3c965a85ed1e497db6b770449dffb09a'
go
SELECT max(id) as current_id FROM faqadminlog
go
INSERT INTO faqadminlog (id, time, usr, text, ip) VALUES (1, 1112707296, '', 'Loginerror<br />
Login: admin<br />
Pass: 3c965a85ed1e497db6b770449dffb09a', '10.196.148.123')
go

I've also checked the tables and they are all empty (except my account in the table faquser).

Ronan