Tabellen eruit

Installatie lukt niet? Plotseling een foutmelding. Of weet je niet hoe iets werkt. Problemen met phpBB2 kun je in dit archief opzoeken.
Forumregels

Sinds 1 januari 2009 wordt phpBB2 niet meer ondersteund.
Onderstaande informatie is verouderd en dient uitsluitend als archief.phpBB2.0.x
Gesloten
Gebruikersavatar
Impactforra
Berichten: 327
Lid geworden op: 01 nov 2005, 16:37

Tabellen eruit

Bericht door Impactforra » 09 jan 2006, 19:56

Code: Selecteer alles

$sql = array();
$sql[] = "DROP TABLE " . $table_prefix . "config (config_name, config_value) VALUES ('smilie_columns', '4')";
$sql[] = "DROP TABLE " . $table_prefix . "config (config_name, config_value) VALUES ('smilie_rows', '5')";
$sql[] = "DROP TABLE " . $table_prefix . "config (config_name, config_value) VALUES ('smilie_window_columns', '8')";
$sql[] = "DROP TABLE " . $table_prefix . "config (config_name, config_value) VALUES ('smilie_cat_min', '2')";
$sql[] = "DROP TABLE " . $table_prefix . "config (config_name, config_value) VALUES ('show_smilie_cat_name', '1')";
$sql[] = "DROP TABLE IF EXISTS `" . $table_prefix . "smilies_cat`";
$sql[] = "CREATE TABLE `" . $table_prefix . "smilies_cat` (
  `cat_id` smallint(3) unsigned NOT NULL auto_increment,
  `cat_name` varchar(255) NOT NULL default '',
  `description` varchar(255) NOT NULL default 'N/A',
  `cat_order` smallint(3) NOT NULL default '0',
  `hidden` tinyint(1) NOT NULL default '1',
  `smilies_total` smallint(4) NOT NULL default '0',
  PRIMARY KEY  (`cat_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies_cat` VALUES (1, 'phpBB', 'The default phpBB Smiles', 1, 0, 46)";
$sql[] = "DROP TABLE IF EXISTS `" . $table_prefix . "smilies`";
$sql[] = "CREATE TABLE `" . $table_prefix . "smilies` (
  `smilies_id` smallint(5) unsigned NOT NULL auto_increment,
  `code` varchar(50) default NULL,
  `smile_url` varchar(100) default NULL,
  `emoticon` varchar(75) default NULL,
  `cat_id` smallint(5) NOT NULL default '1',
  `smilies_order` smallint(5) NOT NULL default '0',
  `cat_hidden` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`smilies_id`)
) ENGINE=MyISAM AUTO_INCREMENT=47";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (1, ':arrow:', 'icon_arrow.gif', 'Arrow', 1, 1, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (2, ':-D', 'icon_biggrin.gif', 'Very Happy', 1, 2, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (3, ':D', 'icon_biggrin.gif', 'Very Happy', 1, 3, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (4, ':grin:', 'icon_biggrin.gif', 'Very Happy', 1, 4, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (5, ':-?', 'icon_confused.gif', 'Confused', 1, 5, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (6, ':?', 'icon_confused.gif', 'Confused', 1, 6, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (7, ':???:', 'icon_confused.gif', 'Confused', 1, 7, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (8, '8)', 'icon_cool.gif', 'Cool', 1, 8, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (9, '8-)', 'icon_cool.gif', 'Cool', 1, 9, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (10, ':cool:', 'icon_cool.gif', 'Cool', 1, 10, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (11, ':''(', 'icon_cry.gif', 'Crying or Very sad', 1, 11, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (12, ':''-(', 'icon_cry.gif', 'Crying or Very sad', 1, 12, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (13, ':cry:', 'icon_cry.gif', 'Crying or Very sad', 1, 13, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (14, ':shocked:', 'icon_eek.gif', 'Shocked', 1, 14, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (15, ':evil:', 'icon_evil.gif', 'Evil or Very Mad', 1, 15, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (16, ':!:', 'icon_exclaim.gif', 'Exclamation', 1, 16, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (17, ':idea:', 'icon_idea.gif', 'Idea', 1, 17, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (18, ':lol:', 'icon_lol.gif', 'Laughing', 1, 18, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (19, ':-x', 'icon_mad.gif', 'Mad', 1, 19, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (20, ':mad:', 'icon_mad.gif', 'Mad', 1, 20, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (21, ':x', 'icon_mad.gif', 'Mad', 1, 21, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (22, ':mrgreen:', 'icon_mrgreen.gif', 'Mr. Green', 1, 22, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (23, ':-|', 'icon_neutral.gif', 'Neutral', 1, 23, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (24, ':neutral:', 'icon_neutral.gif', 'Neutral', 1, 24, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (25, ':|', 'icon_neutral.gif', 'Neutral', 1, 25, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (26, ':?:', 'icon_question.gif', 'Question', 1, 26, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (27, ':-P', 'icon_razz.gif', 'Razz', 1, 27, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (28, ':-p', 'icon_razz.gif', 'Razz', 1, 28, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (29, ':P', 'icon_razz.gif', 'Razz', 1, 29, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (30, ':p', 'icon_razz.gif', 'Razz', 1, 30, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (31, ':razz:', 'icon_razz.gif', 'Razz', 1, 31, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (32, ':oops:', 'icon_redface.gif', 'Embarassed', 1, 32, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (33, ':roll:', 'icon_rolleyes.gif', 'Rolling Eyes', 1, 33, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (34, ':(', 'icon_sad.gif', 'Sad', 1, 34, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (35, ':-(', 'icon_sad.gif', 'Sad', 1, 35, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (36, ':sad:', 'icon_sad.gif', 'Sad', 1, 36, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (37, ':)', 'icon_smile.gif', 'Smile', 1, 37, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (38, ':-)', 'icon_smile.gif', 'Smile', 1, 38, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (39, ':smile:', 'icon_smile.gif', 'Smile', 1, 39, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (40, ':-o', 'icon_surprised.gif', 'Surprised', 1, 40, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (41, ':eek:', 'icon_surprised.gif', 'Surprised', 1, 41, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (42, ':o', 'icon_surprised.gif', 'Surprised', 1, 42, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (43, ':twisted:', 'icon_twisted.gif', 'Twisted Evil', 1, 43, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (44, ':wink:', 'icon_wink.gif', 'Wink', 1, 44, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (45, ';)', 'icon_wink.gif', 'Wink', 1, 45, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (46, ';-)', 'icon_wink.gif', 'Wink', 1, 46, 0)";
Kan iemand dit zo maken dat alle tabellen eruit liggen?

