Demo

Probiere ClanSphere aus und teste daran herum. Demo


Antworten: 4
Seite [1]
Billbo


Try to beat me





Beiträge: 118
# Thema - 27.07.2009 um 20:26 Uhr
Hab nen Problem mit dem Update von 2008.2.1 auf 2009.0.RC1:


mehr... +-
UPDATE {pre}_options SET options_value = '2009.0 RC1' WHERE options_mod = 'clansphere' AND options_name = 'version_name';
UPDATE {pre}_options SET options_value = '2009-03-25' WHERE options_mod = 'clansphere' AND options_name = 'version_date';
UPDATE {pre}_options SET options_value = '36' WHERE options_mod = 'clansphere' AND options_name = 'version_id';

CREATE TABLE {pre}_eventguests (
eventguests_id {serial},
events_id int(8) NOT NULL default '0',
users_id int(8) NOT NULL default '0',
eventguests_since int(14) NOT NULL default '0',
PRIMARY KEY (eventguests_id),
UNIQUE (events_id, users_id)
){engine};

CREATE TABLE {pre}_pictures (
pictures_id {serial},
pictures_mod varchar(20) NOT NULL default '',
pictures_fid int(8) NOT NULL default '0',
pictures_file varchar(20) NOT NULL default '',
PRIMARY KEY (pictures_id)
) {engine};

CREATE TABLE {pre}_medals (
medals_id {serial},
medals_extension varchar(20) NOT NULL default '',
medals_name varchar(200) NOT NULL default '',
medals_text text,
PRIMARY KEY (medals_id)
){engine};

CREATE TABLE {pre}_medalsuser (
medalsuser_id {serial},
medals_id int(8) NOT NULL default '0',
users_id int(8) NOT NULL default '0',
medalsuser_date int(14) NOT NULL default '0',
PRIMARY KEY (medalsuser_id)
){engine};

ALTER TABLE {pre}_access ADD access_ajax int(2) NOT NULL default '0';
ALTER TABLE {pre}_access ADD access_medals int(2) NOT NULL default '0';
ALTER TABLE {pre}_awards ADD squads_id int(8) NOT NULL default '0';
ALTER TABLE {pre}_boardmods ADD categories_id int(8) NOT NULL default '0';
ALTER TABLE {pre}_comments ADD comments_guestnick varchar(40) NOT NULL default '';
ALTER TABLE {pre}_events ADD events_cancel int(2) NOT NULL default '0';
ALTER TABLE {pre}_events ADD events_close int(2) NOT NULL default '0';
ALTER TABLE {pre}_events ADD events_guestsmax int(8) NOT NULL default '0';
ALTER TABLE {pre}_events ADD events_guestsmin int(8) NOT NULL default '0';
ALTER TABLE {pre}_events ADD events_needage int(2) NOT NULL default '0';
ALTER TABLE {pre}_events ADD events_pictures text;
ALTER TABLE {pre}_events ADD events_venue varchar(40) NOT NULL default '';
ALTER TABLE {pre}_folders ADD folders_advanced varchar(20) NOT NULL default '';
ALTER TABLE {pre}_ranks ADD squads_id int(8) NOT NULL default '0';
ALTER TABLE {pre}_squads ADD squads_text text;
ALTER TABLE {pre}_users ADD users_delete int(2) NOT NULL default '0';

ALTER TABLE {pre}_threads ADD threads_close2 int(8) NOT NULL default '0';
UPDATE {pre}_threads SET threads_close2 = threads_close;
ALTER TABLE {pre}_threads DROP threads_close;
ALTER TABLE {pre}_threads ADD threads_close int(8) NOT NULL default '0';
UPDATE {pre}_threads SET threads_close = threads_close2;
ALTER TABLE {pre}_threads DROP threads_close2;

ALTER TABLE {pre}_faq DROP faq_time;
ALTER TABLE {pre}_gallery DROP gallery_close;
ALTER TABLE {pre}_gallery DROP gallery_download;

INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('articles', 'max_navlist', '4');
INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('board', 'list_subforums', '1');
INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('clansphere', 'ajax_navlists', '');
INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('clansphere', 'cellspacing', '1');
INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('clansphere', 'developer', '0');
INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('comments', 'allow_unreg', '0');
INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('events', 'max_height', '600');
INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('events', 'max_size', '204800');
INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('events', 'max_width', '800');
INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('events', 'req_fulladress', '0');
INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('events', 'req_fullname', '0');
INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('events', 'req_mobile', '0');
INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('events', 'req_phone', '0');
INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('games', 'max_height', '30');
INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('games', 'max_size', '15360');
INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('games', 'max_width', '30');
INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('users', 'def_picture', '0');
UPDATE {pre}_options SET options_value = '350' WHERE options_mod = 'clansphere' AND options_name = 'sec_news';

CREATE INDEX {pre}_boardmods_categories_id_index ON {pre}_boardmods (categories_id);
CREATE INDEX {pre}_eventguests_events_id_index ON {pre}_eventguests (events_id);
CREATE INDEX {pre}_eventguests_users_id_index ON {pre}_eventguests (users_id);
CREATE INDEX {pre}_pictures_pictures_fid_index ON {pre}_pictures (pictures_fid);
CREATE INDEX {pre}_pictures_pictures_id_index ON {pre}_pictures (pictures_id);
CREATE INDEX {pre}_medalsuser_medals_id_index ON {pre}_medalsuser (medals_id);
CREATE INDEX {pre}_medalsuser_users_id_index ON {pre}_medalsuser (users_id);

CREATE INDEX {pre}_captcha_speedup_index ON {pre}_captcha (captcha_id, captcha_ip, captcha_time);
CREATE INDEX {pre}_comments_speedup_index ON {pre}_comments (comments_fid, comments_id, comments_mod);
CREATE INDEX {pre}_count_speedup_index ON {pre}_count (count_id, count_ip, count_time);
CREATE INDEX {pre}_users_speedup_index ON {pre}_users (users_id, users_laston);



Was kann ich tun? Bin mit meinem Latein am ende :(
www.82nd.at


Zuletzt editiert von Billbo am 27.07.2009 um 20:27 Uhr (2x Editiert)
Inaktiv
hajo ClanSphere Team


VIP - Poster




Herkunft: Barsbüttel
Beiträge: 9411
# Antwort: 1 - 28.07.2009 um 01:12 Uhr
was daran ist das problem?

am besten mal error log datei posten bzw. debug ausgabe beim ausführen


------------------
ClanSphere - professional clan care starts here

Inaktiv
|
Billbo
Thread-Ersteller


Try to beat me





Beiträge: 118
# Antwort: 2 - 28.07.2009 um 22:59 Uhr
Hab Hilfe bekommen...
danke für die Mühe


Inaktiv
|
Miraculix


Going for pro




Herkunft: Füssen
Beiträge: 429
# Antwort: 3 - 29.07.2009 um 00:00 Uhr
Und an was lag es?


------------------
greeetz Miraculix

Band-Page -> www.muddleheaded-scum.de

Inaktiv
|
Billbo
Thread-Ersteller


Try to beat me





Beiträge: 118
# Antwort: 4 - 29.07.2009 um 08:32 Uhr
Musste erst einige uralt Module rauswerfen. Dann noch mal brav alle updates hochgeladen und es ging.


Inaktiv
|
Antworten: 4
Seite [1]


Sie müssen sich registrieren, um zu antworten.