Change: ID of Prefix

[Ghostt]

Originally Posted by Marco van Herwaarden

Open it with a text editor and search where this column is used.

i know how to search for it i have cuteftp pro...
just dont understand the sense of it and what to change. i told you i need to rename the names of the IDs

CATEGORY: "Erledigt" <rename to> "solvedthread"
PREFIX: "Erledigt1" <rename to> "solvedthread_solved"

cant find "Erledigt" or something else in the file ...

[Marco van Herwaarden]

The mysql-schema file will show you in which tables have a column named prefixid. For all those tables you will need to update the values in that column, changing your old prefix-id to the new.

[Ghostt]

Originally Posted by Marco van Herwaarden

The mysql-schema file will show you in which tables have a column named prefixid. For all those tables you will need to update the values in that column, changing your old prefix-id to the new.

ah that you mean. sry but im to sql noob for this i cant that...

ive searched vor "Erledigt" the "old"at phpmyadmin prefix and it showed many tables more then 140+ i think because so many theards have that prefix allready.

i need an other solution like replace comand for sql or so..

[Marco van Herwaarden]

Once you have determined which tables to update you can use MySQL queries to change the values:

[sql]UPDATE <TableName> SET prefixid = "<NewPrefixID>" WHERE prefixid = "<OldPrefixId>";[/sql]I strongly recommend to make a bakcup first and to try it on a test database first.