Demo

Probiere ClanSphere aus und teste daran herum. Demo


Antworten: 3
Seite [1]
Wurzel


Try to beat me




Beiträge: 102
# Thema - 26.02.2008 um 14:18 Uhr
hallo,

habe heute das update von 2007.4.4 auf 2008 durchgeführt

leider kamen fast nur fehlermeldungen, habe mich aber bemüht es so zu machen wie man es machen soll.

mehr... +-

CREATE TABLE {pre}_abcode (
abcode_id int(8) unsigned NOT NULL auto_increment,
abcode_func varchar(8) NOT NULL default '',
abcode_pattern varchar(40) NOT NULL default '',
abcode_result varchar(40) NOT NULL default '',
abcode_file varchar(80) NOT NULL default '',
PRIMARY KEY (abcode_id)
) TYPE=MyISAM # cs_sql_query - Table 'cs_abcode' already exists
INSERT INTO {pre}_abcode (abcode_func, abcode_pattern, abcode_result, abcode_file) VALUES ('img', '', '', 'smile.gif') # 1
INSERT INTO {pre}_abcode (abcode_func, abcode_pattern, abcode_result, abcode_file) VALUES ('img', ' # cs_sql_query - 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 ''' at line 1
)', '', 'wink.gif') # cs_sql_query - 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 ')', '', 'wink.gif')' at line 1
INSERT INTO {pre}_abcode (abcode_func, abcode_pattern, abcode_result, abcode_file) VALUES ('img', '', '', 'biggrin.gif') # 1
INSERT INTO {pre}_abcode (abcode_func, abcode_pattern, abcode_result, abcode_file) VALUES ('img', '', '', 'tongue.gif') # 1
INSERT INTO {pre}_abcode (abcode_func, abcode_pattern, abcode_result, abcode_file) VALUES ('img', '', '', 'cool.gif') # 1
INSERT INTO {pre}_abcode (abcode_func, abcode_pattern, abcode_result, abcode_file) VALUES ('img', '', '', 'lol.gif') # 1
INSERT INTO {pre}_abcode (abcode_func, abcode_pattern, abcode_result, abcode_file) VALUES ('img', ' # cs_sql_query - 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 ''' at line 1
(', '', 'frown.gif') # cs_sql_query - 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 '', '', 'frown.gif')' at line 1
INSERT INTO {pre}_abcode (abcode_func, abcode_pattern, abcode_result, abcode_file) VALUES ('img', '', '', 'mad.gif') # 1
INSERT INTO {pre}_abcode (abcode_func, abcode_pattern, abcode_result, abcode_file) VALUES ('img', '', '', 'rolleyes.gif') # 1
CREATE TABLE {pre}_abonements (
abonements_id int(8) unsigned NOT NULL auto_increment,
users_id int(8) NOT NULL default '0',
threads_id int(8) NOT NULL default '0',
PRIMARY KEY (abonements_id)
) TYPE=MyISAM # cs_sql_query - Table 'cs_abonements' already exists
CREATE TABLE {pre}_access (
access_id int(8) unsigned NOT NULL auto_increment,
access_name varchar(40) NOT NULL default '',
access_access int(2) NOT NULL default '0',
access_clansphere int(2) NOT NULL default '0',
access_abcode int(2) NOT NULL default '0',
access_articles int(2) NOT NULL default '0',
access_awards int(2) NOT NULL default '0',
access_banners int(2) NOT NULL default '0',
access_board int(2) NOT NULL default '0',
access_boardmods int(2) NOT NULL default '0',
access_boardranks int(2) NOT NULL default '0',
access_buddys int(2) NOT NULL default '0',
access_cash int(2) NOT NULL default '0',
access_categories int(2) NOT NULL default '0',
access_clans int(2) NOT NULL default '0',
access_comments int(2) NOT NULL default '0',
access_computers int(2) NOT NULL default '0',
access_contact int(2) NOT NULL default '0',
access_count int(2) NOT NULL default '0',
access_cups int(2) NOT NULL default '0',
access_database int(2) NOT NULL default '0',
access_errors int(2) NOT NULL default '0',
access_events int(2) NOT NULL default '0',
access_explorer int(2) NOT NULL default '0',
access_faq int(2) NOT NULL default '0',
access_fckeditor int(2) NOT NULL default '0',
access_fightus int(2) NOT NULL default '0',
access_files int(2) NOT NULL default '0',
access_gallery int(2) NOT NULL default '0',
access_games int(2) NOT NULL default '0',
access_gbook int(2) NOT NULL default '0',
access_history int(2) NOT NULL default '0',
access_joinus int(2) NOT NULL default '0',
access_links int(2) NOT NULL default '0',
access_linkus int(2) NOT NULL default '0',
access_logs int(2) NOT NULL default '0',
access_maps int(2) NOT NULL default '0',
access_members int(2) NOT NULL default '0',
access_messages int(2) NOT NULL default '0',
access_modules int(2) NOT NULL default '0',
access_news int(2) NOT NULL default '0',
access_newsletter int(2) NOT NULL default '0',
access_options int(2) NOT NULL default '0',
access_partner int(2) NOT NULL default '0',
access_quotes int(2) NOT NULL default '0',
access_ranks int(2) NOT NULL default '0',
access_replays int(2) NOT NULL default '0',
access_rules int(2) NOT NULL default '0',
access_static int(2) NOT NULL default '0',
access_search int(2) NOT NULL default '0',
access_servers int(2) NOT NULL default '0',
access_shoutbox int(2) NOT NULL default '0',
access_squads int(2) NOT NULL default '0',
access_users int(2) NOT NULL default '0',
access_usersgallery int(2) NOT NULL default '0',
access_votes int(2) NOT NULL default '0',
access_wars int(2) NOT NULL default '0',
access_wizard int(2) NOT NULL default '0',
PRIMARY KEY (access_id),
UNIQUE (access_name)
) TYPE=MyISAM # cs_sql_query - Table 'cs_access' already exists
INSERT INTO {pre}_access (access_name, access_access, access_clansphere, access_abcode, access_articles, access_awards, access_banners, access_board, access_boardmods, access_boardranks, access_buddys, access_cash, access_categories, access_clans, access_comments, access_computers, access_contact, access_count, access_cups, access_database, access_explorer, access_errors, access_events, access_faq, access_fckeditor, access_fightus, access_files, access_gallery, access_games, access_gbook, access_history, access_joinus, access_links, access_linkus, access_logs, access_maps, access_members, access_messages, access_modules, access_news, access_newsletter, access_options, access_partner, access_quotes, access_ranks, access_replays, access_rules, access_static, access_search, access_servers, access_shoutbox, access_squads, access_users, access_usersgallery, access_votes, access_wars, access_wizard) VALUES ('{guest}', 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0) # cs_sql_query - Unknown column 'access_database' in 'field list'



das ist ein kleiner ausschnitt.

nun kann man nicht mal mehr als webmaster neue themen erstellen, unter verwaltung keine themen mehr bearbeiten und auf listcat hat auch keiner mehr zugriff. auf die einzelnen beiträger wiederum hat man ganz normalen zugriff.

was habe ich falsch gemacht?

gruss
JP


------------------
mfg
Wurzel
Inaktiv
duRiel ClanSphere Team


Weltmeister




Herkunft: Cambridge
Beiträge: 7300
# Antwort: 1 - 26.02.2008 um 16:53 Uhr
argh..
hast die sql dateien der installation eingespielt statt der update sql dateien.

RTFM


Inaktiv
|
Wurzel
Thread-Ersteller


Try to beat me




Beiträge: 102
# Antwort: 2 - 26.02.2008 um 17:33 Uhr
ups, dummeit muss bestraft werden .... danke dir :-)


------------------
mfg
Wurzel

Inaktiv
|
Fr33z3m4n ClanSphere Team


Medal of Honor




Herkunft: Hamm
Beiträge: 11094
# Antwort: 3 - 27.02.2008 um 13:05 Uhr
so, hab mal ins aktuelle SVN eingebaut, das man die install.sql nicht mehr importieren kann, um solche Fehler, die schon öfters gemacht wurden, zu verhindern.


------------------
mfg
Patrick "Fr33z3m4n" Jaskulski

Antoine de Saint-Exupéry: Wenn Du ein Schiff bauen willst, so trommle nicht Männer zusammen, um Holz zu beschaffen, Aufgaben zu verteilen, sondern lehre die Männer die Sehnsucht nach dem endlosen weiten Meer.

Inaktiv
|

Dieses Thema wurde von duRiel ClanSphere Team PM geschlossen.

Antworten: 3
Seite [1]