mySQL Error: an error in your SQL syntax near 'Array' at line 1

[lovepieds]

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é

[Abbas Ali]

Did the installation script ran sucessfully?

Please provide the URL and server details.

[lovepieds]

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

[Abbas Ali]

I checked your installation and it seems that there is something wrong with some script. Is your copy a CVS checkout?

[Joachim Müller]

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

Joachim

[Abbas Ali]

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

Fatal error :
There was an error while processing a database query

[Joachim Müller]

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

[Capone]

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

[Joachim Müller]

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

[Capone]

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.

[Capone]

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?

[Tranz]

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

[Capone]

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

[kegobeer]

Have you followed the installation instructions?  According to the installer you haven't set the permissions for albums, edit, userpics, or include to 777.

[Capone]

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

[sanderkoopmans]

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.