Advanced search  

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]

Pages: [1]   Go Down

Author Topic: [solved] mySQL Error: Table 'hdllc_db.cpg_users' doesn't exist  (Read 4437 times)

0 Members and 1 Guest are viewing this topic.

HDLLC

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 15
    • Hughes Design LLC

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
« Last Edit: July 31, 2004, 09:18:46 pm by Nibbler »
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: mySQL Error: Table 'hdllc_db.cpg_users' doesn't exist
« Reply #1 on: July 31, 2004, 07:13:24 am »

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

GauGau
Logged

HDLLC

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 15
    • Hughes Design LLC
Re: mySQL Error: Table 'hdllc_db.cpg_users' doesn't exist
« Reply #2 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
« Last Edit: July 31, 2004, 03:28:51 pm by HDLLC »
Logged

Nibbler

  • Guest
Re: mySQL Error: Table 'hdllc_db.cpg_users' doesn't exist
« Reply #3 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.
Logged

HDLLC

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 15
    • Hughes Design LLC
Re: mySQL Error: Table 'hdllc_db.cpg_users' doesn't exist
« Reply #4 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
Logged

Nibbler

  • Guest
Re: mySQL Error: Table 'hdllc_db.cpg_users' doesn't exist
« Reply #5 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.
Logged

HDLLC

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 15
    • Hughes Design LLC
Re: mySQL Error: Table 'hdllc_db.cpg_users' doesn't exist
« Reply #6 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
« Last Edit: July 31, 2004, 07:25:13 pm by HDLLC »
Logged

Nibbler

  • Guest
Re: mySQL Error: Table 'hdllc_db.cpg_users' doesn't exist
« Reply #7 on: July 31, 2004, 09:18:29 pm »

Solved directly. Cause was an incomplete upload of the package.
Logged
Pages: [1]   Go Up
 

Page created in 0.021 seconds with 20 queries.