Joomla Templates Club 406,261 posts

[mufassa Friend mufassaJoin date: October 2007Posts: 5Downloads:0Uploads:0]

#123077

When I run the database creation it returns the following error, anybody have any ideas

SQL=Data truncated for column ‘bank_account_type’ at row 1 SQL=–
n– Dumping data for table `jos_vm_order_user_info`
n–
n
nINSERT INTO `jos_vm_order_user_info` (`order_info_id`, `order_id`, `user_id`, `address_type`, `address_type_name`, `company`, `title`, `last_name`, `first_name`, `middle_name`, `phone_1`, `phone_2`, `fax`, `address_1`, `address_2`, `city`, `state`, `country`, `zip`, `user_email`, `extra_field_1`, `extra_field_2`, `extra_field_3`, `extra_field_4`, `extra_field_5`, `bank_account_nr`, `bank_name`, `bank_sort_code`, `bank_iban`, `bank_account_holder`, `bank_account_type`) VALUES (1, 1, 67, ‘BT’, ‘-default-‘, ‘joom’, ‘Mr.’, ‘cuong’, ‘vu’, ‘quang’, ‘0912580018’, ”, ”, ‘118 pho hue’, ”, ‘hanoi’, ”, ‘VNM’, ‘084’, ‘cuongvq@joomlancers.com’, ”, ”, ”, ”, ”, ”, ”, ”, ”, ”, ”):
– – – – – – – – – –
—
— Dumping data for table `#__vm_order_user_info`
—

INSERT INTO `#__vm_order_user_info` (`order_info_id`, `order_id`, `user_id`, `address_type`, `address_type_name`, `company`, `title`, `last_name`, `first_name`, `middle_name`, `phone_1`, `phone_2`, `fax`, `address_1`, `address_2`, `city`, `state`, `country`, `zip`, `user_email`, `extra_field_1`, `extra_field_2`, `extra_field_3`, `extra_field_4`, `extra_field_5`, `bank_account_nr`, `bank_name`, `bank_sort_code`, `bank_iban`, `bank_account_holder`, `bank_account_type`) VALUES (1, 1, 67, ‘BT’, ‘-default-‘, ‘joom’, ‘Mr.’, ‘cuong’, ‘vu’, ‘quang’, ‘0912580018’, ”, ”, ‘118 pho hue’, ”, ‘hanoi’, ”, ‘VNM’, ‘084’, ‘cuongvq@joomlancers.com’, ”, ”, ”, ”, ”, ”, ”, ”, ”, ”, ”)
= = = = = = = = = =

[mufassa Friend mufassaJoin date: October 2007Posts: 5Downloads:0Uploads:0]

#230623

Anybody, I have tried the Joomla installation over and over using the site wizard and every time it populates the MySQL database I get the same error, someone please HELP.

[Michael Casha Friend Michael CashaJoin date: September 2014Posts: 2561Downloads:1Uploads:32 Thanks: 41 Thanked: 119 times in 1 posts]

#230637

Is there something wrong with the .sql file maybe?

[mufassa Friend mufassaJoin date: October 2007Posts: 5Downloads:0Uploads:0]

#231015

Use MYSQL 4.0 and not 5 and it will be fine, had the same problem

[Author]

Posts