Mijn error:

Code: Selecteer alles

Couldn't obtain smilies data

DEBUG MODE

SQL Error : 1146 Table 'phpbb2.phpbb2_smilies' doesn't exist

SELECT * FROM phpbb2_smilies

Line : 755
File : bbcode.php
Waarom het file niet goed is? Zie maar:

Code: Selecteer alles

# DROP TABLE phpbb2_config (config_name, config_value) VALUES ('smilie_columns', '4')
+++ Error: You have an error in your SQL syntax near '(config_name, config_value) VALUES ('smilie_columns', '4')' at line 1

# DROP TABLE phpbb2_config (config_name, config_value) VALUES ('smilie_rows', '5')
+++ Error: You have an error in your SQL syntax near '(config_name, config_value) VALUES ('smilie_rows', '5')' at line 1

# DROP TABLE phpbb2_config (config_name, config_value) VALUES ('smilie_window_columns', '8')
+++ Error: You have an error in your SQL syntax near '(config_name, config_value) VALUES ('smilie_window_columns', '8')' at line 1

# DROP TABLE phpbb2_config (config_name, config_value) VALUES ('smilie_cat_min', '2')
+++ Error: You have an error in your SQL syntax near '(config_name, config_value) VALUES ('smilie_cat_min', '2')' at line 1

# DROP TABLE phpbb2_config (config_name, config_value) VALUES ('show_smilie_cat_name', '1')
+++ Error: You have an error in your SQL syntax near '(config_name, config_value) VALUES ('show_smilie_cat_name', '1')' at line 1

# DROP TABLE IF EXISTS `phpbb2_smilies_cat`
+++ Successful

