Error when posting a comment

Welcome to Geeklog Saturday, January 25 2020 @ 11:28 am EST

Error when posting a comment | 9 comments | Create New Account

The following comments are owned by whomever posted them. This site is not responsible for what they say.

Error when posting a comment

Authored by: Takashi on Monday, January 01 2007 @ 04:12 am EST

Hi, all, a happy new year. I'm Takashi.
I don't know if it is appropriate to post error report
as an comment to this story but it's convenient for me.
I apologize in advance if it is not good.

I installed geeklog 1.4.1 and experienced an error.
When I posted a comment, I had the following message.

2,mysql_fetch_array(): supplied argument is not a valid MySQL result resource,
/home/takashi/geeklog-1.4.1/system/databases/mysql.class.php,657,Array

I did *clean install* with brand-new database and configuration files.
I also had the same error message when I tried to upgrade from 1.4.0 .

I have one more problem. UTF-8 titles and messages are not displayed correctly,
even if MySQL holds correct UTF-8 strings. I tried to retrieve some articles
from gl_stories with a brief php script with mysql_query and mysql_fetch_array
and confirmed that the table is not corrupted. It seems to be the same problem
as I see bafflegab UTF-8 strings in gl_stories (or other tables) with phpMyAdmin.

I use Debian GNU/Linux etch .

The effect of SET NAMES utf8

Authored by: Takashi on Monday, January 01 2007 @ 05:59 am EST

I posted a comment which reports two problems.
Now I've found that the latter problem (UTF-8 related one) was caused by complex interaction among SET NAMES and server/client default charset.

In geeklog 1.4.0, mysql.class.php didn't care the charset used during the communication between MySQL server and client. Then, in geeklog 1.4.1, mysql.class.php sends SET NAMES just after the beginning of the connection in _connect() method. The problem reported previously was caused by this difference.

I resolved this problem by dumping and restoring the geeklog database by mysqldump. I did some modifications on dump file and my.cnf before/during/after the operation.

Geeklog

Search

Resources

About

Getting started

Support

Development

Topics

User Functions

What's New

Articles last 4 weeks

Comments last 4 weeks

Pages last 4 weeks

Links last 4 weeks

Downloads last 4 weeks