Server: ipower
Platform Type: Debian
MySQL Version: 5.0.45
Perl Version: 5.8.8
PHP Version: 5.2.12
Program: phpbb v 3.0.8 - installed from server's Simple Scripts
page.


Issue:

Server and phpbb blame each other for malfunctioning database, and we
have no idea how to fix.


Symptoms:

Bulletin Board users report that frequently when they click on a link,
it can take awhile for the page to load.

All users have reported receiving the following error message when
they made a post, and their submission is lost:

General Error
SQL ERROR [ mysql4 ]

Incorrect string value: '\xE2\x80\x82 Co...' for column 'post_text' at
row 1 [1366]

An SQL error occurred while fetching this page. Please contact the
Board Administrator if this problem persists. Please notify the board
administrator or webmaster.



Advice on Solution from Server and PHP:


phpbb said:

"Cause: This is usually a result of the database being upgraded. For
example from MySQL 3.0.x or 4.0.x to 4.1.x or 5.x, quite often the web
host will do such an upgrade without warning.

The problem is that the schema of the databases in older versions will
not work correctly in newer versions without various things being
changed. The result of such an upgrade without fixing the database
schema is the above mentioned error.

This issue has become more common on the support forums recently, and
more importantly many people have been incorrectly submitting this as
a phpBB bug.

Your database collations are probably set to Latin instead of
utf8_bin"

.........................

Server said: "There is no server related issues with the database."
Recommended we come to Google forum for help.

.........................


Our Solution Attempted

Went into the database. Clicked "Operations" tab. Drop down menu set
at "latin1_swedish_ci." Switched to "utf8_unicode_ci." Then went
into each individual table and switched to "utf8_unicode_ci."

While in each table, we encounter error messages on all tables:

"PRIMARY and INDEX keys should not both be set for column
`session_id`"

or

"No Index Defined!"

or


"More than Index key was created for column forum ID"






Issue not resolved

Users still getting SQL error message.






Solution Attempted:

Unable to determine a fix.

Noted that when we clicked on table link, it states the collation is
"utf8_unicode_ci", but when we clicked on the Operations and Structure
tabs in the database, the tables in there show the collations as
"latin1_swedish_c."

Newbie_phpbb <justice.gaga (AT) gmail (DOT) com> wrote:

This error usually means that MySQL detected an invalid utf8 sequence.
However the above sequence is correct, it encodes U+2002, "EN SPACE"
(http://www.fileformat.info/info/unic...2002/index.htm)

So this error makes no sense IMHO.

It would be quite helpful to know the exact table definition and the
charset_connection used by the client. But it seems you have no idea
how phpbb works. So I suggest that you contact the maintainers of it.

I should also add that 5.0.45 is stone age. It is possible (but not
very likely) that this is a known bug that is fixed in more recent
MySQL versions. Consider an upgrade!


XL

thank you for the response. You are correct. My experience is with
providing content and some html web page. I am filling in for our
techie that is out because of head injury.

I am currently going through each table and manually switching every
latin entry to the unicode. Just got an error message. Something
about a duplicate perez key 2. Note sure why it does not want me to
switch its collation table to unicode.

So, I'm inclined to think its the database. As for going to phpbb or
the server, that only nets me a response to look to the other guy for
the answer. I have already been shopping for new host.

BTW: What does IMHO mean?




On Jul 5, 2:25*pm, Axel Schwenke <axel.schwe... (AT) gmx (DOT) de> wrote:

Newbie_phpbb wrote:


it means in my humble opinion.
IMHO

On 05-07-2011 17:50, Newbie_phpbb wrote:

mysql4 ?????

Which version of PHPBB is running? (latest is 3.0.8)

I have a forum running with MySQL 5.0.67, so i dont think its has to do
with the version of your database, but i may be some content in the
database....

If you can find the row in phpbb_posts which causes the problem, you
might be able to change the text (in post_text) to a more correct value.



--
Luuk

Installed in March, the 3.0.8 version.

How do I go about determining which row. There are 90 tables in the
nuke and 62 tables in the forum databases.

What throws me is when it states "row 1 1366" because I cannot find a
row fitting that description.

In 2006, i created a submission page that have about 20 questions, in
Dreamweaver using php. On the server side I created the database. I
have never had any error messages or issues. When I need to look at
something on certain or column, I am able to navigate it easily,
mostly because it numbers the entries.

I have not been able to wrap my brain around the structure of the
phpbb's database structure, such as locating that row you speak about.

In terms of cause and effect, I have narrowed the issue being caused
by any submissions that contains an ACSII character.









On Jul 6, 12:26*am, Luuk <L... (AT) invalid (DOT) lan> wrote:

On Wed, 6 Jul 2011 19:01:36 -0700 (PDT), Newbie_phpbb wrote:
That's row 1 of your result set, when that query ran. Once you know what
post it's trying to show, you'll know how to get to that row.

Also, don't top-post.

--
40. I will be neither chivalrous nor sporting. If I have an unstoppable
superweapon, I will use it as early and as often as possible instead
of keeping it in reserve.
--Peter Anspach's list of things to do as an Evil Overlord

On 07-07-2011 04:01, Newbie_phpbb wrote:

The list of tables is at:
http://wiki.phpbb.com/Tables

I personally think you need to look at this table:
http://wiki.phpbb.com/Table.phpbb_posts
(because it containts the posts)

to give an example :
if this url should give a problem:
http://www.phpbb.com/community/viewt...f=65&t=2115251
than your SQL might look like:
SELECT post_text from phpbb_posts where topic_id=2115251

--
Luuk

Thank you for the links and advice.

I was wondering, does anyone know if VBulletin as all these error
messages and issues too?

I'm feeling over my head with the phpbb, as it has been steady stream
of endless issues and problems, that require working knowledge of SQL
operations and php coding. I have been trying for three months to
wrap my head around phpbb, but I am fatiqued. I have a web site to
manage in addition to the bulletin board. I need something that is
not high maintinance.

I looked around this forum, and noticed I was finding VBullitin
problems. Would I be able to transfer the phpbb to VBulletin easily?

On 7/9/2011 10:12 AM, Newbie_phpbb wrote:
That's interesting, because I've had several PHP BBs's over the years
and never had any problems requiring a knowledge of PHP or MySQL.

You need to keep both up to date for security reasons, but that's not
too hard, either. And you'll have similar problems if you don't keep
any software up to date.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================