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

[Smith, John]

Does it pass all the folder permission tests? That sounds like no write permissions on root...

Regards

John Smith
Learning Technologist
School of Health and Life Sciences

Sent from Samsung Galaxy SII


Maurizio Bricola <mbricola at iicd.org> wrote:



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<mailto: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> [mailto: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<mailto: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<tel:%2B31-%280%2970-311%2073%2011>
Follow us: www.iicd.org<http://www.iicd.org/> | facebook.com/iicd.org<http://facebook.com/iicd.org> | twitter.com/iicd<http://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<mailto:Xerte at lists.nottingham.ac.uk>
http://lists.nottingham.ac.uk/mailman/listinfo/xerte


Glasgow Caledonian University is a registered Scottish charity, number SC021474