Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
0 votes
255 views
in Q2A Core by
Ok, I now have ready the design for the 1.2.1. version and want to update the site. I have changes in my advanced theme in the css file and in some core files according to the instructions here found.

Am I right in just

a) Uploading the new 1.2.1
b) Copying .htaccess and the config file from the old installation
c) Copying the changed corefiles
d) Copying my new theme including css and the qa-theme.php

Or did I miss something ?

( It is better asking before I get in trouble with the database ! )

Thanks so far

monk333

1 Answer

0 votes
by
 
Best answer
Just overwite all the files (your theme will be still in place), that all! it should work.

This time there are no database changes.
by
Ok, so I think everything should work well. In the afternoon I will do it.
But, yes, there is an database update this time. I made a trial already with 1.2 and 1.2.1 . There was a massage regarding an databaseupdate. I will see later again.

I am just a bit nervous as DisgrountedGoat had Problems with 1.0 to 1.2 and about databases or better mysql I do not know so much to handle problems safely.

Thank You so far

monk333
by
i dont remember about database changes. everything went fine for me from 1.2 to 1.2.1
by
There were no database changes from 1.2 to 1.2.1.
by
OK, obviously You are right. What I did was an upgrade from 1.2 beta1 !!! (and not 1.2 final) to 1.2.1 It worked out fine.

If there an database upgrade is normal, everything is ok and please do not read the rest of this reply.

Otherwise, here are the changes


Running query: LOCK TABLES qcanc_categories WRITE, qcanc_contentwords WRITE, qcanc_cookies WRITE, qcanc_iplimits WRITE, qcanc_options WRITE, qcanc_pages WRITE, qcanc_posts WRITE, qcanc_posttags WRITE, qcanc_titlewords WRITE, qcanc_userlimits WRITE, qcanc_userpoints WRITE, qcanc_userprofile WRITE, qcanc_users WRITE, qcanc_uservotes WRITE, qcanc_words WRITE ...

1 upgrade step/s remaining...

Running query: ALTER TABLE qcanc_users CHANGE COLUMN emailcode emailcode CHAR(8) CHARACTER SET ascii NOT NULL DEFAULT '', CHANGE COLUMN sessioncode sessioncode CHAR(8) CHARACTER SET ascii NOT NULL DEFAULT '', CHANGE COLUMN flags flags TINYINT UNSIGNED NOT NULL DEFAULT 0 ...

Running query: ALTER TABLE qcanc_posts CHANGE COLUMN acount acount SMALLINT UNSIGNED NOT NULL DEFAULT 0, CHANGE COLUMN upvotes upvotes SMALLINT UNSIGNED NOT NULL DEFAULT 0, CHANGE COLUMN downvotes downvotes SMALLINT UNSIGNED NOT NULL DEFAULT 0, CHANGE COLUMN format format CHAR(1) CHARACTER SET ascii NOT NULL DEFAULT '' ...

Running query: ALTER TABLE qcanc_categories CHANGE COLUMN qcount qcount INT UNSIGNED NOT NULL DEFAULT 0 ...

Running query: ALTER TABLE qcanc_words CHANGE COLUMN titlecount titlecount INT UNSIGNED NOT NULL DEFAULT 0, CHANGE COLUMN contentcount contentcount INT UNSIGNED NOT NULL DEFAULT 0, CHANGE COLUMN tagcount tagcount INT UNSIGNED NOT NULL DEFAULT 0 ...

Running query: ALTER TABLE qcanc_userpoints CHANGE COLUMN points points INT NOT NULL DEFAULT 0, CHANGE COLUMN qposts qposts MEDIUMINT NOT NULL DEFAULT 0, CHANGE COLUMN aposts aposts MEDIUMINT NOT NULL DEFAULT 0, CHANGE COLUMN cposts cposts MEDIUMINT NOT NULL DEFAULT 0, CHANGE COLUMN aselects aselects MEDIUMINT NOT NULL DEFAULT 0, CHANGE COLUMN aselecteds aselecteds MEDIUMINT NOT NULL DEFAULT 0, CHANGE COLUMN qupvotes qupvotes MEDIUMINT NOT NULL DEFAULT 0, CHANGE COLUMN qdownvotes qdownvotes MEDIUMINT NOT NULL DEFAULT 0, CHANGE COLUMN aupvotes aupvotes MEDIUMINT NOT NULL DEFAULT 0, CHANGE COLUMN adownvotes adownvotes MEDIUMINT NOT NULL DEFAULT 0, CHANGE COLUMN qvoteds qvoteds INT NOT NULL DEFAULT 0, CHANGE COLUMN avoteds avoteds INT NOT NULL DEFAULT 0, CHANGE COLUMN upvoteds upvoteds INT NOT NULL DEFAULT 0, CHANGE COLUMN downvoteds downvoteds INT NOT NULL DEFAULT 0 ...

Running query: LOCK TABLES qcanc_categories WRITE, qcanc_contentwords WRITE, qcanc_cookies WRITE, qcanc_iplimits WRITE, qcanc_options WRITE, qcanc_pages WRITE, qcanc_posts WRITE, qcanc_posttags WRITE, qcanc_titlewords WRITE, qcanc_userlimits WRITE, qcanc_userpoints WRITE, qcanc_userprofile WRITE, qcanc_users WRITE, qcanc_uservotes WRITE, qcanc_words WRITE ...

Running query: UNLOCK TABLES ...

Your Question2Answer database has been updated.

Go to admin center
...