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;
#
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.
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
The sql directory is part of coppermine, and in the package,
Got it working. Thanks all!