uni template

My system has screwed up whilst uploading the latest 7.1 to my server. I now cant access site or admin. Ive tried to run the upgrade but i cant change the site to uni template. How can i alter this to uni template without accessing the admin panel or even the site. Is there a file i cange that will default my site back to uni template.

thanks in advance.

Run the following query:

UPDATE  `sys_options` SET  `VALUE` =  'uni' WHERE  `Name` =  'template' LIMIT 1;

Hi Alex,

thanks for your reply. I ended up restoring a backup version and then trying to upgrade after changing the template. I now have another problem when trying to upgrade. I got the following message after running the upgrade,

UPDATE `sys_options`, `sys_options_tmp`SET `VALUE` = `v`WHERE `Name` = `n` AND `VALUE` != `v` AND `n` NOT IN ('featured_num', 'top_members_max_num', 'sys_ps_enabled_group_1', 'categ_show_columns', 'sys_uridnsbl_enable', 'main_div_width');: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='

Now when i try again to run the upgrade i get the message, update can not be applied. Any ideas?

thanks again

Jim

For some reason tables collates don't match, I would suggegst to try to change the following:

 
CREATE TEMPORARY TABLE `sys_options_tmp` (
  `n` varchar(64) NOT NULL default '',
  `v` mediumtext NOT NULL,
  PRIMARY KEY  (`n`)
) DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; /* OR utf8_unicode_ci */

in upgrade/files/7.0.9-7.1.0.B1/sql.sql file.

Make sure that collate is the same as collate in your `sys_options` table.

Then run upgrade script again - http://www.boonex.com/forums/topic/Errors-fixing-procedures-during-upgrade.htm

hi Alex,

Ive followed your instruction and have now got the script to run. Its bombed out whilst installing modules. I believe its the payment module that its stopped at. I get the following error but for love nor money can i find the solution.

SET @iCategoryId = (SELECT `ID` FROM `sys_options_cats` WHERE `name` = @sModuleName);: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='

Whilst not a programmer i understand its a similar problem from the original problem but still canT solve it. My database is general and the tables are a mixture of general and unicode.

Any ideas?

thanks for all your help.

jim

Anybody out there, point me in the right direction. Its obviously a problem with the UTF8 and the clash with general and unicode. I have a mixture of both could i search and replace in the database and say just change to general or unicode? i cant continue with the upgrade until i solve this issue.

thanks in advance.

All table collations must match.

The tables in your database must be utf8_general_ci. All text fields in those tables must be as well.

You have some that are utf8_unicode_ci which is causing a mismatch.

I am betting it happened when you restored your database. You said you did a restore in your second post.

Your current one is in the table sys_options_cats. Table and test fields must be utf8_general_ci

Hi Deano,

Thanks for your imput. I searched and replaced the unicode for general, saved the database and uploaded it. Still failed to work as database was still showing a lot of unicode. I then uploaded the database in smaller sections and the upgrade script started to run again and was installing more modules until the following error.

SET @iMenuEventsTop = (SELECT `ID` FROM `sys_menu_top` WHERE `Parent` = 0 AND `Type` = 'top' AND `Name` = 'Forums');: Subquery returns more than 1 row

really sorry to keep posting more errors, but there arent too many more modules to upgrade so hopefully, im nearly there.lol thanks for your help.

 Looks like you have two parent entries named Forums. There should only be one.

Run this query in phpmyadmin.

SELECT * FROM `sys_menu_top` WHERE `Parent` = 0 AND `Type` = 'top' AND `Name` = 'Forums')

If you get more than one returned back then that's the cause of the problem.

Keep the one with the lowest ID and remove the other one. Hopefully there is only one extra. If there is more then something is seriously screwed.