Still no MySQL 5 support?

General questions relating to Joomla! There are other boards for more specific help on Joomla! features and extensions.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Locked
jljubich
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Sun Jan 15, 2006 5:19 pm
Location: Córdoba, Argentina

Still no MySQL 5 support?

Post by jljubich » Sun Jan 15, 2006 5:27 pm

I have waited Joomla 1.0.6 for days! Still no MySQL 5 support?

User avatar
benedikt
Joomla! Explorer
Joomla! Explorer
Posts: 346
Joined: Mon Aug 22, 2005 2:29 pm
Location: Gent - Belgium

Re: Still no MySQL 5 support?

Post by benedikt » Sun Jan 15, 2006 5:38 pm

As stated in the roadmap, MySQL will probably be supported in the 1.1 release

jljubich
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Sun Jan 15, 2006 5:19 pm
Location: Córdoba, Argentina

Re: Still no MySQL 5 support?

Post by jljubich » Sun Jan 15, 2006 5:46 pm

Is there anything I can do to have Joomla working with MySQL 5 in the meantime?

User avatar
benedikt
Joomla! Explorer
Joomla! Explorer
Posts: 346
Joined: Mon Aug 22, 2005 2:29 pm
Location: Gent - Belgium

Re: Still no MySQL 5 support?

Post by benedikt » Sun Jan 15, 2006 5:59 pm

I'm not sure.
Maybe there's something here: http://forum.joomla.org/index.php/topic ... #msg156917
If you do a search on MySQL 5, you'll find lots of other treads that might be of use.

edit
Here's another one: http://forum.joomla.org/index.php/topic,23659.0.html
(oops... didn't see Tonie's post)
Last edited by benedikt on Sun Jan 15, 2006 6:02 pm, edited 1 time in total.

User avatar
Tonie
Joomla! Master
Joomla! Master
Posts: 16584
Joined: Thu Aug 18, 2005 7:13 am

Re: Still no MySQL 5 support?

Post by Tonie » Sun Jan 15, 2006 6:00 pm

You can read this thread. When checking the Joomla 1.0.6 files, which will be rereleased because of an SVN packaging function, I see the following file /includes/database.mysql5.php. I haven't heard from Masterchief yet, but my guess is that you would have to rename database.php to something else and then rename the database.mysql5.php to database.php.

jljubich
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Sun Jan 15, 2006 5:19 pm
Location: Córdoba, Argentina

Re: Still no MySQL 5 support?

Post by jljubich » Sun Jan 15, 2006 6:04 pm

Tonie wrote: ...I see the following file /includes/database.mysql5.php. I haven't heard from Masterchief yet, but my guess is that you would have to rename database.php to something else and then rename the database.mysql5.php to database.php.
That's what I did (after installing Joomla); but got following error...

Code: Select all

Fatal error: Call to undefined method mosSession::_setSchema() in D:\...\wwwroot\includes\database.php on line 757
Do you think I have to install Joomla again; but, renaming the database.mysql5.php to database.php, before?

Best regards,

Jorge.-

User avatar
Tonie
Joomla! Master
Joomla! Master
Posts: 16584
Joined: Thu Aug 18, 2005 7:13 am

Re: Still no MySQL 5 support?

Post by Tonie » Sun Jan 15, 2006 6:07 pm

I will test this when the patch is officially there, I just build a Mysql 5 test system.

jljubich
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Sun Jan 15, 2006 5:19 pm
Location: Córdoba, Argentina

Re: Still no MySQL 5 support?

Post by jljubich » Sun Jan 15, 2006 6:11 pm

Tonie wrote: I will test this when the patch is officially there, I just build a Mysql 5 test system.
Do you mean the package I have recently (a couple of minutes ago) downloaded from joomla.org is not official or has bugs?

User avatar
benedikt
Joomla! Explorer
Joomla! Explorer
Posts: 346
Joined: Mon Aug 22, 2005 2:29 pm
Location: Gent - Belgium

Re: Still no MySQL 5 support?

Post by benedikt » Sun Jan 15, 2006 6:13 pm

Something went wrong with the SVN packaging function.
see http://forum.joomla.org/index.php/topic ... #msg173300

jljubich
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Sun Jan 15, 2006 5:19 pm
Location: Córdoba, Argentina

Re: Still no MySQL 5 support?

Post by jljubich » Sun Jan 15, 2006 6:16 pm

benedikt wrote: Something went wrong with the SVN packaging function.
see http://forum.joomla.org/index.php/topic ... #msg173300
Oh, man... then, there is a light of hope having Joomla running with MySQL 5!

jljubich
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Sun Jan 15, 2006 5:19 pm
Location: Córdoba, Argentina

Re: Still no MySQL 5 support?

Post by jljubich » Sun Jan 15, 2006 6:58 pm

Tonie wrote: I will test this when the patch is officially there, I just build a Mysql 5 test system.
Same error with database.mysql5.php in new package...

Code: Select all

