forum.coppermine-gallery.net

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Installation & Setup => Topic started by: Dracocid on December 25, 2004, 04:10:42 pm

Title: Error: Array in line 1
Post by: Dracocid on December 25, 2004, 04:10:42 pm
Hello:
 When I want to install the coppermine in my server, I complete all the dates about user, pass, name of db... But I receive a faillure that say: mySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Array' at line 1

I have tried with the version 1,2, 1,21.... All give me this fail.

What can I do?

Many thanks.
Title: Re: Error: Array in line 1
Post by: Hein Traag on December 25, 2004, 04:17:55 pm
Did you try installing the latest stable version of cpg. Also check if your running the latest php and zend versions.
Title: Re: Error: Array in line 1
Post by: kegobeer on December 25, 2004, 05:45:30 pm
You need to check with your webhost and make sure when they upgraded php that they also upgraded their Zend optimizer to 2.5.7.  If you search for your error you will find related posts.
Title: Re: Error: Array in line 1
Post by: Dracocid on December 25, 2004, 10:36:20 pm
First, thanks by the help...

My webhost says me that the phpMyAdmin is 2.6.0-alpha2 and the MySQL is 4.1.7-standard

Some solution?

Title: Re: Error: Array in line 1
Post by: kegobeer on December 25, 2004, 10:40:01 pm
phpmyadmin and mysql versions aren't the issue.  We need to know what version of php you are running, and what version of the Zend optimizer you have.  You can ask your host for that information, or make a php script with this in it:

<?php
phpinfo();
?>

Upload it to your site and execute it.  Look for the php version and zend version.  If your php version is 4.3.10, you must have zend 2.5.7, otherwise Coppermine won't run.  Your host has to upgrade Zend - they should already know that.
Title: Re: Error: Array in line 1
Post by: NEOo on December 26, 2004, 10:28:34 am
I have the same problem it has worked always until yesterday I get the array in line 1 error when I do the install again

Versions:
php:
PHP Version 4.3.10
Mysql:
Client API version  3.23.49

The full array 1 error:
mySQL Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Array' at line 1

In the photoalbum I get this error:
There was an error while processing a database query

I think the problem lays in the database somehow.
So maybe this can help to solve our problems
Title: Re: Error: Array in line 1
Post by: Joachim Müller on December 26, 2004, 11:39:38 am
NEOo, you have to learn to use some common sense. You have been told to respect board rules:
1) Don't double-post nor cross-post
2) Search before posting
3) Don't PM supporters

This is an official warning, you'll get banned if you don't play by the rules!

Joachim
Title: Re: Error: Array in line 1
Post by: NEOo on December 27, 2004, 11:27:32 am
im sorry didnt know that all.
sorry

but i know the anwser now, the zend optimizer has to be upgraded than it all will work fine again..