Advanced search  

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

Pages: [1]   Go Down

Author Topic: [solved] mySQL Error: Table 'hdllc_db.cpg_users' doesn't exist  (Read 4436 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.018 seconds with 19 queries.