Loading...
 
Development

Development


MySQL 4.1

posts: 5

So, when will be TW finally fully compatible with MySQL 4.1? And don't tell me that MySQL4.1 compatibility is only priority 1 (low) issue, as it seems from http://dev.tikiwiki.org/tiki-view_tracker_item.php?trackerId=5&itemId=10

And, PLEASE shut up with 'go find tw friendly host'. I'm NOT going to downgrade from my fine hosting.

posts: 2881 United Kingdom

Hello.

Well after bringing the issue up with marclaporte, mysql 4.1 support will NOT be happening for a long time.

So if you want to use TikiWiki use a friendly compatible host, or go find another CMS.

Damian
http://tikihost.net


posts: 1630 Canada

Hi Analytik!

Tiki strives to be useable by as many databases as possible. This is why we use the ADOdb abstraction layer.

The tracker you link to mentions Mysql 5 Alpha, not 4.1. Even so, I have increased the priority level.

I mentioned to Damian on IRC that lack of mysql 4.1 support is not a blocker bug for 1.9.0 We will look into this for 1.9.1 Please report any issues with Tiki 1.9.x & mysql 4.1 on dev.tikiwiki.org with as much detail.

Best regards,

M ;-)

posts: 5

Thanks for reply!

Well, it's sad to see that it won't happen anytime soon, but I understand it's no easy task.

TW is great project and I'll be using it on all my appropriate webs as soon as it will work on 4.1. Hopefully even donate with few bucks or at least some code changes. Good luck until then!


posts: 5

Well, I could not resist and try to run TW190 on MySQL4.1. It worked if on my WAMP localhost, but has some strange issues on Unix production server.

Nevermind, here's a little help for whoever cares - some table modifications to fit into MySQL 4.1 limit of 1000Bytes for indexes (like primary key). With UTF8 charset this is a problem since 1 character = 3 Bytes in UTF8. I had to cut most fields into VARCHAR(150) and I don't guarantee one bit that it'll work.

Image
Copy to clipboard
ALTER TABLE `tiki_newsreader_marks` CHANGE `user` `user` VARCHAR( 150 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL , CHANGE `serverId` `serverId` INT( 12 ) DEFAULT '0' NOT NULL , CHANGE `groupName` `groupName` VARCHAR( 150 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL , CHANGE `timestamp` `timestamp` INT( 14 ) DEFAULT '0' NOT NULL; ALTER TABLE `tiki_page_footnotes` CHANGE `user` `user` VARCHAR( 150 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL , CHANGE `pageName` `pageName` VARCHAR( 150 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL , CHANGE `data` `data` TEXT CHARACTER SET utf8 COLLATE utf8_slovak_ci DEFAULT NULL; ALTER TABLE `tiki_searchindex` CHANGE `searchword` `searchword` VARCHAR( 80 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL , CHANGE `location` `location` VARCHAR( 80 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL , CHANGE `page` `page` VARCHAR( 150 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL , CHANGE `count` `count` INT( 11 ) DEFAULT '1' NOT NULL , CHANGE `last_update` `last_update` INT( 11 ) DEFAULT '0' NOT NULL; ALTER TABLE `tiki_secdb` CHANGE `md5_value` `md5_value` VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL , CHANGE `filename` `filename` VARCHAR( 240 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL , CHANGE `tiki_version` `tiki_version` VARCHAR( 60 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL , CHANGE `severity` `severity` INT( 4 ) DEFAULT '0' NOT NULL; ALTER TABLE `tiki_user_assigned_modules` CHANGE `name` `name` VARCHAR( 150 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL , CHANGE `position` `position` CHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci DEFAULT NULL , CHANGE `ord` `ord` INT( 4 ) DEFAULT NULL , CHANGE `type` `type` CHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci DEFAULT NULL , CHANGE `user` `user` VARCHAR( 150 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL; ALTER TABLE `tiki_user_taken_quizzes` CHANGE `user` `user` VARCHAR( 150 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL , CHANGE `quizId` `quizId` VARCHAR( 150 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL; ALTER TABLE `tiki_user_votings` CHANGE `user` `user` VARCHAR( 150 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL , CHANGE `id` `id` VARCHAR( 150 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL , CHANGE `optionId` `optionId` INT( 10 ) DEFAULT '0' NOT NULL; ALTER TABLE `tiki_user_watches` CHANGE `user` `user` VARCHAR( 150 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL , CHANGE `event` `event` VARCHAR( 40 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL , CHANGE `object` `object` VARCHAR( 140 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL , CHANGE `hash` `hash` VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci DEFAULT NULL , CHANGE `title` `title` VARCHAR( 250 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci DEFAULT NULL , CHANGE `type` `type` VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci DEFAULT NULL , CHANGE `url` `url` VARCHAR( 250 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci DEFAULT NULL , CHANGE `email` `email` VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci DEFAULT NULL;

Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting