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: mySQL Error: an error in your SQL syntax near 'Array' at line 1  (Read 10376 times)

0 Members and 1 Guest are viewing this topic.

lovepieds

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
mySQL Error: an error in your SQL syntax near 'Array' at line 1
« on: January 24, 2005, 02:20:57 pm »





Hello,

I have just install (try  ::)) Coppermine on my server... and it doesn't run...

This error message appear :
mySQL Error: You have an error in your SQL syntax near 'Array' at line 1

I don't know where correct this ?

Can you help me ?

Best regards,

André
Logged

Abbas Ali

  • Administrator
  • Coppermine addict
  • *****
  • Country: in
  • Offline Offline
  • Gender: Male
  • Posts: 2165
  • Spread the PHP Web
    • Ranium Systems
Re: mySQL Error: an error in your SQL syntax near 'Array' at line 1
« Reply #1 on: January 24, 2005, 06:15:52 pm »

Did the installation script ran sucessfully?

Please provide the URL and server details.
Logged
Chief Geek at Ranium Systems

lovepieds

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
Re: mySQL Error: an error in your SQL syntax near 'Array' at line 1
« Reply #2 on: January 25, 2005, 07:44:31 am »


Hello

Yes, the script ran sucessfuly...

I have install it here :
http://unephoto.contactmoi.com/install.php

Server détails :

MySQL Host : local
MySQL Database Name : guidedes
MySQL Username : guidedes
Password : send by private message

Thanks for your help


Logged

Abbas Ali

  • Administrator
  • Coppermine addict
  • *****
  • Country: in
  • Offline Offline
  • Gender: Male
  • Posts: 2165
  • Spread the PHP Web
    • Ranium Systems
Re: mySQL Error: an error in your SQL syntax near 'Array' at line 1
« Reply #3 on: January 25, 2005, 08:30:50 am »

I checked your installation and it seems that there is something wrong with some script. Is your copy a CVS checkout?
Logged
Chief Geek at Ranium Systems

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: mySQL Error: an error in your SQL syntax near 'Array' at line 1
« Reply #4 on: January 25, 2005, 09:14:31 am »

@Abbas: use versioncheck.php to answer this question for you ;)

Joachim
Logged

Abbas Ali

  • Administrator
  • Coppermine addict
  • *****
  • Country: in
  • Offline Offline
  • Gender: Male
  • Posts: 2165
  • Spread the PHP Web
    • Ranium Systems
Re: mySQL Error: an error in your SQL syntax near 'Array' at line 1
« Reply #5 on: January 25, 2005, 09:42:30 am »

@Joachim: i already tried it and it gives following error.

Fatal error :
There was an error while processing a database query
Logged
Chief Geek at Ranium Systems

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: mySQL Error: an error in your SQL syntax near 'Array' at line 1
« Reply #6 on: January 25, 2005, 09:58:53 am »

versioncheck doesn't contain any mySQL queries, so the error must be generic. Is phpMyAdmin (or similar) available on the webspace of lovepieds? Can you go to coppermine's config and enable debug_mode? I guess you will need full access to the webspace (ftp and database tool) to find out more, I'm not sure you'd want to go through this process. Maybe it's time lovepieds answered some of those questions: where did you get the coppermine files from? What version are you using? Is there a phpMyAdmin account available? Please do not PM me, and don't post security-related data publicly (authentification data).

Joachim
Logged

Capone

  • Coppermine newbie
  • Offline Offline
  • Posts: 9
Re: mySQL Error: an error in your SQL syntax near 'Array' at line 1
« Reply #7 on: January 25, 2005, 12:17:35 pm »

i have got the same problem

i uploaded files to uragallery folder.

i done it by not making a database but install with
username ura gallery etc and i get array 1 error etc

i cleaned it all

uploaded again made my own database before i installed and entered exactly the same username and db name as database and getting the same error on install screen.

http://prdownloads.sourceforge.net/coppermine/cpg1.3.2.zip?download i downloaded
« Last Edit: January 25, 2005, 12:24:01 pm by Capone »
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: mySQL Error: an error in your SQL syntax near 'Array' at line 1
« Reply #8 on: January 26, 2005, 09:37:03 am »

