| View previous topic :: View next topic |
| Author |
Message |
internet.news
-
Joined: 06 Nov 2005
Posts: 1
|
 Posted: Sun Nov 06, 2005 11:11 pm Post subject: Invision Board - Error @ Installing... |
 |
|
I installed PHP5 + MySql 5 and started
sm_install.php for the invision forum to
install it, but then I got the following
error:
Warning!
The following errors must be rectified before continuing!
Please go back and try again!
mySQL Error: Invalid default value for 'macro_set'
Query:CREATE TABLE sharenoevil_macro ( macro_id smallint(3) NOT NULL auto_increment, macro_value varchar(200) default NULL, macro_replace text, can_remove tinyint(1) default '0', macro_set smallint(3) NOT NULL default '', PRIMARY KEY (macro_id), KEY macro_set (macro_set) ) TYPE=MyISAM;
Can anyone help me? |
|
| Back to top |
   |
 |
aprelium
-
Joined: 22 Mar 2002
Posts: 6800
|
| Posted: Mon Nov 07, 2005 10:29 am Post subject: Re: Invision Board - Error @ Installing... |
|
|
internet.news,
Several scripts are not compatible with MySQL 5. So when a script reports errors in MySQL queries, try downgrading to MySQL 4. This is for example the case with Mambo.
But we recommend asking the question on SM forums. May be they can give you a better advice or refer you to a patch to fix this issue.
_________________
Support Team
Aprelium - http://www.aprelium.com |
|
| Back to top |
 |
|
btos
-
Joined: 10 Feb 2006
Posts: 15
|
| Posted: Sun Feb 19, 2006 8:30 pm Post subject: Mambo |
|
|
| Which version of Mambo is incompatible with PHP5 & MySql? I've not heard that one yet but then I'm new to php. I've got both set up for testing when I get the time but from what I've read so far, I'm really going to be abusing myself if I run the gauntlet. On the upside, I'll have a cool set-up that will streamline website developement. Any clues are valuable. Thanks. |
|
| Back to top |
 |
|
aprelium
-
Joined: 22 Mar 2002
Posts: 6800
|
| Posted: Mon Feb 20, 2006 11:19 am Post subject: Re: Mambo |
|
|
btos,
Officially Mambo can run on PHP 5. But many people will encounter problems with it on PHP 5. So if you're new to PHP, it's wiser to use it with PHP 4. From a performance point of view, PHP 4 and 5 are very close. It's just to save your time and make the deployment of Mambo less frustrating.
_________________
Support Team
Aprelium - http://www.aprelium.com |
|
| Back to top |
|
|
|
