Ошибки MySQL при апдейте

Post Reply
Bjakin
Posts: 136
Joined: Sun Dec 16, 2012 2:37 pm

Ошибки MySQL при апдейте

Post by Bjakin »

Здравствуйте. Решил сделать апдейт с 49 на 50 версию. Сначала установил скрипт на сабдомен, скопировал базу, сделал апдейт. При апдейте повылазили следующие ошибки:

Mysql error: 1146 (Table 'test2.rot_galleries' doesn't exist) in query SHOW COLUMNS FROM rot_galleries.Mysql error: 1146 (Table 'test2.rot_gallery_stats' doesn't exist) in query SHOW INDEXES FROM rot_gallery_stats.Adding index for rot_gallery_stats
Mysql error: 1146 (Table 'test2.rot_gallery_stats' doesn't exist) in query ALTER TABLE `rot_gallery_stats` ADD INDEX ( `best_thumb` ) .Creating tds tables
Creating rot_gallery_info
Altering rot_gallery_data
Mysql error: 1146 (Table 'test2.rot_galleries' doesn't exist) in query SHOW COLUMNS FROM rot_galleries .Mysql error: 1146 (Table 'test2.rot_galleries' doesn't exist) in query SHOW FULL COLUMNS FROM rot_galleries.rot_gal2tag.gallery_md5 collation != rot_galleries.gallery_md5 collation, fixing ...
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' at line 1) in query ALTER TABLE `rot_gal2tag` CHANGE `gallery_md5` `gallery_md5` CHAR(32) CHARACTER SET latin1 COLLATE NOT NULL.rot_gallery_info.gallery_md5 collation != rot_galleries.gallery_md5 collation, fixing ...
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' at line 1) in query ALTER TABLE `rot_gallery_info` CHANGE `gallery_md5` `gallery_md5` CHAR(32) CHARACTER SET latin1 COLLATE NOT NULL.rot_gal2model.gallery_md5 collation != rot_galleries.gallery_md5 collation, fixing ...
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' at line 1) in query ALTER TABLE `rot_gal2model` CHANGE `gallery_md5` `gallery_md5` CHAR(32) CHARACTER SET latin1 COLLATE NOT NULL.Update rot_page_items

В админке все галереи и тумбы пропали. Выдает ошибки:
Mysql error:: 1146 (Table 'test2.rot_galleries' doesn't exist) (db_link) in query select count(*) from rot_galleries as g JOIN rot_gallery_stats as gs on gs.thumb_id = g.id where status = 1 and g.rgroup != 0 and gs.total_shows < '300' . (dev.ero-love.com)

Mysql error:: 1146 (Table 'test2.rot_galleries' doesn't exist) (db_link) in query select SQL_CALC_FOUND_ROWS g.id, gs.total_ctr as max_ctr, gs.total_shows as casts, gs.total_clicks as clicks, g.priority as gs_priority FROM rot_galleries as g JOIN rot_gallery_data as gd on gd.gallery_md5 = g.gallery_md5 JOIN rot_gallery_info as gi on gi.gallery_md5 = g.gallery_md5 JOIN rot_gal2group as g2gr on g2gr.gal_id = g.id JOIN rot_gallery_stats as gs on gs.thumb_id = g.id WHERE 1 = 1 and gs.best_thumb = "yes" and not (g.rgroup = '0' and sponsor_id = 3) and g.status IN ( 0,1,2,10) group by g.gallery_md5 order by max_ctr desc limit 0, 15. (dev.ero-love.com)
admin
Site Admin
Posts: 38004
Joined: Wed Sep 10, 2008 11:43 am

Re: Ошибки MySQL при апдейте

Post by admin »

Не скопирована или скопирована не полностью база

Table 'test2.rot_galleries' doesn't exist
Don't forget to run script update
rembo1978
Posts: 540
Joined: Thu Jul 26, 2012 5:12 am

Re: Ошибки MySQL при апдейте

Post by rembo1978 »

admin wrote:Не скопирована или скопирована не полностью база

Table 'test2.rot_galleries' doesn't exist
И что делать дальше ???
У меня выдает такое в putty
Update 51.
**Update 51**

Please, Take a look at wiki for comments.
http://smartcj.com/wiki/doku.php?id=update_51

Stopping rotation for a while
rot_gallery_data1.gallery_md5 collation != rot_galleries.gallery_md5 collation, fixing ...
Mysql error:: 1054 (Unknown column 'gallery_md5' in 'rot_gallery_data1') (db_link) in query ALTER TABLE `rot_gallery_data1` CHANGE `gallery_md5` `gallery_md5` CHAR(32) COLLATE latin1_swedish_ci NOT NULL. (домен.net) ....
Build 201409111007 (Lastest build: 201506030910
Хочу обновить версию не получается что сделать ???
admin
Site Admin
Posts: 38004
Joined: Wed Sep 10, 2008 11:43 am

Re: Ошибки MySQL при апдейте

Post by admin »

Хм, а какие поля есть в rot_gallery_data1 ?
Это при апдейт с какой версии ?
Don't forget to run script update
Post Reply