1 Topic by jacobswell (edited by jacobswell 2004-05-07 15:24)

  • From: South Korea
  • Registered: 2004-05-02
  • Posts: 96

Topic: Another bug with sqlite :(

Another bug with sqlite.

when you log in, the bug is not shown, when you logout, you can find.
the bug is topic name is shown as 0 not a string name.

to avoid this, change like this.
in viewtopic.php(line 106) :

$result = $db->query('SELECT t.subject, t.closed, t.sticky, t.num_replies, f.id, 
f.forum_name, f.moderators, f.closed AS forum_closed, f.admmod_only, "0" 
FROM '.$db->prefix.'topics AS t INNER JOIN '.$db->prefix.'forums AS f ON 
t.forum_id=f.id WHERE t.id='.$id.' AND t.moved_to IS NULL') or error('Unable to 
fetch topic info', __FILE__, __LINE__, $db->error());

difference is between 0 and "0" smile

jacobswell's Website

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: Another bug with sqlite :(

Once again, since when does PunBB support SQLite? I'm guessing your talking about PunBB++, but then you're in the wrong place.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

  • From: South Korea
  • Registered: 2004-05-02
  • Posts: 96

Re: Another bug with sqlite :(

It's my fault that I posted. but I think it will help you when you make punbb support sqlite. thanks.

jacobswell's Website

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: Another bug with sqlite :(

The SQLite support for 1.2 is already done and I don't believe it has this problem. Anyway, I'll have a look at it when I get home.

[Topic moved]

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website