[Xerte] Re: SQL error while installing Xerte on our server

[Maurizio Bricola]

Dear All, we tried several things up to now and none of them worked.

We have found someone else with a similar issue here:
http://lists.nottingham.ac.uk/pipermail/xerte-dev/2014-February/006676.html

It seems there is some issues with the installer.

Anyone has found a workaround?

Thanks!


With Kind Regards,
Maurizio Bricola
Technical Advisor Solutions and Innovations
*Working days: Mon - Tue - Wed - Thu*
International Institute for Communication and Development (IICD)
P.O. Box 11586, 2502 AN The Hague, the Netherlands
Visitors: Raamweg 5, 2596 HL The Hague
Phone: +31-(0)70-311 73 11
Follow us: www.iicd.org | facebook.com/iicd.org | twitter.com/iicd
*People | ICT | Development*






On 12 May 2014 18:45, Maurizio Bricola <mbricola at iicd.org> wrote:

> Hi Ron thanks we' ll give it a try to that. Cheers
> On 12 May 2014 18:36, "Ron Mitchell" <ronm at mitchellmedia.co.uk> wrote:
>
>> Hi
>>
>> I think if no database.php is getting created then you need to
>> check/change permissions on the root directory to allow that to happen if
>> only temporarily.
>>
>> HTH
>>
>> Ron
>>
>>
>>
>> *From:* xerte-bounces at lists.nottingham.ac.uk [mailto:
>> xerte-bounces at lists.nottingham.ac.uk] *On Behalf Of *Maurizio Bricola
>> *Sent:* 12 May 2014 17:15
>> *To:* Xerte discussion list
>> *Cc:* Andrei Barburas
>> *Subject:* [Xerte] Re: SQL error while instaling Xerte on our server
>>
>>
>>
>> Hi Ron, thanks for your prompt reply. Yes we did that, still non
>> database.php file gets created. Hence the error I believe.
>> Anything else we should look at?
>> Cheers
>>
>> On 12 May 2014 16:46, "Ron Mitchell" <ronm at mitchellmedia.co.uk> wrote:
>>
>> Did you create the empty database and database user first and then use
>> those credentials during setup?
>>
>> Check that database.php has been created in the root of your install and
>> that the entries it contains are correct.
>>
>>
>>
>> *From:* xerte-bounces at lists.nottingham.ac.uk [mailto:
>> xerte-bounces at lists.nottingham.ac.uk] *On Behalf Of *Maurizio Bricola
>> *Sent:* 12 May 2014 10:57
>> *To:* xerte at lists.nottingham.ac.uk
>> *Subject:* [Xerte] SQL error while instaling Xerte on our server
>>
>>
>>
>> Dear All, we have first tried Xerte on a Xammp installation and
>> everything went fine. We decided to make it available online for the
>> schools we are currently supporting.
>>
>> When going through the setup we ran into the following issue:
>>
>>
>>
>> *Warning*: session_start() [function.session-start<http://cdn3.iicd.org/xerte/setup/function.session-start>]:
>> Cannot send session cookie - headers already sent by (output started at
>> /home/cdn3iicd/public_html/xerte/setup/page_password.php:3) in
>> */home/cdn3iicd/public_html/xerte/setup/page_password.php* on line *4*
>>
>> *Warning*: session_start() [function.session-start<http://cdn3.iicd.org/xerte/setup/function.session-start>]:
>> Cannot send session cache limiter - headers already sent (output started at
>> /home/cdn3iicd/public_html/xerte/setup/page_password.php:3) in
>> */home/cdn3iicd/public_html/xerte/setup/page_password.php* on line *4*
>>
>> Sorry, the attempt to open database using account cdn3iicd_xusers failed.
>> MySQL reports the following error -
>>
>> *1064 - 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
>> '' at line 1*
>>
>>
>>
>> The account cdn3iicd_xusers must already exist, and have access to
>> database
>> Using given MySQL account failed!
>>
>> Your Xerte Online Toolkits database configuration file is not created!
>> Please investigate the error messages and return to the previous page by
>> pressing the button below!
>>
>> Any help is highly appreciated,
>>
>> t
>>
>> hanks!
>>
>>
>>
>> With Kind Regards,
>> Maurizio Bricola
>> Technical Advisor Solutions and Innovations
>>
>> *Working days: Mon - Tue - Wed - Thu*
>>
>> International Institute for Communication and Development (IICD)
>> P.O. Box 11586, 2502 AN The Hague, the Netherlands
>> Visitors: Raamweg 5, 2596 HL The Hague
>> Phone: +31-(0)70-311 73 11
>>
>> Follow us: www.iicd.org | facebook.com/iicd.org | twitter.com/iicd
>>
>> *People | ICT | Development*
>>
>>
>>
>>
>>
>> This message and any attachment are intended solely for the addressee and
>> may contain confidential information. If you have received this message in
>> error, please send it back to me, and immediately delete it.   Please do
>> not use, copy or disclose the information contained in this message or in
>> any attachment.  Any views or opinions expressed by the author of this
>> email do not necessarily reflect the views of the University of Nottingham.
>>
>> This message has been checked for viruses but the contents of an
>> attachment may still contain software viruses which could damage your
>> computer system, you are advised to perform your own checks. Email
>> communications with the University of Nottingham may be monitored as
>> permitted by UK legislation.
>>
>>
>>
>>
>> _______________________________________________
>> Xerte mailing list
>> Xerte at lists.nottingham.ac.uk
>> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
>>
>> This message and any attachment are intended solely for the addressee and
>> may contain confidential information. If you have received this message in
>> error, please send it back to me, and immediately delete it.   Please do
>> not use, copy or disclose the information contained in this message or in
>> any attachment.  Any views or opinions expressed by the author of this
>> email do not necessarily reflect the views of the University of Nottingham.
>>
>> This message has been checked for viruses but the contents of an
>> attachment may still contain software viruses which could damage your
>> computer system, you are advised to perform your own checks. Email
>> communications with the University of Nottingham may be monitored as
>> permitted by UK legislation.
>>
>>
>> _______________________________________________
>> Xerte mailing list
>> Xerte at lists.nottingham.ac.uk
>> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
>>
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nottingham.ac.uk/pipermail/xerte/attachments/20140515/c56fa42b/attachment-0001.html>