IS IPB 100% compatible with mysql 4.1 ?

General Chat

Our community chat forum areas are for off-topic discussion only. Please do not post topics about IPS or its products and services here. We provide other forum areas for IPS discussion.

Do you need technical support on IPS products or services?

You can obtain support via the client area, or you can try to obtain peer-to-peer support at IPS Resources.

Did you find a bug in one of our products?

If you believe you've found a bug please post it to the bug tracker.

Have a suggestion or feedback?

Use the company feedback forum or appropriate product feedback forum. You can also submit a ticket in your client area if it's a private matter.

(2 Pages)
1
2
→

You cannot start a new topic
You cannot reply to this topic

IS IPB 100% compatible with mysql 4.1 ? Rate Topic:

#1 Guest_thewiseoldman_*

Group: Guests

Posted 29 October 2004 - 07:59 AM

Hello,

MySQL 4.1 has been released, it is a big improvement not just bug fix.

Severals things have changed ie : Fulltext

Does IPB has been tested with mySQL 4.1, what should we take care about before and while converting to 4.1 ?

Regards.

Gilles

Sorry for the previous empty topic, a bug occured :huh:

Back to top of the page up there ^
MultiQuote
Reply

#2 Cheule

Look, a Cat on a Carpet!

Group: Members
Posts: 505
Joined: 09-May 03
Location:UK

Posted 29 October 2004 - 08:13 AM

I would think that as MySQL 4.1 has just been released, there's been no time to fully test it with IPB2. I should imagine future IPB updates may take full advantage of whatever the new MySQL version brings

Bloodnet-Online forums

Back to top of the page up there ^
MultiQuote
Reply

#3 Guest_thewiseoldman_*

Group: Guests

Posted 29 October 2004 - 08:22 AM

This is not a beta but a production version.

4.1 is an interesting version in many areas (faster, more secure, more stable, fully relationnal, mysql cluster), some host (my host actually) would like to upgrade to 4.1 but doesn't want to crash hundreds of IPB boards (full text for example)

Back to top of the page up there ^
MultiQuote
Reply

#4 Tim Dorr

Ham Spappy

Group: +Active Customers
Posts: 831
Joined: 26-June 02
Location:Atlanta, GA

Posted 29 October 2004 - 08:27 AM

There are really only 3 "big" changes:

Quote

Incompatible change: Binary values such as 0xFFDF now are assumed to be strings instead of numbers. This fixes some problems with character sets where it's convenient to input a string as a binary value. With this change, you should use CAST() if you want to compare binary values numerically as integers

Quote

Incompatible change: String comparison now works according to SQL standard: Instead of stripping end spaces before comparison, we now extend the shorter string with spaces.

Quote

Incompatible change: TIMESTAMP is now returned as a string in 'YYYY-MM-DD HH:MM:SS' format

The rest are all either special cases (weirdly named tables or special character sets), and don't affect 99.99% of the users out there. And given those changes above, I don't see any problems relating to IPB offhand.

timdorr.com - FeedScrub - A Small Orange Software

Back to top of the page up there ^
MultiQuote
Reply

#5 Tim Dorr

Ham Spappy

Group: +Active Customers
Posts: 831
Joined: 26-June 02
Location:Atlanta, GA

Posted 29 October 2004 - 08:29 AM

[quote=thewiseoldman,Oct 29 2004, 03:22 AM](full text for example)

<{POST_SNAPBACK}>

[/quote]

The only thing they improved with FULLTEXT is to make it faster. Nothing incompatible has been changed or added.

Edit: It's really the new additions that add some major improvments. Prepared statements could make a big impact on MySQL speed if IPB were to support them (and this would be easy with the way the SQL abstraction works now).

timdorr.com - FeedScrub - A Small Orange Software

Back to top of the page up there ^
MultiQuote
Reply

#6 Nimdock

Knowledge is Power

Group: +Active Customers
Posts: 2,005
Joined: 14-June 03
Gender:Male
Location:Title Town

Posted 29 October 2004 - 09:25 AM

So... still minimum four characters for search?

Controversia Futbol Colombia

Back to top of the page up there ^
MultiQuote
Reply

#7 Guest_thewiseoldman_*

Group: Guests

Posted 29 October 2004 - 09:36 AM

This is not related to MySQL 4.0 or 4.1 but mysql server configuration, it's up to you to set it to less

Back to top of the page up there ^
MultiQuote
Reply

#8 marcele

Spam Happy

Group: +Active Customers
Posts: 754
Joined: 26-February 04
Gender:Male
Location:Edmonton, Alberta, Canada

Posted 29 October 2004 - 01:30 PM

Have been running 4.1 on our devel servers and the development board is working fine with it..

Timdor , yes prepared statements would be nice with IPB!!

Is there anyone working on a php5 mysqli driver for IPB?

The only thing holding me back from using php5 and mysqli is the lack of a freeware php cacher...

Turck mmcache is not compatable with php5!

Back to top of the page up there ^
MultiQuote
Reply

#9 Nimdock

Knowledge is Power

Group: +Active Customers
Posts: 2,005
Joined: 14-June 03
Gender:Male
Location:Title Town

Posted 29 October 2004 - 03:51 PM

[quote=thewiseoldman,Oct 29 2004, 05:36 AM]This is not related to MySQL 4.0 or 4.1 but mysql server configuration, it's up to you to set it to less

<{POST_SNAPBACK}>

[/quote]
I see now, I remember someone said on this forum that it was a limitation on MySQL, I didn't know it could be changed on the server configuration.

Controversia Futbol Colombia

Back to top of the page up there ^
MultiQuote
Reply

#10 mrbuzz

IPB Full Member

Group: Members
Posts: 152
Joined: 31-May 03
Location:Santa Clara, Calif.