if you reply to a thread you should read it before: supporters requested the url of the original starter of this thread, so it might be a good idea to do the same thing if you have the same problems, don't you think? ::)

Joachim
Logged

Capone

  • Coppermine newbie
  • Offline Offline
  • Posts: 9
Re: mySQL Error: an error in your SQL syntax near 'Array' at line 1
« Reply #9 on: January 28, 2005, 10:27:13 pm »

k

heres my site: www.ura-clan.co.uk/uragallery

mysql version: 3.23.58 - heard this version is dodgy but host wont change it
control panel: is Plesk
phpmyadmin: yes

Error after i create database then complete install, after i submit install it refreshs with the following error: mySQL Error: an error in your SQL syntax near 'Array' at line 1

my mate said it aint able to update the database or something, then when i go to www.ura-clan.com/uragallery i get the query on database error

is there anyway to go round it?

any ideas truelly greatful.
« Last Edit: January 28, 2005, 10:35:18 pm by Capone »
Logged

Capone

  • Coppermine newbie
  • Offline Offline
  • Posts: 9
Re: mySQL Error: an error in your SQL syntax near 'Array' at line 1
« Reply #10 on: January 28, 2005, 10:34:08 pm »

versioncheck doesn't contain any mySQL queries, so the error must be generic. Is phpMyAdmin (or similar) available on the webspace of lovepieds? Can you go to coppermine's config and enable debug_mode? I guess you will need full access to the webspace (ftp and database tool) to find out more, I'm not sure you'd want to go through this process. Maybe it's time lovepieds answered some of those questions: where did you get the coppermine files from? What version are you using? Is there a phpMyAdmin account available? Please do not PM me, and don't post security-related data publicly (authentification data).

Joachim

where is the config and name of the file
is it config.php?
Logged

Tranz

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Female
  • Posts: 6149
Re: mySQL Error: an error in your SQL syntax near 'Array' at line 1
« Reply #11 on: January 28, 2005, 10:47:53 pm »

It's a link you will see when in admin mode.
Logged

Capone

  • Coppermine newbie
  • Offline Offline
  • Posts: 9
Re: mySQL Error: an error in your SQL syntax near 'Array' at line 1
« Reply #12 on: January 28, 2005, 11:04:55 pm »

i cant get to admin mode as coppermine wont install.
stuck on install.php as i get that error.
Logged

kegobeer

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 4637
  • Beer - it does a body good!
    • The Kazebeer Family Website
Re: mySQL Error: an error in your SQL syntax near 'Array' at line 1
« Reply #13 on: January 29, 2005, 02:14:22 am »

Have you followed the installation instructions?  According to the installer you haven't set the permissions for albums, edit, userpics, or include to 777.
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

Capone

  • Coppermine newbie
  • Offline Offline
  • Posts: 9
Re: mySQL Error: an error in your SQL syntax near 'Array' at line 1
« Reply #14 on: January 29, 2005, 12:02:15 pm »

i done all that

now i go create a database

db name: uragallery
db user:
db user pass:

then enter the details into install .php
Logged

sanderkoopmans

  • Coppermine newbie
  • Offline Offline
  • Posts: 1
Re: mySQL Error: an error in your SQL syntax near 'Array' at line 1
« Reply #15 on: January 29, 2005, 02:34:03 pm »

Hi lovepieds  an others.

This morning I check my homepage and saw that coppermine could not get to my database. Everything was working fine a day before. So with all the backups at hand I started agian and to my suprise I got the same "SQL syntax near 'Array' at line 1" error. I got in contact with my webhosting service and ask them if they changed something. The answer was "no" but a few hour later everything was running agian. I contacted them again and now their story is that there was a recurring database problem, whatever that means. The hosting company fixed it. I could do nothing about the problem on my end they said.

So I still don't know the solution, or what the problem was but maybe this story helps.
Logged
Pages: [1]   Go Up
 

Page created in 0.024 seconds with 15 queries.