cpg148_ban

[mx5]

Hello,

i hope you can help me with this isue (im dutch so sorry for my bad english)

I have deleted the  cpg148_ban..? quirie out of my database no i get a error who can help me restore the database?

[Sami]

There is no cpg148_ban are you talking about cpg148_banned table? if so , then you can create it with executing this query under your phpmyadmin

Code Select Expand


CREATE TABLE cpg148_banned (
        ban_id int(11) NOT NULL auto_increment,
        user_id int(11) DEFAULT NULL,
        ip_addr tinytext DEFAULT NULL,
        expiry datetime DEFAULT NULL,
        brute_force tinyint(5) NOT NULL default '0',
        PRIMARY KEY  (ban_id)
) TYPE=MyISAM;


You can find all tables structure under sql/schema.sql

[Joachim Müller]

Remember to adjust the table prefix if you chose a different prefix during install.

[mx5]

thx for tha fast help!!!!