[solved] Installing DX2.0 SQL Error

reecebong

I install couple of times just notice there's error while installing. Even after installed with this error the forum is still working fine ( but i think there must be something wrong in the future). Here is the error i captured in 1 seconds after installed Discuz x2.0

vot

Thanx!
BugFix:
Edit the/install/data/install_data.sql
Edit line #16:
INSERT INTO pre_common_credit_rule VALUES ('6','Send PM','search','4','0','0','0','0','0','0','0','0','0','0','0','');
Replace the 'search' with 'sendpm':
INSERT INTO pre_common_credit_rule VALUES ('6','Send PM','sendpm','4','0','0','0','0','0','0','0','0','0','0','0','');

reecebong

Thanks! could you please tell us the step how to manually fix this without re-install it again?  since we have just setup everything in our forum.

vot

1. Run your PhpMyAdmin
2. Choose your database
3) Choose the table pre_common_credit_rule     (replace "pre_" with your db prefix)
4) Click "browse"
5) Find a record with id=6 (Send PM)
6) Click the "Edit" icon at this record
7) Edit the field "action", set this to "sendpm"
8) Click the SAVE button
9) Check if a record with id=7 exists
10) If no record with id=7, execute this query:

1. INSERT INTO pre_common_credit_rule VALUES ('7','Search','search','4','0','0','0','0','0','0','0','0','0','0','0','');

Copy the Code

11) Go to Admin-Center and clean the cache

reecebong

Actually, i re-paste all the SQL coding from install_data.sql to query and run it. Hopefully that wouldn't causing any problem. Anyway, Thank you so much for all the instruction and your works!

willard

I have tried to do as you say.

BugFix:
Edit the/install/data/install_data.sql
Edit line #16:
INSERT INTO pre_common_credit_rule VALUES ('6','Send PM','search','4','0','0','0','0','0','0','0','0','0','0','0','');
Replace the 'search' with 'sendpm':
INSERT INTO pre_common_credit_rule VALUES ('6','Send PM','sendpm','4','0','0','0','0','0','0','0','0','0','0','0','');

Operating system installation.
Can work normally.



Thanks for the help.