Having Trouble on the install page
Permalink
Notice: Undefined variable: dsn in ...\concrete\concrete\libraries\loader.php on line 121
From the install page I get
mysql error: [1364: Field 'jDateLastRun' doesn't have a default value] in EXECUTE("INSERT INTO Jobs (jName, jDescription, jDateInstalled, jNotUninstallable, jHandle) VALUES('Index Search Engine','Index the site to allow searching to work quickly and accurately.','2008-10-30 23:56:42 PM',1,'index_search')")
What is your MySQL version?
Could you try enabling less strict date checking described here?
http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html
I'm wondering if c5 needs to be a little less lax in some of its queries but we've never noticed it before.
You guys are on it. I've been looking into this some more, It's more than likely on my end.
The Database was created with 59 tables, site.php is blank...
'jDateLastRun' does not allow nulls, has no default and is a datetime. My datetime format is set to %Y-%m-%d %H:%i:%s.
I'll try again later.
Thanks
Page http://www.concrete5.org/index.php?cID=229 write me this error and there is not button for new question.
Notice: Undefined variable: dsn in ...\concrete\concrete\libraries\loader.php on line 121
Hi, I ran into the very same problem.
I edited the file <install dir>/concrete/config/db.xml
I commented the NOTNULL requirements for PkgId and jDateLastRun
I also had to default the jLastStatusText to an empty string.
I drop the db and created it again, reset the config and files dirs to their original state and the installation finally worked.
Guess that either the models/job.php install method needs to be edited or the db.xml file updated to get a clean install script
I edited the file <install dir>/concrete/config/db.xml
I commented the NOTNULL requirements for PkgId and jDateLastRun
I also had to default the jLastStatusText to an empty string.
I drop the db and created it again, reset the config and files dirs to their original state and the installation finally worked.
Guess that either the models/job.php install method needs to be edited or the db.xml file updated to get a clean install script
If you're having troubles getting install to work and it's an error in your Jobs table, try opening
concrete/config/db.xml
finding the <table name="Jobs"> portion of the XML, and replace it with this:
(You'll want to view the entire code block above and paste it out.)
For databases that are more strict that may work better.
concrete/config/db.xml
finding the <table name="Jobs"> portion of the XML, and replace it with this:
<table name="Jobs"> <field name="jID" type="I" size="10"> <KEY/> <AUTOINCREMENT/> <UNSIGNED/> </field> <field name="jName" type="C" size="100"> <NOTNULL/> </field> <field name="jDescription" type="C" size="255"> <NOTNULL/> </field> <field name="jDateInstalled" type="T"></field> <field name="jDateLastRun" type="T"></field> <field name="pkgID" type="I" size="10">
Viewing 15 lines of 36 lines. View entire code block.
(You'll want to view the entire code block above and paste it out.)
For databases that are more strict that may work better.
I've tried install concrete on Ubuntu 8.10. I've created concrete mysql database and user, but install page writes:
Unable to connect to a database using those credentials.
are you specifying "localhost" as your db server?
Apache 2.2
PHP Version 5.2.6
MySQL 5.0
PHPMyAdmin 3.0.1
I'm having the same problem. Although not on Ubuntu Intrepid but on my host provider. I have 'localhost' defined as database server but no luck anyway :(
does your server support php5! and mysql databases?
quess i had the same problem - with my php4 server
greets,
anda
yeah. php 5.2.6 and mysql 4.1.22-standard-log.
i think I got everything right. but might be overlooking something :-(
I have just tried to install C5 and get the same error as in this topic.
My hosting package is windows with PHP5, MySQL5 Database, and the mysql server is not localhost.
Any help in getting past this stage would be appreciated.
My hosting package is windows with PHP5, MySQL5 Database, and the mysql server is not localhost.
Any help in getting past this stage would be appreciated.
I'm having the same problem when I tried to install:
Notice: Undefined variable: dsn in ........ concrete\libraries\loader.php on line 121
I checked the files and noticed that $dns seems to be defined in ADOdb.php, but this file is not refered by any other file. Does anyone was able to solve this issue?
Notice: Undefined variable: dsn in ........ concrete\libraries\loader.php on line 121
I checked the files and noticed that $dns seems to be defined in ADOdb.php, but this file is not refered by any other file. Does anyone was able to solve this issue?
I know this is an old thread, but here's one possible solution.
I ran into this problem after a failed installation attempt (I caused the failure - no bugs here :p). Anyway, during installation, the sites.php file is created - if you try to install again, it checks to see if that file is there. If it is, then it assumes you've already installed. BUT, if it didn't properly initialize the database info the first time through, it will fail with this error.
So, the solution that worked for me was to delete config/sites.php.
I ran into this problem after a failed installation attempt (I caused the failure - no bugs here :p). Anyway, during installation, the sites.php file is created - if you try to install again, it checks to see if that file is there. If it is, then it assumes you've already installed. BUT, if it didn't properly initialize the database info the first time through, it will fail with this error.
So, the solution that worked for me was to delete config/sites.php.
I had the same problem. Just reinstall php and mysql to newer versions.
