forum.coppermine-gallery.net

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Installation & Setup => Topic started by: HDLLC on July 31, 2004, 06:04:02 am

Title: [solved] mySQL Error: Table 'hdllc_db.cpg_users' doesn't exist
Post by: HDLLC on July 31, 2004, 06:04:02 am

I am trying to instaill and work with Coppermine on a Mac OSX server...  I get the following error:
mySQL Error: Table 'hdllc_db.cpg_users' doesn't exist

TBH, I am not sure what steps to take on the mySQL side (phpMyAdmin) - figuring the problem lies in that nothing is there for the script to connect to?

Thanks in advance for any help provided!

--Jeff

Title: Re: mySQL Error: Table 'hdllc_db.cpg_users' doesn't exist
Post by: Joachim Müller on July 31, 2004, 07:13:24 am

did you check using phpMyAdmin that the table in question exists?

GauGau

Title: Re: mySQL Error: Table 'hdllc_db.cpg_users' doesn't exist
Post by: HDLLC on July 31, 2004, 03:07:13 pm

The tables don't exist - This is the first time I have used mySQL or PHP - so this is a learning experience.
Do I just need to create a table in myPHP admin for each of the folders that required "write" access?
How can I tell how many fields should be created for each table?

I have a db in myPHPadmin called "test".  Tables are:
businesspartners_tb, charitablefoundation_tb, content_tb, contentimages_tb, media_tb and users_tb

Is this the db to use or do I need to create a new one?

I have contents of the Coppermine package in a folder in the root of my server called (cpg).  

Thanks in advance!

--Jeff

Title: Re: mySQL Error: Table 'hdllc_db.cpg_users' doesn't exist
Post by: Nibbler on July 31, 2004, 03:37:25 pm

You need to create a database for coppermine to use, and then add a user to the database with preferably full permissions. You then tall coppermine to use that user and that database during the install.

Title: Re: mySQL Error: Table 'hdllc_db.cpg_users' doesn't exist
Post by: HDLLC on July 31, 2004, 03:42:16 pm

Can do-  Thanks!

Wondered though - where can I get details as to what tables to create, number of fields, etc...?
Once I can get that figured out, I should be set.  Did not find that in the docs...

Thanks again!

--Jeff

Title: Re: mySQL Error: Table 'hdllc_db.cpg_users' doesn't exist
Post by: Nibbler on July 31, 2004, 04:09:02 pm

Coppermine creates the tables for you, there is no need to make them yourself. The details are in the sql directory if you need them though.

Title: Re: mySQL Error: Table 'hdllc_db.cpg_users' doesn't exist
Post by: HDLLC on July 31, 2004, 05:45:16 pm

Hmmm...  I guess I am confused...  Could I have the wrong path to the db, or ?
Right now, I have a db called "hdllc_db" - that is the one that my ISP told me I had to use.  
There is also a "test" db, which has a bunch of tables already set-up...  

Would you be game to help me out, if I gave you the username/password?  Chat on IM?

Thanks-

--Jeff

Title: Re: mySQL Error: Table 'hdllc_db.cpg_users' doesn't exist
Post by: Nibbler on July 31, 2004, 09:18:29 pm

Solved directly. Cause was an incomplete upload of the package.