Problème query création de tables sous PHP

**DjSoulz** · 25/03/2007, 19h46

Bonjours,

j'essai de faire un script d'installation pour un cms mais le probleme c'est que lorsque je l'execute il ne fait que la premiere query et ensuite il dit qu'il y a une erreur alors que la query est bien executé, alors, les autres ne se fond pas.

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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
IF ($_GET['step'] == "3") {
require('../config.php3');
echo '<center>';
echo '<br>';
echo '<br>';
echo '<br>';
echo '<br>';
echo '<br>';
echo '<br>';
echo '<br>';
echo '<br>';
echo '<br>';
mssql_connect($config['KalWeb']['servername'], $config['KalWeb']['username'], $config['KalWeb']['password']) OR exit('Unable to etablish a connexion');
mssql_select_db($config['KalWeb']['dbname']) OR exit('Can\'t select the database');
mssql_query("CREATE TABLE [kalweb_about] (
		[id] [int] IDENTITY (1, 1) NOT NULL ,
	[content] [varchar] (8000) COLLATE Danish_Norwegian_BIN NULL
) ON [PRIMARY]") OR die('<b>Query Error, line 98');
mssql_query("CREATE TABLE [dbo].[kalweb_config] (
	[webtitle] [varchar] (100) COLLATE Korean_Wansung_CS_AS NOT NULL ,
	[client] [varchar] (100) COLLATE Korean_Wansung_CS_AS NOT NULL ,
	[patch] [varchar] (100) COLLATE Korean_Wansung_CS_AS NOT NULL ,
	[forum] [varchar] (50) COLLATE Korean_Wansung_CS_AS NOT NULL ,
	[ads] [varchar] (250) COLLATE Korean_Wansung_CS_AS NOT NULL ,
	[show_gm] [tinyint] NOT NULL 
) ON [PRIMARY]
GO") OR die('<b>Query Error, line 102');
mssql_query("CREATE TABLE [dbo].[kalweb_news] (
	[news_title] [varchar] (100) COLLATE Polish_CI_AS NULL ,
	[news_autor] [varchar] (100) COLLATE Polish_CI_AS NULL ,
	[news_category] [varchar] (100) COLLATE Polish_CI_AS NULL ,
	[news_context] [text] COLLATE Polish_CI_AS NULL ,
	[news_id] [varchar] (100) COLLATE Polish_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO") OR die('<b>Query Error, line 111');
mssql_query("CREATE TABLE [dbo].[kalweb_links] (
	[link_name] [varchar] (100) COLLATE Polish_CI_AS NULL ,
	[link_address] [text] COLLATE Polish_CI_AS NULL ,
	[link_description] [text] COLLATE Polish_CI_AS NULL ,
	[link_id] [varchar] (100) COLLATE Polish_CI_AS NULL ,
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO") OR die('<b>Query Error, line 119');
mssql_query("CREATE TABLE [dbo].[kalweb_servers] (
	[name] [varchar] (100) COLLATE Polish_CI_AS NULL ,
	[experience] [varchar] (100) COLLATE Polish_CI_AS NULL ,
	[drops] [varchar] (100) COLLATE Polish_CI_AS NULL ,
	[gsport] [varchar] (100) COLLATE Polish_CI_AS NULL ,
	[ip] [varchar] (100) COLLATE Polish_CI_AS NULL ,
	[display_order] [varchar] (100) COLLATE Polish_CI_AS NULL ,
	[version] [varchar] (100) COLLATE Polish_CI_AS NULL ,
	[type] [varchar] (50) COLLATE Polish_CI_AS NULL 
) ON [PRIMARY]
GO") OR die('<b>Query Error, line 126');
mssql_query("CREATE TABLE [kalweb_download] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[link] [varchar] (50) COLLATE Korean_Wansung_CS_AS NULL ,
	[name] [varchar] (60) COLLATE Korean_Wansung_CS_AS NULL ,
	[version] [varchar] (50) COLLATE Korean_Wansung_CS_AS NULL ,
	[descr] [varchar] (1000) COLLATE Danish_Norwegian_BIN NULL 
) ON [PRIMARY]") OR die('<b>Query Error, line 137');
mssql_query("CREATE TABLE [kalweb_rules] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[content] [text] COLLATE Danish_Norwegian_BIN NULL 
) ON [PRIMARY]") OR die('<b>Query Error, line 144');
}