Discussion :

[DjSoulz]

Bonjours,

j'essai de faire un systeme d'installation pour un CMS sous mssql 2005. Lorsque j'execute le script, il fait la premiere requete et dit ensuite qu'elle est pas bonne alors que je la voit dans la base de donnée avec tout les champs, Se qui pose probleme car le autre ne s'execute 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
66
 
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');
}

[DjSoulz]

Personne peu m'aider ?