Hello,
I followed instructions to move to new server "How to move script to another server"
I can enter admin area, but there is a message: "WARNING! THIS IS IMPORTANT ! Looks like you have script FILES version 49, while DB version 48
Common reason for this situation is loading old backup (version 48) into newer version of script (49). Please, run updates ASAP. "
I updated old dbase on old server and then made mysqldump?
Biggest problem - I copied files from scj/cgi - index.php, common.php, out.php to my root and when I open page I just see blank white page...
Please help me.
Move to new server
Re: Move to new server
"WARNING! THIS IS IMPORTANT ! Looks like you have script FILES version 49, while DB version 48
Common reason for this situation is loading old backup (version 48) into newer version of script (49). Please, run updates ASAP. "
Common reason for this situation is loading old backup (version 48) into newer version of script (49). Please, run updates ASAP. "
Don't forget to run script update
-
- Posts: 60
- Joined: Wed Feb 20, 2013 6:27 pm
Re: Move to new server
Yes, that's what I'm explaining - I run updated on old server, then make mysql dumpadmin wrote:"WARNING! THIS IS IMPORTANT ! Looks like you have script FILES version 49, while DB version 48
Common reason for this situation is loading old backup (version 48) into newer version of script (49). Please, run updates ASAP. "
then downloaded install file from here http://smartcj.com/scj_install/dl.php?type=ic
I made clean install, then restored mysql dump from old host...
-
- Posts: 60
- Joined: Wed Feb 20, 2013 6:27 pm
Re: Move to new server
Thanks for advice, yes I run it and it updated to v 49 (I thought as new clean install it will install most updated ver, anyway)...admin wrote:run update at new server
Now in my admin everything seems ok, but when I open root domain, it's blank page again.
I copied index,out,common from /scj/cgi to root
Should I do anything esle?
Thank you!
-
- Posts: 60
- Joined: Wed Feb 20, 2013 6:27 pm
Re: Move to new server
admin wrote:Try to open /scj/tube/
Does it work ?
Got this error:
Mysql error: 1052 (Column 'alt' in field list is ambiguous) in query SELECT id, g.gallery_slug, g.gallery_md5, sponsor_id, url, source_url, rot_content_id, embed_template, thumb_url, embed_code, flv_url, flv_size_x, flv_size_y, flv_thumb_url, tags, type, rgroup, content, content_type, duration, date, activation_date, casts, clicks, rating, priority, crop_profile_id, status, alt, description, custom_var1, custom_var2, custom_var3 FROM rot_galleries as g LEFT JOIN rot_gallery_data as gd ON gd.gallery_md5 = g.gallery_md5 WHERE id IN (723,1822,3685,3123,3073,1921,3669,1535,1705,1470,1530,2970,2207,3024,3054,1491,3862,1746,2200,3860,2954,3099,5131,3892,3004,1837,1752,1892) .
Just noticed in Rotation-Sponsor there are not mine sponsors, just empty rows.
In Rotation Import-> I can select sponsors (they are showed in this menu)..
Maybe Rotation Sponsors is broken somehow?
Re: Move to new server
I guess you stopped update 49.
Restore DB version 48 again.
Drop table rot_gallery_data
Run update again
Do NOT interrupt it
Restore DB version 48 again.
Drop table rot_gallery_data
Run update again
Do NOT interrupt it
Don't forget to run script update
-
- Posts: 60
- Joined: Wed Feb 20, 2013 6:27 pm
Re: Move to new server
Thank you, but could you tell me how to restore db 48 again?admin wrote:I guess you stopped update 49.
Restore DB version 48 again.
Drop table rot_gallery_data
Run update again
Do NOT interrupt it
Also while I made update I did not interrupt it and on the end it says everything is ok..
Re: Move to new server
exectly the same asThank you, but could you tell me how to restore db 48 again?
I made clean install, then restored mysql dump from old host...
Don't forget to run script update