# CREATE TABLE `phpbb2_smilies_cat` ( `cat_id` smallint(3) unsigned NOT NULL auto_increment, `cat_name` varchar(255) NOT NULL default '', `description` varchar(255) NOT NULL default 'N/A', `cat_order` smallint(3) NOT NULL default '0', `hidden` tinyint(1) NOT NULL default '1', `smilies_total` smallint(4) NOT NULL default '0', PRIMARY KEY (`cat_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2
+++ Error: You have an error in your SQL syntax near 'ENGINE=MyISAM AUTO_INCREMENT=2' at line 9

# DROP TABLE `phpbb2_smilies_cat` VALUES (1, 'phpBB', 'The default phpBB Smiles', 1, 0, 46)
+++ Error: You have an error in your SQL syntax near 'VALUES (1, 'phpBB', 'The default phpBB Smiles', 1, 0, 46)' at line 1

# DROP TABLE IF EXISTS `phpbb2_smilies`
+++ Successful

# CREATE TABLE `phpbb2_smilies` ( `smilies_id` smallint(5) unsigned NOT NULL auto_increment, `code` varchar(50) default NULL, `smile_url` varchar(100) default NULL, `emoticon` varchar(75) default NULL, `cat_id` smallint(5) NOT NULL default '1', `smilies_order` smallint(5) NOT NULL default '0', `cat_hidden` tinyint(1) NOT NULL default '1', PRIMARY KEY (`smilies_id`) ) ENGINE=MyISAM AUTO_INCREMENT=47
+++ Error: You have an error in your SQL syntax near 'ENGINE=MyISAM AUTO_INCREMENT=47' at line 10

