PHP has encountered an Access Violation at 01AEAC6A

[skuddies]

hi all,

i'm using PHP (5.2.10) on iis6, Mysql version 5.1.35 and phpmyfaq 2.64. I've everything configured and running fine until i hit the install button on setup.php. The error i get is "PHP has encountered an Access Violation at 01AEAC6A" . Any ideas?

Thanks in advance!

[skuddies]

i've had alook online and the above message suggests an issue with mismatched libmysql.dlls. What i have done is added C:\PHP to the path in the environment variables. When i now hit the setup it creates the database in mysql and it comes back with the following error:

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

DB error: Incorrect string value: '\xE2\x88\x9A\xE2\x80\xA2' for column 'stopword' at row 1

Query:

INSERT INTO faqstopwords (id, lang, stopword) VALUES (171, 'da', 'fâ??â?¢')

Any Ideas?

[Thorsten]

Hi,

could you please upgrade PHP and MySQL first, this could cause the issue.

bye
Thorsten

[skuddies]

hi thorsten,

i've upgraded to PHP 5.2.13 and MySql to 5.1.46 and i'm getting the same error:

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

DB error: Incorrect string value: '\xE2\x88\x9A\xE2\x80\xA2' for column 'stopword' at row 1

Query:

INSERT INTO faqstopwords (id, lang, stopword) VALUES (171, 'da', 'fâ??â?¢')

The database goes through the install and its always the same table that generates the error.

Any ideas?

K

[Thorsten]

Hi,

you can remove the stopwords. Please open install/setup.php, go to line 635 and remove the following line:

Code: Select all

    require_once 'stopwords.sql.php';    // INSERTs for stopwords

bye
Thorsten

[m.ardito]

i solved this problem re-creating the database with utf-8 character set and reinstalling phpmyfaq

hi, Marco

[Thorsten]

Hi,

ah, good to know!

bye
Thorsten