| forum.bitel.ru http://forum.bitel.ru/ |
|
| Тип поля "Комментарий" у дома в БД http://forum.bitel.ru/viewtopic.php?f=49&t=11901 |
Страница 1 из 1 |
| Автор: | igimux [ 30 авг 2016, 12:52 ] |
| Заголовок сообщения: | Тип поля "Комментарий" у дома в БД |
Добрый день! В базе данных в таблице address_house поле comment типа varchar(100). Можно его обновить до типа text? |
|
| Автор: | skn [ 30 авг 2016, 14:38 ] |
| Заголовок сообщения: | Re: Тип поля "Комментарий" у дома в БД |
Попрбуйте |
|
| Автор: | Администратор [ 30 авг 2016, 23:31 ] |
| Заголовок сообщения: | Re: Тип поля "Комментарий" у дома в БД |
Изменение типа колонки в БД проблем вызвать не должно. Для скрипта начального создания БД тип изменен. Запрос обновления существующих БД делать не стал, т.к. таблица довольно большая, может исполняться медленно. При необходимости клиенты могут сами сделать ALTER. |
|
| Автор: | igimux [ 31 авг 2016, 06:11 ] |
| Заголовок сообщения: | Re: Тип поля "Комментарий" у дома в БД |
Спасибо! |
|
| Автор: | igimux [ 19 сен 2016, 09:23 ] |
| Заголовок сообщения: | Re: Тип поля "Комментарий" у дома в БД |
Ошибка, если написать большое количество символов. Поле "Комментарий" - textarea, в БД тип поля TEXT, а программа падает при вводе большого количества символов, очень не хорошо... Прошу исправить, спасибо! Код: http://127.0.0.1:9088/user/directory/address.do?action=addressUpdate&addressHouseId=109&addressCountryId=&addressCityId=1&addressItemId=19&addressAreaId=2&addressQuarterId=0&house=49&postIndex=123456&comment=234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+234234+234+234+234+23+423+&config=s.box.index%3D675000%0A&capacity=&objectType=address_house&id=109&action=parameterGet&returnUrl=%2Fuser%2Fparameter.do%3Faction%3DparameterList%26id%3D109%26objectType%3Daddress_house%26parameterGroup%3D-1&tableId=UIID1474255180951¶mId=23&objectType=address_house&id=109&action=parameterGet&returnUrl=%2Fuser%2Fparameter.do%3Faction%3DparameterList%26id%3D109%26objectType%3Daddress_house%26parameterGroup%3D-1&tableId=UIID1474255180951¶mId=41&objectType=address_house&id=109&action=parameterGet&returnUrl=%2Fuser%2Fparameter.do%3Faction%3DparameterList%26id%3D109%26objectType%3Daddress_house%26parameterGroup%3D-1&tableId=UIID1474255180951¶mId=42&objectType=address_house&id=109&action=parameterGet&returnUrl=%2Fuser%2Fparameter.do%3Faction%3DparameterList%26id%3D109%26objectType%3Daddress_house%26parameterGroup%3D-1&tableId=UIID1474255180951¶mId=38&objectType=address_house&id=109&action=parameterGet&returnUrl=%2Fuser%2Fparameter.do%3Faction%3DparameterList%26id%3D109%26objectType%3Daddress_house%26parameterGroup%3D-1&tableId=UIID1474255180951¶mId=59&objectType=address_house&id=109&action=parameterGet&returnUrl=%2Fuser%2Fparameter.do%3Faction%3DparameterList%26id%3D109%26objectType%3Daddress_house%26parameterGroup%3D-1&tableId=UIID1474255180951¶mId=39&objectType=address_house&id=109&action=parameterGet&returnUrl=%2Fuser%2Fparameter.do%3Faction%3DparameterList%26id%3D109%26objectType%3Daddress_house%26parameterGroup%3D-1&tableId=UIID1474255180951¶mId=46&objectType=address_house&id=109&action=parameterGet&returnUrl=%2Fuser%2Fparameter.do%3Faction%3DparameterList%26id%3D109%26objectType%3Daddress_house%26parameterGroup%3D-1&tableId=UIID1474255180951¶mId=50&objectType=address_house&id=109&action=parameterGet&returnUrl=%2Fuser%2Fparameter.do%3Faction%3DparameterList%26id%3D109%26objectType%3Daddress_house%26parameterGroup%3D-1&tableId=UIID1474255180951¶mId=51&objectType=address_house&id=109&action=parameterGet&returnUrl=%2Fuser%2Fparameter.do%3Faction%3DparameterList%26id%3D109%26objectType%3Daddress_house%26parameterGroup%3D-1&tableId=UIID1474255180951¶mId=48&objectType=address_house&id=109&action=parameterGet&returnUrl=%2Fuser%2Fparameter.do%3Faction%3DparameterList%26id%3D109%26objectType%3Daddress_house%26parameterGroup%3D-1&tableId=UIID1474255180951¶mId=52&objectType=address_house&id=109&action=parameterGet&returnUrl=%2Fuser%2Fparameter.do%3Faction%3DparameterList%26id%3D109%26objectType%3Daddress_house%26parameterGroup%3D-1&tableId=UIID1474255180951¶mId=53&objectType=address_house&id=109&action=parameterGet&returnUrl=%2Fuser%2Fparameter.do%3Faction%3DparameterList%26id%3D109%26objectType%3Daddress_house%26parameterGroup%3D-1&tableId=UIID1474255180951¶mId=54&responseType=json
|
|
| Автор: | Администратор [ 22 сен 2016, 02:49 ] |
| Заголовок сообщения: | Re: Тип поля "Комментарий" у дома в БД |
Исправлено. Будет включено в следующее обновление. |
|
| Автор: | igimux [ 22 сен 2016, 06:59 ] |
| Заголовок сообщения: | Re: Тип поля "Комментарий" у дома в БД |
Спасибо |
|
| Страница 1 из 1 | Часовой пояс: UTC + 5 часов [ Летнее время ] |
| Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |
|