5
resolved
Thanks ..
------------------
Bug is described here
http://bugs.mysql.com/bug.php?id=13551
to solve
open sources/Boards.php
find buggy query
Quote:
and make it look like the following
Quote:
Thanks ..
------------------
Bug is described here
http://bugs.mysql.com/bug.php?id=13551
to solve
open sources/Boards.php
find buggy query
Quote:
SELECT f.*, c.id as cat_id, c.position as cat_position, c.state as cat_state, c.name as cat_name, c.description as cat_desc
and make it look like the following
Quote:
// FIX 5.0.15
$DB->query("SELECT f.*, c.id as cat_id, c.position as cat_position, c.state as cat_state, c.name as cat_name, c.description as cat_desc,
c.image, c.url, m.member_name as mod_name, m.member_id as mod_id, m.is_group, m.group_id, m.group_name, m.mid
FROM ( ibf_forums f, ibf_categories c )
LEFT JOIN ibf_moderators m ON (f.id=m.forum_id)
WHERE c.id=f.category
ORDER BY c.position, f.position");
7
Quote:
Can you help me?
How i can fix it?
mySQL query error: SELECT f.*, c.id as cat_id, c.position as cat_position, c.state as cat_state, c.name as cat_name, c.description as cat_desc,
c.image, c.url, m.member_name as mod_name, m.member_id as mod_id, m.is_group, m.group_id, m.group_name, m.mid
FROM xoops_ipb_forums f, xoops_ipb_categories c
LEFT JOIN xoops_ipb_moderators m ON (f.id=m.forum_id)
WHERE c.id=f.category
ORDER BY c.position, f.position
mySQL error: Unknown column 'f.id' in 'on clause'
mySQL error code:
Date: Sunday 31st of December 2006 08:39:00 AM
Can you help me?
How i can fix it?
9
Quote:
i tried TinyD 2.2 modul and didnt like it.
cjay content blocks very comfortable.
and I wrote a lot of articles for cjay content.
but now i didt clone this modul :(
Regards.
xuser wrote:
why not try TinyD 2.2, the world's most simple and flexible and cloneable content module.
i tried TinyD 2.2 modul and didnt like it.
cjay content blocks very comfortable.
and I wrote a lot of articles for cjay content.
but now i didt clone this modul :(
Regards.
Login
Search
Recent Posts
Who's Online
Donat-O-Meter
| Stats | |
| Goal: | $100.00 |
| Due Date: | Apr 30 |
| Gross Amount: | $0.00 |
| Net Balance: | $0.00 |
| Left to go: | $100.00 |
 |
|