im portal sql fout

Hulp nodig bij een modificaties of op zoek naar een MOD? Bekijk ons archief. Support wordt helaas niet meer verleend.
Forumregels

Sinds 1 januari 2009 wordt phpBB2 niet meer ondersteund.
Onderstaande informatie is verouderd en dient uitsluitend als archief.
phpBB2.0.x
Gesloten
ajcied
Berichten: 657
Lid geworden op: 28 feb 2004, 12:55

im portal sql fout

Bericht door ajcied » 05 sep 2004, 19:58

Code: Selecteer alles

INSERT INTO phpbb_blocks VALUES (1, 'Board Navigation', '<table width="100%" cellpadding="0" cellspacing="1" border="0">\r\n<tr>\r\n<td align="left"><span class="genmed" style="line-height: 150%">\r\n<a href="portal.php">Home</a><br />\r\n<a href="index.php">Forum</a><br />\r\n<a href="memberlist.php">Meamberlist</a><br />\r\n<a href="faq.php">FAQ</a><br />\r\n<a href="search.php">Search</a><br />\r\n</span></td>\r\n</tr>\r\n</table>', '@', 2, 1, '', 0, 0, 0, 0, '', 0, 1, 1, 1, 0, '');
INSERT INTO phpbb_blocks VALUES (2, 'Statistics', '', 'r', 3, 1, 'blocks_imp_statistics', 0, 1, 1, 43200, '', 1, 1, 1, 1, 0, '5');
INSERT INTO phpbb_blocks VALUES (3, 'Links', '<table width="100%" cellpadding="0" cellspacing="1" border="0">\r\n<tr>\r\n<td class="row1" align="center"><a href="http://phpbbintegramod.sourceforge.net" target="_blank" class="gen">IntegraMOD</a></td>\r\n</tr>\r\n</table>', 'r', 2, 1, '', 0, 1, 0, 0, '', 0, 1, 1, 1, 0, '');
INSERT INTO phpbb_blocks VALUES (4, 'Welcome to IM Portal', '<table cellspacing="0" cellpadding="0" border="0" width="100%">\r\n<tr>\r\n<td align="center"><span class="gen">\r\nWelcome to IM Portal<br /><br />For questions, comments and suggestions, please visit <a href="http://www.integramod.com">IntegraMOD</a>\r\n</span>\r\n</td>\r\n</tr>\r\n</table>', 'c', 2, 1, '', 0, 1, 0, 0, '', 0, 1, 1, 1, 0, '');
INSERT INTO phpbb_blocks VALUES (5, 'News', '', 'c', 3, 1, 'blocks_imp_forum', 0, 1, 0, 0, '', 1, 1, 1, 1, 0, '');
INSERT INTO phpbb_blocks VALUES (6, 'User Block', '', '@', 3, 1, 'blocks_imp_user_block', 0, 0, 0, 0, '', 1, 1, 1, 1, 0, '');
INSERT INTO phpbb_blocks VALUES (7, 'Who is Online', '', '@', 4, 1, 'blocks_imp_online_users', 0, 0, 1, 300, '', 1, 1, 1, 1, 0, '');
INSERT INTO phpbb_blocks VALUES (8, 'Poll', 'hkghk', 'r', 4, 1, 'blocks_imp_poll', 0, 1, 0, 0, '', 0, 1, 1, 1, 0, '');
INSERT INTO phpbb_blocks VALUES (9, 'Recent Topics', '', 'r', 1, 1, 'blocks_imp_recent_topics', 0, 1, 1, 300, '', 1, 1, 1, 1, 0, '');
INSERT INTO phpbb_blocks VALUES (10, 'Search', '', '@', 5, 1, 'blocks_imp_search', 0, 0, 1, 1000000000, '', 1, 1, 1, 1, 0, '');
INSERT INTO phpbb_blocks VALUES (11, 'sample block', '[size=12:81ef439b94][b:81ef439b94][color=red:81ef439b94]This is just a sample block[/color:81ef439b94][/b:81ef439b94] showing the capabilities of [b:81ef439b94][color=green:81ef439b94]IM Portal[/color:81ef439b94][/b:81ef439b94] with the use of BBCodes.[/size:81ef439b94] \r\n\r\n :lol:  8)  :o  :( \r\n[quote:81ef439b94]This version of IM Portal uses a multi-page feature to create more than one page for your portal.  Try visiting this address: [b:81ef439b94]http://www.myforum.com/portal.php?page=2[/b:81ef439b94]. Replace www.myforum.com with the correct location[/quote:81ef439b94]The block below (Welcome to IM Portal) is an example of a block using HTML.', 'c', 1, 1, '', 0, 1, 0, 0, '81ef439b94', 1, 1, 1, 1, 0, '');
INSERT INTO phpbb_blocks VALUES (12, 'Sample 1', 'This page shows an example of the multi-page feature of IM Portal.  This page also displays the forum-wide blocks.\r\n\r\n[code:1:82bdfbd9b5]Try to visit: http://www.myforum.com/portal.php?page=3[/code:1:82bdfbd9b5]', 'c', 1, 1, '', 0, 2, 0, 0, '82bdfbd9b5', 1, 1, 1, 1, 0, '');
INSERT INTO phpbb_blocks VALUES (13, 'Sample 6', 'This block also shows the [b:0c6a883c90][color=orange:0c6a883c90]multi-page feature of IM Portal[/color:0c6a883c90][/b:0c6a883c90].  But this time, it does not display the forum-wide blocks.\r\n\r\nYou can now proceed to the [b:0c6a883c90][color=blue:0c6a883c90]ACP[/color:0c6a883c90][/b:0c6a883c90] and delete the sample layouts/pages in the layout management page.', 'c', 1, 1, '', 0, 3, 0, 0, '0c6a883c90', 1, 1, 1, 1, 0, '');
INSERT INTO phpbb_blocks VALUES (14, 'News', '', 'c', 4, 1, 'blocks_imp_forum', 0, 3, 0, 0, '', 0, 1, 1, 1, 0, '');
INSERT INTO phpbb_blocks VALUES (15, 'Sample 2', 'This is the new feature of IM Portal which enables a block with the following options:[list:8466b58e05][*:8466b58e05]with or without titlebar\r\n[*:8466b58e05]with or without border\r\n[*:8466b58e05]with or without background[/list:u:8466b58e05]\r\nThis block is without a titlebar, border and background', 'c', 2, 1, '', 0, 2, 0, 0, '8466b58e05', 1, 0, 0, 0, 0, '');
INSERT INTO phpbb_blocks VALUES (16, 'Sample 3', 'Without titlebar only  :o', 'c', 3, 1, '', 0, 2, 0, 0, '7e13fbbacc', 1, 1, 0, 1, 0, '');
INSERT INTO phpbb_blocks VALUES (17, 'Sample 4', 'Without background only  :wink:', 'c', 4, 1, '', 0, 2, 0, 0, '5b8176554c', 1, 1, 1, 0, 0, '');
INSERT INTO phpbb_blocks VALUES (18, 'Sample 5', 'Without border  :arrow:  :idea:  :arrow:', 'c', 5, 1, '', 0, 2, 0, 0, 'ed31156971', 1, 0, 1, 1, 0, '');
INSERT INTO phpbb_blocks VALUES (19, 'Sample 7', 'Take note that pages and blocks can have different permissions.  There are 2 kinds of permissions to set, per user level and per usergroups.  It is allowed to mix permissions but it is wise to set the user level to registered when usergroups are used (e.g. making a page only accessible for a specific usergroup)  :wink:', 'c', 2, 1, '', 0, 3, 0, 0, '16703bc74c', 1, 1, 0, 0, 0, '');
INSERT INTO phpbb_blocks VALUES (20, 'Sample 8', 'To support localization for IM Portal, titlebars can also be localized so titles being displayed, instead of being retrieved from the database will be retrieved from the language files.  This only applies for those blocks which has a language file.  :shock:  8)', 'c', 3, 1, '', 0, 3, 0, 0, '48d2dd24ac', 1, 0, 1, 0, 0, '');
Als ik die in voer krijg een een foutmelding(gebruik de phpBBhack db generator)

