Corregir error con IPB 1.3.1 y mysql 5.0.32

5 Replies

Hoy se actualizo el servidor del departamento a la nueva version de debian (etch), y nos encontramos con mas de un problema al terminar el apt, ahora les podré la solucion del error que me aparecia en el foro invision board 1.3.1

El error de ipb decia

mysql error: Unknown column ‘f.id’ in ‘on clause’

solucion

Open sources/boards.php

Find:

$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”);

Replace with:

CODE

$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”);

Save & upload sources/boards.php

Open sources/dynamiclite/csite.php
Find:

CODE

$DB->query(”SELECT t.tid, t.title, t.state, t.last_vote, p.* $sql
FROM ibf_topics t, ibf_polls p
$extra
WHERE t.tid=$tid AND p.tid=t.tid”);

Replace with:

CODE

$DB->query(”SELECT t.tid, t.title, t.state, t.last_vote, p.* $sql
FROM (ibf_topics t, ibf_polls p)
$extra
WHERE t.tid=$tid AND p.tid=t.tid”);

Save & upload sources/dynamiclite/csite.php
Enlace con solucion

5 thoughts on “Corregir error con IPB 1.3.1 y mysql 5.0.32”

  4. carcanada

    Bad credit rating credit cards universal life insurance company antique car insurance online quote prudential dental insurance plans us.
    Auto insurance quote car policy discount car insurance company car cheap from insurance quote uk car cheap insurance quote student.

  5. dyclefdem

    are in a very good problem, you will not just throw them away. Marketing them is usually a better technique to discard them, asSecond Hand Bags From Chanel Readily available On the internet Every single woman loves to possess designer goods and likes to flauntrange and better deals. Also, when you converse to someone in human being, you may have improved possibilities of negotiatingweb-sites that only deal in discount purses – this kind of as many generated by Chanel. In almost any case, this kind of web-sites aremight be employed even for a life time if taken good care of. On the subject of Chanel purses and purses, there [url=http://www.beatsbydrdre-eshop.net]beats by dre[/url] head? Does it materialize that by the time you will get cost-free to go and store, it really is time with the Chanel boutique tojewelry. There are actually fantastic photos out there with comprehensive products descriptions for you to know more details on theofficial shop on line web page exactly where people can look through as a result of the products and solutions and area their order on the internet.web site is simply the essential costs, regarded as factory charges.On top of that, Chanel normally has good discounts andreplica bags rather than authentic and genuine ones. And it can be even easier to achieve this from the scenario of wholesale

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.