Posted 29 October 2004 - 07:36 PM

Has anyone tried mysql 4.1 with 2.0.1 running on a large production board? If so, give us some feedback on 4.1!

buzz / Neurox Media
idolforums.com | leeliu.com

Back to top of the page up there ^
MultiQuote
Reply

#11 cooldude7273

IPB Customer

Group: +Active Customers
Posts: 2,654
Joined: 05-January 04
Location:Dan-Roswell, GA, USA From: Nick-Raleigh, NC, USA

Posted 29 October 2004 - 07:55 PM

Timestamp might have to be changed...
I have seen it come out in that format before I think.

Need Hosting? LimitlessHosting.net | *My Blog!* |TheTechArea.com
This Post Copyright © 2008 Cooldude7273 enterprise, all rights reserved.
Biggest Bot List For IPB EVER v5.0.5 Released! + more!

Back to top of the page up there ^
MultiQuote
Reply

#12 Dr. Bongoots

iDiot

Group: Members
Posts: 1,879
Joined: 13-February 02
Location:Land of the Long White Cloud

Posted 17 November 2004 - 11:42 AM

Any updates on MySQLI compliance? (PHP 5.x and MySQL 4.1.3+)

My Blog: A day in the life of a guy with a plastic tube from his brain to his stomach.

The first 12 markers of my Y-DNA:

Are we related? Posted Image

Back to top of the page up there ^
MultiQuote
Reply

#13 nexthostbiz

IPB Member

Group: Members
Posts: 66
Joined: 29-August 03

Posted 03 May 2005 - 10:08 PM

any update?

Expect Success,

http://Shahrooz.Bhopti.com

CEO- YoungMasterminds.com

TEAM LEADER / TRAINER / MOTIVATOR / WEBMASTER
************************************************
If you ever need anything, please don't hesitate to ask me.
The possibilities are endless ... It’s Your Move …

Back to top of the page up there ^
MultiQuote
Reply

#14 Stewart

I live!

Group: +Active Customers
Posts: 8,052
Joined: 13-February 02
Location:Glasgow, Scotland, UK

Posted 03 May 2005 - 10:34 PM

Dr. Bongoots, on Nov 17 2004, 12:42 PM, said:

Any updates on MySQLI compliance? (PHP 5.x and MySQL 4.1.3+)

nexthostbiz, on May 3 2005, 11:08 PM, said:

any update?

Planned, but it will be likely after 2.1, although hopefully not long after

Back to top of the page up there ^
MultiQuote
Reply

#15 princetontiger88

Staff Emeritus

Group: Members
Posts: 14,951
Joined: 14-February 02

Posted 03 May 2005 - 10:39 PM

i guess mysqli will be a different module? it will take a loooong time for php5's and mysql 4.1's mainstream use.

Back to top of the page up there ^
MultiQuote
Reply

#16 nexthostbiz

IPB Member

Group: Members
Posts: 66
Joined: 29-August 03

Posted 03 May 2005 - 11:02 PM

is PHP5 and Mysql 4.1 currently supported without mysqli?

Back to top of the page up there ^
MultiQuote
Reply

#17 princetontiger88

Staff Emeritus

Group: Members
Posts: 14,951
Joined: 14-February 02

Posted 03 May 2005 - 11:04 PM

yes, I believe so.

Back to top of the page up there ^
MultiQuote
Reply

#18 AtariAge

Spam Happy

Group: +Active Customers
Posts: 902
Joined: 02-July 04
Gender:Male

Posted 03 May 2005 - 11:06 PM

Uhrrr, has IPB 2.0.3 not been tested with MySQL 4.1? Because that's what I'm running on my server, for about three weeks now (migrated from a phpBB forum). It's a big forum with nearly 850,000 posts, so if there are any issues with MySQL 4.1 it would be nice to know. And I did tweak the FULLTEXT search so it works with three character words.

..Al

Back to top of the page up there ^
MultiQuote
Reply

#19 princetontiger88

Staff Emeritus

Group: Members
Posts: 14,951
Joined: 14-February 02

Posted 03 May 2005 - 11:08 PM

if you haven't had a problem yet, I don't see why you would start to have a problem.

Back to top of the page up there ^
MultiQuote
Reply

#20 Tim Dorr

Ham Spappy

Group: +Active Customers
Posts: 831
Joined: 26-June 02
Location:Atlanta, GA

Posted 04 May 2005 - 04:23 AM

AtariAge, on May 3 2005, 06:06 PM, said:

..Al

Neowin's been running MySQL 4.1 for a while. We're pretty big, so I think you'll be safe

Invision Power Services: IS IPB 100% compatible with mysql 4.1 ? - Invision Power Services

General Chat

IS IPB 100% compatible with mysql 4.1 ? Rate Topic:

#1 Guest_thewiseoldman_*

#2 Cheule

#3 Guest_thewiseoldman_*

#4 Tim Dorr

#5 Tim Dorr

#6 Nimdock

#7 Guest_thewiseoldman_*

#8 marcele

#9 Nimdock

#10 mrbuzz

#11 cooldude7273

#12 Dr. Bongoots

#13 nexthostbiz

#14 Stewart

#15 princetontiger88

#16 nexthostbiz

#17 princetontiger88

#18 AtariAge

#19 princetontiger88

#20 Tim Dorr

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users

Skin and Language

Execution Stats

Invision Power Services: IS IPB 100% compatible with mysql 4.1 ? - Invision Power Services

General Chat

#1 Guest_thewiseoldman_*

#3 Guest_thewiseoldman_*

#7 Guest_thewiseoldman_*

1 User(s) are reading this topic 0 members, 1 guests, 0 anonymous users

Skin and Language

Execution Stats

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users