Gebruikersavatar
Luuk
Berichten: 7311
Lid geworden op: 22 okt 2003, 10:07
Locatie: Delft

Bericht door Luuk » 05 sep 2004, 20:05

en wat is die foutmelding :roll:
Afbeelding

ajcied
Berichten: 657
Lid geworden op: 28 feb 2004, 12:55

Bericht door ajcied » 06 sep 2004, 15:21

Parse error: parse error in /data/members/free/tripod/nl/r/o/s/rosaleszone/htdocs/phpBB2/db_update.php on line 57

http://members.lycos.nl/rosaleszone/php ... update.txt

Gebruikersavatar
mosymuis
Berichten: 6940
Lid geworden op: 05 feb 2003, 14:00
Locatie: Amsterdam
Contacteer:

Bericht door mosymuis » 06 sep 2004, 15:49

Logisch... query #1 puilt uit van de dubbele quotes.

Zoek

Code: Selecteer alles

$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (1, 'Board Navigation', '<table width="100%" cellpadding="0" cellspacing="1" border="0">\r\n<tr>\r\n<td align="left"><span class="genmed" style="line-height: 150%">\r\n<a href="portal.php">Home</a><br />\r\n<a href="index.php">Forum</a><br />\r\n<a href="memberlist.php">Meamberlist</a><br />\r\n<a href="faq.php">FAQ</a><br />\r\n<a href="search.php">Search</a><br />\r\n</span></td>\r\n</tr>\r\n</table>', '@', 2, 1, '', 0, 0, 0, 0, '', 0, 1, 1, 1, 0, '')";
Vervang met

