|
|
phpBB2 by Przemo
Support forów phpBB2 modified by Przemo
|
|
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:
"
here's your problem. Add
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. |
|
|
|
 |
|
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
|
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 | |
 |
|