Перейти к содержанию
Форумы

Целостность базы данных - проблема после обновления


Mitya

Рекомендуемые сообщения

Принудили обновится до беты3.

 

таймауты выставил все в 6000 сек.

 

скрипт обновления базы отработал около 100 сек и отобразил белую страницу.

 

проверка целостности базы выдала следующее:

 

Base Version: 3.0 Beta3 от 28.12.2010.

 

Checking database structure with /admin/modules/database.php: something wrong!

 

f_acc_1 not found at table acc!

f_acc_2 not found at table acc!

f_acc_3 not found at table acc!

f_acc_4 not found at table acc!

service1 not found at table actions!

service2 not found at table actions!

f_actions_1 not found at table actions!

f_actions_2 not found at table actions!

f_actions_3 not found at table actions!

f_actions_4 not found at table actions!

f_awards_1 not found at table awards!

f_awards_2 not found at table awards!

f_awards_3 not found at table awards!

f_awards_4 not found at table awards!

f_banlist_1 not found at table banlist!

f_banlist_2 not found at table banlist!

f_banlist_3 not found at table banlist!

f_banlist_4 not found at table banlist!

lang not found at table banners!

f_blocked_1 not found at table blocked!

f_blocked_2 not found at table blocked!

f_blocked_3 not found at table blocked!

f_blocked_4 not found at table blocked!

f_cards_1 not found at table cards!

f_cards_2 not found at table cards!

f_cards_3 not found at table cards!

f_cards_4 not found at table cards!

f_contacts_1 not found at table contacts!

f_contacts_2 not found at table contacts!

f_contacts_3 not found at table contacts!

f_contacts_4 not found at table contacts!

f_coupon_conf_1 not found at table coupon_conf!

f_coupon_conf_2 not found at table coupon_conf!

f_coupon_conf_3 not found at table coupon_conf!

f_coupon_conf_4 not found at table coupon_conf!

f_coupon_data_1 not found at table coupon_data!

f_coupon_data_2 not found at table coupon_data!

f_coupon_data_3 not found at table coupon_data!

f_coupon_data_4 not found at table coupon_data!

f_custom_pkgs_1 not found at table custom_pkgs!

f_custom_pkgs_2 not found at table custom_pkgs!

f_custom_pkgs_3 not found at table custom_pkgs!

f_custom_pkgs_4 not found at table custom_pkgs!

f_discount_1 not found at table discount!

f_discount_2 not found at table discount!

f_discount_3 not found at table discount!

f_discount_4 not found at table discount!

f_dns_1 not found at table dns!

f_dns_2 not found at table dns!

f_dns_3 not found at table dns!

f_dns_4 not found at table dns!

authinfo not found at table domen!

nexus1 not found at table domen!

nexus2 not found at table domen!

f_domen_1 not found at table domen!

f_domen_2 not found at table domen!

f_domen_3 not found at table domen!

f_domen_4 not found at table domen!

f_faqconf_1 not found at table faqconf!

f_faqconf_2 not found at table faqconf!

f_faqconf_3 not found at table faqconf!

f_faqconf_4 not found at table faqconf!

lang not found at table faqdata!

f_faqdata_1 not found at table faqdata!

f_faqdata_2 not found at table faqdata!

f_faqdata_3 not found at table faqdata!

f_faqdata_4 not found at table faqdata!

f_files_1 not found at table files!

f_files_2 not found at table files!

f_files_3 not found at table files!

f_files_4 not found at table files!

f_firma_1 not found at table firma!

f_firma_2 not found at table firma!

f_firma_3 not found at table firma!

f_firma_4 not found at table firma!

f_freedomen_1 not found at table freedomen!

f_freedomen_2 not found at table freedomen!

f_freedomen_3 not found at table freedomen!

f_freedomen_4 not found at table freedomen!

f_history_1 not found at table history!

f_history_2 not found at table history!

f_history_3 not found at table history!

f_history_4 not found at table history!

f_host_1 not found at table host!

f_host_2 not found at table host!

f_host_3 not found at table host!

f_host_4 not found at table host!

f_h_answers_1 not found at table h_answers!

f_h_answers_2 not found at table h_answers!

