phpBB • Free and Open Source Forum Software

I get this: SQL ERROR [ mssql_odbc ] [Microsoft][ODBC SQL Server Driver][SQL Server]ORDER BY items must appear in the select list if SELECT DISTINCT is specified. [37000] SQL SELECT distinct(p.topic_id) , p.forum_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, u.user_i...

Hi! I want to change colour of the board and nothing else. I want to change it from blue to green. I use Prosilver. Which files in the images directory should I change? I have tried but as you can see the result is no good. http://hagaviken.d2g.com/images/bild1.jpg Any suggestions would apreciated. ...

Got this when trying to register as a user: SQL ERROR [ mssql_odbc ] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'ESCAPE'. [37000] SQL SELECT a.group_id, ao.auth_option, a.forum_id, a.auth_setting, a.auth_role_id, r.auth_setting as role_auth_setting FROM phpbb_ac...

ok, find the line of code that looks like $query = utf8_decode($query); in includes/db/mssql.php and remove it. Try your actions again Thank you David! That did it :D :D :D I knew that there where someone clever in this coummunity who had the solution. Is this something that will be changed in the ...

DavidMJ wrote: which DBAL did you install with? MSSQL or MSSQL-ODBC?

I use MSSQL-ODBC

There is nothing to do to "fix it" per se since betas should not be used in a live environment, however... to eliminate user error from an actual edge-case regression bug within phpBB3 Beta3 due to the encoding switch, at the very least go through the following list: Is the Beta3 install ...

Naturally, it does not. I might be server setup related, try upload a .htaccess to your root on server for your Beta 3 board containing the line : AddDefaultCharset UTF-8 I run my forums on a Windows2003-server. I think .htaccess only is for Apache servers. :? There must be something else in this c...

karlake, Is your question releated to a Swedish language package under development ? No eventually not. I was just puzzled when my browser couldn´t show our Swedish characters for example in the Sitenamn and Site description (and in posts). I don´t understand why? Worked well in Beta2 and I was sur...

Beta 2 has been superceded by beta 3 and therefore should not be needed for testing - or are we talking about a live forum here? No not live forums, but I did some work on the B2-forum and have not had the time to make any documentation of that yet. Was going to have it running for a while before I...

david63 wrote: Why have you still gor beta 2 installed?

To fix your problem delete beta 2.

I don´t see why that should be any problem with 2 forums. They have separate databases and are in separate directories on the webserver. Guide me, please!

I have one forum based on Beta2 and just installed another based on Beta3. Got one problem with the character encoding. In beta2 it works just fine with our Swedish characters and if one looks at the source of the pages it says: "<meta http-equiv="content-type" content="text/html...

I have installed the Attachment mod ver 2.3.9 on my phpBB ver 2.0.6 and it works just fine besides from that part of creating thumbnails. I have installed Image Imagick and it´s working just fine when tested. Settings in Special categories: Display Images Inlined: Yes Create Thumbnail: Yes Minimum T...