database import problem

[minky67]

This is the database problem i have

SQL query:

CREATE TABLE `sn_payment` ( `payment_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Internal payment ID', `payment_status` int(11) DEFAULT '0' COMMENT 'Payment status', `payment_user_id` bigint(20) unsigned DEFAULT NULL, `payment_user_name` varchar(64) DEFAULT NULL, `payment_amount` decimal(60,5) DEFAULT '0.00000' COMMENT 'Amount paid', `payment_currency` varchar(3) DEFAULT '' COMMENT 'Payment currency', `payment_dark_matter_paid` decimal(65,0) DEFAULT '0' COMMENT 'Real DM paid for', `payment_dark_matter_gained` decimal(65,0) DEFAULT '0' COMMENT 'DM gained by player (with bonuses)', `payment_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Payment server timestamp', `payment_comment` text COMMENT 'Payment comment', `payment_module_name` varchar(255) DEFAULT '' COMMENT 'Payment module name', `payment_external_id` varchar(255) DEFAULT '' COMMENT 'External payment ID in payment system', `payment_external_date` datetime DEFAULT [...]

MySQL said: Documentation
#1071 - Specified key was too long; max key length is 1000 bytes

[Gorlum]

What was error message?

[minky67]

Look here
http://i689.photobucket.com/albums/vv25 ... 1c399c.png

[Gorlum]

Change
`payment_module_name` varchar(255) DEFAULT '' COMMENT 'Payment module name',
`payment_external_id` varchar(255) DEFAULT '' COMMENT 'External payment ID in payment system',

From 255 to, say, 120

[minky67]

Worked fine thankyou
one more question how do i change Main e-mail address from root@localhost to the email i wish to use



Хорошо работал спасибо
еще один вопрос, как я могу изменить Главная адрес электронной почты от корневой @ lokalny_host к электронной почте я хочу использовать

[Gorlum]

Worked fine thankyou
one more question how do i change Main e-mail address from root@localhost to the email i wish to use



Хорошо работал спасибо
еще один вопрос, как я могу изменить Главная адрес электронной почты от корневой @ lokalny_host к электронной почте я хочу использовать

Through DB - table `users`

[minky67]

thankyou