phpBB2 by Przemo
Support forów phpBB2 modified by Przemo

FAQFAQ - PIERWSZA POMOC!!  regulaminREGULAMIN  SzukajSZUKAJ  UżytkownicyUżytkownicy  GrupyGrupy  StatystykiStatystyki
RejestracjaRejestracja  ZalogujZaloguj  DownloadDownload  katalog Forów DyskusyjnychKatalog Forów   FAQ Video tutoriale

Poprzedni temat «» Następny temat
Important! How can I make this SQL Change undone?
Autor Wiadomość
JA$ON

Posty: 116
Wysłany: 13-05-2007, 18:36   Important! How can I make this SQL Change undone?

Hi!
When i installed the karma mod i had to do the following sql change:
Kod:
CREATE TABLE phpbb_karma_comments (
   karma_id mediumint(8) NOT NULL auto_increment,
   karma_to mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   karma_from mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   karma_desc char(255) NOT NULL,
   karma_date int(11) DEFAULT '0' NOT NULL,
   karma_key tinyint(1) DEFAULT '0' NOT NULL,
   karma_viewed tinyint(1) DEFAULT '0' NOT NULL,
   PRIMARY KEY (karma_id)
);

INSERT INTO `phpbb_config` SET `config_name`='karma_comments', `config_value`='0';
INSERT INTO `phpbb_config` SET `config_name`='karma_comments_obligatory', `config_value`='0';
INSERT INTO `phpbb_config` SET `config_name`='karma_comments_max', `config_value`='3';
INSERT INTO `phpbb_config` SET `config_name`='karma_onoff', `config_value`='1';
INSERT INTO `phpbb_config` SET `config_name`='simple_karma', `config_value`='0';
INSERT INTO `phpbb_config` SET `config_name`='time_between_karma', `config_value`='24';
INSERT INTO `phpbb_config` SET `config_name`='admin_karma', `config_value`='1';
INSERT INTO `phpbb_config` SET `config_name`='min_post_karma', `config_value`='0';
INSERT INTO `phpbb_config` SET `config_name`='lag_karmer', `config_value`='1';
ALTER TABLE `phpbb_users` ADD `karma_plus` MEDIUMINT DEFAULT '0' NOT NULL ;
ALTER TABLE `phpbb_users` ADD `karma_minus` MEDIUMINT DEFAULT '0' NOT NULL ;
ALTER TABLE `phpbb_users` ADD `karma_time` BIGINT DEFAULT '0' NOT NULL ;

i did that but the karma mod only brings me a lot of problems so how can i make this change undone?
how can reverse this?
please help quickly, i need to uninstall the karma mod as soon as possible...
_________________
Hey Gość, please take second to visit my Portal.
 
     
Gadatliwa Kasia 

   
yasiu


Pomógł: 12 razy
Posty: 206
Wysłany: 13-05-2007, 20:43   

If you want uninstall, you must delete this table in PhpMyAdmin:

Kod:
DROP TABLE `phpbb_karma_comments`;



And change other files who you modify in instalation mod.
 
     
JA$ON

Posty: 116
Wysłany: 13-05-2007, 23:52   

i tried that but i got the error:
Kod:
#1051 - Unknown table 'phpbb_karma_comments'


[ Added: 14-05-2007, 00:00 ]
because i already deleted that table manually but the mod is still making problems..
maybe i should explain the problem.
whenr i edit my profile i get the following error:
Cytat:
Could not update users table

DEBUG MODE

SQL Error : 1064 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 ' user_allowhtml = 0, user_allowbbcode = 1, user_allow_viewonline = 1, user_notif' at line 2

UPDATE phpbb_users SET user_email = 'jaze@email.de', user_icq = '', user_website = 'http://www.Sublines.de', user_occ = 'Diese Seite, Musik, Graffiti, Sport, Party!', user_interests = 'Sublines.de', user_from = 'Bremen', user_field_1 = 'Sprayer.gif',user_field_2 = 'Germany.gif', user_sig = '', user_custom_color = '', user_custom_rank = '', user_sig_bbcode_uid = '', user_viewemail = 0, user_viewaim = 1, user_aim = '', user_yim = '', user_msnm = 't.jason@web.de', user_attachsig = 1, user_allowsmile = 1, karma_setonoff = , user_allowhtml = 0, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_gg = 0, user_notify_pm = 1, user_popup_pm = 1, user_timezone = 1, user_lang = 'english', user_style = 2, user_active = 1, user_actkey = '', no_report_popup = 0, no_report_mail = 0, user_birthday = '6739', user_next_birthday_greeting = '2007', user_gender = 1, allowpm = 1, user_ip_login_check = 1 WHERE user_id = 2

Line : 705
File : usercp_register.php

Wenn du dieses Problem nicht los wirst,
kannst du Hilfe ersuchen oder gehe auf: http://www.przemo.org/phpBB2/

when i posted this in a different topic,
azwel said:
"
Kod:
karma_setonoff = ,

here's your problem. Add
Kod:
''

to avoid it:
Kod:
karma_setonoff = '',
."
my question was: how exactly can i do that?
and because i never got an answer to hat, even though i was asking this in two topics, i just tried to uninstall the karma mod so that there would not be an error any more in the sql syntax. but deleting the table 'phpbb_karma_comments' did not change anything..

can you help me please? im pretty sure the problem is caused by the karma mod because i never noticed it before i installed it but i could be wrong of cours..
_________________
Hey Gość, please take second to visit my Portal.
 
     
Wyświetl posty z ostatnich:   
Odpowiedz do tematu
Nie możesz pisać nowych tematów
Nie możesz odpowiadać w tematach
Nie możesz zmieniać swoich postów
Nie możesz usuwać swoich postów
Nie możesz głosować w ankietach
Możesz załączać pliki na tym forum
Możesz ściągać załączniki na tym forum
Dodaj temat do Ulubionych
Wersja do druku

Skocz do:  

Kopiowanie wszelkich treści zawartych na forum, modyfikacji oraz instrukcji bez zgody administracji i autorów tematów/postów zabronione!

Powered by phpBB modified by Przemo © 2003 phpBB
Strona wygenerowana w 0,06 sekundy. Zapytań do SQL: 12
Polecane serwisy

Najlepsze oprogramowanie do prowadzenia sklepu internetowegoNajlepszy program do sklepu firmowany przez Przem'a

Sklep z gadżetami

serwis laptopów

phpbb

Design Cart - Tworzenie sklepu internetowego

iRonin.IT

• Zamów reklamę