forum.coppermine-gallery.net

Support => Older/other versions => cpg1.2 Standalone Support => Topic started by: Rip-rip on December 21, 2003, 09:29:36 pm

Title: [1.2.1 standalone]mySQL Error : Query was empty
Post by: Rip-rip on December 21, 2003, 09:29:36 pm

When trying to install I get the above error. When I then press Try Again I get the following error:

mySQL Error: Table 'cpg11d_albums' already exists

What's went wrong, and what to do?

thnx in advance

Title: Re: [1.2.1 standalone]mySQL Error : Query was empty
Post by: wthai on January 23, 2004, 09:35:42 pm

Quote from: "Rip-rip"

When trying to install I get the above error. When I then press Try Again I get the following error:

mySQL Error: Table 'cpg11d_albums' already exists

What's went wrong, and what to do?

thnx in advance

I have the exact same problem, can anyone help us out??

thanks

Title: Database Installation - Empty Query
Post by: wthai on January 23, 2004, 11:41:55 pm

The following four posts were merged to this thread.
-Hyperion
 

How do I create the proper DB in mysql for coppermine?  I'm using phpMyAdmin, and tried create a empty DB w/ no tables.  When I run install.php, i get something like 'sql error: query empty'.

running,

XP,apache2,php 4.3, and mysql 4.1

Thanks

Title: [1.2.1 standalone]mySQL Error : Query was empty
Post by: hyperion on January 24, 2004, 12:07:32 am

A link would be nice, but we can start down the check off list.

1. Can you verify that PHPMyAdmin is functioning properly?

2. Can you verify that the permissions on the /sql folder are correct?

Title: [1.2.1 standalone]mySQL Error : Query was empty
Post by: wthai on January 24, 2004, 12:35:01 am

i'm not really sure how to verify that phpmyadmin is fucntioning properly.  But I know that when I try to create a new DB, the DB name shows up in the mysql/data folder.  

Also all I did with the folder permissions was uncheck the "read-only" option in the windows properties section for my albums, include, and sql folders.

Sorry, I'm really new to this...

Title: [1.2.1 standalone]mySQL Error : Query was empty
Post by: hyperion on January 24, 2004, 12:53:39 am

XP and Apache don't really have a permissions system, so this is unlikely to be the core problem.

This might be related to your use of MySQL 4.1.   PHP 4.3's default MySQL extension is designed for older versions of MySQL.  You may need to activate the MySQLi extension in PHP.

For more info, go the source itself:

www.php.net

Click on the "Manual" link, and then scroll down to find the info on the MySQL and MySQLi extensions.

To learn more about PHP, MySQL, and Apache, try SAMS Teach Yourself PHP, MySQL, and Apache in 24 Hours.  It is a very good book for beginners. It will walk you through all the setups, etc.

Title: [1.2.1 standalone]mySQL Error : Query was empty
Post by: Joachim Müller on January 24, 2004, 11:14:28 am

http://coppermine.sourceforge.net/faq.php?q=howtoask#howtoask

GauGau

Title: Re: [1.2.1 standalone]mySQL Error : Query was empty
Post by: kegobeer on February 01, 2005, 04:24:49 am

You are attempting to install Coppermine 1.2.1?