mysql help! ???

[fareforce]

I have a sql database called "alaskastudio_com"
I filled in all of my user info when running the coppermine install file, and get:

• • • ERROR • • • 
The following errors were encountered and need to be corrected first:

mySQL Error: Table 'alaskastudio_com.cpg132_users' doesn't exist


Then I go in and create the table "cpg132_users" and get:

• • • ERROR • • • 
The following errors were encountered and need to be corrected first:

mySQL Error: Column count doesn't match value count at row 1




The interface I use for sql is phpMyAdmin 2.2.0 when I go to create a table it asks me for the name and the number of fields. How many fields do i need? what do I name the fields? What other info do i need when creating this? Or am I doing it all wrong??? Here is table structure I have been trying:


#
# Table structure for table `cpg132_users`
#

CREATE TABLE cpg132_users (
  1 tinyint(4) NOT NULL default '0',
  2 tinyint(4) NOT NULL default '0',
  3 tinyint(4) NOT NULL default '0',
  4 tinyint(4) NOT NULL default '0'
) TYPE=MyISAM;

#

[Nibbler]

Drop all the coppermine tables, upload the sql directory properly, and then try installation again. You may need to remove the include/config.inc.php and the install.lock for it to allow you to re-install.

[fareforce]

Where am I uploading it to? Are the files I am uploading included with coppermine? Sorry I have never delt with sql before. It is my own server, so I can do what ever I want (with in reason) to it.. Bad side is I get no tech support

[Nibbler]

The sql directory is part of coppermine, and in the package,

[fareforce]

Got it working. Thanks all!