scj_1to2_db_converter

Axcel
Posts: 1223
Joined: Sun Dec 09, 2012 12:43 pm

Re: scj_1to2_db_converter

Post by Axcel »

редис, я ж написал.
т.е. в конфиг после установки я добавил только настройки редиса.
admin
Site Admin
Posts: 37234
Joined: Wed Sep 10, 2008 11:43 am

Re: scj_1to2_db_converter

Post by admin »

тогда не знаю
скидывайте шел и данные что как делать что б повторить проблему
Don't forget to run script update
admin
Site Admin
Posts: 37234
Joined: Wed Sep 10, 2008 11:43 am

Re: scj_1to2_db_converter

Post by admin »

спасибо, разобрался, все ок уже
Don't forget to run script update
Axcel
Posts: 1223
Joined: Sun Dec 09, 2012 12:43 pm

Re: scj_1to2_db_converter

Post by Axcel »

не могу сделать ап до 1.50, сейчас 1.49
пишет:

cd /home/axcel/web/MYSITE.com/public_html/scj/admin; env HTTP_HOST=MYSITE.com php update.php 50
Processing 50
Update 50.
**Update 50**

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

Stopping rotation for a while
Adding index for rot_gallery_stats
Creating tds tables
Creating rot_gallery_info
Altering rot_gallery_data
Coping data to rot_gallery_info
100% copied
Done
Altering rot_galleries
rot_gallery_info.gallery_md5 collation != rot_galleries.gallery_md5 collation, fixing ...
Update rot_page_items
done
Optimizing history table ...
Downloading files
0% downloaded Can not download ic5/bin/scj_ex.php, please, contact support 500
admin
Site Admin
Posts: 37234
Joined: Wed Sep 10, 2008 11:43 am

Re: scj_1to2_db_converter

Post by admin »

Fixed
Don't forget to run script update
admin
Site Admin
Posts: 37234
Joined: Wed Sep 10, 2008 11:43 am

Re: scj_1to2_db_converter

Post by admin »

правда у меня такого старого нет уже, но скачивается нормально файл
Don't forget to run script update
Axcel
Posts: 1223
Joined: Sun Dec 09, 2012 12:43 pm

Re: scj_1to2_db_converter

Post by Axcel »

сделал ап до 1.51, запустил конвертацию, а там:

Coping table rot_models (27.936641216278, 0.005263090133667)
Coping table rot_models_data (27.938636064529, 0.0019948482513428)
Coping table rot_sponsors (27.940973043442, 0.0023369789123535)
Coping table rot_sponsors_data (27.961894035339, 0.020920991897583)
Coping table rot_crop_profiles (27.979330062866, 0.017436027526855)
Coping table rot_pages (27.983250141144, 0.0039200782775879)
Mysql error 1054: Unknown column 'template_content_limit' in 'field list' (Please, run update. If it doesnt help - contact script support) (27.988524198532, 0.0052740573883057)
PHP Fatal error: Uncaught exception 'Exception' with message 'Mysql error:: 1054 (Unknown column 'template_content_limit' in 'field list') (db_link) in query insert ignore into rot_pages (`id`, `name`, `rows`, `cols`, `shows`, `clicks`, `benchmark_start`, `benchmark_pages`, `template`, `save_path`, `create_archives`, `cms_page`, `template_content_limit`) values ('4', 'index', '20', '5', '1840', '22', '1300914809', '0', '<template name=default ><a href=\"/gallery/<!--GALLERY_SLUG-->/index.html?<!--THUMB_LINK-->\"><img src=<!--THUMB_URL--> width=\"240\" height=\"180\" border=\"1\"></a></template><!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">
<html xmlns=\"http://www.w3.org/1999/xhtml\">
<head>
<title>Source</title>
<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\" />
<meta name=\"keywords\" content=\"keys\" />
<meta name=\"description\" content=\"desc\" />
<link rel=\"stylesheet\" href=\"css/style.css\" type=\"text/c in /home/axcel/web/MY-SITE.com/public_html/scj2/includes/db_modules/mysql.php on line 129

Fatal error: Uncaught exception 'Exception' with message 'Mysql error:: 1054 (Unknown column 'template_content_limit' in 'field list') (db_link) in query insert ignore into rot_pages (`id`, `name`, `rows`, `cols`, `shows`, `clicks`, `benchmark_start`, `benchmark_pages`, `template`, `save_path`, `create_archives`, `cms_page`, `template_content_limit`) values ('4', 'index', '20', '5', '1840', '22', '1300914809', '0', '<template name=default ><a href=\"/gallery/<!--GALLERY_SLUG-->/index.html?<!--THUMB_LINK-->\"><img src=<!--THUMB_URL--> width=\"240\" height=\"180\" border=\"1\"></a></template><!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">
<html xmlns=\"http://www.w3.org/1999/xhtml\">
<head>
<title>Source</title>
<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\" />
<meta name=\"keywords\" content=\"keys\" />
<meta name=\"description\" content=\"desc\" />
<link rel=\"stylesheet\" href=\"css/style.css\" type=\"text/c in /home/axcel/web/MY-SITE.com/public_html/scj2/includes/db_modules/mysql.php on line 129
-sh-4.2$
admin
Site Admin
Posts: 37234
Joined: Wed Sep 10, 2008 11:43 am

Re: scj_1to2_db_converter

Post by admin »

думаю вы 50й провели , а 51 уже нет
Don't forget to run script update
Axcel
Posts: 1223
Joined: Sun Dec 09, 2012 12:43 pm

Re: scj_1to2_db_converter

Post by Axcel »

вот сейчас ещё раз проверил
(c) SmartCJ Pro V 1.51 Build 201603221213
admin
Site Admin
Posts: 37234
Joined: Wed Sep 10, 2008 11:43 am

Re: scj_1to2_db_converter

Post by admin »

не знаю конечно каким образом оно прошло без изменений но надо сделать в базе первой версии

ALTER TABLE `rot_pages` DROP `template_content_limit`
Don't forget to run script update
Post Reply