Een error in mijn sql script
Ik zit met een klein probleempje. Ik ben sinds gisteren bezig met een installatie script van mijn software en het ziet er al (ookal zeg ik het zelf) aardig mooi uit. Het enigste dat mijn uitzicht verpest is een MySQL error. Dit is het script waar de error vandaan komt:
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
$install_sql_server = $_POST['sql_server'];
$install_sql_usernm = $_POST['sql_uname'];
$install_sql_passwd = $_POST['sql_pass'];
$install_sql_dbname = $_POST['sql_name'];
$install_sql_dbpref = $_POST['sql_pref'];
global $install_sql_server, $install_sql_usernm, $install_sql_passwd, $install_sql_dbname, $install_sql_dbpref;
mysql_connect($install_sql_server, $install_sql_usernm, $install_sql_passwd) or die ("Incorrect sql password, server or username. Please try again");
mysql_select_db($install_sql_dbname) or die ("Invalid database. Please try again and remember that you'll have to create the database manually");
mysql_query("
CREATE TABLE IF NOT EXISTS `".$install_sql_dbpref."blogreplies` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`poster` longtext NOT NULL,
`message` longtext NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`blog` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `".$install_sql_dbpref."blogs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`starter` mediumtext NOT NULL,
`title` mediumtext NOT NULL,
`content` longtext NOT NULL,
`replies` int(11) NOT NULL,
`postdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`status` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `".$install_sql_dbpref."faq` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`message` longtext NOT NULL,
`title` mediumtext NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
INSERT INTO `".$install_sql_dbpref."faq` (`id`, `message`, `title`) VALUES
(1, 'You may have noticed that Catalyst has a \"default language\". That does only mean that that''s the default translation language of the software. This can be different on other installations.', 'A default language?'),
(2, 'Catalyst has a standard body changer in the header. This only has effect for yourself. because it doesn''t change anything in the stylesheet. It is only active till you refresh the page.', 'A body changer?'),
(3, 'Normally, you can find the \"Powered by Catalyst\" text in the footer and title. If this isn''t correct, this administrator is using an illegal version of Catalyst language editor. That doesn''t mean it''s Catalyst''s site. This site is only using our software. For questions about the license, just click on the link in the footer.', 'The copyright'),
(4, 'This software is in it''s original shape written by the Catalyst Group. The software is currently in Beta stage.', 'Who wrote this software?'),
(5, 'If you found a bug, please contact the administrator of this site. He will contact us if it''s a bug or he/she will fix it by him/herself.', 'I found a bug!'),
(6, 'Yes, you can. Please check the settings section in the administration panel.', 'Can I disable the shoutbox?'),
(7, 'Because we can''t implent all features. If you need a new feature, just look on the support forum. You might also find the answer in the plugins board.', 'Why isn''t feature x available?'),
(8, 'That''s quite simple. Catalyst has a build in path detect system, but it will cost a few minutes for your browser to load that script. It will be enabled automatically when one of the paths are incorrect. Don''t be afraid, it won''t happen a lot of times.', 'What will happen when the paths are incorrect?'),
(9, 'First, you can ask other translators with the private message system. If they don''t reply, you can always open a ticket in the ticket system. You can find it with the \"support\" tab.', 'What should I do when I don''t know something?'),
(10, 'Status updates are for translators who would like to say what they''re doing. Finished a translation? Then it''s a perfect moment to update your status.', 'Status updates');
CREATE TABLE IF NOT EXISTS `".$install_sql_dbpref."messages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` longtext NOT NULL,
`send` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`from` longtext NOT NULL,
`message` longtext NOT NULL,
`title` longtext NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `".$install_sql_dbpref."news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`newsmessage` mediumtext NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
INSERT INTO `".$install_sql_dbpref."news` (`id`, `newsmessage`) VALUES
(1, 'Welcome to Catalyst!'),
(2, 'Catalyst - Just installed!');
CREATE TABLE IF NOT EXISTS `".$install_sql_dbpref."online` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` longtext NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`action` longtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `".$install_sql_dbpref."shouts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` text NOT NULL,
`message` longtext NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
INSERT INTO `".$install_sql_dbpref."shouts` (`id`, `user`, `message`, `time`) VALUES
(1, 'Catalyst Group', 'Hey! Welcome to the shoutbox. This is just a sample shout', '2011-01-24 16:44:16');
CREATE TABLE IF NOT EXISTS `".$install_sql_dbpref."solved` (
`file` longtext NOT NULL,
`status` text NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `".$install_sql_dbpref."status` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`poster` mediumtext NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`message` longtext NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `".$install_sql_dbpref."team` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` mediumtext NOT NULL,
`position` longtext NOT NULL,
`joined` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`website` longtext NOT NULL,
`email` longtext NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `".$install_sql_dbpref."tickets` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` mediumtext NOT NULL,
`message` longtext NOT NULL,
`replies` varchar(255) NOT NULL,
`starter` longtext NOT NULL,
`lastposter` longtext NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
INSERT INTO `".$install_sql_dbpref."tickets` (`id`, `title`, `message`, `replies`, `starter`, `lastposter`) VALUES
(1, 'My first ticket!', 'Welcome to Catalyst Language Editor!<br />We hope enjoy using your Catalyst installation.', '1', 'Catalyst Language Editor', 'Catalyst Language Editor');
CREATE TABLE IF NOT EXISTS `".$install_sql_dbpref."tmessages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`message` longtext NOT NULL,
`poster` mediumtext NOT NULL,
`posted` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`ticket` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
INSERT INTO `".$install_sql_dbpref."tmessages` (`id`, `message`, `poster`, `posted`, `ticket`) VALUES
(1, 'And this is the first reply to your first ticket!', 'Catalyst Language Editor', '2011-01-18 15:41:17', '1');
CREATE TABLE IF NOT EXISTS `".$install_sql_dbpref."users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` text NOT NULL,
`password` mediumtext NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`translations` varchar(255) NOT NULL,
`group` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;") or die (mysql_error());
$install_sql_usernm = $_POST['sql_uname'];
$install_sql_passwd = $_POST['sql_pass'];
$install_sql_dbname = $_POST['sql_name'];
$install_sql_dbpref = $_POST['sql_pref'];
global $install_sql_server, $install_sql_usernm, $install_sql_passwd, $install_sql_dbname, $install_sql_dbpref;
mysql_connect($install_sql_server, $install_sql_usernm, $install_sql_passwd) or die ("Incorrect sql password, server or username. Please try again");
mysql_select_db($install_sql_dbname) or die ("Invalid database. Please try again and remember that you'll have to create the database manually");
mysql_query("
CREATE TABLE IF NOT EXISTS `".$install_sql_dbpref."blogreplies` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`poster` longtext NOT NULL,
`message` longtext NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`blog` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `".$install_sql_dbpref."blogs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`starter` mediumtext NOT NULL,
`title` mediumtext NOT NULL,
`content` longtext NOT NULL,
`replies` int(11) NOT NULL,
`postdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`status` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `".$install_sql_dbpref."faq` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`message` longtext NOT NULL,
`title` mediumtext NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
INSERT INTO `".$install_sql_dbpref."faq` (`id`, `message`, `title`) VALUES
(1, 'You may have noticed that Catalyst has a \"default language\". That does only mean that that''s the default translation language of the software. This can be different on other installations.', 'A default language?'),
(2, 'Catalyst has a standard body changer in the header. This only has effect for yourself. because it doesn''t change anything in the stylesheet. It is only active till you refresh the page.', 'A body changer?'),
(3, 'Normally, you can find the \"Powered by Catalyst\" text in the footer and title. If this isn''t correct, this administrator is using an illegal version of Catalyst language editor. That doesn''t mean it''s Catalyst''s site. This site is only using our software. For questions about the license, just click on the link in the footer.', 'The copyright'),
(4, 'This software is in it''s original shape written by the Catalyst Group. The software is currently in Beta stage.', 'Who wrote this software?'),
(5, 'If you found a bug, please contact the administrator of this site. He will contact us if it''s a bug or he/she will fix it by him/herself.', 'I found a bug!'),
(6, 'Yes, you can. Please check the settings section in the administration panel.', 'Can I disable the shoutbox?'),
(7, 'Because we can''t implent all features. If you need a new feature, just look on the support forum. You might also find the answer in the plugins board.', 'Why isn''t feature x available?'),
(8, 'That''s quite simple. Catalyst has a build in path detect system, but it will cost a few minutes for your browser to load that script. It will be enabled automatically when one of the paths are incorrect. Don''t be afraid, it won''t happen a lot of times.', 'What will happen when the paths are incorrect?'),
(9, 'First, you can ask other translators with the private message system. If they don''t reply, you can always open a ticket in the ticket system. You can find it with the \"support\" tab.', 'What should I do when I don''t know something?'),
(10, 'Status updates are for translators who would like to say what they''re doing. Finished a translation? Then it''s a perfect moment to update your status.', 'Status updates');
CREATE TABLE IF NOT EXISTS `".$install_sql_dbpref."messages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` longtext NOT NULL,
`send` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`from` longtext NOT NULL,
`message` longtext NOT NULL,
`title` longtext NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `".$install_sql_dbpref."news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`newsmessage` mediumtext NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
INSERT INTO `".$install_sql_dbpref."news` (`id`, `newsmessage`) VALUES
(1, 'Welcome to Catalyst!'),
(2, 'Catalyst - Just installed!');
CREATE TABLE IF NOT EXISTS `".$install_sql_dbpref."online` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` longtext NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`action` longtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `".$install_sql_dbpref."shouts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` text NOT NULL,
`message` longtext NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
INSERT INTO `".$install_sql_dbpref."shouts` (`id`, `user`, `message`, `time`) VALUES
(1, 'Catalyst Group', 'Hey! Welcome to the shoutbox. This is just a sample shout', '2011-01-24 16:44:16');
CREATE TABLE IF NOT EXISTS `".$install_sql_dbpref."solved` (
`file` longtext NOT NULL,
`status` text NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `".$install_sql_dbpref."status` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`poster` mediumtext NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`message` longtext NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `".$install_sql_dbpref."team` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` mediumtext NOT NULL,
`position` longtext NOT NULL,
`joined` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`website` longtext NOT NULL,
`email` longtext NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `".$install_sql_dbpref."tickets` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` mediumtext NOT NULL,
`message` longtext NOT NULL,
`replies` varchar(255) NOT NULL,
`starter` longtext NOT NULL,
`lastposter` longtext NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
INSERT INTO `".$install_sql_dbpref."tickets` (`id`, `title`, `message`, `replies`, `starter`, `lastposter`) VALUES
(1, 'My first ticket!', 'Welcome to Catalyst Language Editor!<br />We hope enjoy using your Catalyst installation.', '1', 'Catalyst Language Editor', 'Catalyst Language Editor');
CREATE TABLE IF NOT EXISTS `".$install_sql_dbpref."tmessages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`message` longtext NOT NULL,
`poster` mediumtext NOT NULL,
`posted` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`ticket` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
INSERT INTO `".$install_sql_dbpref."tmessages` (`id`, `message`, `poster`, `posted`, `ticket`) VALUES
(1, 'And this is the first reply to your first ticket!', 'Catalyst Language Editor', '2011-01-18 15:41:17', '1');
CREATE TABLE IF NOT EXISTS `".$install_sql_dbpref."users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` text NOT NULL,
`password` mediumtext NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`translations` varchar(255) NOT NULL,
`group` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;") or die (mysql_error());
Dit is de error die mijn uitzich verpestte:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `cat_blogs` ( `id` int(11) NOT NULL AUTO_INCREM' at line 12
Kan iemand me helpen? Alvast bedankt.
- Robert
Code (php)
1
CREATE TABLE IF NOT EXISTS `".$install_sql_dbpref."blogs`
Maar ik snap het niet, want ik kan zelf geen enkele fout ontdekken. Zou het misschien kunnen komen doordat ik het niet in losse sql query blokken stop?
CREATE TABLE IF NOT EXISTS '. mysql_real_escape_string($install_sql_dbpref).'blogs
mischien dat dit werkt
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `mysql_real_escape_string(cat_).'blogs` ( `id` ' at line 12
Dit is het stukje van de blogs:
Code (php)
1
2
3
4
5
6
7
8
9
10
11
2
3
4
5
6
7
8
9
10
11
CREATE TABLE IF NOT EXISTS `mysql_real_escape_string($install_sql_dbpref).'blogs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`starter` mediumtext NOT NULL,
`title` mediumtext NOT NULL,
`content` longtext NOT NULL,
`replies` int(11) NOT NULL,
`postdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`status` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
`id` int(11) NOT NULL AUTO_INCREMENT,
`starter` mediumtext NOT NULL,
`title` mediumtext NOT NULL,
`content` longtext NOT NULL,
`replies` int(11) NOT NULL,
`postdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`status` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''cat_blogreplies' ( 'id' int(11) NOT NULL AUTO_INCREMENT, 'poster' l' at line 1
Het script dat ik nu heb is:
Code (php)
1
2
3
4
5
6
7
8
9
2
3
4
5
6
7
8
9
CREATE TABLE IF NOT EXISTS '".$install_sql_dbpref."blogreplies' (
'id' int(11) NOT NULL AUTO_INCREMENT,
'poster' longtext NOT NULL,
'message' longtext NOT NULL,
'date' timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
'blog' int(11) NOT NULL,
PRIMARY KEY ('id'),
UNIQUE KEY 'id' ('id')
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
'id' int(11) NOT NULL AUTO_INCREMENT,
'poster' longtext NOT NULL,
'message' longtext NOT NULL,
'date' timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
'blog' int(11) NOT NULL,
PRIMARY KEY ('id'),
UNIQUE KEY 'id' ('id')
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'blogreplies ( id int(11) NOT NULL AUTO_INCREMENT, poster longtext NO' at line 1
Robert Monden op 01/02/2011 20:18:07:
Gedaan, maar nog steeds dezelfde error. :(
Ik bedoel zet die echo hier eens neer.
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
$sql_queryvaninstall = mysql_query("
CREATE TABLE IF NOT EXISTS $install_sql_dbpref blogreplies (
id int(11) NOT NULL AUTO_INCREMENT,
poster longtext NOT NULL,
message longtext NOT NULL,
date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
blog int(11) NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS ".$install_sql_dbpref."blogs (
id int(11) NOT NULL AUTO_INCREMENT,
starter mediumtext NOT NULL,
title mediumtext NOT NULL,
content longtext NOT NULL,
replies int(11) NOT NULL,
postdate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
status text NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS ".$install_sql_dbpref."faq (
id int(11) NOT NULL AUTO_INCREMENT,
message longtext NOT NULL,
title mediumtext NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
INSERT INTO ".$install_sql_dbpref."faq (id, message, title) VALUES
(1, You may have noticed that Catalyst has a \"default language\". That does only mean that thats the default translation language of the software. This can be different on other installations., A default language?),
(2, Catalyst has a standard body changer in the header. This only has effect for yourself. because it doesnt change anything in the stylesheet. It is only active till you refresh the page., A body changer?),
(3, Normally, you can find the \"Powered by Catalyst\" text in the footer and title. If this isnt correct, this administrator is using an illegal version of Catalyst language editor. That doesnt mean its Catalysts site. This site is only using our software. For questions about the license, just click on the link in the footer., The copyright),
(4, This software is in its original shape written by the Catalyst Group. The software is currently in Beta stage., Who wrote this software?),
(5, If you found a bug, please contact the administrator of this site. He will contact us if its a bug or he/she will fix it by him/herself., I found a bug!),
(6, Yes, you can. Please check the settings section in the administration panel., Can I disable the shoutbox?),
(7, Because we cant implent all features. If you need a new feature, just look on the support forum. You might also find the answer in the plugins board., Why isnt feature x available?),
(8, Thats quite simple. Catalyst has a build in path detect system, but it will cost a few minutes for your browser to load that script. It will be enabled automatically when one of the paths are incorrect. Dont be afraid, it wont happen a lot of times., What will happen when the paths are incorrect?),
(9, First, you can ask other translators with the private message system. If they dont reply, you can always open a ticket in the ticket system. You can find it with the \"support\" tab., What should I do when I dont know something?),
(10, Status updates are for translators who would like to say what theyre doing. Finished a translation? Then its a perfect moment to update your status., Status updates);
CREATE TABLE IF NOT EXISTS ".$install_sql_dbpref."messages (
id int(11) NOT NULL AUTO_INCREMENT,
user longtext NOT NULL,
send timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
from longtext NOT NULL,
message longtext NOT NULL,
title longtext NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS ".$install_sql_dbpref."news (
id int(11) NOT NULL AUTO_INCREMENT,
newsmessage mediumtext NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
INSERT INTO ".$install_sql_dbpref."news (id, newsmessage) VALUES
(1, Welcome to Catalyst!),
(2, Catalyst - Just installed!);
CREATE TABLE IF NOT EXISTS ".$install_sql_dbpref."online (
id int(11) NOT NULL AUTO_INCREMENT,
user longtext NOT NULL,
time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
action longtext NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS ".$install_sql_dbpref."shouts (
id int(11) NOT NULL AUTO_INCREMENT,
user text NOT NULL,
message longtext NOT NULL,
time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id),
UNIQUE KEY id (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
INSERT INTO ".$install_sql_dbpref."shouts (id, user, message, time) VALUES
(1, Catalyst Group, Hey! Welcome to the shoutbox. This is just a sample shout, 2011-01-24 16:44:16);
CREATE TABLE IF NOT EXISTS ".$install_sql_dbpref."solved (
file longtext NOT NULL,
status text NOT NULL,
time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS ".$install_sql_dbpref."status (
id int(11) NOT NULL AUTO_INCREMENT,
poster mediumtext NOT NULL,
time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
message longtext NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS ".$install_sql_dbpref."team (
id int(11) NOT NULL AUTO_INCREMENT,
name mediumtext NOT NULL,
position longtext NOT NULL,
joined timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
website longtext NOT NULL,
email longtext NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS ".$install_sql_dbpref."tickets (
id int(11) NOT NULL AUTO_INCREMENT,
title mediumtext NOT NULL,
message longtext NOT NULL,
replies varchar(255) NOT NULL,
starter longtext NOT NULL,
lastposter longtext NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
INSERT INTO ".$install_sql_dbpref."tickets (id, title, message, replies, starter, lastposter) VALUES
(1, My first ticket!, Welcome to Catalyst Language Editor!<br />We hope enjoy using your Catalyst installation., 1, Catalyst Language Editor, Catalyst Language Editor);
CREATE TABLE IF NOT EXISTS ".$install_sql_dbpref."tmessages (
id int(11) NOT NULL AUTO_INCREMENT,
message longtext NOT NULL,
poster mediumtext NOT NULL,
posted timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
ticket varchar(255) NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
INSERT INTO ".$install_sql_dbpref."tmessages (id, message, poster, posted, ticket) VALUES
(1, And this is the first reply to your first ticket!, Catalyst Language Editor, 2011-01-18 15:41:17, 1);
CREATE TABLE IF NOT EXISTS ".$install_sql_dbpref."users (
id int(11) NOT NULL AUTO_INCREMENT,
username text NOT NULL,
password mediumtext NOT NULL,
time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
translations varchar(255) NOT NULL,
group text NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;") or die (mysql_error());
echo $sql_queryvaninstall;
CREATE TABLE IF NOT EXISTS $install_sql_dbpref blogreplies (
id int(11) NOT NULL AUTO_INCREMENT,
poster longtext NOT NULL,
message longtext NOT NULL,
date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
blog int(11) NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS ".$install_sql_dbpref."blogs (
id int(11) NOT NULL AUTO_INCREMENT,
starter mediumtext NOT NULL,
title mediumtext NOT NULL,
content longtext NOT NULL,
replies int(11) NOT NULL,
postdate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
status text NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS ".$install_sql_dbpref."faq (
id int(11) NOT NULL AUTO_INCREMENT,
message longtext NOT NULL,
title mediumtext NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
INSERT INTO ".$install_sql_dbpref."faq (id, message, title) VALUES
(1, You may have noticed that Catalyst has a \"default language\". That does only mean that thats the default translation language of the software. This can be different on other installations., A default language?),
(2, Catalyst has a standard body changer in the header. This only has effect for yourself. because it doesnt change anything in the stylesheet. It is only active till you refresh the page., A body changer?),
(3, Normally, you can find the \"Powered by Catalyst\" text in the footer and title. If this isnt correct, this administrator is using an illegal version of Catalyst language editor. That doesnt mean its Catalysts site. This site is only using our software. For questions about the license, just click on the link in the footer., The copyright),
(4, This software is in its original shape written by the Catalyst Group. The software is currently in Beta stage., Who wrote this software?),
(5, If you found a bug, please contact the administrator of this site. He will contact us if its a bug or he/she will fix it by him/herself., I found a bug!),
(6, Yes, you can. Please check the settings section in the administration panel., Can I disable the shoutbox?),
(7, Because we cant implent all features. If you need a new feature, just look on the support forum. You might also find the answer in the plugins board., Why isnt feature x available?),
(8, Thats quite simple. Catalyst has a build in path detect system, but it will cost a few minutes for your browser to load that script. It will be enabled automatically when one of the paths are incorrect. Dont be afraid, it wont happen a lot of times., What will happen when the paths are incorrect?),
(9, First, you can ask other translators with the private message system. If they dont reply, you can always open a ticket in the ticket system. You can find it with the \"support\" tab., What should I do when I dont know something?),
(10, Status updates are for translators who would like to say what theyre doing. Finished a translation? Then its a perfect moment to update your status., Status updates);
CREATE TABLE IF NOT EXISTS ".$install_sql_dbpref."messages (
id int(11) NOT NULL AUTO_INCREMENT,
user longtext NOT NULL,
send timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
from longtext NOT NULL,
message longtext NOT NULL,
title longtext NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS ".$install_sql_dbpref."news (
id int(11) NOT NULL AUTO_INCREMENT,
newsmessage mediumtext NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
INSERT INTO ".$install_sql_dbpref."news (id, newsmessage) VALUES
(1, Welcome to Catalyst!),
(2, Catalyst - Just installed!);
CREATE TABLE IF NOT EXISTS ".$install_sql_dbpref."online (
id int(11) NOT NULL AUTO_INCREMENT,
user longtext NOT NULL,
time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
action longtext NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS ".$install_sql_dbpref."shouts (
id int(11) NOT NULL AUTO_INCREMENT,
user text NOT NULL,
message longtext NOT NULL,
time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id),
UNIQUE KEY id (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
INSERT INTO ".$install_sql_dbpref."shouts (id, user, message, time) VALUES
(1, Catalyst Group, Hey! Welcome to the shoutbox. This is just a sample shout, 2011-01-24 16:44:16);
CREATE TABLE IF NOT EXISTS ".$install_sql_dbpref."solved (
file longtext NOT NULL,
status text NOT NULL,
time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS ".$install_sql_dbpref."status (
id int(11) NOT NULL AUTO_INCREMENT,
poster mediumtext NOT NULL,
time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
message longtext NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS ".$install_sql_dbpref."team (
id int(11) NOT NULL AUTO_INCREMENT,
name mediumtext NOT NULL,
position longtext NOT NULL,
joined timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
website longtext NOT NULL,
email longtext NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS ".$install_sql_dbpref."tickets (
id int(11) NOT NULL AUTO_INCREMENT,
title mediumtext NOT NULL,
message longtext NOT NULL,
replies varchar(255) NOT NULL,
starter longtext NOT NULL,
lastposter longtext NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
INSERT INTO ".$install_sql_dbpref."tickets (id, title, message, replies, starter, lastposter) VALUES
(1, My first ticket!, Welcome to Catalyst Language Editor!<br />We hope enjoy using your Catalyst installation., 1, Catalyst Language Editor, Catalyst Language Editor);
CREATE TABLE IF NOT EXISTS ".$install_sql_dbpref."tmessages (
id int(11) NOT NULL AUTO_INCREMENT,
message longtext NOT NULL,
poster mediumtext NOT NULL,
posted timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
ticket varchar(255) NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
INSERT INTO ".$install_sql_dbpref."tmessages (id, message, poster, posted, ticket) VALUES
(1, And this is the first reply to your first ticket!, Catalyst Language Editor, 2011-01-18 15:41:17, 1);
CREATE TABLE IF NOT EXISTS ".$install_sql_dbpref."users (
id int(11) NOT NULL AUTO_INCREMENT,
username text NOT NULL,
password mediumtext NOT NULL,
time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
translations varchar(255) NOT NULL,
group text NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;") or die (mysql_error());
echo $sql_queryvaninstall;