f_h_answers_3 not found at table h_answers!

f_h_answers_4 not found at table h_answers!

f_h_fieldsconf_1 not found at table h_fieldsconf!

f_h_fieldsconf_2 not found at table h_fieldsconf!

f_h_fieldsconf_3 not found at table h_fieldsconf!

f_h_fieldsconf_4 not found at table h_fieldsconf!

f_h_fieldsdata_1 not found at table h_fieldsdata!

f_h_fieldsdata_2 not found at table h_fieldsdata!

f_h_fieldsdata_3 not found at table h_fieldsdata!

f_h_fieldsdata_4 not found at table h_fieldsdata!

f_h_logs_1 not found at table h_logs!

f_h_logs_2 not found at table h_logs!

f_h_logs_3 not found at table h_logs!

f_h_logs_4 not found at table h_logs!

lang not found at table h_templates!

f_h_templates_1 not found at table h_templates!

f_h_templates_2 not found at table h_templates!

f_h_templates_3 not found at table h_templates!

f_h_templates_4 not found at table h_templates!

lang not found at table h_tickets!

f_h_tickets_1 not found at table h_tickets!

f_h_tickets_2 not found at table h_tickets!

f_h_tickets_3 not found at table h_tickets!

f_h_tickets_4 not found at table h_tickets!

f_h_timer_1 not found at table h_timer!

f_h_timer_2 not found at table h_timer!

f_h_timer_3 not found at table h_timer!

f_h_timer_4 not found at table h_timer!

f_icqlog_1 not found at table icqlog!

f_icqlog_2 not found at table icqlog!

f_icqlog_3 not found at table icqlog!

f_icqlog_4 not found at table icqlog!

serviceid not found at table invmaker!

invoiceid not found at table invmaker!

techinfo not found at table invmaker!

thestatus not found at table invmaker!

f_invmaker_1 not found at table invmaker!

f_invmaker_2 not found at table invmaker!

f_invmaker_3 not found at table invmaker!

f_invmaker_4 not found at table invmaker!

par01 not found at table merchants!

par02 not found at table merchants!

par03 not found at table merchants!

par04 not found at table merchants!

par05 not found at table merchants!

par06 not found at table merchants!

par07 not found at table merchants!

par08 not found at table merchants!

par09 not found at table merchants!

par10 not found at table merchants!

par11 not found at table merchants!

par12 not found at table merchants!

par13 not found at table merchants!

par14 not found at table merchants!

par15 not found at table merchants!

lang not found at table network!

f_network_1 not found at table network!

f_network_2 not found at table network!

f_network_3 not found at table network!

f_network_4 not found at table network!

ID not found at table new1_table!

f_new1_1 not found at table new1_table!

f_new1_2 not found at table new1_table!

f_new1_3 not found at table new1_table!

f_new1_4 not found at table new1_table!

f_new1_5 not found at table new1_table!

f_new1_6 not found at table new1_table!

f_new1_7 not found at table new1_table!

f_new1_8 not found at table new1_table!

f_new1_9 not found at table new1_table!

f_new1_10 not found at table new1_table!

f_new1_11 not found at table new1_table!

f_new1_12 not found at table new1_table!

f_new1_13 not found at table new1_table!

f_new1_14 not found at table new1_table!

f_new1_15 not found at table new1_table!

f_new1_16 not found at table new1_table!

f_new1_17 not found at table new1_table!

f_new1_18 not found at table new1_table!

f_new1_19 not found at table new1_table!

f_new1_20 not found at table new1_table!

ID not found at table new2_table!

f_new2_1 not found at table new2_table!

f_new2_2 not found at table new2_table!

f_new2_3 not found at table new2_table!

f_new2_4 not found at table new2_table!

f_new2_5 not found at table new2_table!

f_new2_6 not found at table new2_table!

f_new2_7 not found at table new2_table!

f_new2_8 not found at table new2_table!

f_new2_9 not found at table new2_table!

f_new2_10 not found at table new2_table!

f_new2_11 not found at table new2_table!

f_new2_12 not found at table new2_table!

f_new2_13 not found at table new2_table!

f_new2_14 not found at table new2_table!

f_new2_15 not found at table new2_table!

