DB-Table not found.

[nhet]

Hi, in my WBB 2.3.6 installation dosn't exists the DB-Table board_structure.

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'usr_web0_2.bb0_board_structure' doesn't exist' in /var/www/web0/html/forumMig/forums.php:79 Stack trace: #0 /var/www/web0/html/forumMig/forums.php(79): PDOStatement->execute() #1 /var/www/web0/html/forumMig/forums.php(140): insertForum(0, Object(PDO), Object(PDO), 1) #2 {main} thrown in /var/www/web0/html/forumMig/forums.php on line 79

[RobertZenz]

Could you please verify that this table does not exist by using your database frontend (like mysqladmin, HeidiSQL, whatever you use)? And in the same vein check if they may be named differently?

[nhet]

Hi,

this is the List of all tables in DB: bb0_access bb0_acpmenuitemgroups bb0_acpmenuitemgroupscount bb0_acpmenuitems bb0_acpmenuitemscount bb0_adminsessions bb0_announcements bb0_applications bb0_attachments bb0_avatars bb0_bbcodes bb0_bc_bann bb0_bc_config bb0_bc_gag bb0_bc_gag_raum bb0_bc_raum bb0_bc_raum_ban bb0_bc_text bb0_bc_useronline bb0_boards bb0_boardvisit bb0_config_kt bb0_designelements bb0_designpacks bb0_events bb0_f1tip_fahrer bb0_f1tip_gesamt bb0_f1tip_guthaben bb0_f1tip_options bb0_f1tip_punkte bb0_f1tip_rennen bb0_f1tip_spieler bb0_f1tip_team bb0_filebase_attachments bb0_filebase_entries bb0_filebase_moderators bb0_filebase_permissions bb0_filebases bb0_folders bb0_formel_config bb0_formel_fahrer bb0_formel_highscore bb0_formel_highscore_saison bb0_formel_rennen bb0_formel_strecken bb0_formel_tipps bb0_gal_cats bb0_gal_groups bb0_gal_highlights bb0_gal_mailed bb0_gal_main bb0_groupcombinations bb0_groupleaders bb0_groups bb0_groupvalues bb0_groupvariablegroups bb0_groupvariables bb0_icons bb0_jgs_betriebssystem bb0_jgs_bildschirm bb0_jgs_browser bb0_jgs_hits bb0_jgs_land bb0_jgs_portal_itratos bb0_jgs_portal_rdf bb0_jgs_ref bb0_jgs_sprache bb0_kt_ligen bb0_kt_mannschaften bb0_kt_paare bb0_kt_tabellendaten bb0_kt_tage bb0_kt_usertipps bb0_languagecats bb0_languagepacks bb0_languages bb0_linklist_werwarda bb0_linkliste_config bb0_linkliste_disclaimer bb0_linkliste_kategorien bb0_linkliste_links bb0_linkliste_links_kommentare bb0_mailqueue bb0_mails bb0_map_mod_config bb0_map_mod_country bb0_map_mod_map bb0_map_mod_place bb0_map_mod_text bb0_map_mod_user bb0_moderators bb0_optiongroups bb0_options bb0_permissions bb0_polloptions bb0_polls bb0_portal_box bb0_portal_box_type bb0_portal_hide bb0_portal_module bb0_portal_navilink bb0_portal_newscat bb0_portal_object2box bb0_portal_optiongroups bb0_portal_options bb0_portal_tip bb0_postcache bb0_posts bb0_privatemessage bb0_privatemessagereceipts bb0_profilefields bb0_ranks bb0_register_keys bb0_searchs bb0_sessions bb0_smilies bb0_sponsoren bb0_sponsoren_links_k bb0_sponsoren_links_l bb0_sponsoren_offuser bb0_sponsoren_seiten bb0_sponsoren_seitezubox bb0_sponsoren_sessions_clicks bb0_sponsoren_sessions_views bb0_sponsoren_statistik bb0_stats bb0_styles bb0_subscribeboards bb0_subscribethreads bb0_templatepacks bb0_templates bb0_threads bb0_threadvisit bb0_user2groups bb0_user_upload bb0_user_upload_config bb0_user_upload_daten bb0_userfields bb0_userpic bb0_userpic_config bb0_users bb0_vgthread_werb_config bb0_vgthread_werb_daten bb0_votes bb0_wlw bb0_wm2006_options bb0_wm2006_punkte bb0_wm2006_spiele bb0_wm2006_teams bb0_wm2006_userpunkte bb0_wm2006_usertipps bb0_wm2006_vortag bb0_wordlist bb0_wordmatch

[RobertZenz]

It looks like the structure of the database has changed. These import scripts where written based on WBB Lite 2, I believe 2.1 or something. Looks like the internal structure of all these tables has changed (or there always was a vast difference between Lite and not Lite). Now that I look at it, I most likely should mention that in the README, sorry for missing that.

I'm not sure if I can adapt the scripts to these changes, I neither have a WBB Lite and especially not WBB installation (and no PHPBB installation for that matter) at hand with which I could test these now.

If you could post the CREATE TABLE statements/table structures (so what columns they have, including their type) for

• bb0_boards
• bb0_posts
• bb0_users
• bb0_userfields
• bb0_threads

I could tell you how feasible it is to adapt the scripts, if at all feasible.

[nhet]

Hi,

I hope I have found the correct one. The installation is not the lite version. Version ist 2.3.6 Installation time somewhere in 2004 or 2005

structure.sql.txt

[RobertZenz]

That does look a little different, but nothing too alien, so there might be a way.

Let me take a closer look at this when I get home, no promises, though.

[nhet]

That sounds good.

[RobertZenz]

I've started working on the wbb-2.3.1 branch (which is already on the repo so that you can see it). I believe that threads, posts and users are already in a shape that it can be used, but forums/categories is a problem...is there a chance that you can provide me with a dump of the data together with a screenshot of the forum which shows how the forums/categories are sorted?

What I'd need would be the output of this select:

SELECT
    boardid,
    styleid,
    parentid,
    parentlist,
    childlist,
    boardorder,
    title,
    description,
    sortfield,
    sortorder,
    isboard
FROM
    bb1_boards;

If you're uncomfortable with giving out this information publicly, maybe you can send it to me by e-mail.

Why are these such a problem? Well, ordering of the forums/categories was/is a clusterfuck in both, the WBB I originally worked with and PHPBB...it's complicated, and from the data structure you provided it seems like it changed significantly. Without the actual data I could only guess...which would take us both a lot of time to get right.

[nhet]

Hi,

I think bb0_boards.sql.txt that isn't confidential. :)

[RobertZenz]

Okay, that seemed easier than thought. You can find the scripts in the wbb-2.3.1 branch (which is accessible over the web UI through the branch button next to the title).

Those should work, I can only verify that I did not do any blatant typos, but can't verify the logic I wrote without spending a lot more time. So, please try those and report any errors and the results and I'll see if I can get that sorted out if something pops up.