Webmaster Forum Forum Index Webmaster Forum
Tiger Team Solutions Tech Support
 
 FAQFAQ   SearchSearch   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

MySQL 4.0 or 5.0 for Joomla?

 
Post new topic   Reply to topic    Webmaster Forum Forum Index -> Joomla Help
View previous topic :: View next topic  
Author Message
twin_rotor
Senior Tiger Member
Senior Tiger Member


Joined: 01 Aug 2007
Posts: 116
Location: Russvegas

PostPosted: Fri Sep 21, 2007 8:42 am    Post subject: MySQL 4.0 or 5.0 for Joomla?

I have the option to use either. Which do you prefer?

I'm actually in the process of installing it to see how it is.. Smile

EDIT: I went ahead and did the database in v.5, but I'd still like to hear your input on what version is best for Joomla. I searched the Joomla forum and found people installing on both versions, so I figured what the heck.

This is actually the first database my provider has offered in v.5 without a disclamer/warning... It use to give a warning that v.5 was unstable.
_________________
www.alliedcombatexperts.org
Back to top
TigerBot
Tiger Member


Joined: 19 Jun 2007




PostPosted: Fri Sep 21, 2007 8:42 am    Post subject: Sponsored Advertisement




_________________
TigerBot
Back to top
Staff
Tiger Member
Tiger Member


Joined: 03 Jul 2007
Posts: 91

PostPosted: Fri Sep 21, 2007 12:32 pm    Post subject:

We have tried our best to stay away from v5, but recently our host told us they were not going to offer any more v4 databases.

So we have recently started to use v5 and everything is going good so far, however I do remember a few months ago we ran into problems trying to use v5. I guess they must have fixed it since then. We're keeping our fingers crossed.

I think it is inevitable that everyone will have to go to v5 eventually, so you might as well join the crowd.
Back to top
twin_rotor
Senior Tiger Member
Senior Tiger Member


Joined: 01 Aug 2007
Posts: 116
Location: Russvegas

PostPosted: Sat Sep 22, 2007 12:18 pm    Post subject:

Thank you for your response, Sir.

I ened up using a MySQL v5 datbase because I wasn't sure if I could use PHP 5 with a MySQL v4 database. Here is why I'm running the Joomla PHP script in version 5:

PHP 4 registrer globals are set "On" by defualt.
I cannot use php commands in any .htacess file I upload to set register globals "Off"(I can't even modify my root .htaccess file. This is all restricted by my host.).
I have no SSH access, so running scripts to upload mutiple php.ini files was out of the question. I wasn't about to sit here and upload a php.ini file to each directory(I started to, but man it was taking forever).

After all that, I finally read that PHP 5 default register global settings is "Off". So I simply moddified the Joomla .htaccess file with the extra line at the end to run PHP5(Addtype is one command allowed by my host):

Code:
##
# @version $Id: htaccess.txt 4094 2006-06-21 18:35:46Z stingrey $
# @package Joomla
# @copyright Copyright (C) 2005 - 2006 Open Source Matters. All rights reserved.
# @license GNU/GPL
# Joomla! is Free Software
##

#####################################################
#  READ THIS COMPLETELY IF YOU CHOOSE TO USE THIS FILE
#
# The line just below this section: 'Options +FollowSymLinks' may cause problems
# with some server configurations.  It is required for use of mod_rewrite, but may already
# be set by your server administrator in a way that dissallows changing it in
# your .htaccess file.  If using it causes your server to error out, comment it out (add # to
# beginning of line), reload your site in your browser and test your sef url's.  If they work,
# it has been set by your server administrator and you do not need it set here.
#
# Only use one of the two SEF sections that follow.  Lines that can be uncommented
# (and thus used) have only one #.  Lines with two #'s should not be uncommented
# In the section that you don't use, all lines should start with #
#
#####################################################

#####  SOLVING PROBLEMS WITH COMPONENT URL's that don't work #####
# SPECIAL NOTE FOR SMF USERS WHEN SMF IS INTEGRATED AND BRIDGED
# OR ANY SITUATION WHERE A COMPONENT's URL's AREN't WORKING
#
# In both the 'Standard SEF', and '3rd Party or Core SEF' sections the line:
# RewriteCond %{REQUEST_URI} ^(/component/option,com) [NC,OR] ##optional - see notes##
# May need to be uncommented.  If you are running your Joomla from
# a subdirectory the name of the subdirectory will need to be inserted into this
# line.  For example, if your Joomla is in a subdirectory called '/test/',
# change this:
# RewriteCond %{REQUEST_URI} ^(/component/option,com) [NC,OR] ##optional - see notes##
# to this:
# RewriteCond %{REQUEST_URI} ^(/test/component/option,com) [NC,OR] ##optional - see notes##
#
#####################################################


##  Can be commented out if causes errors, see notes above.
Options +FollowSymLinks

#
#  mod_rewrite in use

RewriteEngine On


#  Uncomment following line if your webserver's URL
#  is not directly related to physical file paths.
#  Update Your Joomla Directory (just / for root)

# RewriteBase /


########## Begin - Joomla! core SEF Section
############# Use this section if you are using a 3rd party (Non Joomla! core) SEF extension - e.g. OpenSEF, 404_SEF, 404SEFx, SEF Advance, etc
#
#RewriteCond %{REQUEST_URI} ^(/component/option,com) [NC,OR]       ##optional - see notes##
RewriteCond %{REQUEST_URI} (/|\.htm|\.php|\.html|/[^.]*)$  [NC]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule (.*) index.php
AddType x-mapp-php5 .php
#
########## End - Joomla! core SEF Section


Now for the fun stuff... Smile BTW, I'm also using v1.5 of Joomla.
_________________
www.alliedcombatexperts.org
Back to top
bsmith
Graphics Guru
Graphics Guru


Joined: 19 Jun 2007
Posts: 678
Location: Arkansas, USA

PostPosted: Sat Sep 22, 2007 10:55 pm    Post subject:

if you need help figuring out how to skin things... let me know. I can rock a joomla template pretty hard. And made somethings work that others have thought was impossible... (got to think outside of the box sometimes) Smile
_________________
If you have an an urgent question, please call me.
Spam will be removed.
Back to top
twin_rotor
Senior Tiger Member
Senior Tiger Member


Joined: 01 Aug 2007
Posts: 116
Location: Russvegas

PostPosted: Sun Sep 23, 2007 10:35 am    Post subject:

Thanks Brian, I appreciate that. I'm not sure if I'm going to move ahead with it or not. Right now, my biggest concern is the lack time I have to work on it. I don't want to leave my guys hanging with a half devolped site. Not that its a big deal at all, but what I have works great for what we are doing currently.
_________________
www.alliedcombatexperts.org
Back to top
Display posts from previous:   
Post new topic   Reply to topic    Webmaster Forum Forum Index -> Joomla Help All times are GMT - 6 Hours
Page 1 of 1

 
Jump to:  
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 vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group