[1.2.1 standalone]mySQL Error : Query was empty [1.2.1 standalone]mySQL Error : Query was empty
 

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]

Main Menu

[1.2.1 standalone]mySQL Error : Query was empty

Started by Rip-rip, December 21, 2003, 09:29:36 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

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

wthai

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

wthai

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

hyperion

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?
"Then, Fletch," that bright creature said to him, and the voice was very kind, "let's begin with level flight . . . ."

-Richard Bach, Jonathan Livingston Seagull

(https://coppermine-gallery.com/forum/proxy.php?request=http%3A%2F%2Fwww.mozilla.org%2Fproducts%2Ffirefox%2Fbuttons%2Fgetfirefox_small.png&hash=9f6d645801cbc882a52f0ee76cfeda02625fc537)

wthai

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...

hyperion

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.
"Then, Fletch," that bright creature said to him, and the voice was very kind, "let's begin with level flight . . . ."

-Richard Bach, Jonathan Livingston Seagull

(https://coppermine-gallery.com/forum/proxy.php?request=http%3A%2F%2Fwww.mozilla.org%2Fproducts%2Ffirefox%2Fbuttons%2Fgetfirefox_small.png&hash=9f6d645801cbc882a52f0ee76cfeda02625fc537)

Joachim Müller


kegobeer

You are attempting to install Coppermine 1.2.1?
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