Text only | Text with Images

coppermine-gallery.com/forum

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Installation & Setup => Topic started by: bluestrike on July 25, 2004, 04:38:02 PM

Title: MSQL ERROR
Post by: bluestrike 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
Title: Re: MSQL ERROR
Post by: kegobeer 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.
Title: Re: MSQL ERROR
Post by: jamesmct 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?
Title: Re: MSQL ERROR
Post by: yeroen 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 :)
Title: Re: MSQL ERROR
Post by: jamesmct 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?

Title: Re: MSQL ERROR
Post by: Joachim Müller 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

Title: Re: MSQL ERROR
Post by: jamesmct 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
Title: Re: MSQL ERROR
Post by: Joachim Müller on July 30, 2004, 08:01:11 AM
what error message do you get?

GauGau
Title: Re: MSQL ERROR
Post by: jamesmct 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
Title: Re: MSQL ERROR
Post by: Joachim Müller 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
Title: Re: MSQL ERROR
Post by: Nibbler on August 01, 2004, 04:08:49 PM
Likely cause is a missing sql directory.
Text only | Text with Images