# DROP TABLE `phpbb2_smilies` VALUES (1, ':arrow:', 'icon_arrow.gif', 'Arrow', 1, 1, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (1, ':arrow:', 'icon_arrow.gif', 'Arrow', 1, 1, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (2, ':-D', 'icon_biggrin.gif', 'Very Happy', 1, 2, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (2, ':-D', 'icon_biggrin.gif', 'Very Happy', 1, 2, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (3, ':D', 'icon_biggrin.gif', 'Very Happy', 1, 3, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (3, ':D', 'icon_biggrin.gif', 'Very Happy', 1, 3, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (4, ':grin:', 'icon_biggrin.gif', 'Very Happy', 1, 4, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (4, ':grin:', 'icon_biggrin.gif', 'Very Happy', 1, 4, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (5, ':-?', 'icon_confused.gif', 'Confused', 1, 5, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (5, ':-?', 'icon_confused.gif', 'Confused', 1, 5, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (6, ':?', 'icon_confused.gif', 'Confused', 1, 6, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (6, ':?', 'icon_confused.gif', 'Confused', 1, 6, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (7, ':???:', 'icon_confused.gif', 'Confused', 1, 7, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (7, ':???:', 'icon_confused.gif', 'Confused', 1, 7, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (8, '8)', 'icon_cool.gif', 'Cool', 1, 8, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (8, '8)', 'icon_cool.gif', 'Cool', 1, 8, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (9, '8-)', 'icon_cool.gif', 'Cool', 1, 9, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (9, '8-)', 'icon_cool.gif', 'Cool', 1, 9, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (10, ':cool:', 'icon_cool.gif', 'Cool', 1, 10, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (10, ':cool:', 'icon_cool.gif', 'Cool', 1, 10, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (11, ':''(', 'icon_cry.gif', 'Crying or Very sad', 1, 11, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (11, ':''(', 'icon_cry.gif', 'Crying or Very sad', 1, 11, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (12, ':''-(', 'icon_cry.gif', 'Crying or Very sad', 1, 12, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (12, ':''-(', 'icon_cry.gif', 'Crying or Very sad', 1, 12, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (13, ':cry:', 'icon_cry.gif', 'Crying or Very sad', 1, 13, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (13, ':cry:', 'icon_cry.gif', 'Crying or Very sad', 1, 13, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (14, ':shocked:', 'icon_eek.gif', 'Shocked', 1, 14, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (14, ':shocked:', 'icon_eek.gif', 'Shocked', 1, 14, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (15, ':evil:', 'icon_evil.gif', 'Evil or Very Mad', 1, 15, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (15, ':evil:', 'icon_evil.gif', 'Evil or Very Mad', 1, 15, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (16, ':!:', 'icon_exclaim.gif', 'Exclamation', 1, 16, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (16, ':!:', 'icon_exclaim.gif', 'Exclamation', 1, 16, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (17, ':idea:', 'icon_idea.gif', 'Idea', 1, 17, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (17, ':idea:', 'icon_idea.gif', 'Idea', 1, 17, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (18, ':lol:', 'icon_lol.gif', 'Laughing', 1, 18, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (18, ':lol:', 'icon_lol.gif', 'Laughing', 1, 18, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (19, ':-x', 'icon_mad.gif', 'Mad', 1, 19, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (19, ':-x', 'icon_mad.gif', 'Mad', 1, 19, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (20, ':mad:', 'icon_mad.gif', 'Mad', 1, 20, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (20, ':mad:', 'icon_mad.gif', 'Mad', 1, 20, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (21, ':x', 'icon_mad.gif', 'Mad', 1, 21, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (21, ':x', 'icon_mad.gif', 'Mad', 1, 21, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (22, ':mrgreen:', 'icon_mrgreen.gif', 'Mr. Green', 1, 22, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (22, ':mrgreen:', 'icon_mrgreen.gif', 'Mr. Green', 1, 22, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (23, ':-|', 'icon_neutral.gif', 'Neutral', 1, 23, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (23, ':-|', 'icon_neutral.gif', 'Neutral', 1, 23, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (24, ':neutral:', 'icon_neutral.gif', 'Neutral', 1, 24, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (24, ':neutral:', 'icon_neutral.gif', 'Neutral', 1, 24, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (25, ':|', 'icon_neutral.gif', 'Neutral', 1, 25, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (25, ':|', 'icon_neutral.gif', 'Neutral', 1, 25, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (26, ':?:', 'icon_question.gif', 'Question', 1, 26, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (26, ':?:', 'icon_question.gif', 'Question', 1, 26, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (27, ':-P', 'icon_razz.gif', 'Razz', 1, 27, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (27, ':-P', 'icon_razz.gif', 'Razz', 1, 27, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (28, ':-p', 'icon_razz.gif', 'Razz', 1, 28, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (28, ':-p', 'icon_razz.gif', 'Razz', 1, 28, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (29, ':P', 'icon_razz.gif', 'Razz', 1, 29, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (29, ':P', 'icon_razz.gif', 'Razz', 1, 29, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (30, ':p', 'icon_razz.gif', 'Razz', 1, 30, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (30, ':p', 'icon_razz.gif', 'Razz', 1, 30, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (31, ':razz:', 'icon_razz.gif', 'Razz', 1, 31, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (31, ':razz:', 'icon_razz.gif', 'Razz', 1, 31, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (32, ':oops:', 'icon_redface.gif', 'Embarassed', 1, 32, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (32, ':oops:', 'icon_redface.gif', 'Embarassed', 1, 32, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (33, ':roll:', 'icon_rolleyes.gif', 'Rolling Eyes', 1, 33, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (33, ':roll:', 'icon_rolleyes.gif', 'Rolling Eyes', 1, 33, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (34, ':(', 'icon_sad.gif', 'Sad', 1, 34, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (34, ':(', 'icon_sad.gif', 'Sad', 1, 34, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (35, ':-(', 'icon_sad.gif', 'Sad', 1, 35, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (35, ':-(', 'icon_sad.gif', 'Sad', 1, 35, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (36, ':sad:', 'icon_sad.gif', 'Sad', 1, 36, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (36, ':sad:', 'icon_sad.gif', 'Sad', 1, 36, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (37, ':)', 'icon_smile.gif', 'Smile', 1, 37, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (37, ':)', 'icon_smile.gif', 'Smile', 1, 37, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (38, ':-)', 'icon_smile.gif', 'Smile', 1, 38, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (38, ':-)', 'icon_smile.gif', 'Smile', 1, 38, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (39, ':smile:', 'icon_smile.gif', 'Smile', 1, 39, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (39, ':smile:', 'icon_smile.gif', 'Smile', 1, 39, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (40, ':-o', 'icon_surprised.gif', 'Surprised', 1, 40, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (40, ':-o', 'icon_surprised.gif', 'Surprised', 1, 40, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (41, ':eek:', 'icon_surprised.gif', 'Surprised', 1, 41, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (41, ':eek:', 'icon_surprised.gif', 'Surprised', 1, 41, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (42, ':o', 'icon_surprised.gif', 'Surprised', 1, 42, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (42, ':o', 'icon_surprised.gif', 'Surprised', 1, 42, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (43, ':twisted:', 'icon_twisted.gif', 'Twisted Evil', 1, 43, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (43, ':twisted:', 'icon_twisted.gif', 'Twisted Evil', 1, 43, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (44, ':wink:', 'icon_wink.gif', 'Wink', 1, 44, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (44, ':wink:', 'icon_wink.gif', 'Wink', 1, 44, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (45, ';)', 'icon_wink.gif', 'Wink', 1, 45, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (45, ';)', 'icon_wink.gif', 'Wink', 1, 45, 0)' at line 1

