Welcome Guest ( Log In | Register )


Check out the FREE chatroom mod for IPB 3.x

> IPB Help

IMPORTANT DISCLAIMER - PLEASE READ

You are currently in an unofficial IPB help forum where members assist other members with Invision Power Board. While you may receive help with your Invision Power Board questions in this forum it is important to note the following:

Note: Let us state again that support provided in IPB Help is provided by the kindness of others. The staff of Invisionize do not officially provide support for Invision Power Board. If you would like official support from Invision Power Services, please open a new support ticket from your Invision Power Services Customer Area page.

 
 Reply to this topicStart new topic
ipb 1.3 on mysql 5.x
mcm-never-dies
post Dec 6 2005, 04:26 PM
Post #1


Member
**

Group: Members
Posts: 193
Joined: 28-January 05
Member No.: 142,544
IPB Version: 1.3.x
I did some edits to my ipb 1.3 to get it to work with mysql 5.x. I don't know if this are all required changes, but I'm still looking for them wink.gif

Open sources/boards.php

Find:
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");

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
Go to the top of the page
 
+Quote Post
Asm0dey
post Jun 15 2006, 09:18 AM
Post #2


Newbie
*

Group: Members
Posts: 2
Joined: 8-November 04
Member No.: 132,014
IPB Version: 1.3.x
There's another huge trouble. On MySQL 5 it's impossible to send long messages. Here is the trouble:

SQL
mySQL query error: INSERT INTO ibf_posts (author_id,use_sig,use_emo,ip_address,post_date,icon_id,post,author_name,forum_id,topic_id,queued,attach_id,attach_hits,attach_type,c_music,c_mood,attach_file) VALUES ('1','1','1','**MY IP**','1150384497','',' HERE IS THE MESSAGE. HERE IS THE MESSAGE. HERE IS THE MESSAGE. HERE IS THE MESSAGE. HERE IS THE MESSAGE. HERE IS THE MESSAGE. HERE IS THE MESSAGE. HERE IS THE MESSAGE. HERE IS THE MESSAGE. HERE IS THE MESSAGE. HERE IS THE MESSAGE. HERE IS THE MESSAGE. HERE IS THE MESSAGE. HERE IS THE MESSAGE. HERE IS THE MESSAGE. ','Asmodey','18','1483','0','','','','','','')

mySQL error: Duplicate entry ' ' for key 5
mySQL error code:
Date: Thursday 15th 2006f June 2006 07:14:57 PM


HOW TO REPAIR THIS?

This post has been edited by Asm0dey: Jun 15 2006, 09:19 AM
Go to the top of the page
 
+Quote Post
mcm-never-dies
post Jun 22 2006, 07:16 AM
Post #3


Member
**

Group: Members
Posts: 193
Joined: 28-January 05
Member No.: 142,544
IPB Version: 1.3.x
that has nothing to do with mysql 5.. probably because of a mod you installed
Go to the top of the page
 
+Quote Post
joskevdb
post Feb 2 2007, 03:43 AM
Post #4


Newbie
*

Group: Members
Posts: 4
Joined: 30-June 05
Member No.: 164,870
IPB Version: Not Applicable
thx, works fine! smile2.gif
Go to the top of the page
 
+Quote Post
Humbe
post Feb 15 2007, 07:13 AM
Post #5


Newbie
*

Group: Members
Posts: 25
Joined: 29-August 05
Member No.: 172,971
IPB Version: 2.0.x
I'll check if this is the problem that I've been having, for example I can't see the user's profile or the Control Panel.

I'll try this then I'll let you guys know.
Go to the top of the page
 
+Quote Post
Dr.Vision
post Aug 16 2008, 03:45 AM
Post #6


Newbie
*

Group: Members
Posts: 14
Joined: 11-April 08
Member No.: 326,387
IPB Version: 1.3.x
Thank you so much it worked mad props mate. thanks. to you and Pit
Go to the top of the page
 
+Quote Post
« Next Oldest · General Support · Next Newest »
 

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Lo-Fi Version Time is now: 2nd September 2010 - 09:09 AM

Search Engine Keywords
IPB img code don\'t work, ipb insert user mysql, search
Powered By IP.Board © 2010  IPS, Inc.
Licensed to: Invisionize
CommunitySEO 1.2.3 © 2010  IPB SEO Module
Invision Skins · IPB Skins