forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: mx5 on August 07, 2006, 09:09:53 pm

Title: cpg148_ban
Post by: mx5 on August 07, 2006, 09:09:53 pm

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?

Title: Re: cpg148_ban
Post by: Sami on August 07, 2006, 09:13:51 pm

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]

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

Title: Re: cpg148_ban
Post by: Joachim Müller on August 07, 2006, 09:17:10 pm

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

Title: Re: cpg148_ban
Post by: mx5 on August 07, 2006, 09:23:33 pm

thx for tha fast help!!!!