# DROP TABLE `phpbb2_smilies` VALUES (46, ';-)', 'icon_wink.gif', 'Wink', 1, 46, 0)
+++ Error: You have an error in your SQL syntax near 'VALUES (46, ';-)', 'icon_wink.gif', 'Wink', 1, 46, 0)' at line 1
Omhoog
Gebruikersavatar
Paul
Beheerder
Beheerder
Berichten: 20316
Lid geworden op: 23 okt 2003, 11:38
Locatie: Utrecht
Contacteer:
Contacteer Paul

Bericht door Paul » 09 jan 2006, 20:00

Met die querys verwijder je tabbellen, alleen zijn ze niet goed :)

Toen ik voor het eerst ze zag, vond ik ze wel grappig :lol:
Omhoog
Gebruikersavatar
Impactforra
Berichten: 327
Lid geworden op: 01 nov 2005, 16:37

Bericht door Impactforra » 09 jan 2006, 20:01

paulus schreef:Met die querys verwijder je tabbellen, alleen zijn ze niet goed :)
Dit is me db_update.php zoals ik hem bij de mod kreeg

Code: Selecteer alles

<?php
/***************************************************************************
 *                               db_update.php
 *                            -------------------
 *
 *   copyright            : ©2003 Freakin' Booty ;-P & Antony Bailey
 *   project              : http://sourceforge.net/projects/dbgenerator
 *   Website              : http://freakingbooty.no-ip.com/ & http://www.rapiddr3am.net
 *
 ***************************************************************************/

/***************************************************************************
 *
 *   This program is free software; you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation; either version 2 of the License, or
 *   (at your option) any later version.
 *
 ***************************************************************************/

define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);

//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
//
// End session management
//


if( !$userdata['session_logged_in'] )
{
	$header_location = ( @preg_match('/Microsoft|WebSTAR|Xitami/', getenv('SERVER_SOFTWARE')) ) ? 'Refresh: 0; URL=' : 'Location: ';
	header($header_location . append_sid("login.$phpEx?redirect=db_update.$phpEx", true));
	exit;
}

if( $userdata['user_level'] != ADMIN )
{
	message_die(GENERAL_MESSAGE, 'You are not authorised to access this page');
}


$page_title = 'Updating the database';
include($phpbb_root_path . 'includes/page_header.'.$phpEx);

echo '<table width="100%" cellspacing="1" cellpadding="2" border="0" class="forumline">';
echo '<tr><th>Updating the database</th></tr><tr><td><span class="genmed"><ul type="circle">';


