[solved] mySQL Error: Table 'hdllc_db.cpg_users' doesn't exist [solved] mySQL Error: Table 'hdllc_db.cpg_users' doesn't exist
 

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Main Menu

[solved] mySQL Error: Table 'hdllc_db.cpg_users' doesn't exist

Started by HDLLC, July 31, 2004, 06:04:02 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

HDLLC

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

Joachim Müller

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

GauGau

HDLLC

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

Nibbler

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.

HDLLC

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

Nibbler

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.

HDLLC

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

Nibbler

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