f_new2_16 not found at table new2_table!

f_new2_17 not found at table new2_table!

f_new2_18 not found at table new2_table!

f_new2_19 not found at table new2_table!

f_new2_20 not found at table new2_table!

ID not found at table new3_table!

f_new3_1 not found at table new3_table!

f_new3_2 not found at table new3_table!

f_new3_3 not found at table new3_table!

f_new3_4 not found at table new3_table!

f_new3_5 not found at table new3_table!

f_new3_6 not found at table new3_table!

f_new3_7 not found at table new3_table!

f_new3_8 not found at table new3_table!

f_new3_9 not found at table new3_table!

f_new3_10 not found at table new3_table!

f_new3_11 not found at table new3_table!

f_new3_12 not found at table new3_table!

f_new3_13 not found at table new3_table!

f_new3_14 not found at table new3_table!

f_new3_15 not found at table new3_table!

f_new3_16 not found at table new3_table!

f_new3_17 not found at table new3_table!

f_new3_18 not found at table new3_table!

f_new3_19 not found at table new3_table!

f_new3_20 not found at table new3_table!

ID not found at table new4_table!

f_new4_1 not found at table new4_table!

f_new4_2 not found at table new4_table!

f_new4_3 not found at table new4_table!

f_new4_4 not found at table new4_table!

f_new4_5 not found at table new4_table!

f_new4_6 not found at table new4_table!

f_new4_7 not found at table new4_table!

f_new4_8 not found at table new4_table!

f_new4_9 not found at table new4_table!

f_new4_10 not found at table new4_table!

ID not found at table new5_table!

f_new5_1 not found at table new5_table!

f_new5_2 not found at table new5_table!

f_new5_3 not found at table new5_table!

f_new5_4 not found at table new5_table!

f_new5_5 not found at table new5_table!

f_new5_6 not found at table new5_table!

f_new5_7 not found at table new5_table!

f_new5_8 not found at table new5_table!

f_new5_9 not found at table new5_table!

f_new5_10 not found at table new5_table!

lang not found at table news!

f_news_1 not found at table news!

f_news_2 not found at table news!

f_news_3 not found at table news!

f_news_4 not found at table news!

f_passport_1 not found at table passport!

f_passport_2 not found at table passport!

f_passport_3 not found at table passport!

f_passport_4 not found at table passport!

thefile not found at table payments!

f_payments_1 not found at table payments!

f_payments_2 not found at table payments!

f_payments_3 not found at table payments!

f_payments_4 not found at table payments!

everyterm not found at table serviceconf!

everywhat not found at table serviceconf!

f_serviceconf_1 not found at table serviceconf!

f_serviceconf_2 not found at table serviceconf!

f_serviceconf_3 not found at table serviceconf!

f_serviceconf_4 not found at table serviceconf!

f_servicedata_1 not found at table servicedata!

f_servicedata_2 not found at table servicedata!

f_servicedata_3 not found at table servicedata!

f_servicedata_4 not found at table servicedata!

ID not found at table specdom!

name not found at table specdom!

amount not found at table specdom!

thetype not found at table specdom!

cost not found at table specdom!

prolongcost not found at table specdom!

transfercost not found at table specdom!

transfercost not found at table special!

f_supports_1 not found at table supports!

f_supports_2 not found at table supports!

f_supports_3 not found at table supports!

f_supports_4 not found at table supports!

f_tarifdom_1 not found at table tarifdom!

f_tarifdom_2 not found at table tarifdom!

f_tarifdom_3 not found at table tarifdom!

f_tarifdom_4 not found at table tarifdom!

f_top_1 not found at table top!

f_top_2 not found at table top!

f_top_3 not found at table top!

f_top_4 not found at table top!

ID not found at table waitdays!

thetype not found at table waitdays!

cost not found at table waitdays!

viewdays not found at table waitdays!

waitdays not found at table waitdays!

 

 

Что делать?)

 

повторно обновится никак, возвращать все обратно?

 

сам биллинг визауально работает, но что возникнет в процессе эксплуатации не ясно..

Ссылка на комментарий
Поделиться на другие сайты

и часть лога еще

 

city!==region at domen!

