vtiger

[amirmofidi]

Hi!

I'm trying to install vtiger 4.2.4 on a hosted linux server. I don't have access to the php.ini file and i get stuck on step 5 everytime.

I've tried to create the tables manually with the vtigercrm-4.2.3.sql file but i get the following error:

Quote:
CREATE TABLE `CustomerDetails` (
`customerid` int( 19 ) NOT NULL ,
`portal` varchar( 3 ) default NULL ,
`support_start_date` date default NULL ,
`support_end_date` date default NULL ,
PRIMARY KEY ( `customerid` )
)ENGINE = MYISAM DEFAULT CHARSET = latin1

MySQL sa:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 7


PHP Version 5.1.4
MySQL 4.0.24

Please, can anyone help me here?
I'm stuck.

[philip]

Hi,

In MySQL 4.0.x, if a dump file has 'DEFAULT CHARSET=latin1' at the end of table creation command, will thrown exception, try removing the text 'DEFAULT CHARSET=latin1' from sql file and then dump it.

Regards,
Philip

[amirmofidi]

Thx!

That helped but I ran in to new problems.
I removed all DEFAULT CHARSET=latin1; and got the following error

Quote: CREATE TABLE `files` (
`id` varchar( 36 ) NOT NULL ,
`name` varchar( 36 ) default NULL ,
`content` longblob,
`deleted` int( 1 ) NOT NULL default '0',
`date_entered` timestamp NOT NULL defaultCURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`assigned_user_id` varchar( 36 ) default NULL ,
PRIMARY KEY ( `id` ) ,
KEY `idx_cont_owner_id_and_name` ( `assigned_user_id` , `name` , `deleted` )
)ENGINE = MYISAM

MySQL sa:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`assigned_use