The Joomla! Forum ™

Download

Demo


Board index » Joomla! Older Version Support » Joomla! 1.0 » General Questions - 1.0.x

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.



Post new topic Reply to topic  Page 1 of 1
  [ 20 posts ] 
  Print view Previous topic | Next topic 
Author Message
jljubich
PostPosted: Sun Jan 15, 2006 5:27 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Sun Jan 15, 2006 5:19 pm
Posts: 10
Location: Córdoba, Argentina
I have waited Joomla 1.0.6 for days! Still no MySQL 5 support?
Top
 Profile  
 
benedikt
PostPosted: Sun Jan 15, 2006 5:38 pm 
User avatar
Joomla! Explorer
Joomla! Explorer
Offline

Joined: Mon Aug 22, 2005 2:29 pm
Posts: 346
Location: Gent - Belgium
As stated in the roadmap, MySQL will probably be supported in the 1.1 release
Top
 Profile  
 
jljubich
PostPosted: Sun Jan 15, 2006 5:46 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Sun Jan 15, 2006 5:19 pm
Posts: 10
Location: Córdoba, Argentina
Is there anything I can do to have Joomla working with MySQL 5 in the meantime?
Top
 Profile  
 
benedikt
PostPosted: Sun Jan 15, 2006 5:59 pm 
User avatar
Joomla! Explorer
Joomla! Explorer
Offline

Joined: Mon Aug 22, 2005 2:29 pm
Posts: 346
Location: Gent - Belgium
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.

Top
 Profile  
 
Tonie
PostPosted: Sun Jan 15, 2006 6:00 pm 
User avatar
Joomla! Master
Joomla! Master
Offline

Joined: Thu Aug 18, 2005 7:13 am
Posts: 16009
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.

_________________
Joomla forum global moderator.

Take care
Top
 Profile  
 
jljubich
PostPosted: Sun Jan 15, 2006 6:04 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Sun Jan 15, 2006 5:19 pm
Posts: 10
Location: Córdoba, Argentina
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:
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.-
Top
 Profile  
 
Tonie
PostPosted: Sun Jan 15, 2006 6:07 pm 
User avatar
Joomla! Master
Joomla! Master
Offline

Joined: Thu Aug 18, 2005 7:13 am
Posts: 16009
I will test this when the patch is officially there, I just build a Mysql 5 test system.

_________________
Joomla forum global moderator.

Take care
Top
 Profile  
 
jljubich
PostPosted: Sun Jan 15, 2006 6:11 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Sun Jan 15, 2006 5:19 pm
Posts: 10
Location: Córdoba, Argentina
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?
Top
 Profile  
 
benedikt
PostPosted: Sun Jan 15, 2006 6:13 pm 
User avatar
Joomla! Explorer
Joomla! Explorer
Offline

Joined: Mon Aug 22, 2005 2:29 pm
Posts: 346
Location: Gent - Belgium
Something went wrong with the SVN packaging function.
see http://forum.joomla.org/index.php/topic ... #msg173300
Top
 Profile  
 
jljubich
PostPosted: Sun Jan 15, 2006 6:16 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Sun Jan 15, 2006 5:19 pm
Posts: 10
Location: Córdoba, Argentina
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!
Top
 Profile  
 
jljubich
PostPosted: Sun Jan 15, 2006 6:58 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Sun Jan 15, 2006 5:19 pm
Posts: 10
Location: Córdoba, Argentina
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:
Fatal error: Call to undefined method mosSession::_setSchema() in D:\...\wwwroot\includes\database.php on line 757
Top
 Profile  
 
jljubich
PostPosted: Mon Jan 16, 2006 3:26 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Sun Jan 15, 2006 5:19 pm
Posts: 10
Location: Córdoba, Argentina
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?
Top
 Profile  
 
Tonie
PostPosted: Mon Jan 16, 2006 8:40 pm 
User avatar
Joomla! Master
Joomla! Master
Offline

Joined: Thu Aug 18, 2005 7:13 am
Posts: 16009
I have installed, but no go yet. Problems with the default install, no site with the renaming of the Mysql 5 php files.

_________________
Joomla forum global moderator.

Take care
Top
 Profile  
 
evil-bert
PostPosted: Tue Jan 31, 2006 2:16 pm 
User avatar
Joomla! Fledgling
Joomla! Fledgling
Offline

Joined: Tue Jan 31, 2006 10:02 am
Posts: 1
Location: Germany
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.
Top
 Profile  
 
Tonie
PostPosted: Tue Jan 31, 2006 2:35 pm 
User avatar
Joomla! Master
Joomla! Master
Offline

Joined: Thu Aug 18, 2005 7:13 am
Posts: 16009
My test Joomla is running happily on PHP5 and Mysql 5 now. Now to start getting functionality in there to test the rest.

_________________
Joomla forum global moderator.

Take care
Top
 Profile  
 
jljubich
PostPosted: Tue Jan 31, 2006 3:07 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Sun Jan 15, 2006 5:19 pm
Posts: 10
Location: Córdoba, Argentina
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.-
Top
 Profile  
 
Tonie
PostPosted: Tue Jan 31, 2006 3:09 pm 
User avatar
Joomla! Master
Joomla! Master
Offline

Joined: Thu Aug 18, 2005 7:13 am
Posts: 16009
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.

_________________
Joomla forum global moderator.

Take care
Top
 Profile  
 
jljubich
PostPosted: Tue Jan 31, 2006 3:19 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Sun Jan 15, 2006 5:19 pm
Posts: 10
Location: Córdoba, Argentina
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).
Top
 Profile  
 
andy61
PostPosted: Fri Feb 17, 2006 11:13 am 
Joomla! Fledgling
Joomla! Fledgling
Offline

Joined: Fri Feb 17, 2006 10:26 am
Posts: 1
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
Top
 Profile  
 
stingrey
PostPosted: Fri Feb 17, 2006 1:12 pm 
User avatar
Joomla! Hero
Joomla! Hero
Offline

Joined: Mon Aug 15, 2005 4:36 pm
Posts: 2756
Location: Marikina, Metro Manila, Philippines
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 - Joomlatools Team Member
http://www.joomlatools.eu <-- Joomla extensions that just work
http://path.to/rey.gigataras <-- About Me :)
Online Community Manager, Support Engineer, Web Developer, Event Manager, Sports Coach :D
Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 1
  [ 20 posts ] 


Board index » Joomla! Older Version Support » Joomla! 1.0 » General Questions - 1.0.x

Who is online

Users browsing this forum: No registered users and 8 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group