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

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

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.