Change: ID of Prefix

[Ghostt]

How can i the ID of the Prefix/category?

is it enough to change the "Table vbprefix " or is there a sql command i can use to change it in my whole forum?

[Marco van Herwaarden]

There should be no reason to change this.

[Ghostt]

Originally Posted by Marco van Herwaarden

There should be no reason to change this.

but i see the table in phpadmin why it shouldnt work? do i break my DB with a change ?

[Marco van Herwaarden]

It is refenced in othewr places. As a rule of thumb you should never try to change any of the id fields, it also doesn't server any purpose to change them.

[Ghostt]

the reason why i want to change is complex :
i have to change it because ive installed this mod Mark Threads As 'Solvedbut i had allready befor a solved prefix and want to keep the ropics as solved and not to have another prefix or 2 "solved"prefixes

[Marco van Herwaarden]

In that case you will need to update all tables where it is used. You can find all tables by searching the file ./install/mysql-schema.php for "prefixid".

After you have updated all tables, edit & save any prefix in the AdminCP to rebuild the datastore.

[Ghostt]

sry but i dont have a install folder anymore, because of security reasons ive deleted it after vb install...
is there any alternative method?

[Marco van Herwaarden]

You should still have the zip-file on your PC, otherwise you can download it again from the Members' Area.

PS For security reasons you only need to delete the install.php file, not the directory. Some files in the directory are even needed in case of some maintenance functions.

[Ghostt]

ok ive found the ‎mysql-schema.php file from 3. ‎November ‎2009 and loaded it up to installl derectory. but what i have to do now ?
dont understand the sense to search for "prefixid" and then what?

what i have to change:


CATEGORY: Erledigt <change to> solvedthread
PREFIX: Erledigt1 <change to> solvedthread_solved

[Marco van Herwaarden]

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