Fatal error: Call to undefined method mosSession::_setSchema() in D:\...\wwwroot\includes\database.php on line 757

jljubich
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Sun Jan 15, 2006 5:19 pm
Location: Córdoba, Argentina

Re: Still no MySQL 5 support?

Post by jljubich » Mon Jan 16, 2006 3:26 pm

Tonie wrote: I will test this when the patch is officially there, I just build a Mysql 5 test system.
Could you test it? Some workaround on Joomla with MySQL 5?

User avatar
Tonie
Joomla! Master
Joomla! Master
Posts: 16584
Joined: Thu Aug 18, 2005 7:13 am

Re: Still no MySQL 5 support?

Post by Tonie » Mon Jan 16, 2006 8:40 pm

I have installed, but no go yet. Problems with the default install, no site with the renaming of the Mysql 5 php files.

User avatar
evil-bert
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Tue Jan 31, 2006 10:02 am
Location: Germany
Contact:

Re: Still no MySQL 5 support?

Post by evil-bert » Tue Jan 31, 2006 2:16 pm

I had the same problem with MySQL 5.0.16 and joomla 1.0.7. I renamed the database.mysql5.php to database.php, but I got the same error with the missing "method mosSession::_setSchema()" or (without php error-reporting) a blank site.

After some hard minutes testing and debugging, I found the correct method at the database.mysql5.php.
The setSchema-method is there (some lines above 757), but I think there is a problem with the name. The getSchema-method is named like &_MethodName, but the setSchema-method comes without the &_. After I renamed the setSchema-method to &_setSchema everything works fine with mysql 5.0.16 ...

I have no time at the moment to figure out everything at my site, but what I saw that works good.

User avatar
Tonie
Joomla! Master
Joomla! Master
Posts: 16584
Joined: Thu Aug 18, 2005 7:13 am

Re: Still no MySQL 5 support?

Post by Tonie » Tue Jan 31, 2006 2:35 pm

My test Joomla is running happily on PHP5 and Mysql 5 now. Now to start getting functionality in there to test the rest.

jljubich
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Sun Jan 15, 2006 5:19 pm
Location: Córdoba, Argentina

Re: Still no MySQL 5 support?

Post by jljubich » Tue Jan 31, 2006 3:07 pm

Tonie wrote: My test Joomla is running happily on PHP5 and Mysql 5 now. Now to start getting functionality in there to test the rest.
Could you please describe your tests to replicate them here?

Best regards,

Jorge.-

User avatar
Tonie
Joomla! Master
Joomla! Master
Posts: 16584
Joined: Thu Aug 18, 2005 7:13 am

Re: Still no MySQL 5 support?

Post by Tonie » Tue Jan 31, 2006 3:09 pm

I basically had to remove 'Strict' mode in the Mysql file my.ini. I now have a default install with no content or components, but this works without problems. I will first have to create my content migration script to go from Mysql 4.0.x --> Mysql 5 and from character set Latin to UTF.

jljubich
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Sun Jan 15, 2006 5:19 pm
Location: Córdoba, Argentina

Re: Still no MySQL 5 support?

Post by jljubich » Tue Jan 31, 2006 3:19 pm

Tonie wrote: I basically had to remove 'Strict' mode in the Mysql file my.ini.
Yes, that's what I did some time ago. I had to set error level to none, too, to avoid several warnings. I am still having some troubles with 3rd. party modules such SimpleFAQ 2.11 (not neccesarily related with SQL 5, but, probably).

andy61
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Fri Feb 17, 2006 10:26 am

SOLUTION to MySQL 5 support?

Post by andy61 » Fri Feb 17, 2006 11:13 am

the problem is due to a couple of bugs in database.mysql5.php (to be renamed database.php).
  • in line 741, the function setSchema() should be renamed to _setSchema()
  • in line 755 - function _getSchema() - the & must be removed
my versions:
  • Win XP SP2
  • mySQL 5.0.17-nt
  • Joomla! v1.0.7

User avatar
stingrey
Joomla! Hero
Joomla! Hero
Posts: 2756
Joined: Mon Aug 15, 2005 4:36 pm
Location: Marikina, Metro Manila, Philippines
Contact:

Re: SOLUTION to MySQL 5 support?

Post by stingrey » Fri Feb 17, 2006 1:12 pm

andy61 wrote: the problem is due to a couple of bugs in database.mysql5.php (to be renamed database.php).
  • in line 741, the function setSchema() should be renamed to _setSchema()
  • in line 755 - function _getSchema() - the & must be removed
Thank you corrected and will be available in 1.0.8

For future reference, please report bugs here:
http://developer.joomla.org/sf/tracker/ ... acker.bugs
Rey Gigataras
http://www.wizmediateam.com <-- great team of talented Web Designers and Programmers!
http://about.me/reygigataras <-- About Me :)
Partner, Business Development & Project Manager, Event Manager, Sports Coach :D


Locked

Return to “General Questions - 1.0.x”