country!==city at domen!

thecode!==country at domen!

region!==thecode at domen!

comments!==serviceid at invmaker!

setup!==everyterm at serviceconf!

tovps!==everywhat at serviceconf!

control!==setup at serviceconf!

os!==tovps at serviceconf!

thecpu!==control at serviceconf!

thememory!==os at serviceconf!

thehdd!==thecpu at serviceconf!

thetrafic!==thememory at serviceconf!

forauto!==thehdd at serviceconf!

field1!==thetrafic at serviceconf!

field2!==forauto at serviceconf!

field3!==field1 at serviceconf!

field4!==field2 at serviceconf!

field5!==field3 at serviceconf!

field6!==field4 at serviceconf!

cancel_ok!==field5 at serviceconf!

cancel_money!==field6 at serviceconf!

special!==cancel_ok at serviceconf!

Config table entries count: 800 VS 640 (needs VS current)!

Ссылка на комментарий
Поделиться на другие сайты

Не обновилось все как надо. Откатывайте базу назад, вносите изменение в php.ini по времени выполнения скрипта, перезагружайте апач и заново запускайте файл обновления базы.

 

Если не сработает, то еще раз делайте откат базы и

 

Для дальнейшего исследования проблемы необходимо следующее:

1. URL скрипта.

2. Данные доступа в админ-центр биллинга, проверка по IP адресу должна быть отключена;

3. Данные доступа на FTP с биллингом;

4. URL темы на форуме forum.advanta.org (если тема создавалась).

На admin @ advanta.org

 

Я в сети еще около часа.

Ссылка на комментарий
Поделиться на другие сайты

Алексей, а не проще разделить скрипт апдейтера на несколько шагов? Т.е. выполнилась группа, допустим обновление страницы и переход ко второму шагу и т.п. и не будет трабл с настройками пхп и подобными случаями...

Ссылка на комментарий
Поделиться на другие сайты

Может дадите sql запрос за изменения базы - мы его выполним от рута..? а то поздно уже отказывать. уже прошло немало транзакций в билилнге.

Ссылка на комментарий
Поделиться на другие сайты

в общем решили вопрос так: изменили версию базы на 3.05 в таблице config

 

удалили те таблицы которые скрипт обнолвения создал table1... table5 (или как-то так называются)

 

и запустили скрипт повторно - вродь все прошло успешно со второй попытки.

Ссылка на комментарий
Поделиться на другие сайты

теперь осталось

 

city!==region at acc!

country!==city at acc!

thecode!==country at acc!

region!==thecode at acc!

city!==region at domen!

country!==city at domen!

thecode!==country at domen!

region!==thecode at domen!

 

 

сколько не бился по информации из других тем - исправить это не удалось

Ссылка на комментарий
Поделиться на другие сайты

Может дадите sql запрос за изменения базы - мы его выполним от рута..? а то поздно уже отказывать. уже прошло немало транзакций в билилнге.

Там не просто sql-запросы, а вычисления, изменения полей и пр.

 

в общем решили вопрос так: изменили версию базы на 3.05 в таблице config

 

удалили те таблицы которые скрипт обнолвения создал table1... table5 (или как-то так называются)

 

и запустили скрипт повторно - вродь все прошло успешно со второй попытки.

Теоретически, так тоже все ок :)

 

теперь осталось

 

city!==region at acc!

country!==city at acc!

thecode!==country at acc!

region!==thecode at acc!

city!==region at domen!

country!==city at domen!

thecode!==country at domen!

region!==thecode at domen!

 

 

сколько не бился по информации из других тем - исправить это не удалось

Поиском по форуму воспользуйтесь. Недавно был подобный вопрос.

Это сообщение относится еще к временам обновления с Beta1 или Alpha3 и не является критическим.

Ссылка на комментарий
Поделиться на другие сайты

Для публикации сообщений создайте учётную запись или авторизуйтесь

Вы должны быть пользователем, чтобы оставить комментарий

Создать учетную запись

Зарегистрируйте новую учётную запись в нашем сообществе. Это очень просто!

Регистрация нового пользователя

Войти

Уже есть аккаунт? Войти в систему.

Войти
×
×
  • Создать...