$sql = array();
$sql[] = "DROP TABLE " . $table_prefix . "config (config_name, config_value) VALUES ('smilie_columns', '4')";
$sql[] = "DROP TABLE " . $table_prefix . "config (config_name, config_value) VALUES ('smilie_rows', '5')";
$sql[] = "DROP TABLE " . $table_prefix . "config (config_name, config_value) VALUES ('smilie_window_columns', '8')";
$sql[] = "DROP TABLE " . $table_prefix . "config (config_name, config_value) VALUES ('smilie_cat_min', '2')";
$sql[] = "DROP TABLE " . $table_prefix . "config (config_name, config_value) VALUES ('show_smilie_cat_name', '1')";
$sql[] = "DROP TABLE IF EXISTS `" . $table_prefix . "smilies_cat`";
$sql[] = "CREATE TABLE `" . $table_prefix . "smilies_cat` (
  `cat_id` smallint(3) unsigned NOT NULL auto_increment,
  `cat_name` varchar(255) NOT NULL default '',
  `description` varchar(255) NOT NULL default 'N/A',
  `cat_order` smallint(3) NOT NULL default '0',
  `hidden` tinyint(1) NOT NULL default '1',
  `smilies_total` smallint(4) NOT NULL default '0',
  PRIMARY KEY  (`cat_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies_cat` VALUES (1, 'phpBB', 'The default phpBB Smiles', 1, 0, 46)";
$sql[] = "DROP TABLE IF EXISTS `" . $table_prefix . "smilies`";
$sql[] = "CREATE TABLE `" . $table_prefix . "smilies` (
  `smilies_id` smallint(5) unsigned NOT NULL auto_increment,
  `code` varchar(50) default NULL,
  `smile_url` varchar(100) default NULL,
  `emoticon` varchar(75) default NULL,
  `cat_id` smallint(5) NOT NULL default '1',
  `smilies_order` smallint(5) NOT NULL default '0',
  `cat_hidden` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`smilies_id`)
) ENGINE=MyISAM AUTO_INCREMENT=47";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (1, ':arrow:', 'icon_arrow.gif', 'Arrow', 1, 1, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (2, ':-D', 'icon_biggrin.gif', 'Very Happy', 1, 2, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (3, ':D', 'icon_biggrin.gif', 'Very Happy', 1, 3, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (4, ':grin:', 'icon_biggrin.gif', 'Very Happy', 1, 4, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (5, ':-?', 'icon_confused.gif', 'Confused', 1, 5, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (6, ':?', 'icon_confused.gif', 'Confused', 1, 6, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (7, ':???:', 'icon_confused.gif', 'Confused', 1, 7, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (8, '8)', 'icon_cool.gif', 'Cool', 1, 8, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (9, '8-)', 'icon_cool.gif', 'Cool', 1, 9, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (10, ':cool:', 'icon_cool.gif', 'Cool', 1, 10, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (11, ':''(', 'icon_cry.gif', 'Crying or Very sad', 1, 11, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (12, ':''-(', 'icon_cry.gif', 'Crying or Very sad', 1, 12, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (13, ':cry:', 'icon_cry.gif', 'Crying or Very sad', 1, 13, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (14, ':shocked:', 'icon_eek.gif', 'Shocked', 1, 14, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (15, ':evil:', 'icon_evil.gif', 'Evil or Very Mad', 1, 15, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (16, ':!:', 'icon_exclaim.gif', 'Exclamation', 1, 16, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (17, ':idea:', 'icon_idea.gif', 'Idea', 1, 17, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (18, ':lol:', 'icon_lol.gif', 'Laughing', 1, 18, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (19, ':-x', 'icon_mad.gif', 'Mad', 1, 19, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (20, ':mad:', 'icon_mad.gif', 'Mad', 1, 20, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (21, ':x', 'icon_mad.gif', 'Mad', 1, 21, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (22, ':mrgreen:', 'icon_mrgreen.gif', 'Mr. Green', 1, 22, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (23, ':-|', 'icon_neutral.gif', 'Neutral', 1, 23, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (24, ':neutral:', 'icon_neutral.gif', 'Neutral', 1, 24, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (25, ':|', 'icon_neutral.gif', 'Neutral', 1, 25, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (26, ':?:', 'icon_question.gif', 'Question', 1, 26, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (27, ':-P', 'icon_razz.gif', 'Razz', 1, 27, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (28, ':-p', 'icon_razz.gif', 'Razz', 1, 28, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (29, ':P', 'icon_razz.gif', 'Razz', 1, 29, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (30, ':p', 'icon_razz.gif', 'Razz', 1, 30, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (31, ':razz:', 'icon_razz.gif', 'Razz', 1, 31, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (32, ':oops:', 'icon_redface.gif', 'Embarassed', 1, 32, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (33, ':roll:', 'icon_rolleyes.gif', 'Rolling Eyes', 1, 33, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (34, ':(', 'icon_sad.gif', 'Sad', 1, 34, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (35, ':-(', 'icon_sad.gif', 'Sad', 1, 35, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (36, ':sad:', 'icon_sad.gif', 'Sad', 1, 36, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (37, ':)', 'icon_smile.gif', 'Smile', 1, 37, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (38, ':-)', 'icon_smile.gif', 'Smile', 1, 38, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (39, ':smile:', 'icon_smile.gif', 'Smile', 1, 39, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (40, ':-o', 'icon_surprised.gif', 'Surprised', 1, 40, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (41, ':eek:', 'icon_surprised.gif', 'Surprised', 1, 41, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (42, ':o', 'icon_surprised.gif', 'Surprised', 1, 42, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (43, ':twisted:', 'icon_twisted.gif', 'Twisted Evil', 1, 43, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (44, ':wink:', 'icon_wink.gif', 'Wink', 1, 44, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (45, ';)', 'icon_wink.gif', 'Wink', 1, 45, 0)";
$sql[] = "DROP TABLE `" . $table_prefix . "smilies` VALUES (46, ';-)', 'icon_wink.gif', 'Wink', 1, 46, 0)";

