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

    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";


    rabtech wrote:

    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...