Is it possible to bring the bookmarks forward to 3.1 from 2.1

The sale of extensions in the shop will cease on 29 July 2022.
The extensions will then be made available free of charge, possibly even a little earlier. They will then also be freely available in the WoltLab Plugin Store.

For more information, see the announcement of changes on zaydowicz.de.
  • I recently had Woltlab upgrade my site to the latest forum version. Many of the plugins I had were available for the new 3.1 forum.


    The bookmarks however didn't make the transition. I have over 2000 members and some of them had pages of bookmarks. And they have asked every day if I would please try to retrieve their bookmarks I have looked thru the SQL dump and its so large that I cant find the bookmark section. Even if I did find it I probably wouldn't be able to use it.


    Is their anyway possible that I can pay you to help me. I have the SQL dump from the day before the upgrade happened. I have people using the new bookmark plugin and its working great. I just need to bring the old bookmarks over and make them happy. ^^

  • Well, the 2.x-version has an export function...

    If you did an upgrade to 3.1 (not import), it would be possible. During an update user and post IDs do not change; doing an import, they might change.


    Try to extract the table wbb1_uzbookmark from the dump and we'll see.

  • I just checked in the new database and all 831 bookmarks are there. Is there a way to reindex so that it will pick up those bookmarks and put them under each user that had them. Or if the user had a way to find the post ID they could just find the post with this list and recreate the bookmark. But like I said they are all in the new database.


    Below is a snippet of the list that is attached. There are about 831 bookmarks total.

    192;"1483238933";"50137";"569";"Street Doc";"1473507412";"42";"Amp and speakers"
    193;"1483285296";"79830";"244";"V-SHOT";"1483148225";"66";"Calculating fuse size needed"
    194;"1483445562";"80393";"112";"TheRock";"1483332698";"31";"Speaker wire color code"
    195;"1483451185";"80708";"31";"Tripod";"1483450647";"31";"My stereo upgrade "
    196;"1483606421";"14460";"25";"WraithSS";"1463419843";"542";"Camera Wiring"
    197;"1483847118";"82403";"1";"rabtech";"1483823123";"66";
    198;"1484051027";"83055";"102";"WOLF";"1484018121";"42";"Pods"
    199;"1484107752";"83233";"78";"Ruptured Duck";"1484096789";"66";
    200;"1484184672";"82877";"367";"KayTwo";"1483975182";"367";"LED strip connectors"
    201;"1484188001";"83262";"175";"EjFord";"1484100332";"145";"Good read you created us.


    202";"1484371323";"81893";"393";"Jeff@DDMWorks";"1483743336";"747";"Ddm turbo


    203";"1484416467";"82000";"227";"King";"1483758682";"66";
    204;"1484686750";"84919";"82";"Slingrazor";"1484605115";"66";
    205;"1484857413";"85435";"1";"rabtech";"1484710851";"66";
    206;"1485394199";"88215";"31";"Tripod";"1485369507";"367";"Battery comparison"
    207;"1485478920";"88716";"401";"mniron";"1485476797";"259";"POWER GRIP HOSE CLAMP"
    208;"1486046452";"90399";"155";"Gonfast38";"1486045843";"850";"tire info"
    209;"1486421186";"91696";"569";"Street Doc";"1486420804";"367";"Horn"
    210;"1486692906";"91596";"275";"Jeff Welter";"1486387147";"24";"Welter "
    211;"1486812132";"93090";"51";"robert.piner";"1486770603";"726";
    212;"1486907010";"13875";"187";"Jdin";"1463253339";"187";"My Sim Rig"
    213;"1486949112";"93802";"1";"rabtech";"1486948944";"66";
    214;"1487041047";"94103";"31";"Tripod";"1487037063";"726";"Torque Specs"
    215;"1487164912";"94462";"313";"MEFIburn";"1487132153";"29";"Mefi"

    307;"1497463726";"131895";"530";"VIPNiSS";"1497411703";"29";"halo information"
    308;"1497532067";"131873";"530";"VIPNiSS";"1497409324";"24";"Halo sizes"
    309;"1497739703";"129871";"25";"WraithSS";"1496918255";"6";
    310;"1497791451";"132921";"491";"Goats_Hogs";"1497747472";"381";"Swing arm bolt"
    311;"1497929973";"133398";"429";"Ross";"1497926848";"381";
    312;"1497977237";"133304";"367";"KayTwo";"1497909216";"1120";"2016 slingshot"
    313;"1498153744";"131895";"530";"VIPNiSS";"1497411703";"34";"Halo set up"
    314;"1498154022";"62172";"75";"MACAWS";"1477532057";"947";"thread pulling hub"
    315;"1498158517";"123324";"146";"BryanL";"1495081097";"34";"plug to do a horn mod"
    316;"1498185319";"133487";"1";"rabtech";"1497969492";"381";
    317;"1498424536";"134838";"13";"Bill Martin";"1498424099";"367";"Anti rust"
    318;"1498428073";"134838";"13";"Bill Martin";"1498424099";"838";"Rust protection info"
    319;"1498508800";"135087";"259";"mytoy";"1498506742";"95";"Dieter's Windshield"
    320;"1498607361";"41536";"1";"rabtech";"1471190578";"31";"Knock Sensor pic"
    321;"1498819996";"33703";"107";"BKL";"1468888176";"274";"Bkl ride"
    322;"1498880416";"51970";"255";"gkrepps57";"1474235262";"1211";"sena setup"
    323;"1498921243";"136323";"268";"Flybuddy";"1498915389";"274";"harley jokes"
    324;"1499048021";"128947";"556";"scootertrash";"1496703216";"924";"F4+3 Mean Sling top"
    325;"1499479904";"137726";"1085";"Bigdog";"1499473285";"381";
    326;"1499625288";"137984";"268";"Flybuddy";"1499623626";"381";
    327;"1499712492";"137956";"386";"Live-a-Little!";"1499609752";"34";"transmission mount"
    328;"1499740792";"254";"21";"Painter";"1460323401";"1086";"Panel removal "
    330;"1500860331";"141094";"73";"FunCycle";"1500836693";"43";
    332;"1500946763";"141358";"401";"mniron";"1500944889";"491";
    333;"1501012751";"141463";"182";"ivor";"1500982904";"43";
    334;"1501027955";"141623";"837";"UK_Paul";"1501025861";"29";"Luggage carrier"
    336;"1501089476";"7261";"276";"hrmiracle";"1461591320";"65";"Center headlight replacement"
    337;"1501120684";"141671";"9";"Nemesis1701";"1501036591";"95";"Rear Trunk Spoiler"
    338;"1501197723";"137347";"61";"airoutlaw";"1499357265";"381";
    339;"1501272176";"142425";"244";"V-SHOT";"1501271904";"367";"Halos"
    340;"1501861598";"115931";"16";"gpcustoms";"1493075089";"13";"Bolts"
    342;"1502156981";"69309";"556";"scootertrash";"1480043984";"367";
    343;"1502566478";"145579";"95";"Bubblehead";"1502563573";"29";"Tshirts"
    344;"1502570763";"79154";"31";"Tripod";"1482947275";"31";"Rear view mirror 1"
    345;"1502900488";"146337";"392";"Dave@DDMWorks";"1502896898";"29";"What oil to use"
    347;"1502905923";"146369";"31";"Tripod";"1502904361";"198";"Belt alignment noise


    348";"1502919984";"142153";"1302";"Slingshot Racing Cup";"1501206383";"66";"race club"
    349;"1502993899";"146388";"392";"Dave@DDMWorks";"1502911827";"850";"oil for the sling"
    350;"1503194503";"147015";"13";"Bill Martin";"1503193050";"1180";
    351;"1503272304";"145610";"31";"Tripod";"1502576846";"381";
    352;"1504022546";"149297";"1229";"Tech_Rick";"1504020809";"31";"Oil Drain Valve"
    353;"1504067751";"147690";"75";"MACAWS";"1503537935";"402";"2017 SS Booze & Blues."
    354;"1504115976";"94103";"31";"Tripod";"1487037063";"838";"Slingshot Torque"
    355;"1504332526";"28636";"531";"ClarionMike";"1467316130";"1366";


  • I just checked in the new database and all 831 bookmarks are there.

    How fortunate ;)


    Use the attached plugin to convert the old bookmarks into the new format. It will do the work during installation. Just uninstall it afterwards and do not re-install it. Each installation will create new bookmarks. If everything is ok, you can delete the old table wbb1_uzbookmark.


    Please, use it only if you did an update and not an import; it requires the user and post IDs to be identical (old / new system). And there must be reasonable PHP script limits, because it might take some time to execute it.


    Warnung: I could only do a rudimentary test run; too many data and lacking your users / posts. Better try it first in your test / backup installation...