Sunday, October 15, 2006

How to install Joomla 1.0.11 with Mysql 5

Started to get installation errors in step 2 inserting data in the db. Such as:

SQL=BLOB/TEXT column \'text\' can\'t have a default value SQL=# Table structure for table `jos_poll_data`\n\nCREATE TABLE `jos_poll_data` (\n `id` int(11) NOT NULL auto_increment,\n `pollid` int(4) NOT NULL default \'0\',\n `text` text NOT NULL default \'\',\n `hits` int(11) NOT NULL default \'0\',\n PRIMARY KEY (`id`),\n KEY `pollid` (`pollid`,`text`(1))\n) TYPE=MyISAM:- - - - - - - - - -# Table structure for table `#__poll_data`CREATE TABLE `#__poll_data` ( `id` int(11) NOT NULL auto_increment, `pollid` int(4) NOT NULL default '0', `text` text NOT NULL default '', `hits` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `pollid` (`pollid`,`text`(1))) TYPE=MyISAM= = = = = = = = = =


I tried fixing the joomla.sql file like some of the other posts such as http://forum.joomla.org/index.php/topic,103176.msg522184.html#msg522184 but kept getting more errors. So instead to solve the problem I just launched the Mysql instance config wizard and set the database to not be "strict". The installation worked fine after

6 Comments:

Anonymous Anonymous said...

You are the man! I spent hours trying to figure out why I couldn't get past step 2.

Thank you so much!

8:43 PM  
Anonymous Anonymous said...

Found this post at 5:07 PM; site was up and running at 5:08. Spent most of the afternoon trying to figure this one out. Thanks!!!

11:12 PM  
Anonymous Anonymous said...

I will echo the other comments, your tip got me over the hump and joomla is now running. It's odd, I've installed Joomla several times, and never had this problem.

Thanks!

4:59 PM  
Anonymous Anonymous said...

hello,

I see that this solution works!
How do you set the database to not be "strict" in the the Mysql instance config wizard?

Greetz

10:49 AM  
Blogger Lee said...

Hi thanks for all the compliments. Just trying to give back to all the others who have saved me!

Launch the Instance Configuration Wizard
1. choose reconfigure instance -> next
2. choose detailed configuration -> next
3. choose type of machine -> next
4. choose database usage -> next
5. modify tablespace settings if needed -> next
6. Set number of concurrent connections if needed -> next
7. On this screen is the networking options where the "Enable Strict Mode" is!!!!

Keep going through next till done.
Good luck.

7:24 PM  
Anonymous Nemanja Simovic said...

You can change my.ini file wich is located in \program files\mysql\mysql server 6.0\. Simply delete "STRICT_TRANS_TABLES" from variable sql_mode

# Set the SQL mode to strict
#sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

After that run c:\WINDOWS\system32\services.msc and restart mysql service.

11:25 AM  

Post a Comment

Links to this post:

Create a Link

<< Home