phpMyFAQ

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


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 ...

Hi Torsten,

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

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 ...

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.


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 ...

Hi Torsten,

I've tried the rc3 and still have the same message.
Again I have made a trace on the SQL server to see what it does.
I'm wondering if it is not something about the selection of the database. Indeed I don't see anywhere in this trace the BD name. What do you think?
Ronan


Audit Login ...

Hi Torsten,

When you have time, can you send me a fix for MS SQL ?

I'm also using PHPMYFAQ with mysql and it works great!

Thank you.

Ronan

Hi!

When I do this...

CREATE TABLE faq_faquser (
id integer NOT NULL,
name varchar(64) NOT NULL,
pass varchar(64) NOT NULL,
realname varchar(255) DEFAULT '',
email varchar(255) DEFAULT '',
rights varchar(255) NOT NULL,
PRIMARY KEY (id))
go
SELECT @@ERROR AS ErrorCode


... it creates ...

Hi,

Yes it is possible. I did it by hand and it worked.
Do you think there are other traces that could be more explicit?

Ronan

Hi Thorsten,

I've made a log with sql server and this is what it does:


CREATE TABLE faq_faquser (
id integer NOT NULL,
name varchar(64) NOT NULL,
pass varchar(64) NOT NULL,
realname varchar(255) DEFAULT '',
email varchar(255) DEFAULT '',
rights varchar(255) NOT NULL,
PRIMARY KEY (id))
go
SELECT ...

Hi!

I've tried the patch you've sent to my email and now I get this message.
I've tried the script on 2 different SQL Server and I have the same result.

Thank you for your help.

Ronan

Hi,

I made the change you told me to do and It still doesn't work. I get this message (with no explanations)


|

Error: Please install your version of phpMyFAQ once again or send us a bug report.
DB error:

Do you have an idea of the problem?

Ronan

PS: I'm ok to test the script with MS SQL ...

Hi,

I have a problem with phpmyfaq1.4.6.

My system:
PHP v5.0.3
IIS
Mysql v4.1

The script works well except when I want to export in .pdf a document that contains an image.
[edit] > If I do not have an image, it works.

I get this message:


Warning: getimagesize(../www/phpmyfaq1.4.6/images ...

Hi,

I have a problem with phpmyfaq v1.5.0rc1.

My system:
PHP v5.0.3
IIS
SQL Server 2000

When I go to the installer.php page, I fill all the fields and when I clic Valid I get this message:

Parse error: syntax error, unexpected ':' in D:\Data\www\phpmyfaq1.5.0rc1\inc\mssql.php on line 302

Do you ...