error after upgrading sugar to 5.0.0g

[Systems Navigator]

hello,

After I upgraded sugar to version 5.0.0g I got an error while repairing the database.

Repair Database:
Processing database and vardef comparison...
Error creating table: repair_table: Query Failed:CREATE TABLE repair_table (id char(36) NOT NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,project_id char(36) NULL ,projecttask_id char(36) NULL ,projectregistration_date date NOT NULL ,projectregistration_duration float(18,) NOT NULL ,projectregistration_starttime int(11) NOT NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci::MySQL error 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 ') NOT NULL ,projectregistration_starttime int(11) NOT NULL , PRIMARY KEY (id)' at line 1

The table it is about is a custom table which I created via the module builder. I saw various threads about error 1064, but I couldn't fix it with one of them. Does anyone has an idea how to solve this?

Thanks in advance.

OS: Windows 2003 Server R2
Sugar: Version 5.0.0g Pro
Webserver: apache 2.0.59
PHP: Version 5.2.5
Mysql: version 5.0.45

[andopes]

Hi Systems Navigator

The error is in the "projectregistration_duration float( 18, ) NOT NULL ,"
Probably the precision for this field is empty in the vardefs, which generate a sql error.

Look for "projectregistration_duration" into your vardefs files and check if the precision is defined.
Just fix it and click on Quick Repair and Rebuild.

Best regards.

[Systems Navigator]

Thank you very much. This solved the problem. Thjanks for your fast and good response



Regards

[fjhuerte]

Hi andopes,

I am having the same problem but can't trace the problem..
here is the error:

Error creating table: repair_table: Query Failed:CREATE TABLE repair_table (id char(36) NOT NULL ,name varchar(255) NOT NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,case_number varchar(15) NULL ,contact_id char(36) NULL ,interaction_type varchar(100) NOT NULL ,category varchar(100) NOT NULL ,subcategory varchar(100) NOT NULL ,case_status varchar(100) NOT NULL ,case_remarks text NULL ,merchant_name varchar(100) NULL ,transaction_date date NULL ,transaction_amount float NULL ,user_id varchar(50) NULL ,email_address varchar(50) NULL ,statement_date date NULL ,biller varchar(100) NULL ,subscriber_name varchar(100) NULL ,utility_merchant_number varchar(100) NULL ,ten_digit_service_id_number NULL ,nine_digit_service_id_number NULL ,eight_digit_account_number NULL ,mobile_identification_number varchar(25) NULL ,embossed_date date NULL ,preferred_address varchar(100) NULL ,delivery_remarks text NULL ,soa_statement_date date NULL ,current_ba varchar(100) NULL ,soa_preferred_address varchar(100) NULL ,card_number varchar(16) NULL ,from_date datetime NULL ,end_date datetime NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci::MySQL error 1064:

What is causing this?
Thanks!
fjhuerte

[nirmit]

Hi andopes,

I am having the same problem but can't trace the problem..
here is the error:

Error creating table: repair_table: Query Failed:CREATE TABLE repair_table (id char(36) NOT NULL ,name varchar(255) NOT NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,case_number varchar(15) NULL ,contact_id char(36) NULL ,interaction_type varchar(100) NOT NULL ,category varchar(100) NOT NULL ,subcategory varchar(100) NOT NULL ,case_status varchar(100) NOT NULL ,case_remarks text NULL ,merchant_name varchar(100) NULL ,transaction_date date NULL ,transaction_amount float NULL ,user_id varchar(50) NULL ,email_address varchar(50) NULL ,statement_date date NULL ,biller varchar(100) NULL ,subscriber_name varchar(100) NULL ,utility_merchant_number varchar(100) NULL ,ten_digit_service_id_number NULL ,nine_digit_service_id_number NULL ,eight_digit_account_number NULL ,mobile_identification_number varchar(25) NULL ,embossed_date date NULL ,preferred_address varchar(100) NULL ,delivery_remarks text NULL ,soa_statement_date date NULL ,current_ba varchar(100) NULL ,soa_preferred_address varchar(100) NULL ,card_number varchar(16) NULL ,from_date datetime NULL ,end_date datetime NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci::MySQL error 1064:

What is causing this?
Thanks!
fjhuerte

The problem if with

ten_digit_service_id_number NULL ,
nine_digit_service_id_number NULL ,
eight_digit_account_number NULL ,

as no datatype has been specified. Define the datatype in the vardef and repair again.

Peace

[fjhuerte]

ok! I will try this!

Thanks!
fjhuerte

[federico.giunchi]

Hello, I get an error too:

Error creating table: repair_table: Query Failed:CREATE TABLE repair_table (id char(36) NOT NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,salutation varchar(5) NULL ,first_name varchar(100) NULL ,last_name varchar(100) NULL ,title varchar(100) NULL ,department varchar(255) NULL ,do_not_call bool DEFAULT '0' NULL ,phone_home varchar(25) NULL ,phone_mobile varchar(25) NULL ,phone_work varchar(25) NULL ,phone_other varchar(25) NULL ,phone_fax varchar(25) NULL ,primary_address_street varchar(150) NULL ,primary_address_city varchar(100) NULL ,primary_address_state varchar(100) NULL ,primary_address_postalcode varchar(20) NULL ,primary_address_country varchar(255) NULL ,alt_address_street varchar(150) NULL ,alt_address_city varchar(100) NULL ,alt_address_state varchar(100) NULL ,alt_address_postalcode varchar(20) NULL ,alt_address_country varchar(255) NULL ,assistant varchar(75) NULL ,assistant_phone varchar(25) NULL ,lead_source varchar(100) NULL ,reports_to_id char(36) NULL ,birthdate date NULL ,portal_name varchar(255) NULL ,portal_active bool DEFAULT '0' NOT NULL ,portal_app varchar(255) NULL ,campaign_id char(36) NULL , NULL , PRIMARY KEY (id), KEY idx_cont_last_first (last_name, first_name, deleted), KEY idx_contacts_del_last (deleted, last_name), KEY idx_cont_del_reports (deleted, reports_to_id, last_name), KEY idx_reports_to_id (reports_to_id), KEY idx_del_id_user (deleted, id, assigned_user_id), KEY idx_cont_assigned (assigned_user_id)) CHARACTER SET utf8 COLLATE utf8_general_ci::MySQL error 1064:

Thank you in advance.