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: MSQL ERROR  (Read 4348 times)

0 Members and 1 Guest are viewing this topic.

bluestrike

  • Coppermine newbie
  • Offline Offline
  • Posts: 1
MSQL ERROR
« on: July 25, 2004, 04:38:02 pm »

I have uploaded and i have CHmodded also!
But when i wanna install it, gives it an error

Code: [Select]
• • • ERROR • • • 
The following errors were encountered and need to be corrected first:

mySQL Error: Table 'bluestrike.cpg131_users' doesn't exist

 

What does i have to do?
I have an free host on dhost.info
Logged

kegobeer

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 4637
  • Beer - it does a body good!
    • The Kazebeer Family Website
Re: MSQL ERROR
« Reply #1 on: July 25, 2004, 04:43:24 pm »

Does your free host meet the minimum requirements for Coppermine?  Check the documentation for minimum requirements, then ask the host.
Logged
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots

jamesmct

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: MSQL ERROR
« Reply #2 on: July 28, 2004, 08:46:55 pm »

I get the same error,

I am running a Windows 2003 Box running IIS 6
I have MySQL installed and followed the documentation to a T in regards to starting a new database and setting up the proper permissions.  I've given IUSR_Server access to the MySQL directory and everything else that I can think of to get it to work, I have done short of installing MySQL in the wwwroot folder?

Anyone know anything that I might be able to do?
Logged

yeroen

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 24
    • http://phreaky.is-a-geek.net
Re: MSQL ERROR
« Reply #3 on: July 28, 2004, 08:48:18 pm »

Install phpmyadmin, and try to log into your database. Check whether the table actually exists...good luck :)
Logged

jamesmct

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: MSQL ERROR
« Reply #4 on: July 28, 2004, 08:59:30 pm »

Did that, and it doesn't.  How do I make that table?  There is nothing in the documentation on making a users table?

Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: MSQL ERROR
« Reply #5 on: July 29, 2004, 11:03:28 am »

does the mySQL user have the permission to create tables? This is something people who run their own server often forget: you will have to create at least one mySQL user and you will have to assign permissions to him. Coppermine needs these permissions in the mySQL database: CREATE, INSERT, ALTER, DELETE, UPDATE, SELECT.

GauGau

Logged

jamesmct

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: MSQL ERROR
« Reply #6 on: July 29, 2004, 01:20:43 pm »

Did that as well,  gave the user all priviledges.

I have no problem running this on my Laptop running WIndows XP and Apache, but for some reason, it is giving me a hell of a time on Windows 2003
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: MSQL ERROR
« Reply #7 on: July 30, 2004, 08:01:11 am »

what error message do you get?

GauGau
Logged

jamesmct

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: MSQL ERROR
« Reply #8 on: August 01, 2004, 05:08:36 am »

The same error that Bluestreak gets.  Table "..._.cpg131_users" does not exsist.

That is not the exact error typed out, but it is the same one as the error Bluestreak got.

Thanks again
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: MSQL ERROR
« Reply #9 on: August 01, 2004, 08:33:12 am »

OK, as far as I understand you're trying to install from scartch, there are probably not much files in coppermine (if any). I recommend re-installing coppermine. To do that, delete all coppermine files from your webserver and upload them again. Make sure you really upload all files from the package. CHMOD as suggested in the docs. Then run the installer again.

GauGau
Logged

Nibbler

  • Guest
Re: MSQL ERROR
« Reply #10 on: August 01, 2004, 04:08:49 pm »

Likely cause is a missing sql directory.
Logged
Pages: [1]   Go Up
 

Page created in 0.018 seconds with 15 queries.