Code: Selecteer alles

$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (1, 'Board Navigation', '<table width=\"100%\" cellpadding=\"0\" cellspacing=\"1\" border=\"0\">\r\n<tr>\r\n<td align=\"left\"><span class=\"genmed\" style=\"line-height: 150%\">\r\n<a href=\"portal.php\">Home</a><br />\r\n<a href=\"index.php\">Forum</a><br />\r\n<a href=\"memberlist.php\">Meamberlist</a><br />\r\n<a href=\"faq.php\">FAQ</a><br />\r\n<a href=\"search.php\">Search</a><br />\r\n</span></td>\r\n</tr>\r\n</table>', '@', 2, 1, '', 0, 0, 0, 0, '', 0, 1, 1, 1, 0, '')";

ajcied
Berichten: 657
Lid geworden op: 28 feb 2004, 12:55

Bericht door ajcied » 06 sep 2004, 15:58

Parse error: parse error in /data/members/free/tripod/nl/r/o/s/rosaleszone/htdocs/phpBB2/db_update.php on line 59 :x :(

Gebruikersavatar
mosymuis
Berichten: 6940
Lid geworden op: 05 feb 2003, 14:00
Locatie: Amsterdam
Contacteer:

Bericht door mosymuis » 06 sep 2004, 16:03

Kijk nu eens wat ik gedaan heb? Hetzelfde probleem heb je op regel 59; dit kan je nu dus zelf oplossen.

ajcied
Berichten: 657
Lid geworden op: 28 feb 2004, 12:55

Bericht door ajcied » 06 sep 2004, 17:12

snap niet hoe je het doen :oops:
zou jij het willen oplossen in een bestandje?

Gebruikersavatar
Luuk
Berichten: 7311
Lid geworden op: 22 okt 2003, 10:07
Locatie: Delft

Bericht door Luuk » 06 sep 2004, 17:53

als er html staat, bijvoorbeeld target="_blank" moet je dat veranderen in target=\"_blank\"
dus bij alle html de " vervangen door \"
Afbeelding

Gesloten