SMF Support > Install and Upgrade Help

1.1.x > 2.0.2 upgrade problems

<< < (9/11) > >>

K@:
How'd it go?

SnowmanDK:
Oh I still wait for the instructions ;)

SnowmanDK:
Still awaiting instructions  ;)

emanuele:
yups, sorry lost that from the radar...

Okay, now it's a bit late here and I should re-read the topic in order to avoid give you some wrong instruction (I'm even a bit sleepy...), but still there is one that could be easy:
remove this piece from upgrade_1-1.sql

--- Code: ------# Updating indexes on "themes"...
ALTER TABLE {$db_prefix}themes
DROP PRIMARY KEY,
ADD PRIMARY KEY (ID_THEME, ID_MEMBER, variable(30)),
ADD INDEX ID_MEMBER (ID_MEMBER);
---#

--- End code ---
If the upgrade continues, at the end you will check the themes table and you'll drop the primary key, the re-create the primary key according to the line:
ADD PRIMARY KEY (ID_THEME, ID_MEMBER, variable(30)),
and the index
ADD INDEX ID_MEMBER (ID_MEMBER);

Sorry again...

SnowmanDK:
Well... Now it does this:

--- Code: ---Updating and creating indexes... Successful!
Updating indexes on "messages"... Successful!
Updating table indexes... Successful!
Reordering boards and categories... Successful!
Updating indexes and data on "smileys"... Incomplete.
--- End code ---
and then it shows the message below and stops:

--- Code: ---Table 'tss_personal_messages' already exists
--- End code ---

Navigation

[0] Message Index

[#] Next page

[*] Previous page