for( $i = 0; $i < count($sql); $i++ )
{
	if( !$result = $db->sql_query ($sql[$i]) )
	{
		$error = $db->sql_error();

		echo '<li>' . $sql[$i] . '<br /> +++ <font color="#FF0000"><b>Error:</b></font> ' . $error['message'] . '</li><br />';
	}
	else
	{
		echo '<li>' . $sql[$i] . '<br /> +++ <font color="#00AA00"><b>Successful</b></font></li><br />';
	}
}


echo '</ul></span></td></tr><tr><td class="catBottom" height="28">&nbsp;</td></tr>';

echo '<tr><th>Installation Complete</th></tr><tr><td><span class="genmed">Please be sure to delete this file now.<br />If you require any further assistance, please visit the <a href="http://www.phpbbhacks.com/forums">phpBBHacks.com Support Forums</a>.</span></td></tr>';
echo '<tr><td class="catBottom" height="28" align="center"><span class="genmed"><a href="' . append_sid("index.$phpEx") . '">Go back to your index page</a>.</span></td></table>';

include($phpbb_root_path . 'includes/page_tail.'.$phpEx);

?>
Kan je hier meer mee?
Omhoog
Gebruikersavatar
Paul
Beheerder
Beheerder
Berichten: 20316
Lid geworden op: 23 okt 2003, 11:38
Locatie: Utrecht
Contacteer:
Contacteer Paul

Bericht door Paul » 09 jan 2006, 20:03

Dat is absoluut niet goed. Het is de syntax voor een deel voor tabellen verwijderen, en voor een deel voor een rij in te voegen.
Omhoog
Gebruikersavatar
Impactforra
Berichten: 327
Lid geworden op: 01 nov 2005, 16:37

Bericht door Impactforra » 09 jan 2006, 20:04

paulus schreef:Dat is absoluut niet goed. Het is de syntax voor een deel voor tabellen verwijderen, en voor een deel voor een rij in te voegen.
Mijn probleem is, die heb ik toegevoegd maar nu ik die error heb gekregen door die mod wil ik hem weg? Weet jij een oplossing?
Omhoog
Gebruikersavatar
Impactforra
Berichten: 327
Lid geworden op: 01 nov 2005, 16:37

Bericht door Impactforra » 09 jan 2006, 22:09

Impactforra schreef:
paulus schreef:Dat is absoluut niet goed. Het is de syntax voor een deel voor tabellen verwijderen, en voor een deel voor een rij in te voegen.
Mijn probleem is, die heb ik toegevoegd maar nu ik die error heb gekregen door die mod wil ik hem weg? Weet jij een oplossing?
*Opgelost
Omhoog
Gesloten

Terug naar “2.0 Support”