Topic: Kurulum hatas?i

[ALP]

Table 'alp_verisql.smf_sp_blocks' doesn't exist
Dosya: /home/alp/public_html/forum/Packages/temp/install1-1.php
Sat?r: 121

bu hatay? al?yorum yard?m edersen?z sev?n?r?m

[[SiNaN]]

A?a??daki sorguyu phpMyAdmin'den sorgulat?n ve tekrar kurmay? deneyin.

Code: [Select]

DELETE FROM smf_settings
WHERE variable = 'SimplePortal_version'
LIMIT 1

[ALP]

yıne aynı malesef blue dream :S

[[SiNaN]]

Ekteki paketi kullanmayı deneyin.

[ALP]

Table 'ugur_deposql.smf_sp_blocks' doesn't exist
Dosya: /home/ugur/public_html/forum/Packages/temp/install1-1.php
Sat?r: 121 yine ayn? hatay? veriyor

[[SiNaN]]

phpMyAdmin'den bu sorguyu sorgulat?p deneyin:

Code: [Select]

CREATE TABLE IF NOT EXISTS smf_sp_blocks (
  ID_BLOCK int(10) unsigned NOT NULL auto_increment,
  label tinytext NOT NULL,
  type text NOT NULL,
  content text NOT NULL,
  parameters tinytext NOT NULL,
  col tinyint(4) unsigned NOT NULL default 0,
  row tinyint(4) unsigned NOT NULL default 0,
  state tinyint(4) NOT NULL default 1,
  allowed_groups text NOT NULL,
  force_view tinyint(2) unsigned NOT NULL default 0,
  permission_type tinyint(2) unsigned NOT NULL default 0,
  display text NOT NULL,
  PRIMARY KEY  (ID_BLOCK)
)

[ALP]

sorgu çalıştırıldı gösteriyor fakat tabloyu oluşturmuyor

[ALP]

flood yapt???m için özür dilerim ?imdide

 Table 'ugur_deposql.smf_sp_functions' doesn't exist
Dosya: /home/ugur/public_html/forum/Packages/temp/install1-1.php
Sat?r: 171

bu hatay? ver?yor san?r?m sql olusturmuyor sunucum tablo kodlar?n? ver?rm?s?n?z.

[[SiNaN]]

Bununla ilgili hala yardıma ihtiyacınız var mı?

[ALP]

evet hakeb yardıma ihtiyacım var

[[SiNaN]]

S?rayla bu sorgular? çal??t?r?n phpMyAdmin'den:

Code: [Select]

CREATE TABLE IF NOT EXISTS smf_sp_articles (
  ID_ARTICLE int(10) NOT NULL auto_increment,
  ID_CATEGORY int(10) NOT NULL default 0,
  ID_MESSAGE int(10) NOT NULL default 0,
  approved tinyint(2) NOT NULL default 0,
  PRIMARY KEY  (ID_ARTICLE)
)

Code: [Select]

CREATE TABLE IF NOT EXISTS smf_sp_blocks (
  ID_BLOCK int(10) unsigned NOT NULL auto_increment,
  label tinytext NOT NULL,
  type text NOT NULL,
  content text NOT NULL,
  parameters tinytext NOT NULL,
  col tinyint(4) unsigned NOT NULL default 0,
  row tinyint(4) unsigned NOT NULL default 0,
  state tinyint(4) NOT NULL default 1,
  allowed_groups text NOT NULL,
  force_view tinyint(2) unsigned NOT NULL default 0,
  permission_type tinyint(2) unsigned NOT NULL default 0,
  display text NOT NULL,
  PRIMARY KEY  (ID_BLOCK)
)

Code: [Select]

CREATE TABLE IF NOT EXISTS smf_sp_categories (
  ID_CATEGORY int(10) unsigned NOT NULL auto_increment,
  name tinytext NOT NULL,
  picture tinytext NOT NULL,
  articles tinyint(4) NOT NULL default 0,
  publish tinyint(1) NOT NULL default 0,
  PRIMARY KEY  (ID_CATEGORY)
)

Code: [Select]

CREATE TABLE IF NOT EXISTS smf_sp_functions (
  ID_FUNCTION tinyint(4) NOT NULL auto_increment,
  name tinytext NOT NULL,
  parameter tinyint(4) NOT NULL default 0,
  PRIMARY KEY  (ID_FUNCTION)
)

Code: [Select]

INSERT IGNORE INTO smf_sp_functions VALUES (18, 'sp_php', 0);
INSERT IGNORE INTO smf_sp_functions VALUES (17, 'sp_html', 0);
INSERT IGNORE INTO smf_sp_functions VALUES (16, 'sp_smfGallery', 1);
INSERT IGNORE INTO smf_sp_functions VALUES (15, 'sp_smfArcade', 1);
INSERT IGNORE INTO smf_sp_functions VALUES (14, 'sp_smfShop', 0);
INSERT IGNORE INTO smf_sp_functions VALUES (13, 'sp_news', 0);
INSERT IGNORE INTO smf_sp_functions VALUES (12, 'sp_boardNews', 5);
INSERT IGNORE INTO smf_sp_functions VALUES (11, 'sp_recentTopics', 1);
INSERT IGNORE INTO smf_sp_functions VALUES (10, 'sp_recentPosts', 1);
INSERT IGNORE INTO smf_sp_functions VALUES (9, 'sp_topTopics', 2);
INSERT IGNORE INTO smf_sp_functions VALUES (8, 'sp_topBoards', 1);
INSERT IGNORE INTO smf_sp_functions VALUES (7, 'sp_topPoster', 1);
INSERT IGNORE INTO smf_sp_functions VALUES (6, 'sp_quickSearch', 0);
INSERT IGNORE INTO smf_sp_functions VALUES (5, 'sp_boardStats', 0);
INSERT IGNORE INTO smf_sp_functions VALUES (4, 'sp_showPoll', 1);
INSERT IGNORE INTO smf_sp_functions VALUES (3, 'sp_whosOnline', 0);
INSERT IGNORE INTO smf_sp_functions VALUES (2, 'sp_latestMember', 0);
INSERT IGNORE INTO smf_sp_functions VALUES (1, 'sp_userInfo', 0);
INSERT IGNORE INTO smf_sp_functions VALUES (19, 'sp_bbc', 0);
INSERT IGNORE INTO smf_sp_functions VALUES (20, 'sp_attachmentImage', 1);
INSERT IGNORE INTO smf_sp_functions VALUES (21, 'sp_attachmentRecent', 1);
INSERT IGNORE INTO smf_sp_functions VALUES (22, 'sp_mgallery', 2);
INSERT IGNORE INTO smf_sp_functions VALUES (23, 'sp_recent', 2);
INSERT IGNORE INTO smf_sp_functions VALUES (24, 'sp_calendarInformation', 4);
INSERT IGNORE INTO smf_sp_functions VALUES (25, 'sp_rssFeed', 1);