coppermine-gallery.com/forum

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Installation & Setup => Topic started by: lovepieds on January 24, 2005, 02:20:57 PM

Title: mySQL Error: an error in your SQL syntax near 'Array' at line 1
Post by: lovepieds 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é
Title: Re: mySQL Error: an error in your SQL syntax near 'Array' at line 1
Post by: Abbas Ali on January 24, 2005, 06:15:52 PM
Did the installation script ran sucessfully?

Please provide the URL and server details.
Title: Re: mySQL Error: an error in your SQL syntax near 'Array' at line 1
Post by: lovepieds 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


Title: Re: mySQL Error: an error in your SQL syntax near 'Array' at line 1
Post by: Abbas Ali 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?
Title: Re: mySQL Error: an error in your SQL syntax near 'Array' at line 1
Post by: Joachim Müller on January 25, 2005, 09:14:31 AM
@Abbas: use versioncheck.php to answer this question for you ;)

Joachim
Title: Re: mySQL Error: an error in your SQL syntax near 'Array' at line 1
Post by: Abbas Ali 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
Title: Re: mySQL Error: an error in your SQL syntax near 'Array' at line 1
Post by: Joachim Müller 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
Title: Re: mySQL Error: an error in your SQL syntax near 'Array' at line 1
Post by: Capone 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
Title: Re: mySQL Error: an error in your SQL syntax near 'Array' at line 1
Post by: Joachim Müller 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
Title: Re: mySQL Error: an error in your SQL syntax near 'Array' at line 1
Post by: Capone 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.
Title: Re: mySQL Error: an error in your SQL syntax near 'Array' at line 1
Post by: Capone on January 28, 2005, 10:34:08 PM
Quote from: GauGau 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

where is the config and name of the file
is it config.php?
Title: Re: mySQL Error: an error in your SQL syntax near 'Array' at line 1
Post by: Tranz on January 28, 2005, 10:47:53 PM
It's a link you will see when in admin mode.
Title: Re: mySQL Error: an error in your SQL syntax near 'Array' at line 1
Post by: Capone 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.
Title: Re: mySQL Error: an error in your SQL syntax near 'Array' at line 1
Post by: kegobeer 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.
Title: Re: mySQL Error: an error in your SQL syntax near 'Array' at line 1
Post by: Capone 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
Title: Re: mySQL Error: an error in your SQL syntax near 'Array' at line 1
Post by: sanderkoopmans 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.