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: [1.2.1 standalone]mySQL Error : Query was empty  (Read 10296 times)

0 Members and 1 Guest are viewing this topic.

Rip-rip

  • Coppermine newbie
  • Offline Offline
  • Posts: 1
[1.2.1 standalone]mySQL Error : Query was empty
« 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
Logged

wthai

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: [1.2.1 standalone]mySQL Error : Query was empty
« Reply #1 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
Logged

wthai

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Database Installation - Empty Query
« Reply #2 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
Logged

hyperion

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Posts: 1317
  • - retired -
[1.2.1 standalone]mySQL Error : Query was empty
« Reply #3 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?
Logged
"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

(http://www.mozilla.org/products/firefox/buttons/getfirefox_small.png)

wthai

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
[1.2.1 standalone]mySQL Error : Query was empty
« Reply #4 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...
Logged

hyperion

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Posts: 1317
  • - retired -
[1.2.1 standalone]mySQL Error : Query was empty
« Reply #5 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.
Logged
"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

(http://www.mozilla.org/products/firefox/buttons/getfirefox_small.png)

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Logged

kegobeer

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 4637
  • Beer - it does a body good!
    • The Kazebeer Family Website
Re: [1.2.1 standalone]mySQL Error : Query was empty
« Reply #7 on: February 01, 2005, 04:24:49 am »

You are attempting to install Coppermine 1.2.1?
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
Pages: [1]   Go Up
 

Page created in 0.021 seconds with 18 queries.